Financial Modeling in Excel

Exam Questions: 50
Course Level: Basic
Pages: 344 | Content: 326, Supplemental: 18
NASBA Area of Study: Computer Software and Applications
Not Acceptable for: Enrolled Agents
Version: 8255

This course provides a practical and hands-on introduction to financial modeling in Excel. You'll find a well-structured, strategic toolkit to learn modeling from scratch, focusing on the core economic concepts and the structures commonly required within Excel models. The course will discuss the use of models and the factors to consider when designing and building models so that they can be as powerful as possible, and yet simple. It is ideal for financial professionals seeking to build or reinforce essential topics in financial modeling. PLEASE NOTE: Not accepted for Enrolled Agents. All course material provided. Prerequisites: Basic understanding of Excel and financial models. Course level: Basic.

Choose Your Format to ADD TO CART:

Go to CART

Course Information

Table of Contents
  • Modeling and Its Uses
  • Principles of Model Design
  • Menus, Operations, Functions, and Features
  • Sensitivity and Scenario Analysis
  • Growth Calculations for Forecasting
  • Modular Structures and Summary Reports
  • Scaling and Ratio-driven Forecasts
  • Corkscrews and Reverse Corkscrews
  • Waterfall Allocations
  • Interpolations and Allocations
  • Breakeven and Payback Analysis
  • Interest Rates and Compounding
  • Loan Repayment Calculations
  • Discounting, Present Values, and Annuities
  • Returns and Internal Rate of Return
  • The Cost of Capital
  • Financial Statement Modeling
  • Corporate Valuation Modeling
  • Ratio Analysis
  • Statistical Analysis and Measures
  • Data Preparation: Sourcing, Manipulation, and Integration
  • To recall the purpose of using models in Excel
  • To identify best practices for building models in Excel
  • To identify the function used to add up the items in a two-cell range
  • To recall the stated advantage of re-using a single DataTable and switching the output that is being referred to with a lookup function
  • To identify why it is important to make a clear distinction between historical and forecasting components in an Excel model
  • To recall the definition of a flag field
  • To recall frequently calculated ratios for analysis purposes
  • To identify the benefits of corkscrew structures in modeling
  • To identify the main purpose of a waterfall allocation
  • To recall the characteristics of tapering
  • To recognize the purpose of breakeven analysis
  • To identify the Excel function that can be used to convert a stated interest rate to an effective rate
  • To recall the function that calculates the payment that is required in each model period in order to pay the interest charges for the period
  • To recall the purpose of calculating the terminal value in the valuation of a corporation
  • To recognize the characteristics of net present value (NPV)
  • To recall Modigliani and Miller's findings
  • To recall the purpose of a dynamic adjustment mechanism in a financial statement model
  • To recall the role of the explicit forecast in valuation
  • To identify the purpose of DuPont analysis in ratio analysis
  • To recognize the characteristics of various measures of central tendency
  • To recall the characteristics of the "flat table" approach in data integration

PLEASE NOTE: CPE credit measurement is based on NASBA Registry and QAS guidelines of one credit for every 50 minutes. Credit calculation may vary in different states — check with your State Board of Accountancy. Unless otherwise noted in the specific course description, no advanced preparation is required in order to register or complete any PES CPE course. Use of materials or services provided by Professional Education Services, LP ("PES") are governed by the Terms and Conditions stated on PES' website www.mypescpe.com. PES provides these courses with the understanding that it is not providing any accounting, legal, or other professional advice and assumes no liability whatsoever in connection with its use. PES has used diligent efforts to provide quality information and material to its customers, but does not warrant or guarantee the accuracy, timeliness, completeness, or currency of the information contained herein. Ultimately, the responsibility to comply with applicable legal requirements falls solely upon the individual licensee, not PES. PES encourages you to contact your state Board for the latest information and to confirm or clarify any questions or concerns you have regarding your duties or obligations as a licensed professional.