FINC Model Exam Prep

A rising DPO with stable margins most likely indicates:

Increased supplier financing

A high ROE combined with a low ROA most strongly suggests:

High financial leverage

Assuming operations unchanged, if Orion issues $40 of new debt and uses the proceeds to repurchase equity, ROE will most likely:

Increase due to leverage

If Orion reduces inventory by $20 (cash unchanged), what happens to the quick ratio?

stays the same

If Orion’s EBIT increases by 10% with no balance sheet change, which ratio increases the most mechanically?

Interest coverage

In a three-statement model, which ratios should typically be used as constraints rather than drivers?

Leverage and coverage ratios

What happens if the share assumptions stay unchanged in a Top-Down Forecasting?

Revenue grows at the same rate as TAM

Top-Down Forecasting Core Idea

Starts with the overall market and narrows down to the firm

Bottom-Up Forecasting Core Idea

Starts from the firm’s internal drivers

Time-Series Forecasting Core Idea

Uses the historical pattern of sales over time

Linear Regression Forecasting Core Idea

Links sales to explanatory variables

Log-Log Model Interpretation

If X rises by 1%, sales rise by approximately b%. For example, if the coefficient is 1.1 and GDP rises 4%, sales rise about 4.4%

Revenue Schedule Core Idea

Usually project sales using unit growth, price growth, or segment growth assumptions

Cost Schedule Core Idea

Separate fixed and variable costs

Working Capital Schedule Core Idea

Project operating current assets and liabilities

Working Capital Key Takeaways

AR is linked to sales

Inventory is usually linked to COGS

AP is usually linked to COGS

Working Capital Schedule Cash Flow Logic

Higher AR →more cash tied up →negative effect on cash

Higher inventory →more cash tied up →negative effect on cash

Higher AP →more supplier financing →positive effect on cash

Depreciation and Asset Schedule Key Linkage

Capex increases assets

Depreciation reduces asset book value over time and appears as expense on the income statement

Income Tax Schedule Core Idea

Taxable income may differ from book earnings before tax when a book depreciation and tax depreciation differ

Capital Structure Schedule Core Idea

tracks debt balances and interest expense

Top-Down vs. Bottom-Up

Top-Down: Good for plausibility and strategic scale. Most useful for early-stage products, long-horizon modeling, and reality checks vs bottom-up outputs. This is used as a constraint

Bottom-Up: Used for identifying operating drivers, when unit economics are stable and observable, segment data is disclosed, and when the business model is relatively transparent

Forecasting Methods Comparison

Top-Down: macro or industry growth assumptions

Bottom-Up: operational drivers aggregated upward. Connects directly to valuation modeling

Time Series: Historical trend extrapolation

Regression: Statistical driver-based forecasting

If Missing Variables Not Disclosed…

• If revenue and ASP known: Units = Revenue / ASP

• Infer ARPU: ARPU = Revenue / Subscribers

• Estimate Churn from Growth identity Revenue growth = net subscriber growth + ARPU growth

• Rearrange to solve for missing components

Why Bottom -Up Forecasting Matters

• Operational credibility

• Transparent assumptions

• Integrated financial modeling

• Stronger DCF valuation foundation

Equity Schedule

if a company has multiple types of shares: common, preferred, etc.

• should build a sub-section for each type

• include common equity and retained earnings

Revenue Schedule

• Revenue forecast is the most important thing in the 3-statement models

• Key task: get or infer quantity (quantity/activity)

Sales Forecasting: Why Rev is Anchor Variable

• every financial statement scales off revenue

• a perfectly balanced model can still be economically wrong

Sales Forecast: Top Down→What it does

• Answers: is this rev plausible given market size up

• cannot answer:

  • can we produce it?

  • can we finance it?

  • will competitors allow it?

Tom-Down Forecasting: TAM

Total Addressable marketTo

Top-Down Forecasting: SAM

Serviceable Available market (segment you compete in)

Tom-Down Forecasting: SOM

Serviceable obtainable market (What you can realistically capture)

Top-Down Forecasting: Formula

Revenue = TAM x segment share x firm share

• tam = total addressable market

• seg share = portion relevant to firm

  • firm share = competitive capture

TAM Definition

total demand for a product/category if every potential customer in defined market were served

• if TAM meaningless

  • prodcut scope: what products count?

  • geography: Global vs U.S. vs APAC

  • customer type: consumers vs enterprise

  • metric: rev TAM or Unit TAM

How to project TAM growth?

• real growth

• inflation

• If TAM in dollars, it is nominal

  • TAM growth anchors your revenue growth ceiling

Real Growth Meaning

• more units being sold

• consumers upgrading more frequently

• demand is expanding

  • volume-driven expansion

Inflation Meaning

• prices rise across the economy

• nominal revs increase even if real units do not

• input costs likely increase as well

• inflation changes nominal values, not real activity

Assumption of Segment Share “Appropriate”

• anchored in historical data

• has economic drivers

• changes gradually unless justified

• consistent with macro conditions

• passes plausibility checks

• does not imply unrealistic industry transformation

Firm Share Structure

Firm share assumptions are often most dangerous part of a top-down model

Firm Share Assumption “Appropriate”

• anchored in historical data

• has economic mechanism

• consistent with market structure

• supported by capacity

• supported by investment

• bounded and gradual

• reconciled with TAM growth

Top-Down Deep Modeling Lesson

• Top-down errors do not stay in the revenue line

• financial statements are a constraint system

Bottom-Up Constraints

1) identify reported revenue drivers

2) reconciliate to historical growth

3) build transparent assumption table

4) Stress test drivers (strengthens credibility)

Internal Bottom-Up model

• detailed pipeline

• precise churn

• capacity data

• cohort models

External Bottom-Up analyst model

• public disclosures only

• inferred churn

• announced capex plans

• peer benchmarking

Why Time-Series?

Time-series forecasting provides:

• objective baseline

• assumptions discipline

• model comparison benchmark

Linear Time-Series Model Interpretation

Model Assumes:

• rev increases by a constant dollar amt each year

• growth is additive, not compounding

• the slope (beta) represents absolute expansion

Linear Time-Series Model: Firm Types

Linear trend most appropriate:

• firm mature

• growth incremental

• market share stable

• industry growth slow and steady

Examples closer to linear:

• mature consumer staples

• regulated utilities

• saturated industries

Log-Linear Time-Series model Interpretation

Log-linear assumes:

• constant proportional growth

• rev scales multiplicatively

• growth compounds

Fits many firms:

• tech firms

• Scalable service firms

• firms in secular growth industries

Regression Analysis Definition

method for finding the best fitting line for a data set

Simple Linear regression

Using only one independent variable (Xs) to predict the dependent variable (Y)M

Multiple linear regression

Using multiple independent variables (Xs) to predict the dependent variable (Y)

Linear Definition

linearity in parameters

Level-Level: When appropriate

• commodities

• cost models

• when units matter

Weakness:

• does not model proportional growth well

Log-Log: Why this is powerful

• rev is multiplicative

• taking logs

• linear in logs

• makes log-log form economically natural

Log-Linear Sales Forecasting Interpretation to Decision Context

• dollar sensitivity →level-level

• elasticity → log-log

  • usually more intuitive and portable

• growth rate →log-linear

Linear Regression Sales Forecasting Specification Rule of Thumb

Choose functional form based on:
1) economic structure first

2) interpretation second

3) statistical fit third

Never reverse this order

A regression model produces an adjusted of 0.85. What does this value indicate?

The model explains 85% of the variation in sales

Why must revenue growth align with capacity?

growth requires operational support

Cost Structure

Variable Costs: change as as sales change

• raw materials used to make products

• packaging supplies

• delivery costs

Fixed costs: usually do not vary as sales change

• rent

• insurance

Top-down forecasting primarily ensures

market plausibility

When forecasting firm-level sales using regression models, management guidance is most useful for forecasting:

Firm-level operating drivers

After estimating a linear regression, an analyst finds that the residuals are autocorrelated. What should be the appropriate next modeling step?

use AR model

An analyst must choose between a linear and a log-linear model for forecasting sales. What is the best practice when comparing linear and log-linear models is:

Choose lowest RMSE + economic justification

A firm’s revenue is growing at 12% annually, while the total addressable market (TAM) grows at 6%. What this implies about the firm’s market share over time.

Increasing share

Assume TAM grows by 4% and a firm’s market share declines from 15% to 13%. With an initial TAM of $200 billion, how the firm’s revenue is expected to change.

Decrease

Total market = $500B
Segment = 40%
Firm share = 10%
A market experiences an increase in inflation from 2% to 7%, while real growth declines from 4% to 1%.

How nominal market growth is affected?

Increases

Depreciation Schedule

• Depreciation represents how much an asset’s value has been used up

• a method that allocates costs of a fixed asset over its expected useful life

• depr expense should be recorded in the same period as economic benefit it generated

• Land has an infinite useful life and is not depreciated

Asset Schedule

• asset values must be tracked for both accounting and tax purposes

• Acct basis: PP&E tracked and reported on the IFRS standards

• Tax basis: tracked by the gov and used to determine taxalbe income

Income Tax Schedule

includes both current and deferred components under both IFRS and GAAP

Tax Purposes

Accelerated Depr:

• firms are allowed to use some form of accelerated depr for ta purposes

  • higher depr expenses early in asset life, thus lowers taxable income

Loss Carryforward:

• acct rules typically do not allow firms to carry a loss forward into the future as a credit

• firms are allowed to carry losses forward for tax purposes

  • lower taxable income

Capital Structure

• the mix of debt and equity a company is using to finance its business

• debt

  • revolving line of credit

  • term debt

• equity

  • preferred shares

  • common shares

  • dividends

Equity Schedule

• If a company has multiple types of shares: common, preferred, etc.

  • include common equity and retained earnings

Cash section reasoning

excess cash will earn interest →interest income

Debt Section

• If company has various types of debt (ST debt, senior notes, bonds, etc.)

The Revolver

• a flexible piece of debt

  • can be used when it is needed by a company

• even if a company does not need a revolver, it should still be included in its capital structure

• revolver acts as a lender of last resort if the model needs cash

  • negative cash balance →need to get cash from the revolver

• Cash sweep: Cash needs to be paid back ASA the company is able