Excel Time Value of Money Functions for CPAs
SKU: 02-068-01-CPE
Credit Hours: 4
Level: Overview
CPE Category: Computer Software and Applications-Non Technical
Requires Prerequisites or Advanced Preparation: No
Delivery Method: PDF
Instructor: Joseph P. Helstrom, CPA
Course Description:
This course uses practical examples to provide an overall understanding of time value of money concepts and to illustrate time value of money functions in Microsoft Excel.
At the end of this course, students 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