Excel Magic Trick 43: PMT & Amortization Table
ExcelIsFun
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.
|
|
|
Tem ainda a possibilidade de registar as transac??es efectuados (booked) e os lucros/perdas obtidas.
Encontra ainda cota??es com delay m?nimo de 15 minutos para as ac??es dos principais mercados europeus e americanos assim como a cota??o dos principais ?ndices, permitindo de uma forma visual aferir a tend?ncia geral do mercado nesse momento. | Screencast Tags | | account, Amortization, College, Community, consumer, Excel, finance, financial, function, Gel, Girvin, Highline, loan, Mike, PMT, tax |
| |