Chapter 11 Financial Planning Exercise 1 Calculate amount to invest to meet objectives Use Worksheet 11.1. Phoebe Jones is now employed as the managing editor of a well-known business Journal. Although she thoroughly enjoys her job and the people she works with what she would really like to do is open a bookstore of her own. She would like to open her store in about seven years and figures she'll need about $ 70,000 in capital to do so. Given that Phoebe thinks she can make about 10 percent on her money, use Worksheet 11.1 to answer the following questions. 5. How much would Phoebe have to invest today, in one lump sum, to end up with $70,000 in seven years? Round the answer to two decimal places. $ b. If she's starting from scratch, how much would she have to put away annually to accumulate the needed capital in seven years? Round the answer to two decimal places. $ c. How about if she already has $20,000 socked away, how much would she have to put away annually to accumulate the required capital in seven years? Round the answer to two decimal places. d. Given that Phoebe has an idea of how much she needs to save, briefly explain how she could use an investment plan to help reach her objective Data Formulas Review View Home Page Layout Power Pivot Insert PROTECTED VIEW Be careful-Files from the Internet can contain viruses. Unless you need to edit, it's safer to stay i X fox =IF(126=0,0, ROUND(123/126,0)) F E D G H A B C DETERMINING AMOUNT OF INVESTMENT CAPITAL Financial goal: % 1.000 1.000 1. Targeted Financial Goal (see Note 1) 2. Projected Average Return on Investments A. Finding a Lump Sum Investment: 3. Future Value Factor, from Appendix A based on years to target date and a projected average return on investment of % 3 4. Required Lump Sum Investment 4 line 1+ line 3 $ 5 B. Making a Series of Investments over Time: _6 5. Amount of Initial Investment, if any (see Note 2) $ 17 6. Future Value Factor, from Appendix A 18 based on years of target date and a projected average 19 return on investment of % 20 7. Terminal Value of Initial Investment 21 line 5x line 6 22 8. Balance to come from Savings Plan 23 line 1 - line 7 $ 24 9. Future Value Annuity Factor, from Appendix B 25 based on years to target date and a projected average 26 return on investment of % 27 10. Series of Annual Investments Required over Time 28 line 8+ line 9 $ Note 1: The "targeted financial goal is the amount of money you want to accumulate by 30 some target date in the future. Note 2: If you're starting from scratch-I.e., there is no initial investment-enter zero on line 5, skip lines 6 and 7, and then use the total targeted financial goal (from line 1) as the amount to be funded from a savings plan; now proceed with the rest 31 of the worksheet. 32 $ . 0.00 . 33 34
