Excel Time Value of Money Functions for CPAs

Course Description:

The purpose of this course is to teach students about the various time value of money concepts. The course covers many topics such as the Excel time value of money functions, the present value of a single sum, the future value of a single sum, new single sum functions in Excel 2013 and more!

Learning Objectives:

Upon successful completion of this course, participants will be able to:

• Identify which Excel time value of money function should be used in a given circumstance
• Associate compounding periods with the appropriate adjustments to rate and number of periods
• Identify Excel’s sign convention
• Recognize how to solve for rate, number of periods and payment
• Recognize how to use Capital budgeting for internal rate of return and net present value
• Recognize how to use data tables to present alternatives