Hello,
I am trying to get my mind around how to project a future cost of replacing
a piece of capital equipment. I can do it for a calendar year but since we
are on a July to June year the costs may or may not fall into the correct
year heading. Here is where I am so far:
=IF(YEAR($O2)+$AA2=AC$1,ABS(FV($AB2,$AA2,0,$S2,1)) ,0)
with: O2 being the purchase date of the original capital equipment
AA2 being the useful life or time in years before we need to replace the
capital equipment.
AC1 being a year or fiscal year column ie. 2007, 2008,.... where the
replacement cost of the capital equipment would calculate
AB2 being the cost inflator ie. 1.5%
S2 being the cost of the equipment when originally pruchased.

As always thanks for your help.