Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dima
 
Posts: n/a
Default

Thanks Dave O for your reply.
The fraction of the fist positive month, the pay-back portion is calculated
in
the following way (-last negative cum. cash flow)/(fist positive cash flow)
or (-last negative cum. cash flow)/(-last negative cum. cash flow+fist
positive cum. cash flow). How to calculate the fraction automatically and add
it to the negative months count automatically? The cash flow is above the
cum. cash flow.
"Dave O" wrote:

You could determine the point during the month if you have weekly or
daily data to use in the calculation. Or if, for example, the first
cash positive month is month 8, how about
(cum. cash flow month 8) / (revenue month 8)
That would return a fraction of month 8, but it assumes that daily or
weekly revenue streams are even.

Just a heads up: this "count the negative months" logic is correct, up
to a point, but it may mislead your audience. Since cumulative cash
flow can swing from negative to postive and back to negative,
particularly if there are capital expenditures in the outmonths, anyone
who reads your report may assume that there are an unbroken number of
cash negative months followed by an unbroken number of cash positive
months, which is not necessarily the case. This is difficult for
non-finance types to understand, and you may need to explain that to
your audience.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I make a word typed in a cell go to a specific cell in anot Lmatarazzo Excel Discussion (Misc queries) 3 April 21st 05 04:29 AM
calculate percentage JP Excel Worksheet Functions 6 March 2nd 05 02:34 PM
Setting up a spreadsheet to calculate apportionment of service cha چMÃÐÊLÉÎNÊچڤ Excel Worksheet Functions 1 February 12th 05 09:30 PM
Not able to calculate. mark_kramarczyk Excel Worksheet Functions 1 December 29th 04 08:55 PM
How do you calculate the nth root of a number in Excel 2003? William Excel Worksheet Functions 2 November 17th 04 04:19 PM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"