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 For a custom paper on the above topic, place your order now! What We Offer: ¢ On-time delivery guarantee ¢ PhD-level writers ¢ Automatic plagiarism check ¢ 100% money-back guarantee ¢ 100% Privacy and Confidentiality ¢ High Quality custom-written papers
