5. Amortization Table Create an amortization table for the best AFFORDABLE options. Note: you must recalculate...

Transcribed Image Text:

5. Amortization Table Create an amortization table for the best AFFORDABLE options. Note: you must recalculate the payment amount for the table. Do not type the payment figure in. To do the amortization table: Include an input section with all the given variables: price, % down, etc. Label headings for each column of data 2 The first column is the payment number. Print out the worksheet to include only the first 25 payments on one page and the last 25 payments on a second page. I want two pages of printout. Be sure to print out with headings at the top of each column on all printed pages. (Use Print Titles). Submit a formula sheet for only the first 25 payments. 6. Look at your amortization table and tell the couple: a. The number of years and months that 4 of the loan is paid off. b. The number of years and months that of the loan is paid off. c. The number of years and months that % of the loan is paid off. d. The year and month when the payment is equally split between the interest payment and principal payment. To do this: add a column to the right of the remaining balance to determine how much is paid off with each payment to help you easily see where 25% is paid, 50% etc. No print out. Include results in analysis report. 7. Toni wants to know what would happen if they were to pay an extra payment once a year (make this extra payment occur at every 12th payment). This payment will solely be applied to principal. To solve, you will need to modify your amortization table from #5 above. Once you add the modifications, use it to answer the following: a. When will the Truffels pay off the mortgage if they were to make this extra payment? b. What is their interest savings with the extra payment compared to the original mortgage? 5. Amortization Table Create an amortization table for the best AFFORDABLE options. Note: you must recalculate the payment amount for the table. Do not type the payment figure in. To do the amortization table: Include an input section with all the given variables: price, % down, etc. Label headings for each column of data 2 The first column is the payment number. Print out the worksheet to include only the first 25 payments on one page and the last 25 payments on a second page. I want two pages of printout. Be sure to print out with headings at the top of each column on all printed pages. (Use Print Titles). Submit a formula sheet for only the first 25 payments. 6. Look at your amortization table and tell the couple: a. The number of years and months that 4 of the loan is paid off. b. The number of years and months that of the loan is paid off. c. The number of years and months that % of the loan is paid off. d. The year and month when the payment is equally split between the interest payment and principal payment. To do this: add a column to the right of the remaining balance to determine how much is paid off with each payment to help you easily see where 25% is paid, 50% etc. No print out. Include results in analysis report. 7. Toni wants to know what would happen if they were to pay an extra payment once a year (make this extra payment occur at every 12th payment). This payment will solely be applied to principal. To solve, you will need to modify your amortization table from #5 above. Once you add the modifications, use it to answer the following: a. When will the Truffels pay off the mortgage if they were to make this extra payment? b. What is their interest savings with the extra payment compared to the original mortgage?