Doyou know if there is an excel formula that allow the calculation of the totalvalue of say £1000 in 5 years time assuming inflation of 2.5% per annum.
Iknow how to calculate it simply but wondered whether there is another method tojust do an individual year.
Thank you
Doesn't inflation decrease the value of your money while interest increase the amount?
None the less, think you may want to look into Excel's Future Value function.
http://www.techonthenet.com/excel/formulas/fv.php
Bookmarks