See the Beauty of the PMT function and an Amortization Table. For consumers, you can see how much the bank takes from you each month as interest and how much is left over for the loan reduction. For accountants (financial and tax), you can see how much of each cash flow goes toward an Expense and how much reduces the liability by. For financers, you can see how much of the cash flow actually reduces the liability by and how much the deduction on a tax form would be.

Leave a Reply