Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I increase a column of numbers by a percentage-same cell | Excel Discussion (Misc queries) | |||
Implied Compound Interest? | Excel Worksheet Functions | |||
Linea increase | Excel Discussion (Misc queries) | |||
Amount of Increase of Wages | Excel Worksheet Functions | |||
Compound Rate of Return | Excel Worksheet Functions |