New to using Excel here. How does one calculate the current cost if one
knows a building cost $56,000 in 1920. I am assuming annual inflation
rate is 3.5%.
What formula or function would I use?
Thank you.
AB
New to using Excel here. How does one calculate the current cost if one
knows a building cost $56,000 in 1920. I am assuming annual inflation
rate is 3.5%.
What formula or function would I use?
Thank you.
AB
Use the FV (Future Value) function. E.g.,
=FV(3.5%,YEAR(TODAY())-1920,0,-56000)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"A Boe" <"\"m-in-sfca/*No*Spam*\\\""@comcast.net> wrote in
message news:[email protected]...
> New to using Excel here. How does one calculate the current
> cost if one knows a building cost $56,000 in 1920. I am
> assuming annual inflation rate is 3.5%.
>
> What formula or function would I use?
>
> Thank you.
>
> AB
Chip Pearson wrote:
> Use the FV (Future Value) function. E.g.,
>
> =FV(3.5%,YEAR(TODAY())-1920,0,-56000)
>
Thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks