Advanced Segment Build-up Modeling

Learn how to build detailed revenue and segment build-ups into your larger financial model. Many financial projection models are based off simple revenue growth rate and expense margin assumptions, resulting in reduced precision in the projection model. This course teaches various approaches to true, bottoms-up, fundamental analysis from both an account-by-account and business segment basis (very detailed build-up vs. division by division). The results of build-up analysis roll-up into a consolidating income statement that feeds into the income statement revenue items.

No sessions currently available. Contact client services to get the next available date.
CPE CREDITS
7.0
Investment bankers, mergers & acquisitions, leveraged finance and credit professionals. Private equity, buyout and venture capital professionals. Internal M&A and business development. CFO, VP Finance, financial analysts & related functions. New hires and those being groomed for management.
No advance preparation required.
Students will be able to:
  • Learn detailed revenue build-up algorithms for various types of businesses and scenarios
  • Provide additional credibility, support and precision to your financial models
  • Understand and analyze the true drivers of growth in a business and translate into Excel
  • Build sensitivity analysis into model by incorporating different scenarios and cases
Proficiency in: Accounting & Financial Statements, basic Corporate Finance and valuation topics. Basic, general knowledge or interest in leveraged buyouts. Solid proficiency in Excel. Note: To maximize the value & productivity of this course, participants must be proficient and comfortable with Excel - a lack of Excel skills will hamper the ability to properly follow along and acquire the best practices and efficiencies that are presented. Financial calculator required.
Computer:
Each participant must bring his/her own laptop to class.
Detailed Business Segment Build-Up
  • Model out historical change in key drivers of growth and project future detailed growth
  • Analyze and break down growth based on publicly available data and inputs from 10K filing
  • Incorporate and remove effect of growth from non-core items such as foreign exchange rate fluctuations
  • Project future detailed growth assumptions that roll up into larger projection model
  • Instead of just calculating 10% growth rate in revenue, dig into deeper layers of growth drivers
  • For instance, for a retailer, calculate Sales / Sq Foot / Type of Store, which captures: (i) number of stores (store count growth); (ii) size of each store (expansion and size creep); (iii) profitability of each sq foot and same store comps sales (YoY sales growth)

Operating & Division Segment Build-Up

  • Calculate and analyze different operating segments as reported in public filings to roll-up into IS
  • Adjust for extraordinary items by segment based on MD&A and disclosed footnotes
  • Extract, utilize and incorporate volume and pricing increases into operating segment performance
  • Estimate and project future revenue and segment income and allocate for corporate overhead
  • Estimate projected COGS and SG&A on the entire base after operating build-up

Detailed Account by Account Build-Up

  • Project sources of revenue based on growth in number of accounts and customers
  • Model out revenue per account and associated commissions and expenses
  • Incorporate rate increases into model
  • Further enhance model via sensitivity & scenario modeling and analysis
  • Detailed build-up consolidates into Consolidating Income Statement which feeds into model
  • Account for inter-company eliminations in historical pro forma model and projections

Sensitivity Analysis and Multiple Cases

  • Layer sensitivity analysis on top of segment build-up to incorporate various assumptions and cases
  • Build multiple scenarios and cases, including Base Case, Optimistic & Pessimistic Cases
  • Toggle and sensitize profitability and cash flow of model based on various case assumptions

Clients who register for this course will receive a complimentary 3 month subscription to the Financial Times and FT.com. The Financial Times is the world's most respected financial newspaper, providing a broad assessment on finance, business and the industrial sector. Subscriptions will start within 6-8 weeks of the application process and are limited to one per client. For questions about your subscription, call 800-628-8088 or email uscirculation@ft.com. U.S. enrollees only. (All non-U.S. enrollees will receive a subscription to FT.com only.) Lunch included for all students taking day classes.

Lunch included for all students taking day classes.