Download Files: [ Ссылка ]
In this video learn about:
(00:01) Introduction
1. (02:22) PMT function from Borrower point of view, End Payment
(07:10) PMT with Begin Payment
2. (08:19) PMT function from Lender point of view
3. (09:25) PMT function with Balloon payment at end
4. (11:17) PMT function when payments don't start for 1 year
5. (17:20) RATE function: Adjusted APR when there are Points and Fees
6. (23:23) PMT and other formulas: Create an Amortization Table
7. (29:49) CUMIPMT function: to calculate total interest over the life of a loan
8. (30:41) NPER function: How long to pay off your Credit Card Bill
9. (32:20) FV to estimate what you will have at retirement
10. (35:16) PMT to estimate how much you can withdraw each month after you retire
11. (36:55) Calculate total you can withdraw after retirement and how much you actually deposited while saving.
12. (38:25) PMT to calculate how much you have to save each month to have a million dollars when you retire.
Full 111 video Finance class at YouTube: [ Ссылка ]
