interest/inflation formula help

[S]

Could someone please do this formula for me.

£300,000 to work out its worth each year (including interest) Then deduct
cost of living % (inflation) each year.

So £300,000 (at 6% interest) = £318000 deduct (inflation at say 3%)=
£308460 (this would be its net worth say after one year

I would use rows A1 to J10 for the actual amounts

and would use 2 cells in row 2 for the interest rate and for the inflation
figure, this way I could change the rates without altering the formula.


I hope this makes sense.

thanks

 

[OssieMac]

There are a heap of financial functions built into excel. Look up PV (present
value) in Help and also refer to the 'See also' which lists the other
financial functions. I am sure you will find something there to help you.