Listen to this post if you prefer
*** You can get the Excel file by accessing the full free tutorial here. ***
In this FREE hands-on-the-keyboard “build it together” Excel tutorial, you will learn how to model an amortization schedule table for a senior mortgage loan. The flexible tool you will build supports fixed and floating rate interest, an interest-only period on the front end of the loan, a floor and cap on floating rates, and balloon repayment from multiple sources: a permanent loan, residential component sale, and retail component sale.