Completed
) PMT to calculate how much you have to save each month to have a million dollars when you retire.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Highline Excel 2016 Class - Financial Functions: PMT, RATE, NPER and FV Examples
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) PMT function from Borrower point of view, End Payment
- 3 ) PMT with Begin Payment
- 4 ) PMT function from Lender point of view
- 5 ) PMT function with Balloon payment at end
- 6 ) PMT function when payments don't start for 1 year
- 7 ) RATE function: Adjusted APR when there are Points and Fees
- 8 ) PMT and other formulas: Create an Amortization Table
- 9 ) CUMIPMT function: to calculate total interest over the life of a loan
- 10 ) NPER function: How long to pay off your Credit Card Bill
- 11 ) FV to estimate what you will have at retirement
- 12 ) PMT to estimate how much you can withdraw each month after you retire
- 13 ) Calculate total you can withdraw after retirement and how much you actually deposited while saving.
- 14 ) PMT to calculate how much you have to save each month to have a million dollars when you retire.
