Excel Time Value of Money Functions for CPAs
SKU: CPE-07-068
Credit Hours: 4
Level: Basic
Field of Study: Specialized Knowledge
Requires Prerequisites or Advanced Preparation: No
Delivery Method: Online PDF
Instructor: Joseph P Helstrom, CPA
Upon completion of this course, you should 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