Financial Modeling for Business Plans

Business 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.

Learn from industry leaders and ivy league professors either in-person at a public session, on-site at your offices or campus, online, or with blended learning – combining online and in-person sessions.

Course Outcomes

Best practice project finance modeling

Use a financial model to evaluate business decisions

Create scenarios and sensitivities to understand and quantify business risks

Professional presentation of outputs to present to decision makers

Course Previews

Benefit of Leverage

NPV Function

Intro to Debt and Equity

OUR BLENDED LEARNING COMBINING IN-CLASS AND ONLINE MATERIAL ENSURES WE TEACH MORE AND YOU LEARN MORE.

Course Portfolio Region Course Delivery Start Date Price Register/Enquire
Financial Modeling for Business Plans All Online Self Paced Available Soon USD 500 Register

Contact us for on-site or on-campus pricing and options.

The cost of the online course will be credited to you if you join a public session within 12 months of purchase.

Discounts provided off the full course prices.

  • Students and non-profits are eligible for a discount of 50% (no other discounts may be added to this).  Online course price for students and non profits is $250
  • Other discounts
    • Group booking of 3 or more people – 15%  Price per person for online group bookings is $425
    • Early bird (public sessions only ) if book 8 weeks before the course – 10%.
  • 12 months access to our online material, including concept videos with transcriptions, lecture slides, downloadable spreadsheet examples.
  • A complete step-by-step model walk-through, and access to discussion forums for ongoing questions’.
  • Subscription can be extended annually post the first 12 months for $100 per annum.
  • Lunch, tea & coffee at the venue (public session participants only).
  • Membership to the Pivotal180 alumni network.
  • Course completion certificate

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!
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 optimization
  • 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

Pre-requisites

Basic knowledge of Excel only

Equipment Required

Area Items Needed
Online

Computer, 2 screens preferable, Microsoft Excel

Public Session

Laptop and power cord

Public courses run from 9am – 5.30pm at a location to be confirmed  post registration

Range Amount
> 4 weeks before the course Full Refund
1 - 4 weeks before the course 50% Refund
<1 week before the course No Refund

Get in touch to discuss our training or advisory services