Awaiting product image

Excel Time Value of Money Functions for CPAs (TIMC)

Customer Rating
Field of Study
Computer Software & Applications
Level
Overview
Credits
3.5
Qualifies For
CPE


Price:  $ 59

Additional information

Credits

3.5
Format

On Demand
Field of Study Department

Computer Software & Applications
CPE Approved

Yes

Pre-requistes:

Basic understanding of file management and functions

Knowledge Level:

Overview

Major Topics:

  • Time Value of Money Concepts 
  • Understanding Excel Time Value of Money Functions 
  • New Single Sum Functions in Excel 2013 
  • Evaluating Uneven Cash Flows – Capital Budgeting

Learning Objectives:

  • 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

Designed For:

All CPAs

Customer Reviews

Based on 3 reviews
100%
(3)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
P
Pamela N. (Wilmington, US)
Useful course

This course was very helpful and I have already found myself using what I learned to prepare, sort, and filter tables in Excel.

J
Jennifer S. (Foster, US)

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)

L
Lauren V.D. (Montgomery Village, US)

Excel: Audit & Analytical Uses for Filters & Tables (AUMC)

Follow by Email
Facebook
Twitter
LinkedIn
Share