View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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)