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

Dive into a comprehensive 41-minute video tutorial on Excel 2016's financial functions. Learn to use PMT, RATE, NPER, and FV functions through 12 practical examples. Master calculating loan payments from both borrower and lender perspectives, handling balloon payments, and adjusting for delayed payment starts. Explore how to determine adjusted APRs with points and fees, create amortization tables, and calculate total interest over a loan's lifetime. Discover techniques for estimating credit card payoff timelines, projecting retirement savings, and planning withdrawal strategies. Apply these skills to real-world scenarios, from million-dollar retirement goals to optimizing monthly savings plans. Access downloadable files and a full 111-video finance class for further learning.

Syllabus

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