more
Joe Helstrom, CPA
Joe has over 30 years of experience as a CPA in both public accounting and industry with extensive experience in financial reporting and analysis, treasury, tax, information technology, and legal and regulatory matters.
This instructor has 42 courses »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: May 23, 2022
8 Reviews (26 ratings)Reviews
Rodney Troyer
( at Wayne Garage Door)
I've often played around with the financial formulas in Excel, but found them slightly confusing. This course puts a lot of knowledge in a concise format that was easy to understand, and, the examples given made it easy to verify how it actually worked with real numbers.
Anonymous
(CPA / Owner)
Clear instructions in text for applicable functions to use for specific scenarios. Took me a while to complete the problems since I don't routinely use the functions, but I learned them well.
Anonymous
()
This CPE course took me longer than expected but was a useful tool in learning these PV/FV functions. They even had a couple I've never heard of before.
JOSH Aharonoff
( at Graphite Financial)
tough course, but worth it. Fascinating to learn the different details around the time value of money. Thanks for all the assistance!
Anonymous
(Finance Director)
This has good explanations of complex subjects. I appreciated the step by step instructions.
Anonymous
()
This was an excellent course, explains variety of formulas that can easily be done in Excel
Anonymous
()
Text based and pdf. Easy to follow. I need to write a longer review in order to submit.
Anonymous
()
i like the interactive test versus just multiple choice
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 .