Answered step by step
Verified Expert Solution
Question
1 Approved Answer
hmwk help, im not entirely sure if my numbers are right? When Yvonne was twelve, her grandfather gave her $5,000 to be used for college.
hmwk help, im not entirely sure if my numbers are right?
When Yvonne was twelve, her grandfather gave her $5,000 to be used for college. Yvonne was a good student and dreamed of going to a good school so she invested the gift in a 10-year bank CD earning 7%%. She received a generous scholarship and never needed to use the money from her grandfather. After graduating from college at age 22, she began working at a great job. Knowing the value of early investing. she began saving for retirement right away. When the CD matured she put it into an investment account earning 6% % and made an additional annual investment of $1,500 every January 14. She also opened an IRA account and put $2,000 into it every year on January 1" and over the years it earned a steady 7%. Now Yvonne is 45 and thinking she'd like to retire early at age 55. At age 65 she'll get an extremely generous corporate pension, which along with Social Security payments will allow her to live very well indeed. She believes that with clever investing strategies both of her accounts will be able to earn 8%. She plans to continue making the same annual contributions to her accounts until retirement. What Yvonne wants to know is whether her retirement savings will be able to provide enough income each year to allow her to live comfortably until age 65 when the pension kicks in. 1. How much was the CD worth when she transferred it into that investment account? 2. How much is the investment account worth now? 3. How much is the IRA account worth now? 4. How much will she have accumulated when she takes early retirement? 5. How much will she be able to withdraw each January 1" if she takes early retirement? Guidelines: 1. Number and briefly explain each of your steps 2. Show your inputs for each step using the TVM functions of Excel, not the financial calculator 3. Laying out your solution using a timeline may help you visualize the cash flows better 4. Follow the facts as given in the narrative, but list any additional assumptions you make 5. Complete the solution using Excel (xls or xlsx) - no other software/file format is acceptable 6.75% B C D E $ 5,000.00 7% 10 $10,068.00 Value of CD is solved by finding the future value by using the FV funtion. 1 1) 2 Initial amount invested in CD 3 Rate of return 4 Number of years 5 Value of CD when transferred 6 7 2) 8. Initial deposit in the account 9 Additional annual deposit 10 Number of deposits made 11 Rate of return 12 Value of investment amount 13 $10,068.00 1,500.00 23 7% $122,832.64 Value of investment amount is solved by finding the future value with a given PV and annual payment (assuming the additional payments begins in 1 year, ordinary annuity). 143) $ 23 2,000.00 796 $118,402.03 Value of IRA account is solved by finding the future value of the payments (assuming that the payments start now, annuity due) $ 15 Number of deposits 16 The value of the deposit 17 Rate of return 18 Value of IRA account 19 2014) 21 Total accumulated amount now 22 Years till early retirement 23 Rate of return 24 Amount accumulated at retirement 25 26 5) 27 Amount accumulated 28 Number of withdrawls 29 Rate of return 30 Value of each withdrawl 31 241,234.68 10 8% $520,807.57 The accumulated amount at retirement is solved by finding the future value of the amount accumulated 10 years from now $520,807.57 10 8% $71,866.38 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started