Entire page

1. Set up an a ortization schedule for a 5-year, S5 million, 8.5 % loan that requires equal anwend-of-year payments. Be sure to distinguish between the interest and principal portion of each payment. 2. Using the above information set up another amortization schedule showing equal nthly payments This is a spreadsheet problem. Follow the guideline in Table 2-4 Chapter 2, Page 53. DO IT EXACTLY as Table 2-4. The spreadsheet formulae for Schedule # 2 should be to set up the amortization schedule. If you do not know how to print the formulae printed and included. This means the EXCEL formulae developed by you and used embedded in Excel, please ask. This case should be properly presented, that is it must be typewritten. * Checked for MacBook Pro Discuss or list what can be done to save on interest charges for this loan. (Minus 2 points if not done). What is the effective interest rate? Show your calculation. (Minus 1 point if not shown). 3. Using (real) information from a credit card, mortgage, personal loan, or car note, create an amortization schedule showing how long it would take to pay off the jaun in the scheduled monthly payments are made. What advice would you give to the holder of the credit card, mortgage, loan, or car note? b. What is the effective rate? 4 See Wall Street Journal, Tuesday September 30, 2003: Personal Journal, Section D: Read article, "A Car Loan That Outlasts Your Car." The article mentioned that a $20,000 loan with an 8% interest rate over 8 years instead of a 5% loan over 5 years will slash payments by approximately $100, but will add $4,500 to interest cost. Problem: Set up amortization schedules for: a. A $30,000 car loan at 6.5% interest rate over 8 years b. A $30,000 car loan at 3.5% interest rate over 5 years. c. Calculate the exact difference in payments. d. Comment on the article using your knowledge of time value of money Instructions: spelling