The objective of this competency exercise is to demonstrate your ability to use an Excel Spreadsheet for a simple exercise demonstrating the savings of an individual at retirement, depending on such factors as amount saved, interest rate, etc.

All necessary information is given. Your job is to type in the spreadsheet exactly, step by step as given below and follow the directions to complete the retirement projections. Also, once you are done, note the ease of changing the assumptions, and doing "what$-$if$"($sensitivity analysis$)$ on the result! The reason that this is easy is the way that we have shown you to separate the assumptions $($parameters$)$ from the formulas in the model.

The beginning layout for the spreadsheet is given below.

Once you have the correct formulas in row $12,$ simply copy that row down $($drag$,$ or use the copy command$)$ through row $53.$

Once you complete the spreadsheet file, you may show the formulas $($e$.$g$.,$ under Excel $2016,$ select Tools, Options, and then check Formulas, either way, using the short$-$cut key: Ctrl$+).$ Please make sure to save your work and submit the spreadsheet file on time.

Table: Illustration of the Spreadsheet

$\backslash$table$[[,$Column A$,$Column B$,$Column C$,$Column D$,$Column E$],[$Row$1,,\backslash$table$[[$Your Last$],[$Name$]],$First Name,Section #$,],[$Row$2,,,,,],[$Row$3,,,,,],[$Row$4,,$Starting,Age,$25,],[$Row$5,,$Starting,Salary,$35000,],[$Row$6,,$Raise,Percent,$1\mathrm{.}04,],[$Row$7,,$Savings,Rate,$0\mathrm{.}1,],[$Row$8,,$Savings,Cap,$10000,],[$Row$9,,$Interest,Rate,$0\mathrm{.}05,],[$Row$10,$Age,Salary,Saving,Interest,Balance$],[$Row$11,=$D$4,=$D$5,=$MIN$($B$11^(*)$:$\}$ $D$$7,$$D$$8),=$$D$$9*($C$11/2),=$C$11+$D$11],[$Row$12,=$A$11+1,=$B$11*$$D$$6,=$MIN$($B$12^(*)$$D$$7,$$D$$8),=$$D$$9^(*)(($C$12/2)+$E$11),=$E$11+$C$12+$D$12]]$

CAN YOU PLEASE HELP ME WITH EXEL SHEET