How to calculate future cost of roof

R

rcortese

What do I use for a formula to calculate the future replacement cost of a
roof. Todays cost = $5000.00
Inflation Rate of 4% per year
Cost of replacement 30 years in the future
 
L

Lewis Clark

=5000*(1.04)^30

This will be in future dollar terms, not current dollars.

--

What do I use for a formula to calculate the future replacement cost of a
roof. Todays cost = $5000.00
Inflation Rate of 4% per year
Cost of replacement 30 years in the future
 
J

joeu2004

rcortese said:
What do I use for a formula to calculate the future replacement cost of a
roof. Todays cost = $5000.00
Inflation Rate of 4% per year
Cost of replacement 30 years in the future
Click to expand...

Based on your parameters:

=fv(4%, 30, 0, -5000)
 
Top