Overview
1. Create the loan amortization schedule
2. Create the depreciation schedule.
3. Create the schedule that combines interest expenses and depreciation expenses.
4. Create a schedule that converts the interest expense and depreciation expense to after tax dollars
5. Create a schedule that shows the after tax cash out flows...see information below.
Create and loan amortization schedule in Excel spreadsheet - determine how each of the amounts in the table are obtained, calculate them and fill them in for all 360 payments. Note the table shows only the figures for the first two payments and the last two payments; calculate the amounts for the remaining payments and fill them in.
Attachment:- CFinance.docx