Amortization Table
Video:
The speaker explains how to create an Amortization Table with an additional payment column in excel. The amortization table shows how much of each monthly payment is credited towards interest and how much is credited towards principal.
Video:
The speaker talks about how to create an amortization table in Microsoft Excel using the CUMIPMT & CUMPRINC functions to calculate net interest paid and net principal paid figures without having to create an amortization table.
An amortization table, or schedule, provides details around each of the periodic payments that are made on a loan, typically a mortgage. The amortization schedule provides insight into the specific dollar amounts that go towards the interest and principal components of your loan payment.
|
|
| Day Trading | |
 |
Learn winning day trading strategies for profiting in the stock market. |
| Technical Analysis | |
 |
Learn about chart patterns, candlesticks, and technical indicators. |
| Options | |
 |
Learn all about collars, straddles, strangles and a host of other options trading strategies. |
| Personal Finance | |
 |
Advice on retirement planning, college saving, mortgages, and real estate. |
| Value Investing | |
 |
Discover how to identify undervalued stocks that have strong fundamentals. |
| Bonds | |
 |
Learn about the different types of bonds available to investors. |