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

) PMT function when payments don't start for 1 year

6 of 14

6 of 14

) PMT function when payments don't start for 1 year

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.