Question
2. Spreadsheet 2: Calculate the future value ofyour retirement investment. Assume you have invested toward retirement m SI 02000 in stock (equines): two bonds
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667ed4b3ddff1_019667ed4b3c680e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667ed4b43501b_020667ed4b421378.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667ed4b47a0e0_020667ed4b465d21.jpg)
2. Spreadsheet 2: Calculate the future value ofyour retirement investment. Assume you have invested toward retirement m SI 02000 in stock (equines): two bonds (assume face value) and a S2OO savings account _ Calculate what these Investments Will be upon your retirement. Usmg function mzard, calculate the future value of Y2ur savmgs account and your stock InvestmenW SAVINGS TOTAL Annual average gr owth Rate: YN to ears) Slo:oaa Future Value It should be apparent that this initial inveshnent of stocks: bonds and savings: even adjusted for stock appreciation and bond mterest: not be enough to get vou to >our (Part I) calculated nest e" desired! (Unless: ofcourr, voudon'tretirefor a few hundred years) So let's go on. 3) Spreadsheet 3: Now we know what you need, let's calculate additional annual savings required to reach this retirement goal. You have just created 3 possible retirement find goals for yourself: low: medium, and high Now are able to calculate what vou need ro setting aside each vear a by 2) to achieve Y2ur retirement goals, in dae given amcnmt of time you have assigned vourself Put die future value ofY3ur stock: bond and accounts in the table below, then calculate the rest. a) Retirement Goal b) Future Value of Stock, Bonds: and Savings c) Additional Funds needed upon retirement d) Annual savings required to build (d) Low TOTAL: $45,858 = $36,165 = S6,051 Sn'ingn SS, 642 $994, 721 $29,464 Medium Spreadsht I (vui wi low, Spreadsht 2 (s m for uch wd (for a rate, u = to PV = FV = of c
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started