hedgeman50
Board Regular
- Joined
- Sep 20, 2002
- Messages
- 76
I need to calculate the present value of 360 uneven payments (30-year mortgage). Years one through five would be $1x, years six through 10 would be 1.5x, years 11 through 15 would be $1.8x, and so on.
How can I create a calculation that takes the future payments in cells A1 through A360 and discounts those back at a given discount rate?
This is very easy to do with a financial calculator, but I can't seem to figure it out in Excel. Any help is appreciated!
Hedgeman50
How can I create a calculation that takes the future payments in cells A1 through A360 and discounts those back at a given discount rate?
This is very easy to do with a financial calculator, but I can't seem to figure it out in Excel. Any help is appreciated!
Hedgeman50