How to calc. Inflation in a spreadsheet

S

SarahAnne

I am trying to calculate the Growth in Deposit for years 3,4,5,6... with
inflation added in and increasing the 100,000 every year.

Here is all of the information given:
Initial Deposit 100000
Annual Dposit 250000
Gorwth of Deposit 3%
Start Year 3
End Year 6
Account Growth 6%
Tax Rate on Growth 30%

I already have a spreadsheet with the Year, Beg. of Year Balance,
Deposit (This column is not filled in) and then the balance.

HELP! I don't know the formula for this at all... Any suggestions

Sarah
 
Top