Completed
) Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel and Business Math - Future Value, Present Value and Periodic Payments for Annuities
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Cash Flow Pattern Diagram for Future Value and Irregular Cash Flows. Future Value Calculation of Savings Plan with Irregular Cash Flows, Hand Drawings & Diagram.
- 3 ) Excel Example 1: Calculate Future Value of Savings Plan with Irregular Cash Flows.
- 4 ) Cash Flow Pattern Diagram for Present Value Calculation of Irregular Future Cash Flows. Asset Valuation Calculation. Hand Drawings & Diagram.
- 5 ) Excel Example 2: Calculate Present Value of Irregular Future Cash Flows to determine Asset Valuation.
- 6 ) Define Terms for an Annuity
- 7 ) Cash Flow Pattern Diagram for Future Value and Present Value of Periodic Cash Flows
- 8 ) Excel Example 3: Calculate Future Value for Savings Plan with Periodic Cash Flow in an End Annuity. FV Function.
- 9 ) Excel Example 4: Calculate Present Value of Future Periodic Cash Flows (End Annuity) to determine Asset Valuation. PV Function.
- 10 ) 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.
- 11 ) 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.
- 12 ) Excel Example 7: Calculate PMT For a Home Mortgage Loan, Where Loan is Positive Present Value Amount. PMT Function.
- 13 ) Summary
