ExcelBanter - How to calculate future cost of roof

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to calculate future cost of roof (https://www.excelbanter.com/excel-worksheet-functions/96944-how-calculate-future-cost-roof.html)

rcortese

How to calculate future cost of roof

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

How to calculate future cost of roof

Check the FV ('future value') function.

"rcortese" wrote:

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

Lewis Clark

How to calculate future cost of roof

=5000*(1.04)^30

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

--

"rcortese" wrote in message ...
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

[email protected]

How to calculate future cost of roof

rcortese wrote:
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)

All times are GMT +1. The time now is 10:35 AM.