Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I hope I can make this understandable!
I am looking for a formula that enables me to determine the pay back period on an investment project. Relevant input will be the initial investment cost, monthly income generated by this investment (rising annually by CPI) and an allowance for 'cost of money' being the 'Discount factor'. The answer should be a period of months. I can calculate this (a little manually) but need a formula so that I can carry out multiple calculations on a range of scenarios. I know this is probably very simple but I am no Excel expert. Hope someone can assist. Cheers...Scotty |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate Payback Period | Excel Worksheet Functions | |||
payback period for a 10 years investment | Excel Worksheet Functions | |||
payback period | Excel Worksheet Functions | |||
Payback Period | Excel Discussion (Misc queries) | |||
Payback Period | Excel Discussion (Misc queries) |