Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have been able to calculate the reduction in growth where there is a lump
sum investment and have used (1+RATE(120,-600,86144,,1,3.5%))^12-1 where the investment is made by regular monthly payments but cannot find a firula that works where there is an initial investment and regular monthly payments Say initial investment £100,000 regular investments £500 per month Capital at the end of 10 years £210,000 What was the growth rate? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reduction Fractions to LCD | Excel Discussion (Misc queries) | |||
Average data/reduction | New Users to Excel | |||
Worksheet size reduction | Excel Discussion (Misc queries) | |||
need help with a formula - % reduction | New Users to Excel | |||
How can I set up a debt reduction plan? | Excel Discussion (Misc queries) |