Instructor for this course
more

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 .
Course Syllabus
Course Materials
  PDFExcel Time Value of Money Functions for CPAs
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM