To Access This Course:
Time value of money acknowledges that money has a different value today than it does in the future. In simplest terms, it can be described with the question “Would you rather have $100,000 today or $100,000 10 years from now?” Most would rather have the $100,000 today because they could invest it and earn more. Excel's time value of money functions permit you to quantify the value of $100,000 today versus $100,000 ten years from now in a variety of ways. This course explores Excel Time Value of Money Functions for CPAs.
Learning Objectives
- Identify which Excel time value of money function should be used in a given circumstance
- Discover how to 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 (IRR) and net present value (NPV)
- Recognize how to use data tables to present alternatives
Last updated/reviewed: September 24, 2018
Prerequisites
Course Complexity: Foundational
No advanced preparation or prerequisites are required for this course.
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .