Answers to the odd numbered problems are at the end of the book. BERCISE 12.1 corect y completed Excel template developed in Section 10.5 for calculating the any of the problems in Exercise 12.1. Go to Chapter 10 of the OLAS made to a TFSA for 25 years. The contributor expects compounded annually. What will the TFSA be worth to Part (b) exceed the answer to Part (a)? be made to an RESP for 15 years. Assuming that the grow at 8% compounded quarterly, how much will the TFSA mage does the answer to Part (b) exceed the answer to Part (a) $100 invested at the beginning of every month for 25 years if at the beginning of every six months. If the investments earn Spreadsheet template: The partially completed Excel ter future value of any annuity may be used for many of the proce Student Edition and find "FV of Any Annuity." 1. Annual contributions of $1000 will be made to a TFSA investments within the plan to earn 7% compounde after 25 years if the contributions are made: a. At the end of each year? b. At the beginning of each year? c. By what percentage does the answer to Part (b) exceed Quarterly contributions of $1000 will be made to an RESP investments within the plan grow at 8% compoun be worth after 15 years if the contributions are made a. At the end of each quarter? b. At the beginning of each quarter? 6. By what percentage does the answer to 3. What is the future value of $100 invested at the beginn the investments earn: a. 4% compounded monthly? b. 8% compounded monthly? 4. Svetlana intends to invest $1000 at the beginning of every six months. ded semiannually, what will her investments be worth (rounded to the nearest dollar) after: a. 25 years? b. 30 years? 5 our client plans to invest $10.000 at the beginning of each year for the next 14 years. If the invested funds earn 5.1% compounded annually, what will be the total accumulated value after 14 years? 6. Your client has systematically contributed $3000 to her RRSP at the beginning of every three months for the past 17 years. If the RRSP has earned 8.8% compounded quarterly, what is its value today? 7. Today Gus is making his first annual contribution of S2500 to a TFSA. How much will the plan be worth 16 years from now if it earns 5.25% compounded monthly? 8. Astrid has just opened an RESP for her children with her first quarterly deposit of $1700. What will the RESP be worth 11 years from now if the investments within the plan earn 7.5% compounded semiannually? 9. Salvatore will contribute $500 to a mutual fund at the beginning of each calendar quarter. a. What will be the value of his mutual fund after 6 years if the fund earns 7.6% compounded annually? b. How much of this amount represents investment earnings? 10. Monarch Distributing Ltd. plans to accumulate funds for the purchase of a larger warehouse seven years from now. If Monarch contributes $10,000 at the beginning of each month to an investment account earning 4.5% compounded semiannually, what amount (rounded to the nearest dollar) will Monarch accumulate by the end of the seven years? 11. If Hans contributes $1500 to his RRSP on February 1, 1990, and every six months thereafter up to and including February 1, 2017, what amount will he accumulate in the RRSP hul August 1, 2017? Assume that the RRSP will earn 8.5% compounded semiannually. How much of the total will be earnings