Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
calculate percentage | Excel Worksheet Functions | |||
Setting up a spreadsheet to calculate apportionment of service cha | Excel Worksheet Functions | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |