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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding required growth rate 0
How do I calculate interest? 1
Reduction in Growth 4
Impact of Fees on Growth Rate 1
rate of return formula 2
Need a formula for my personal finance spreadsheet 12
What is the formula to get projected growth 4
interest/inflation formula help 1

Top