Financial Modeling: Building a Complete Model in Excel

overview video

WHAT YOU WILL LEARN:

• Financial Modeling
  • Construction and Application of:
    • Core statements
    • Working capital schedule
    • Depreciation schedule
    • Amortization schedule
    • Other long-term items schedule
    • Equity schedule
    • Shares outstanding schedule
    • Debt and interest schedule
  • Troubleshooting the Model
    • Understanding and controlling for circular references
  • Utilizing the Finished Product

Over 7 hours of video-based self-study videos.

This intensive hands-on course teaches you how to build your own interactive financial model from “scratch” by blending accounting, finance, and Excel skills, and utilizing a step-by-step approach. Using real world examples and Excel models, this online course discusses theories, approaches and applications of financial modeling, while giving you the opportunity to construct a model of your own to apply the lessons learned. This course is the online version of one of our most popular live training programs at the top investment banks, consulting firms, and other Fortune 500 companies, as well as the top MBA programs.

KEY FEATURES

• Estimated time to complete is 10-15 hours
• Over 7 hours of video-based instruction
• Optimized for PC based Excel
• The Excel shortcuts in this course are not optimized for Mac versions of Excel, but this will not detract substantially from the course experience

TOPICS COVERED

• Income statement, balance sheet and cash flow statement relationships
• Working capital, depreciation and capital expenditure
• Intangibles amortization schedule
• Shareholders’ equity schedule with a share repurchase table
• Debt and interest schedule with a "cash sweep"
• Understanding and controlling circular references
• Troubleshooting and strategies for balancing a model
• Sensitivity analysis to match expected financial performance
• How to build a quick discounted cash flow analysis (DCF)

PREREQUISITES

• This course requires basic accounting knowledge. The Financial Statement Analysis course fulfills this prerequisite
• This course recommends, but does not require, basic Excel proficiency. We recommend taking the Excel Best Practices course to fulfill this requirement