View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MaR MaR is offline
external usenet poster
 
Posts: 17
Default Calculating Appreciation for a property from purchase date to pres

Hi! I know there is probably a simple answer to this question, but I'm
having a hard time finding it.

I am trying to create a formula so that I can enter the following
information: Purchase date, purchase price and average appreciation (%) to
assess the current value based only on the appreciation. The appreciation
increases the property's value at the end of each year, so I need the sheet
to calculate the amount and compound it annually for the number of years the
property is owned. I hope this makes sense. If anyone has direction for
this, I'd greatly appreciate it.

Thanks a million!