ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel formula question (https://www.excelbanter.com/excel-discussion-misc-queries/192783-excel-formula-question.html)

crookedsoul108

excel formula question
 
I am trying to create a formula where I have a yearly cost and I want to add
inflation adjustment each year over around 20 years and find the total cost
for 20 years. Anyone know how to do that? Thank you.

Mike H

excel formula question
 
Try

=1000*(1+3%)^20

Where
1000 is the present value
3% = inflation
term 20 yrs

Mike

"crookedsoul108" wrote:

I am trying to create a formula where I have a yearly cost and I want to add
inflation adjustment each year over around 20 years and find the total cost
for 20 years. Anyone know how to do that? Thank you.



All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com