B
BigIdeazLittleSkill
I need a formula to calculate compound savings based on salary defferal that
will compound based on a variable (montly,quarterly,annually) as well as
based on variable rate of return, employer match % and salary increase%.
So basically I want to take an monthly salary $6000, figure out a monthly
deferral based on salary (say 2% or $120 ) plus Employer match %(say 2% or
$120 as well) for a total monthly investment of $240 compounded monthly at
7% for year 1.
Then have it increase based on an annual increase rate (say 3% or
$180/month) and repeat for a set number of years (like 20).
Ideally I'd have a list of variables I could enter in to customize this report
I'd like to be able to see a 10 year report for the year end value.
will compound based on a variable (montly,quarterly,annually) as well as
based on variable rate of return, employer match % and salary increase%.
So basically I want to take an monthly salary $6000, figure out a monthly
deferral based on salary (say 2% or $120 ) plus Employer match %(say 2% or
$120 as well) for a total monthly investment of $240 compounded monthly at
7% for year 1.
Then have it increase based on an annual increase rate (say 3% or
$180/month) and repeat for a set number of years (like 20).
Ideally I'd have a list of variables I could enter in to customize this report
I'd like to be able to see a 10 year report for the year end value.