+ Reply to Thread
Results 1 to 7 of 7

Calculation Cash flow

Hybrid View

AaruJaan Calculation Cash flow 12-09-2018, 09:29 AM
AaruJaan Re: Calculation Cash flow 12-09-2018, 12:17 PM
Pepe Le Mokko Re: Calculation Cash flow 12-09-2018, 01:15 PM
AaruJaan Re: Calculation Cash flow 12-10-2018, 06:23 AM
AaruJaan Re: Calculation Cash flow 12-10-2018, 06:47 AM
AaruJaan Re: Calculation Cash flow 12-10-2018, 02:09 PM
JeteMc Re: Calculation Cash flow 12-16-2018, 07:11 PM
  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,853

    Re: Calculation Cash flow

    This proposal employs two helper columns which may be moved and/or hidden for aesthetic purposes.
    I4:I10 are populated using: =IF(MOD(SUM(I3,1),B$14)=0,3,MOD(SUM(I3,1),B$14))
    J4:J10 are populated using: =IF(I4>I3,J3,J$3+3*COUNTIFS(I$4:I4,3))
    Note that J3 is populated with the min exponent (1.5)
    G4:G10 are populated using: =(1+$G$2)^J4
    H3:H10 are populated using: =IF(I3=1,(F2*G2+F3*G3)/2,F3*G3)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-23-2017, 11:21 PM
  2. NPV / PV Calculation / Formula with Cumulative / Compounding Cash Flow
    By donkeybusiness in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-08-2015, 10:36 AM
  3. Present Value fo Cash Flow Calculation Macro
    By forexcellence13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2013, 08:40 PM
  4. Cash Flow Present Value Calculation
    By forexcellence13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2013, 06:43 AM
  5. Loan Calculation Help in a Cash Flow
    By tk4d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-25-2013, 11:32 AM
  6. Cash Flow
    By matthewmcgirr@earthlink.net in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 02:05 PM
  7. [SOLVED] Cash Flow Set-Up
    By Gary T in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-13-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1