Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cash Flows Inflation Adjusted
Can anyone assist with this:
I have annual cash flows that are based on tenure of a building lease. The cash flows are stable and I want to calculate the total cumulative value of those annually adjusted cash flows. Say for instance the cash flow in year 1 is 100 and inflation is 3% then the cash flow in year 10 is 134, which is reach with either of these two formulas: =100*POWER(1+3%,10) =100*(1+3%)^10 Instead of entering the values these can of course be linked to other cells. Both formulas will give me the value in year 10, but not the cumulative total of the CF for the in-between years. Is there a formula for calculating this other than calculating the annual CF in separate cells and then including part of these in an €˜IF= function? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cash Flows Inflation Adjusted
Hi,
Try this =SUMPRODUCT(100*(1+3%)^ROW(1:10)) If this helps, please click the Yes button Cheers, Shane Devenshire "Jes Johansen" wrote: Can anyone assist with this: I have annual cash flows that are based on tenure of a building lease. The cash flows are stable and I want to calculate the total cumulative value of those annually adjusted cash flows. Say for instance the cash flow in year 1 is 100 and inflation is 3% then the cash flow in year 10 is 134, which is reach with either of these two formulas: =100*POWER(1+3%,10) =100*(1+3%)^10 Instead of entering the values these can of course be linked to other cells. Both formulas will give me the value in year 10, but not the cumulative total of the CF for the in-between years. Is there a formula for calculating this other than calculating the annual CF in separate cells and then including part of these in an €˜IF= function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adjusted for inflation wages? | Excel Worksheet Functions | |||
Future Value of Cash Flows | Excel Discussion (Misc queries) | |||
IRR for 2 cash flows | Excel Worksheet Functions | |||
IRR formula for monthly cash flows | Excel Worksheet Functions | |||
Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions |