International Business Growth Radio Network
  • HOME
    • YOU >
      • Grow with Us
      • Themes
      • FAQ
    • US >
      • North American Partners >
        • North American Hosts
        • North American Directory
      • Australasia Partners >
        • Australasia Hosts
        • Australasia Directory
      • South Asia Partners >
        • South Asia Hosts
        • South Asia Directory
      • Prime Meridian Partners >
        • Prime Hosts
        • Prime Directory
      • Exec Team
    • LISTEN NOW >
      • OnAir TODAY
      • Show Notes
      • Podcasts
  • News
  • Blog
  • NETWORK
    • Sponsor Network
    • Special Preferences
    • Privacy
  • NOTES
  • Community
  • APP
  • SHOP

show notes

Stages of Development

Do I really need a financial model? - Scott Geller

24/1/2021

0 Comments

 
Picture
Scott Geller – The CFO Perspective

Episode: Do I really need a financial model? 

Date: January 25, 2020

IBGR.Network - PROFIT Radio. Everything a business owner needs to start, grow or exit a business. GROW WITH US.

INTRODUCTION

Show Objectives - The Why
Financial Modeling is the process conducted to create a financial representation of the entity. It is the process of creating a summary of a company’s expenses and earnings in the form of a spreadsheet that can be used to calculate the impact of a future event or decision. A financial model is the tool to create proactive strategies rather than making reactive adjustments. 


What You Need to Know - The What
  1. A financial model is simply a tool that’s built in spreadsheet software such as MS Excel to forecast a business’ financial performance into the future.
  2. Considerations
    1. Model purpose
    2. Granularity
    3. Flexibility
  3. Purposes
    1. Custom Financial Statements outside of standard accounting SW
    2. Cash Flow Tracking and Forecasting
    3. Financial Forecasting
    4. Scenario Planning
    5. Raising Capital
    6. Making acquisitions
    7. Growing a business organically
    8. Valuing a business
    9. Financial statement analysis / ratio analysis
  4. Sources
    1. DIY - training courses
    2. Download Free ... sometimes get what you pay for
      1. www.corporatefinanceinstitute.com
      2. Industry specific experts or consultants
    3. Purchase ... sometimes get what you pay for
    4. Leverage or hire someone - experience can go a long ways  

What You Need to Do - The How
  1. Planning your needs
    1. Stop, Think, and Plan
    2. Begin with Financials and work back
    3. Historical results
    4. Driving Assumptions
    5. Data Input
    6. Future periods
    7. Sensitivity analysis and scenarios
  2. 3 Statement model
    1. Income Statement
    2. Balance Sheet
    3. CF Statement
  3. Structure 101
    1. x-axis serving as time
    2. y-axis serving as details
    3. Input - Revenue, assumptions,
    4. Detail Tabs - Expenses, historical actuals,
    5. Financials
    6. Summary or Reporting - Fed from Financials for investor, board, leadership, etc
    7. Metrics and Ratios - trending, inter dependencies, red flags
    8. Graphs and Tables
  4. Formulas to accomplish more & Best Practices
    1. SUMIF
    2. VLOOKUP
    3. Error Checks
    4. Group Rows and Columns
    5. Simplicity and Transparency - Regardless of the quality of the calculations, if it looks complex or the model flow isn’t intuitive then expect immediate negative feedback. Transparency drives structure, complicated formulas should be avoided at all cost. A complicated formula can often be broken down into multiple cells and simplified.
    6. Avoid Linking Files
    7. Avoid Pivot Tables
  5. Don't follow a model output blindly
    1. Stress test
    2. Gut test
    3. Reconcile to actual financials


(SAMPLE) Shows 
  • PREVIOUS : Episode 3 - 2021_01_18 - How do I plan for 2021?
  • NEXT: Episode 5 - 2021_01_25_ How do I increase revenue “financially”? 

Resources (optional):
You can connect with Scott via his website or LinkedIn
Connect on LinkedIn
See Scott’s Website


​

F3.04.4NA

0 Comments



Leave a Reply.

    new choice for BUSINESS SEARCH

    ​All IBGR Shows Notes are available for download

    Authors

    - (NA) North American Radio Hosts
    ​- (AA) Australasian Radio Hosts
    - (SA) South Asian Radio Hosts
    - (PM) Prime Meridian Radio Hosts

    Archives

    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020

    Categories

    All
    Season 1 - A. Strategy
    Season 1 - B. Operations
    Season 1 - C. Sales
    Season 1 - D. People
    Season 1 - E. Ownership
    Season 1 - F. Coaching & Consulting
    Season 2 - A. Financial Results
    Season 2 - B. Operational Productivity
    Season 2 - C. Sales Effectiveness
    Season 2 - D. People Performance
    Season 2 - E. Owner As Executive
    Season 3 - C. Customers
    Season 3 - E. Executive
    Season 3 - F. Finances
    Season 3 - IBGR Specials
    Season 3 - O. Operations
    Season 3 - P. People
    Season 3 - Special Series
    Season 4 - Customers
    Season 4 - Executive
    Season 4 - Finance
    Season 4 IBGR Specials
    Season 4 - Market Domination
    Season 4 - Operations
    Season 4 - People
    Season 4 - SPECIAL SHOW
    SPECIAL EPISODE

    RSS Feed

Site powered by Weebly. Managed by Radio.co, Designed by gWORX Media
Photo used under Creative Commons from magerleagues
  • HOME
    • YOU >
      • Grow with Us
      • Themes
      • FAQ
    • US >
      • North American Partners >
        • North American Hosts
        • North American Directory
      • Australasia Partners >
        • Australasia Hosts
        • Australasia Directory
      • South Asia Partners >
        • South Asia Hosts
        • South Asia Directory
      • Prime Meridian Partners >
        • Prime Hosts
        • Prime Directory
      • Exec Team
    • LISTEN NOW >
      • OnAir TODAY
      • Show Notes
      • Podcasts
  • News
  • Blog
  • NETWORK
    • Sponsor Network
    • Special Preferences
    • Privacy
  • NOTES
  • Community
  • APP
  • SHOP