Financial Modeling Fundamentals

Course Content

Financial modeling is one of the most under-rated skills at University, but a must-have skill in business. You can’t start or run a business without a solid forecast or ability to evaluate “what-if” scenarios. Your boss, or your investors, will expect a professional financial model.

This course will bridge the gap from theory to reality. Develop a best-practice financial model based on a real-life case study, in a framework that you can use to evaluate your own business. Understand the impact of leverage and equity dilution due to multiple capital raises, using CAP tables.

Financial Modeling Fundamentals

Course Price: Contact Us

On Request
All
Inhouse Training
Request proposal

SECTION OVERVIEW
Pre-course material
  • Course requirements, objectives, and overview
Introduction to financial modeling

 

 

 

 

  • Different types and uses of financial models
  • How to start building a financial model
  • Best practice principles
  • Best practice accounts and flags
  • Critical Excel functions and shortcuts

 

Historic data and forecasting

 

 

  • Analyzing historic data from your business
  • Forecasting methods
  • Forecasting revenue and costs
  • EBITDA, margins and other metrics
  • Assess the impact of capital costs

Working capital

 

  • Receivables and payables
  • Inventory
  • Why Starbucks has loyalty cards

Capital structure and investment decisions

 

 

 

 

 

  • Introduction to debt and equity
  • The benefits of leverage
  • Debt service – repaying Principal and paying interest
  • The net present value (NPV)
  • Internal rate of return (IRR)
  • Making sensible investment decisions
  • Funding stages for a business
  • Dilution of shareholder value and CAP rate tables

Core Outputs

 

 

 

  • Cash flow statement
  • Income Statement
  • Balance Sheet
  • Build graphs and other outputs required for decision making
  • A note about tax

Sensitivities and business optimizations

 

 

 

  • Creating scenarios and sensitivities
  • Breakeven analysis
  • Solving the price required to achieve a specific return
  • Understanding scale vs profit vs cashflow
  • Removing model circularities

Modeling quality checks and maintenance

 

 

  • File structures, version control, and sign-off protocols
  • Tracking changes in Excel models
  • How to review a model
  • Keep your financial model current, how to update it

This course is suitable for all-levels – there is something for everyone.

  • Financial analysts at banks, investors, developers, and operating entities looking to standardize approaches to modeling or solve new problems
  • Senior participants changing careers or looking to up their skill-set
  • Students wishing to enter a finance role – get ahead of your competition now
  • Anyone else responsible for financial modeling!

Why trust Pivotal180 with your professional development?

  • Pivotal180 is focused exclusively on teaching. Institutional and human capacity building is not a side business.
  • Senior practitioners with real experience lead Pivotal180 training courses
  • Our understanding is from practical transactional experience, not from reading about it or hearing about it from senior people on our team
  • We have trained top advisors, developers, lenders, and funds across the world.
  • We tailor our courses more than anyone else in the market, to meet your needs
  • Our blended solution of instructor led and online training includes 12 months of access to our online courses

Contact us for on-site  pricing and options.

Cancellation Policy for Public Courses

  • 4 weeks before the course: Full Refund*
  • 1-4 weeks before the course: 50% Refund
  • <1 week before the course: No Refund

*Refund is less any merchant fees incurred on payment

  • Course completion certificate
  • Access to Pivotal180 communities

  • Basic knowledge of, and access to Excel
  • Computer/Laptop
  • Power cord

Course Previews

Benefit of Leverage

Changing the Scenario Input From Any Sheet

Intro to Debt and Equity