example of amortization schedule for a note with equal total payments
DESCRIPTION
Example of Amortization Schedule for a Note with Equal Total Payments. The following example is based on information from Exercise 14-11 in your textbook. This problem is assigned as Question 1 in Homework Manager. Problem Data:. Requirements:. Before proceeding, click below - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/1.jpg)
Example of Amortization Schedule
for a Note with Equal Total Payments
The following example is based on information from Exercise 14-11 in your textbook. This problem is assigned as Question 1 in Homework Manager.
![Page 2: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/2.jpg)
On January 1, 2008, Eagle borrows $100,000 cash by signing a four-year, 7% installment note. The note requires four equal total payments of accrued interest and principal on December 31 of each year from 2008 through 2011.
Problem Data:
Requirements:
1. Compute the amount of each of the four equal total payments using the present value table B.3.
2. Prepare an amortization schedule for the installment note.
![Page 3: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/3.jpg)
Before proceeding, click belowfor a printable copy of the
example so that you can work along with the presentation.
Print the Problem and Schedule
![Page 4: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/4.jpg)
Compute the Equal Total PaymentsUsing Table B.3, find the present value factor for four years at 9% interest (from problem data) by reading across from the period and down from the rate.
![Page 5: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/5.jpg)
Compute the Equal Total PaymentsUsing Table B.3, find the present value factor for four years at 9% interest (from problem data) by reading across from the period and down from the rate.
![Page 6: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/6.jpg)
Compute the Equal Total PaymentsUsing Table B.3, find the present value factor for four years at 9% interest (from problem data) by reading across from the period and down from the rate.
![Page 7: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/7.jpg)
Compute the Equal Total Payments
The note payment is computed by dividing the principal by the present value factor.
Principal: $100,000 / PV Factor: 3.3872 =Payment: $29,523 (rounded to the nearest whole dollar)
![Page 8: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/8.jpg)
Complete the Amortization Schedule•Enter the principal in the Beginning Balance blank.
![Page 9: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/9.jpg)
Complete the Amortization Schedule
100,000
•Enter the principal in the Beginning Balance blank.
![Page 10: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/10.jpg)
Complete the Amortization Schedule
100,000
•Enter the principal in the Beginning Balance blank.•Calculate Interest Expense by multiplying the beginning balance by the interest rate stated on the note ($100,000 X .07)
7,000
![Page 11: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/11.jpg)
Complete the Amortization Schedule
100,000
•Enter the principal in the Beginning Balance blank.•Calculate Interest Expense by multiplying the beginning balance by the interest rate stated on the note ($100,000 X .07)•Enter the equal total payment amount in the Credit Cash blank (calculated in Slide 7.)
7,000 29,523
![Page 12: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/12.jpg)
Complete the Amortization Schedule
100,000
1. Enter the principal in the Beginning Balance blank.2. Calculate Interest Expense by multiplying the beginning balance by the
interest rate stated on the note ($100,000 X .07)3. Enter the equal total payment amount in the Credit Cash blank.4. Determine the amount of principal reduction to be debited to Notes
Payable by finding the difference between the cash payment and the amount charged to interest ($29,523 - $7,000).
7,000 29,52322,523
![Page 13: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/13.jpg)
Complete the Amortization Schedule
100,000
1. Enter the principal in the Beginning Balance blank.2. Calculate Interest Expense by multiplying the beginning balance by the interest
rate stated on the note ($100,000 X .07)3. Enter the equal total payment amount in the Credit Cash blank.4. Determine the amount of principal reduction to be debited to Notes Payable by
finding the difference between the cash payment and the amount charged to interest ($29,523 - $7,000).
5. Calculate the Ending (principal) Balance as Beginning Balance less the principal reduction debited to Notes Payable ($100,000 - $22,523) and place the ending balance for this period in the Beginning Balance blank for the next period.
7,000 29,52322,523 77,477
77,477
![Page 14: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/14.jpg)
Complete the Amortization Schedule
100,000
1. Enter the principal in the Beginning Balance blank.2. Calculate Interest Expense by multiplying the beginning balance by the interest
rate stated on the note ($100,000 X .07)3. Enter the equal total payment amount in the Credit Cash blank.4. Determine the amount of principal reduction to be debited to Notes Payable by
finding the difference between the cash payment and the amount charged to interest ($29,523 - $7,000).
5. Calculate the Ending (principal) Balance as Beginning Balance less the principal reduction debited to Notes Payable ($100,000 - $22,523) and place the ending balance for this period in the Beginning Balance blank for the next period.
6. Repeat steps 2-5 through year 2010.
7,000 29,52322,523 77,477
![Page 15: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/15.jpg)
Complete the Amortization Schedule
See if you can complete the note amortization schedule through year 2010 on the problem sheet you printed out. Round your interest expense to the nearest whole dollar.
Check your answers on the following slide.
![Page 16: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/16.jpg)
Complete the Amortization Schedule
100,000 7,000 29,52322,523 77,477
100,000
77,477 53,37724,1005,423 29,523
29,52353,377 3,736
![Page 17: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/17.jpg)
![Page 18: Example of Amortization Schedule for a Note with Equal Total Payments](https://reader036.vdocuments.us/reader036/viewer/2022062309/568148b8550346895db5d2b0/html5/thumbnails/18.jpg)