8. Amortization Schedules

8. Amortization Schedules

    This course will teach you how to prepare an amortization schedule for a loan. An amortization schedule is important to a person who has borrowed money as it clearly shows them the breakdown of each individual loan payment and how much of that payment is applied to the principal of the loan and how much is applied to the interest expense on the loan.

            Amortization of loans is a perfect example of an annuity where the amount of the loan is treated as the present value and the (annuity) payments are applied to the loan so as to reduce the loan to zero by the end of the payment period.

            You will also learn how to jump into an amortization schedule after any number of payments have been made and also how to determine the size of the final payment if it a payment that is not the same size as the regular payments. 

      You will be provided with a workbook within which to work on the examples. The workbook includes the examples that will be discussed during the video lectures and gives you the space to complete the examples.  You can use the completed workbook as your reference. 

      The course will take you about 2-3 hours to complete although this time will vary among different students. 

A simple guide to the preparation of amortization schedules

Url: View Details

What you will learn

• You will be able to construct a full amortization schedule when required
• you will be able to jump into any row of an amortization schedule

Rating: 4.66667

Level: All Levels

Duration: 1 hour

Instructor: Helen Dakin