Answer the given questions and complete the following problems, as applicable. Unless otherwise directed, assume annual compounding periods in computational problems.
You may solve the following problems algebraically, or you may use a financial calculator or Excel spreadsheet. If you choose to solve the problems algebraically, be sure to show your computations. If you use a financial calculator, show your input values. If you use an Excel spreadsheet, show your input values and formulas.
Note: In addition to your solution to each computational problem, you must show the supporting work leading to your solution to receive credit for your answer.
Problem 1. Would you rather have a savings account that paid 4 percent interest, compounded on a monthly basis, or one that compounded interest on an annual basis. Why?
Problem 2. What is an amortization schedule, and what are some of its uses?
Problem 3. "The interest on your home mortgage is tax deductible. Why are the early years of the mortgage more helpful in reducing taxes than in the later years?" (Cornett, Adair, and Nofsinger, 2012, p. 115).
Problem 4. What is the difference between an ordinary annuity and an annuity due?
Problem 5. "What is the future value of a $500 annuity payment over five years if interest rates are 9 percent?" (Cornett, Adair, and Nofsinger, 2012, p. 116). Recalculate the future value at 8 percent interest, and again, at 10 percent interest.
Problem 6. "What is the present value of a $700 annuity payment over four years if interest rates are 10 percent?" (Cornett, Adair, and Nofsinger, 2012, p. 116). Recalculate the present value at 9 percent interest, and again, at 11 percent interest.