This course on Financial Functions in Excel 2016 aims to teach learners how to utilize functions such as PMT, RATE, NPER, and FV for various financial calculations. By the end of the course, students will be able to create amortization tables, calculate total interest on loans, estimate retirement savings, and determine monthly savings needed for specific financial goals. The course employs a tutorial-based teaching method using real-life examples to demonstrate the application of each function. This course is intended for individuals interested in financial analysis, accounting, or anyone looking to enhance their Excel skills for financial management purposes.
Highline Excel 2016 Class - Financial Functions: PMT, RATE, NPER and FV Examples
ExcelIsFun via YouTube
Overview
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..
Taught by
ExcelIsFun
