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

) 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.