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