Excel and Business Math - Future Value, Present Value and Periodic Payments for Annuities

Learn how to calculate future value, present value, and periodic payments for annuities and irregular cash flows in this comprehensive 51-minute video tutorial. Master Excel functions like FV, PV, and PMT to solve financial problems including savings plans, asset valuations, and mortgage loans. Explore cash flow pattern diagrams, hand drawings, and practical examples to understand concepts such as end annuities, irregular cash flows, and loan calculations. Download accompanying Excel files and PDF notes to follow along and reinforce your learning.

) Introduction.
) Cash Flow Pattern Diagram for Future Value and Irregular Cash Flows. Future Value Calculation of Savings Plan with Irregular Cash Flows, Hand Drawings & Diagram..
) Excel Example 1: Calculate Future Value of Savings Plan with Irregular Cash Flows..
) Cash Flow Pattern Diagram for Present Value Calculation of Irregular Future Cash Flows. Asset Valuation Calculation. Hand Drawings & Diagram..
) Excel Example 2: Calculate Present Value of Irregular Future Cash Flows to determine Asset Valuation..
) Define Terms for an Annuity.
) Cash Flow Pattern Diagram for Future Value and Present Value of Periodic Cash Flows.
) Excel Example 3: Calculate Future Value for Savings Plan with Periodic Cash Flow in an End Annuity. FV Function..
) Excel Example 4: Calculate Present Value of Future Periodic Cash Flows (End Annuity) to determine Asset Valuation. PV Function..
) Excel Example 5: Calculate PMT When Present Value Amount is Known. How Much Can We Withdraw at End of Each Month for Next 30 Years? PMT Function..
) Excel Example 6: Calculate PMT When Future Value Amount is Known. How Much Should I Deposit at the End of Each Month to Become Millionaire? PMT Function..
) Excel Example 7: Calculate PMT For a Home Mortgage Loan, Where Loan is Positive Present Value Amount. PMT Function..
) Summary.