A loan can be of two types, a fixed interest rate for the life of the loan or a variable interest rate. The variable interest rate loans often tied to a published index such as the London Interbank Offered Rate plus a fixed percentage. This video explains in detail how you can create a Amortization Schedule for a loan with variable rate of interest at different periods.

To download the practice Excel file please click on the link below
[ Ссылка ]

To learn different ways to create loan amortization schedule please click on the link below
[ Ссылка ]

свернуть