I often find myself calculating the the future value of various things. Most often the cost of buying something large, or debt or sometimes calculating the growth of retirement devices (such as 401k's). Here is the formula for using Excel to calculate the Future Value of something:
FV( interest_rate, number_payments, payment, [PV], [Type] )
I'll post up an example.
No comments:
Post a Comment