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