Please show the formulas used in each cell.

A Chapter 11B Home Insert Draw Page Layout Formulas Data Review view Automate Acrobat & Tell me c F h 1 k L u N 0 P Construct a model that calculates TOTAL RETIREMENT BALANCE at age 60 given: Slastling salary $75,000 at age 24 . Company match of 5% of pre-tax salary for 401(k) Salary incereases 4% peryear. Contribuke 15% of pre-tax incorre to 401(k) arcourt up to $18,000. Individuals under age 50 can contribute 56,500 bo their Roth 1 RA annually, and individuals 50 and over can contribute $7,500 into a Roth IRA. Invest in Vanguard Balanced Index Fund, eaming 6% per year (401K) and Boston Trust Aeset Management Fund eaming 6.5% per year (Roth 1RA. ANsWLR: How much mure is in your retiremernt accourt at age 60? ANSWER: What If you carn 7 . arrual retum on your Ab1kik? Age 24 25 2627 28 29 30 31 32 33 34 37 38 39 40 41 Ab1x Contribution Employer Match 401K Tutal input. 401K Balance (Includuling Interest) BOTH IRA ROTH IRA Balance (Inelueding Interest) TOTAL RETIREMENT BALANCE A Chapter 11B Home Insert Draw Page Layout Formulas Data Review view Automate Acrobat & Tell me c F h 1 k L u N 0 P Construct a model that calculates TOTAL RETIREMENT BALANCE at age 60 given: Slastling salary $75,000 at age 24 . Company match of 5% of pre-tax salary for 401(k) Salary incereases 4% peryear. Contribuke 15% of pre-tax incorre to 401(k) arcourt up to $18,000. Individuals under age 50 can contribute 56,500 bo their Roth 1 RA annually, and individuals 50 and over can contribute $7,500 into a Roth IRA. Invest in Vanguard Balanced Index Fund, eaming 6% per year (401K) and Boston Trust Aeset Management Fund eaming 6.5% per year (Roth 1RA. ANsWLR: How much mure is in your retiremernt accourt at age 60? ANSWER: What If you carn 7 . arrual retum on your Ab1kik? Age 24 25 2627 28 29 30 31 32 33 34 37 38 39 40 41 Ab1x Contribution Employer Match 401K Tutal input. 401K Balance (Includuling Interest) BOTH IRA ROTH IRA Balance (Inelueding Interest) TOTAL RETIREMENT BALANCE