Step 1: Create a Loan Amortization
Schedule
In this first step of your project, you’ll need to create a loan amortization schedule. The following table illustrates the payments and interest amounts for a fixed-rate, 30-year mortgage
loan. The total amount of the mortgage is $300,000, and the interest rate is 6 percent. This mortgage requires monthly payments of $1,798.65, with a final payment of $1,800.23.
The table was created in Excel.
The following is an explanation of the columns in the table:
The first column in the table, with the heading “Payment Number,” shows the 360 payments required to pay off the mortgage loan (30 years, with 12 monthly payments per year).
Step 2: Create a Depreciation
Schedule
Step 3: Create a Schedule Combining
Interest Expenses and Depreciation Expenses
Step 4: Convert the Interest Expense and Depreciation Expense
Step 5: Calculate the Aftertax Cash Outflows
