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

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

ExcelIsFun via YouTube Direct link

) Calculate total you can withdraw after retirement and how much you actually deposited while saving.

13 of 14

13 of 14

) Calculate total you can withdraw after retirement and how much you actually deposited while saving.

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. 1 ) Introduction
  2. 2 ) PMT function from Borrower point of view, End Payment
  3. 3 ) PMT with Begin Payment
  4. 4 ) PMT function from Lender point of view
  5. 5 ) PMT function with Balloon payment at end
  6. 6 ) PMT function when payments don't start for 1 year
  7. 7 ) RATE function: Adjusted APR when there are Points and Fees
  8. 8 ) PMT and other formulas: Create an Amortization Table
  9. 9 ) CUMIPMT function: to calculate total interest over the life of a loan
  10. 10 ) NPER function: How long to pay off your Credit Card Bill
  11. 11 ) FV to estimate what you will have at retirement
  12. 12 ) PMT to estimate how much you can withdraw each month after you retire
  13. 13 ) Calculate total you can withdraw after retirement and how much you actually deposited while saving.
  14. 14 ) PMT to calculate how much you have to save each month to have a million dollars when you retire.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.