Money Management Formative Assignment (interim).
josgakob
guidedance.docxthe assignment is attached.
find the below guidance
1. Set an annual savings rate and escalate it by inflation 2. Calculate interest by applying your interest rate to the capital of the year before. 3. Get the new capital by adding to the previous year's capital the annual saving and the interest earned. 4. Reach a nest -egg at the age of retirement. 5. Draw this down to zero over your years in retirement, again escalating the withdrawal with inflation. The equations you need in Excel are the simplest: multiplying the annual saving rate by 1+the inflation rate (expressed as decimal, of course) multiplying the previous year's end capital by 1+ the interest rate You should use the $ sign to freeze the two rates in your equations Add the savings input plus interest earned to get the new capital year by year/
and find below my information
