Highline Excel 2016 Class 24: Financial Functions: PMT, RATE, NPER and FV 12 Examples





The interactive transcript could not be loaded.


Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jul 7, 2016

Download Files: https://people.highline.edu/mgirvin/A...
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: http://www.youtube.com/playlist?list=...


When autoplay is enabled, a suggested video will automatically play next.

Up next

to add this to Watch Later

Add to

Loading playlists...