Instructor for 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: June 22, 2021

6 Reviews (15 ratings)Reviews

Anonymous Author
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 Author
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.
Member's Profile
tough course, but worth it. Fascinating to learn the different details around the time value of money. Thanks for all the assistance!
Anonymous Author
This has good explanations of complex subjects. I appreciated the step by step instructions.
Anonymous Author
Text based and pdf. Easy to follow. I need to write a longer review in order to submit.
Anonymous Author
i like the interactive test versus just multiple choice


Course Complexity: Foundational

No advanced preparation or prerequisites are required for this course.

Education Provider Information

Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
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 .
Course Syllabus
Course Materials
  PDFExcel Time Value of Money Functions for CPAs