How to calculate future cost of roof

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

=5000*(1.04)^30

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

--

"rcortese" <(E-Mail Removed)> wrote in message news:8BDC0029-8D02-4C91-8DF7-(E-Mail Removed)...
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

's Computer Specifications

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)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculate the diffrence in cost	Calculate difference in price	Microsoft Excel Worksheet Functions	3	18th Oct 2009 06:24 PM
Future Cost	=?Utf-8?B?R2F6emFhYQ==?=	Windows Vista Installation	9	3rd Oct 2006 06:58 PM
Calculate time and cost	=?Utf-8?B?U2pvZXN0YWFs?=	Microsoft Excel Worksheet Functions	2	31st Mar 2005 01:47 PM
Future Cost of AntiSpyware	James Garringer	Spyware Discussion	3	4th Mar 2005 03:29 AM