How to calculate future cost of roof

[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

 

[bpeltzer]

Check the FV ('future value') function.

 

[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

 

[joeu2004]

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

Based on your parameters:

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