Why must a three-statement model balance?

The income statement produces net income, which affects retained earnings and operating cash flow. Investing and financing activity also change cash, while operating assumptions change assets and liabilities. The closing balance sheet must therefore satisfy assets = liabilities + equity. A difference signals a missing link, inconsistent sign or timing error. A balancing plug can hide that error, so trace the difference to the schedule that caused it.

How do I choose between a DCF and market multiples?

A DCF is most useful when you can defend cash flow forecasts, reinvestment needs and a discount rate. Trading multiples show how comparable public companies are priced; transaction multiples reflect prices paid in acquisitions and may include control or deal effects. Use the methods together when possible, reconcile differences in growth, margins, risk and accounting, and keep enterprise value separate from equity value.

What makes a forecast useful for an FP&A decision?

Connect revenue and costs to observable drivers, such as customer count, price, utilization or staffing. Compare actual results with the forecast, separate changes in volume from changes in rate, and update assumptions when evidence changes. Present a range of outcomes with the operational action each outcome suggests. A precise point estimate is less useful if its key assumptions cannot be explained.

FMVA Study Guide: Modeling, Analysis and Valuation

Start with concept 1 Choose a topic

A useful financial model starts with a business question: what could change, how would that affect cash, and what decision follows? This guide develops the skills used in CFI’s Financial Modeling & Valuation Analyst program. You will move from reading accounts to forecasting operating drivers, linking three statements, checking a model and testing uncertain assumptions. You will then turn those forecasts into valuations and planning insights, using Excel and clear visuals to show what matters. The worked examples use small, hypothetical companies so you can follow each calculation and its meaning. Treat each result as a claim to examine: identify its inputs, trace its effects across the statements and decide whether it fits the business.

Financial Modeling

1. Define the model’s decision

Start with the question the model must answer, then work backward to the outputs and schedules needed. A cash funding decision needs a closing cash forecast and the operating, investing, and financing movements behind it. Set the forecast horizon to include the proposed action and its material effects; a one-year view may miss a later repayment. Choose detail that changes the decision, such as monthly cash if timing matters, without adding schedules that cannot be supported by evidence. State the starting cash balance, minimum cash requirement, and treatment of any new financing. Keep these assumptions visible so a reviewer can distinguish a funding gap from a calculation error. The FMVA curriculum includes structured three-statement modeling and forecasts across the statements.

Worked example: Suppose a manager proposes a $30 million investment next year. Forecast operating cash inflow is $24 million, and other investing outflow is $4 million. Before financing, the change in cash is $24 million − $30 million − $4 million = −$10 million. If opening cash must be preserved, the plan needs $10 million of funding or a $10 million reduction in spending.

Watch the distinction: A positive operating cash forecast does not establish that an investment is affordable. Include all planned investing outflows and the required closing cash balance before judging the funding need.

Reference: [1]

2. Prepare a historical base

Historical figures become useful forecast inputs only after their periods, units, definitions, and signs agree. Label whether amounts represent calendar years, fiscal years, quarters, or trailing periods. Convert every series to one currency scale before calculating growth or margins, and document any currency conversion. Revenue and costs may arrive as positive values in source reports, while a model may display costs as negatives; choose one convention and apply it consistently. Reconcile each historical statement to its published totals before forecasting. Then inspect unusual movements, acquisitions, and accounting changes that may make a simple growth rate misleading. A clean historical base lets you identify which forecast changes come from business assumptions and which merely reflect source formatting. Preserve the original figures separately so conversions remain traceable.

Worked example: A source lists prior-year revenue as 2,400 in $ thousands; another lists current revenue as 2.5 in $ millions. The first amount equals $2.4 million. Growth is $2.5 million ÷ $2.4 million − 1 = 0.04167, or about 4.17%. Dividing 2.5 by 2,400 without converting units would produce a meaningless decline.

Watch the distinction: Do not assume matching column labels mean matching periods or units. A fiscal-year figure compared with a calendar-year figure can distort growth even when both amounts are stated in millions.

Reference: [1]

3. Separate inputs from formulas

Put changeable assumptions in clearly labeled input cells and calculate results through references to those cells. This creates one place to revise a price, volume, or cost assumption and makes the effect visible across the model. Organize formulas in schedules that follow the business logic: operating drivers produce revenue and expenses; those feed the statements; the statements feed decision outputs. Use consistent signs, dates, and units, and show source notes beside material inputs. A reviewer should be able to trace an output backward without searching for hidden typed constants inside formulas. Where products truly have different price changes, give each an explicit assumption rather than forcing a shared input. Test the structure by changing one input and checking all expected outputs, plus a few that should remain unaffected.

Worked example: Assume products A and B each sold 100 units at $10, and both use one price-growth input of 6%. Forecast price is $10 × 1.06 = $10.60 for each, so combined revenue is 200 × $10.60 = $2,120. Changing the input to 4% gives $10.40 and $2,080. A separate typed 6% in B’s formula would wrongly leave revenue at $2,100.

Watch the distinction: A formula can look dynamic while containing a typed assumption. If the same business assumption appears in multiple formulas, one revision may update only part of the forecast.

Reference: [1]

4. Build an operating driver tree

Start with a physical or commercial measure of activity, then connect it to revenue through price or yield. For a service firm, headcount, available hours, billable utilization, and rate form a useful sequence: capacity hours equal people times available hours; billed hours equal capacity times utilization; revenue equals billed hours times rate. Each driver has a distinct meaning. More staff expands capacity, higher utilization sells more of that capacity, and a higher rate raises revenue per billed hour. Check whether the proposed utilization is achievable after leave, training, and internal work. Also check whether the rate reflects discounts and the mix of work. A driver tree makes assumptions testable against operational data and exposes implausible forecasts, such as revenue exceeding the hours the team can deliver.

Worked example: Eight consultants can each bill up to 1,500 hours a year at $120 per hour. Maximum revenue is 8 × 1,500 hours × $120/hour = $1,440,000. At 75% billable utilization, forecast billed hours are 9,000 and revenue is 9,000 × $120 = $1,080,000. The unused 3,000 hours explain the gap from capacity revenue.

Watch the distinction: Do not multiply a full-capacity revenue figure by a utilization rate and then reduce billable hours again. That applies the same constraint twice and understates forecast revenue.

Reference: [1]

5. Forecast revenue by segment

A company-wide growth rate can hide very different product, customer, or geographic trends. Split revenue where the underlying drivers differ and where historical data can support the distinction. Forecast each segment from its own volume, price, retention, or growth assumption, then sum the resulting amounts. The consolidated growth rate is a weighted result of those segment forecasts; it is rarely equal to the strongest segment’s growth rate. Review whether a segment’s share of total revenue is changing, since that mix shift can affect margins and working capital as well as sales. Keep segment definitions stable across historical and forecast periods. If a reclassification changes the categories, restate comparable history or explain the break before interpreting growth.

Worked example: Product revenue is $80 million and service revenue is $20 million, for $100 million total. Product growth of 10% gives $88 million; a 5% service decline gives $19 million. Forecast revenue is $107 million, so total growth is $107 million ÷ $100 million − 1 = 7%. Applying 10% to all revenue would overstate the forecast by $3 million.

Watch the distinction: The largest segment’s growth rate is not automatically the company’s growth rate. Calculate each segment first, then compare their combined forecast with the combined historical base.

Reference: [1]

6. Link direct costs to activity

Separate costs that change with output from costs that remain fixed over the modeled range of activity. Materials may be modeled as units produced times cost per unit; factory rent may remain unchanged until capacity requirements change. This distinction helps you forecast gross profit and understand operating leverage. At higher volume, variable cost rises, while fixed cost per unit falls if the fixed amount is spread across more units. Confirm whether cost drivers use units produced, units sold, or another measure, because inventory changes can make those quantities differ. Avoid treating every cost as perfectly fixed or variable across all volumes. A step-up in rent, staffing, or equipment may be needed when production exceeds current capacity. State the range over which the assumption is intended to hold.

Worked example: A factory makes 5,000 units. Materials cost $18 per unit and annual rent is $40,000, so total modeled cost is 5,000 × $18 + $40,000 = $130,000. At 6,000 units, with the same unit cost and rent, cost is $108,000 + $40,000 = $148,000. The $18,000 increase comes entirely from 1,000 additional units of materials.

Watch the distinction: A fixed annual cost is not a fixed cost per unit. Dividing rent by today’s units and applying that per-unit amount to higher volume would incorrectly make rent rise.

Reference: [1]

7. Model operating expenses

Match each material expense to the driver that best explains it. Sales commissions may follow revenue, while salaries may follow headcount and pay increases. Marketing can depend on a campaign plan, and occupancy may follow contracted space rather than sales. A single growth rate across all expenses can obscure these different behaviors and produce misleading margins when revenue changes. Build separate schedules where timing matters: new hires may contribute only part of a year’s salary, and a planned campaign may occur in one quarter. For smaller immaterial lines, a simpler assumption may be adequate if it is labeled. Compare the resulting expense ratios with history, but use that comparison as a diagnostic rather than forcing every line to remain at a historical percentage. Explain any material departure.

Worked example: Forecast revenue is $2 million, and commissions are 4% of revenue, giving $80,000. Office salaries start at $300,000 and rise 3%, giving $309,000. Combined forecast operating expense is $80,000 + $309,000 = $389,000. If revenue changes, the commission line updates; the salary line changes only when its own assumptions change.

Watch the distinction: Growing salaries and commissions at the same rate ignores what drives each line. A sales decline may reduce commissions immediately while committed salaries remain in place.

Reference: [1]

8. Forecast depreciation

An asset schedule turns purchases and useful-life assumptions into depreciation expense, accumulated depreciation, and net book value. Under a simple straight-line assumption, depreciable cost equals purchase cost less residual value; annual depreciation equals that amount divided by useful life. For multiple assets, calculate depreciation by asset group or purchase cohort so old assets stop depreciating and new purchases begin according to a stated timing convention. Depreciation reduces reported profit and the asset’s carrying amount, but the charge itself does not require a current-period cash payment. The purchase is recorded as a cash outflow when it occurs. Check that accumulated depreciation never exceeds the depreciable amount under the stated assumptions and that the income statement charge matches the movement in the asset schedule, allowing for disposals.

Worked example: Equipment costs $100, has no expected residual value, and is depreciated evenly over five years. Annual depreciation is ($100 − $0) ÷ 5 = $20. After year one, accumulated depreciation is $20 and net book value is $80. The $20 expense reduces pretax income; the year-one depreciation entry itself does not reduce cash.

Watch the distinction: Do not record both the full equipment purchase and annual depreciation as current-period cash outflows. The purchase uses cash; depreciation allocates its cost to reported earnings over time.

Reference: [1]

9. Roll forward fixed assets

A net property, plant, and equipment schedule reconciles what the company owned at the start of a period with additions, depreciation, and any disposals or write-downs. In a simple case, closing net assets equal opening net assets plus capital spending minus depreciation. Keep the cash purchase and the income statement depreciation charge in separate schedules, then link both to the balance sheet roll-forward. If assets are sold, remove their carrying amount and account separately for sale proceeds and any gain or loss. A roll-forward is also an audit tool: an unexplained jump in fixed assets may reveal a missing depreciation formula or an acquisition entered twice. Check that the closing schedule balance equals the balance sheet line and that purchases reconcile to investing cash flow.

Worked example: Opening net fixed assets are $180 million. The company buys $50 million of assets and records $30 million of depreciation, with no disposals or write-downs. Closing net fixed assets are $180 million + $50 million − $30 million = $200 million. The $50 million purchase appears in investing cash flow; the $30 million depreciation affects profit and operating cash reconciliation.

Watch the distinction: Capital spending does not increase closing net assets by its full amount when existing assets depreciate during the period. Include every material roll-forward movement before linking the closing balance.

Reference: [1]

10. Forecast receivables

Accounts receivable represents credit sales that have been recognized but not yet collected. A days sales outstanding assumption translates collection timing into a closing balance: forecast credit sales divided by days in the modeled year, multiplied by collection days. Use credit sales if cash sales are material, and make the day-count convention explicit. A higher collection-days assumption raises receivables and usually reduces operating cash for the period, even if reported revenue is unchanged. In the cash flow forecast, the relevant movement is closing receivables minus opening receivables. Check whether a seasonal business needs monthly balances instead of an annual average; the same annual sales can create very different year-end receivables depending on when sales occur. Compare the assumption with historical collections and stated customer terms.

Worked example: Assume annual credit sales of $365 million, a hypothetical 365-day year, and average collection time of 30 days. Forecast receivables are $365 million ÷ 365 days × 30 days = $30 million. If opening receivables were $25 million, the $5 million increase is a use of operating cash, assuming other working capital items are unchanged.

Watch the distinction: A rise in receivables does not mean customers paid more cash. It means more recognized sales remain uncollected at the measurement date, so it reduces cash in the operating reconciliation.

Reference: [1]

11. Forecast inventory and payables

Inventory days describe how much cost is held in stock; payable days describe how long supplier invoices remain unpaid. Multiply a consistent daily cost of goods sold measure by each days assumption to estimate the related balance. Inventory is an operating asset that ties up cash when it grows. Payables are an operating liability that temporarily finances purchases when they grow. The difference between their closing balances offers a snapshot of cash tied up in these two accounts, but the period’s cash flow effect depends on changes from their opening balances. Check that the cost base fits the business: supplier payables may track purchases more closely than cost of goods sold when inventory is changing rapidly. Review whether the days assumptions reflect realistic supply, production, and payment patterns.

Worked example: Assume daily cost of goods sold is $2 million. Inventory covering 20 days is 20 × $2 million = $40 million; payables covering 15 days are 15 × $2 million = $30 million. The closing balances leave $10 million net tied up in inventory after supplier credit. Without opening balances, that $10 million is a position, not a cash flow.

Watch the distinction: Do not call inventory minus payables the period’s operating cash outflow. To calculate cash flow, compare each closing balance with its own opening balance and apply the correct sign.

Reference: [1]

12. Roll forward debt

A debt schedule begins with opening principal, adds new borrowing, subtracts principal repayments, and arrives at closing principal. Keep each loan or facility separate when rates, repayment dates, or restrictions differ. Link new draws and repayments to financing cash flow, and link closing principal to the balance sheet. Interest belongs in a separate calculation because it is the cost of borrowing, not a principal movement. A planned repayment must be tested against forecast cash availability; otherwise the model may show an impossible negative cash balance. If borrowing is used to fill a cash gap, define the draw rule clearly and check whether the facility has a stated limit in the scenario. Reconcile each period’s opening debt to the prior period’s closing debt.

Worked example: Opening debt is $120 million. The company draws $30 million and repays $20 million of principal during the year. Closing debt is $120 million + $30 million − $20 million = $130 million. Financing cash flow records a $30 million inflow and a $20 million outflow, for a net $10 million inflow, before any other financing items.

Watch the distinction: Do not reduce debt principal by the full loan payment when part of that payment is interest. Only the principal portion changes the debt balance; interest follows its own expense and cash treatment.

Reference: [1]

13. Handle interest timing

Interest expense depends on the borrowing balance used and the time that balance is outstanding. A simple annual model may use opening debt, closing debt, or their average; each is an approximation with different implications when borrowing changes materially. State the convention next to the formula. For scheduled midyear movements, average debt can be a reasonable simplification. A monthly schedule is more precise when timing is known. Circularity can arise when interest affects net income and cash, while cash determines the amount borrowed and therefore interest. Resolve it with a stated borrowing convention, an explicit financing schedule, or a controlled iterative calculation when the model supports one. Check that a repayment lowers subsequent interest and that rates are applied to the correct debt tranche.

Worked example: Debt opens at $100 million and closes at $80 million after a scheduled repayment. Under a stated average-balance convention, average debt is ($100 million + $80 million) ÷ 2 = $90 million. At 6% annual interest, modeled expense is $5.40 million. Using closing debt alone gives $4.80 million, understating this convention’s result by $0.60 million.

Watch the distinction: A closing balance is not automatically the amount outstanding all year. If debt changes during the period, using only that balance may misstate interest unless the timing assumption supports it.

Reference: [1]

14. Connect profit and tax

In a simplified forecast, pretax income flows from operating profit after nonoperating items such as interest. Apply the stated modeled tax rate to the appropriate tax base, then subtract the resulting tax expense to obtain net income. This creates a clear sequence: operating assumptions affect profit, profit affects modeled tax, and both affect retained earnings and cash projections. Keep a tax-rate input visible so scenarios update consistently. A flat rate is a modeling assumption, not a complete account of actual tax rules. Losses, timing differences, credits, and jurisdictional effects may require a separate schedule when material, but do not invent them without case evidence. Verify that the income statement tax and any cash tax forecast have their own links; an expense and a payment need not occur in the same period.

Worked example: Assume pretax income of $40 million and a hypothetical modeled tax rate of 25%, with no other tax adjustments. Tax expense is $40 million × 25% = $10 million, leaving net income of $30 million. If pretax income falls to $32 million, modeled tax is $8 million and net income is $24 million. The $8 million profit decline reduces net income by $6 million.

Watch the distinction: Do not subtract the full pretax-income decline from net income while leaving tax unchanged. Under a proportional tax assumption, the modeled tax expense changes with the tax base.

Reference: [1]

15. Roll forward retained earnings

Retained earnings capture cumulative profit kept in the business, subject to distributions and other identified equity adjustments. In a basic model, closing retained earnings equal opening retained earnings plus current net income minus dividends. Link net income from the income statement and dividends from the financing plan, then put the calculated closing balance on the balance sheet. This schedule helps explain why profit can rise while cash falls: earnings increase equity, but dividends distribute cash to owners. Dividends are not an operating expense and should not reduce net income. If the case includes share issuances, repurchases, or other equity movements, model them in the appropriate equity accounts rather than forcing them into retained earnings. Reconcile total equity separately from the retained earnings roll-forward.

Worked example: Opening retained earnings are $70 million. Net income is $24 million and dividends declared and paid are $9 million, with no other retained earnings movements. Closing retained earnings are $70 million + $24 million − $9 million = $85 million. The dividend also reduces financing cash by $9 million; it does not change the $24 million net income figure.

Watch the distinction: Treating a dividend as an income statement expense understates profit and then risks deducting it again from retained earnings. Record it once as a distribution in the equity roll-forward.

Reference: [1]

16. Derive operating cash flow

Under the indirect method, begin with net income and adjust for items that affected reported profit without matching current cash, then account for operating asset and liability movements. Add back depreciation because it reduced profit without a current cash payment. Subtract an increase in receivables because recognized sales have not yet been collected. Add an increase in payables because costs or purchases have not yet been paid. Apply the same sign logic to other working capital accounts: an increase in inventory generally uses cash, while an increase in an operating liability generally preserves it. Check that each balance change is calculated as closing minus opening and appears only once. This reconciliation explains the difference between accounting profit and cash generated by operations.

Worked example: Net income is $30 million, depreciation is $8 million, receivables rise by $5 million, and payables rise by $3 million. With no other adjustments, operating cash flow is $30 million + $8 million − $5 million + $3 million = $36 million. The result exceeds net income because the noncash depreciation and delayed supplier payment more than offset slower customer collection.

Watch the distinction: Do not subtract depreciation again when moving from net income to operating cash flow. Net income already includes that expense; the reconciliation adds it back because no current cash left for the charge.

Reference: [1]

17. Classify investing and financing cash

The cash flow statement groups movements by their economic role. Purchases of long-lived operating assets belong in investing cash flow. Borrowing and principal repayments belong in financing cash flow, as do distributions to owners in a basic model. Classify each item before summing sections so the model reveals how operations are funded and where cash is deployed. A cash outflow has a negative sign; an inflow has a positive sign. These sections connect directly to balance sheet schedules: capital spending increases fixed assets before depreciation, borrowing changes debt, and dividends reduce equity. The cash flow statement must use the same amounts as those schedules. Confirm the applicable reporting convention for items whose classification can vary; the simple example here uses only capital spending, borrowing, and dividends.

Worked example: A company pays $12 million for equipment, borrows $7 million, and pays $2 million in dividends. Investing cash flow is −$12 million. Financing cash flow is $7 million − $2 million = +$5 million. Together, those two sections reduce cash by $7 million before operating cash flow. The equipment, debt, and retained earnings schedules should reflect the same transactions.

Watch the distinction: A loan draw is cash received, but it is not operating revenue. Placing it in operating cash flow hides whether the business itself generates enough cash to fund activity.

Reference: [1]

18. Close the cash balance

Closing cash equals opening cash plus operating, investing, and financing cash flows. The cash flow statement therefore acts as a bridge between two balance sheet dates. Link its calculated closing cash directly to the balance sheet rather than typing a separate value. Check that each cash flow section uses the same period and sign convention; an outflow entered as positive will overstate closing cash. If a scenario contains a required minimum cash balance, compare that requirement with the calculated closing amount and show the funding gap explicitly. The cash bridge should reconcile even when the balance sheet as a whole does not, so use both checks. A matching cash balance verifies this linkage, while a full balance sheet check tests the remaining statement connections.

Worked example: Opening cash is $15 million. Operating cash flow is +$24 million, investing cash flow is −$18 million, and financing cash flow is −$4 million. Net cash movement is $24 million − $18 million − $4 million = +$2 million. Closing cash is $15 million + $2 million = $17 million, which is the amount the closing balance sheet must display.

Watch the distinction: Do not use closing cash as an arbitrary balancing figure. If the balance sheet fails to balance, trace the underlying schedule links; forcing cash can conceal the error.

Reference: [1]

19. Diagnose a balance-sheet break

Calculate a signed check as assets minus liabilities minus equity, and display zero when the statements balance. Both the size and sign of a break help locate a missing entry. A dividend paid reduces cash and retained earnings by the same amount, leaving the check unchanged. If cash falls but retained earnings do not, assets are too low relative to liabilities plus equity, so the signed check is negative. If retained earnings falls but cash does not, the check is positive. Trace the amount through the transaction schedules before editing any formula. A break equal to a known dividend, depreciation charge, or capital purchase is a useful clue, though equal amounts can occur by coincidence. For more practice tracing links, use the FMVA practice questions.

Worked example: Suppose a balanced model pays a $6 million dividend. Cash falls $6 million, but retained earnings is mistakenly unchanged. Assets minus liabilities minus equity becomes −$6 million: liabilities plus equity exceed assets by $6 million. Deducting the dividend from retained earnings lowers equity by $6 million and restores a zero check. A positive $6 million break would suggest the opposite missing cash entry.

Watch the distinction: The direction of the break matters. When cash is reduced but retained earnings is not, assets cannot exceed liabilities plus equity because the only recorded movement lowered assets.

Reference: [1]

20. Compare coherent scenarios

A scenario represents a plausible set of linked business conditions, not an isolated cell change. Lower demand may reduce sales volume and also weaken pricing power; the combined effect can compress contribution margin. Build each case from explicit operating assumptions, then run the same formulas through the income statement, cash flow statement, and balance sheet. Compare outputs relevant to the decision, such as contribution, closing cash, or funding needs. To explain the difference, separate the effect of changing sales from the effect of changing margin using a stated bridge convention. Check that every case remains internally consistent and that the assumptions are credible together. Scenario thinking also supports later valuation applications, where alternative operating paths can produce different cash flow estimates.

Worked example: Base revenue is $100 million at a 30% contribution margin, producing $30 million contribution. A downside case has $90 million revenue at a 25% margin, producing $22.50 million. The decline is $7.50 million. At the old margin, the $10 million revenue loss explains $3 million; the five percentage-point margin drop on $90 million explains another $4.50 million.

Watch the distinction: Do not apply a downside revenue assumption while retaining an incompatible margin assumption without explanation. The case may understate risk if weaker demand also changes price or unit cost.

Reference: [1]

21. Measure sensitivity and stress

A sensitivity test changes one assumption while holding the others fixed. It answers a focused question, such as how much contribution changes for each $1 movement in price. A stress case changes several linked assumptions to represent an adverse business condition. Start with a clearly labeled base case, choose plausible alternative inputs, and let the same formulas calculate every case. Compare both the absolute change and its percentage of the base result. Check whether an input change should affect another line: lower volume may reduce variable costs, while fixed rent may remain unchanged. A stress case is useful for examining funding needs and downside exposure, but it is a conditional result, not a probability forecast. The FMVA curriculum includes scenario and sensitivity analysis.

Worked example: Assume 1,000 units sell at a $12 contribution per unit, with unit cost unchanged if price changes. Base contribution is 1,000 × $12 = $12,000. Cutting price by $1 alone gives 1,000 × $11 = $11,000, a $1,000 decline. If the same price cut accompanies a fall to 800 units, contribution is 800 × $11 = $8,800, or $3,200 below base. The stress combines price and volume effects.

Watch the distinction: Calling the $3,200 decline a price sensitivity hides the volume change. Keep the single-variable result separate so you can see each assumption's effect.

Reference: [1]

Accounting

22. Read the three statements together

The income statement measures performance over a period, the balance sheet shows assets, liabilities, and equity at a date, and the cash flow statement explains movements in cash during the period. Read them as connected views of the same transactions. A credit sale can raise revenue and profit before any customer payment arrives; the unpaid amount becomes a receivable. An expense can reduce profit before or after cash is paid, depending on timing. When building a model, trace net income into equity and trace noncash items and working capital changes into operating cash flow. Then check that ending cash agrees with the balance sheet and that assets equal liabilities plus equity. The FMVA practice questions can help you rehearse these links.

Worked example: Assume no tax and opening balances of zero. A firm sells goods for $10 on credit and pays $6 cash for those goods. Revenue of $10 less cost of $6 gives $4 profit. Cash falls $6, while receivables rise $10, so net assets rise $4 and equity rises $4. Until collection, the cash flow is negative despite positive profit.

Watch the distinction: Treating $4 profit as $4 cash ignores the unpaid customer bill. Trace the $10 receivable and the $6 cash payment before assessing liquidity.

Reference: [1]

23. Apply accrual accounting

Accrual accounting assigns an expense to the period in which the related work or benefit is received, even if payment occurs later. This lets the income statement reflect the resources used to earn that period's revenue. If a company owes wages at month-end, it records wage expense and a payable. The later payment settles that liability; it does not create a second expense. In a forecast, separate the expense schedule from the payment schedule when timing matters. Closing payable equals opening payable plus expense recognized minus cash paid, assuming no other adjustments. A rising payable can temporarily support cash, but it does not improve operating profit. Check whether an apparent profit improvement comes from lower expense or merely from delayed payment.

Worked example: Workers earn $5 of wages in December, payable in January. December's income statement records $5 wage expense, and its balance sheet records a $5 wage payable. If opening payable was zero, January payment of $5 reduces cash and payable to zero. January records no new expense for those December wages. Across both months, expense and payment each total $5.

Watch the distinction: Recording wages only when paid moves December's cost into January and overstates December profit. Payment timing determines cash flow, while work timing determines this expense.

Reference: [1]

24. Trace a credit sale

A credit sale creates revenue when the promised service or goods are delivered under the assumed recognition terms, while collection can happen later. At delivery, record a receivable for the customer's obligation and revenue for the earned amount. At collection, replace the receivable with cash. That exchange changes the composition of assets but creates no additional revenue. For modeling, forecast sales and collections separately: revenue drives reported performance, while collection timing drives receivables and operating cash. A receivables roll-forward is opening receivables plus credit sales minus collections, adjusted for write-offs or other specified items. If sales rise faster than collections, reported growth may coexist with cash pressure. Investigate whether the gap reflects normal terms, slower payment, or doubtful balances.

Worked example: A firm completes a $12 service in March, bills the customer, and collects in April. Assume no opening receivables or other sales. March revenue rises $12 and closing receivables become $12; cash from this customer is zero. In April, cash rises $12 and receivables fall from $12 to zero. April revenue from this completed service is zero because collection settles an existing claim.

Watch the distinction: Adding $12 revenue again when April cash arrives counts the service twice. Reconcile the receivable instead: the March asset turns into April cash.

Reference: [1]

25. Reconcile inventory and gross profit

Inventory is an asset while goods remain unsold. When goods are sold, their cost moves to cost of goods sold, which reduces gross profit. The basic reconciliation is opening inventory plus purchases minus closing inventory equals cost of goods sold, assuming no other movements such as write-downs. Gross profit is sales minus that cost. This calculation helps diagnose inconsistent records: an unexpectedly high closing inventory lowers reported cost of goods sold and raises gross profit, but it may also signal slow-moving stock. Use consistent units and valuation assumptions when comparing periods. In a model, connect purchases, cost of goods sold, and inventory rather than forecasting all three independently; otherwise, the balance sheet and income statement can imply different quantities of goods.

Worked example: Assume all amounts are in thousands of dollars and there are no write-downs. Opening inventory is $14, purchases are $46, and closing inventory is $18. Goods available for sale cost $14 + $46 = $60. Cost of goods sold is $60 − $18 = $42. With sales of $70, gross profit is $70 − $42 = $28, a 40% gross margin.

Watch the distinction: Using purchases of $46 as cost of goods sold ignores the $4 net increase in inventory. Reconcile opening and closing stock before calculating margin.

Reference: [1]

26. Understand noncash depreciation

Depreciation allocates an asset's recorded cost across periods of use. The current period's charge reduces operating profit and the asset's net book value through accumulated depreciation. It is noncash in that period: cash left when the asset was purchased, unless the purchase itself remains unpaid. In an indirect cash flow statement, depreciation is added back to net income because net income included the charge without a current cash outflow. That add-back does not create cash or reverse the economic wear of the asset. Keep the asset purchase in the capital spending schedule and depreciation in the income statement and fixed-asset roll-forward. If depreciation methods or useful-life estimates change, reported profit and book value change even when the asset's purchase cash flow does not.

Worked example: Suppose a machine was purchased in a prior year for $60, has no residual value, and carries $10 depreciation this year. Relative to a forecast without that charge, this year's pretax profit and net book value are each $10 lower. There is no new $60 purchase cash outflow this year. An indirect operating cash flow reconciliation adds back the $10 noncash charge to net income.

Watch the distinction: Adding back depreciation in operating cash flow does not mean the machine was free. Its $60 purchase affected cash when acquired and belongs in the capital spending analysis.

Reference: [1]

27. Distinguish capital spending from expense

Capital spending buys or improves an asset expected to provide benefits beyond the current period, subject to the applicable accounting policy. The initial amount becomes a balance sheet asset; depreciation or amortization then allocates its cost to later income statements. An ordinary expense is recognized in the period it is incurred or consumed. The distinction changes the timing of reported profit, not the initial cash paid for the item. When comparing companies, inspect capitalization policies because aggressive capitalization can make current operating profit appear stronger while increasing future charges. In a forecast, link qualifying capital spending to the fixed-asset schedule and subsequent depreciation. Do not assume that every payment with a long description is capitalizable; the nature of the benefit and accounting treatment determine the classification.

Worked example: Assume a $24 machine qualifies for capitalization, has a three-year useful life, no residual value, and straight-line depreciation. First-year depreciation is $24 / 3 = $8. If the full $24 were instead expensed immediately, first-year pretax profit would be $24 − $8 = $16 lower, all else equal. The initial $24 cash payment is the same under either presentation.

Watch the distinction: Capitalizing a qualifying machine does not eliminate its cost from profit forever. It spreads the recognized expense across useful periods and leaves future depreciation charges.

Reference: [1]

28. Recognize deferred revenue

Cash received before a company delivers the promised service is usually an obligation to the customer, represented by deferred revenue. Receipt increases cash and a liability, with no immediate earned revenue under the assumed arrangement. As service is provided, the liability falls and revenue rises. A useful roll-forward is opening deferred revenue plus advance billings or collections minus revenue recognized, allowing for any refunds or other adjustments. In a model, this timing can produce strong current cash while reported revenue appears later. It also means a deferred revenue balance points to future delivery work, not necessarily future cash collection for that same contract. Read the service terms carefully: recognition should follow delivery or satisfaction of the obligation, rather than an arbitrary cash date.

Worked example: A customer pays $12 for twelve months of evenly delivered service. At receipt, cash rises $12 and deferred revenue rises $12; revenue remains zero. After three completed months, revenue recognized is $12 × 3/12 = $3. Deferred revenue falls to $9, representing nine months of service still owed. Total cash received remains $12, assuming no refund or additional payment.

Watch the distinction: Recognizing all $12 as revenue on receipt would overstate service delivered to date. The $9 remaining liability records work still owed to the customer.

Reference: [1]

29. Separate principal and interest

A loan payment can contain two economically different parts. Principal repays the amount borrowed and reduces the debt balance; interest is the cost of using the lender's funds and reduces pretax profit. Both parts reduce cash when paid. In a debt schedule, closing debt equals opening debt plus new borrowing minus principal repaid, before any specified noncash adjustments. Interest is calculated under a stated balance and timing convention, then linked to the income statement. Separating the two prevents repayment from being counted as an operating expense and prevents interest from silently changing the principal balance. The cash flow statement must reconcile the full payment, although the section used for interest can depend on the reporting framework. Check the loan terms for accrued but unpaid interest.

Worked example: Assume a scheduled $11 cash payment comprises $9 principal and $2 interest, with no unpaid interest from another period. Cash falls $11. Debt falls $9, while $2 interest expense reduces pretax profit. If opening debt was $50 and there were no new draws, closing debt is $50 − $9 = $41. The $2 interest does not reduce debt principal.

Watch the distinction: Expensing all $11 understates profit and leaves debt too high. Allocate the payment using the loan schedule, then reconcile both debt and cash.

Reference: [1]

30. Separate tax expense from tax paid

Tax expense is the charge recognized in the income statement for the period; cash tax paid is the amount remitted. They need not match because payment dates and accounting recognition dates differ. For a simple model without deferred taxes or other adjustments, closing tax payable equals opening payable plus tax expense minus cash paid. A higher closing payable means some recognized expense remains unpaid. When reconciling operating cash flow, the change in this payable helps explain why net income and cash differ. Keep the tax-rate assumption, tax expense, and payment schedule distinct, especially when profit changes late in a forecast. This simple payable roll-forward cannot explain deferred tax assets or liabilities, refunds, or tax charges relating to other periods; model those separately if the case includes them.

Worked example: Assume all figures are in millions of dollars and there are no deferred taxes or refunds. Opening tax payable is $3 million, current tax expense is $8 million, and the company pays $7 million in cash. Closing tax payable is $3 million + $8 million − $7 million = $4 million. The $1 million increase explains why cash tax paid is below current tax expense.

Watch the distinction: Setting cash tax paid equal to tax expense would erase the payable change. Use the opening balance and actual payment schedule to reconcile the liability.

Reference: [1]

31. Normalize operating earnings

Normalizing earnings removes a clearly identified unusual item to estimate performance that may better represent ongoing operations. Begin with reported profit and verify where the item was recorded. Add back an unusual expense or subtract an unusual gain only if the adjustment is relevant, measurable, and disclosed. Then keep ordinary costs, even when management dislikes them. The question is whether the item is expected to recur as part of running the business, not whether excluding it produces a higher number. A normalized measure can help compare periods or support valuation multiples, but it remains an analytical estimate rather than reported profit. Review several years for repeated supposedly exceptional charges and consider whether the company will incur similar costs to sustain operations.

Worked example: Reported operating profit is $18 million after a separately identified $5 million legal settlement assumed to be unusual. Adding it back gives adjusted operating profit of $23 million. A $4 million maintenance bill is expected every year and stays in operating costs, so adjusted profit remains $23 million. Report both $18 million and $23 million, identifying the single adjustment and its assumption.

Watch the distinction: Adding back recurring maintenance because it depresses margin turns normalization into selective cost removal. Retain costs needed to operate the business in future periods.

Reference: [1]

32. Interpret liquidity and leverage

Liquidity ratios compare resources available soon with obligations due soon. The current ratio divides current assets by current liabilities. A quick ratio removes inventory and other assets that may not turn into cash promptly, using the remaining readily realizable assets over current liabilities. These measures are snapshots, so also inspect collection timing, inventory quality, and upcoming payments. A company can show a comfortable current ratio while depending heavily on selling stock to meet bills. Leverage asks a different question: how much financing comes from debt and whether future cash generation can service it. Debt-to-equity and interest coverage offer different views, but each needs careful definitions. Analyze liquidity and leverage together because debt maturities can strain cash even when the asset base appears substantial.

Worked example: Assume all amounts are in millions of dollars. Current assets are $90 million, including $30 million inventory; the remaining $60 million consists of cash and receivables. Current liabilities are $45 million. The current ratio is $90 million / $45 million = 2.00. The quick ratio is ($90 million − $30 million) / $45 million = 1.33. One-third of current assets requires inventory sale before becoming cash.

Watch the distinction: A 2.00 current ratio alone does not prove bills can be paid on time. Examine receivable collection, inventory saleability, and debt maturities.

Reference: [1]

33. Measure returns on capital

Return on invested capital, or ROIC, compares after-tax operating profit with the capital committed to operations. A common numerator is net operating profit after tax, often called NOPAT, which excludes financing costs so the result can be compared with funding costs. The denominator is average invested capital across the period, such as operating assets less noninterest-bearing operating liabilities under a consistently applied definition. Using an average matters when capital changes during the year; an ending balance alone can distort the return generated over the period. A higher ROIC can result from stronger margins, more efficient asset use, or lower operating capital needs. Check both numerator and denominator before calling an increase an improvement, and use consistent treatment of leases, acquisitions, and excess cash across comparisons.

Worked example: A business earns $15 million in after-tax operating profit on $100 million average invested capital. ROIC is $15 million / $100 million = 15%. If average invested capital rises to $125 million while operating profit stays $15 million, ROIC becomes $15 million / $125 million = 12%. The extra $25 million of capital has not yet produced additional profit.

Watch the distinction: Using net income in the numerator mixes operating return with financing effects. Start with after-tax operating profit and pair it with consistently defined operating capital.

Reference: [1]

Valuation

34. Choose a valuation method

Choose a valuation method by asking what evidence is credible and what value the decision requires. A discounted cash flow model, or DCF, estimates value from forecast cash available to capital providers, so it is useful when operating forecasts and a long-run outlook can be defended. Trading comparables infer value from public peers' market prices and matched financial measures; their strength depends on peer similarity. Precedent transactions use acquisition prices and can reflect deal conditions, control, and synergies. Each method produces an indication, not a mechanically correct answer. Reconcile differences by examining growth, margins, risk, timing, and deal terms. If the decision is an acquisition, transaction evidence may be particularly relevant, while a DCF tests what the buyer's cash assumptions imply. The ABV study guide provides a related valuation perspective.

Worked example: Suppose a mature company has credible five-year cash forecasts and several close listed peers. Build a DCF from its own forecast cash flows, then compare the implied multiple with peer trading multiples. If advising on an acquisition price, also review relevant transaction multiples and their deal terms. A high transaction multiple may reflect buyer-specific benefits, so it should not automatically replace the stand-alone DCF result.

Watch the distinction: Selecting the highest method output because it supports a desired price reverses the reasoning. Choose and weight evidence based on forecast quality and comparability.

Reference: [1]

35. Calculate free cash flow to the firm

Free cash flow to the firm, or FCFF, estimates cash generated by operations after necessary reinvestment and before payments to debt or equity investors. Start with earnings before interest and tax, or EBIT, because it measures operating profit before financing. Apply a modeled tax rate to derive after-tax operating profit. Add back noncash depreciation, subtract capital spending, and subtract an increase in noncash operating working capital. A decrease in that working capital releases cash and is added instead. Keep financing items such as interest and principal repayment out of FCFF, then discount FCFF at a rate appropriate for all capital providers. Define working capital carefully: cash and debt are usually handled outside this operating measure. Check that forecasts for capital spending and working capital can support the growth assumed.

Worked example: All figures are in millions of dollars. EBIT is $40 million, the hypothetical modeled tax rate is 25%, depreciation is $6 million, capital spending is $10 million, and noncash operating working capital rises $3 million. After-tax EBIT is $40 million × 75% = $30 million. FCFF is $30 million + $6 million − $10 million − $3 million = $23 million, before financing payments.

Watch the distinction: Subtracting interest from FCFF and then using a WACC discount rate counts financing costs twice. FCFF is cash available before debt and equity payments.

Reference: [1]

36. Calculate a modeled WACC

Weighted average cost of capital, or WACC, combines the required return on equity and the after-tax cost of debt in proportions that reflect the modeled capital structure. The basic formula is equity weight × cost of equity plus debt weight × cost of debt × (1 − tax rate). The debt tax adjustment assumes interest provides a usable tax benefit under the model's assumptions. Use weights that sum to 100%, typically based on market values or a defensible target structure rather than stale accounting balances. Match the discount rate to the cash flow: WACC is commonly paired with FCFF, which belongs to all capital providers. Keep currency, inflation basis, and risk assumptions consistent. Small WACC changes can materially alter a DCF, particularly when terminal value is a large share of enterprise value.

Worked example: Assume a hypothetical firm targets 70% equity and 30% debt. Its equity cost is 10%, debt cost is 6%, and modeled tax rate is 25%, with a usable interest tax benefit. Equity contributes 0.70 × 10% = 7.00 percentage points. Debt contributes 0.30 × 6% × 75% = 1.35 points. WACC is 7.00% + 1.35% = 8.35%.

Watch the distinction: Averaging 10% and 6% to get 8% ignores financing weights and the modeled tax benefit. Calculate each weighted component before adding them.

Reference: [1]

37. Discount explicit cash flows

A DCF converts forecast cash received in different years into value at one valuation date. Under a year-end convention, cash flow in year one is divided by (1 + discount rate), year two by its square, and so on. This reflects the return required for waiting and bearing risk. State whether cash flows occur at year-end, midyear, or another point; switching conventions changes present value. Forecast FCFF should be discounted with a rate consistent with cash available to all capital providers. Sum the present values of explicit forecast years before adding any separately calculated terminal value. When reviewing an Excel model, check the discount-period row as carefully as the cash flows: an off-by-one exponent can materially misstate value. The FMVA certification page identifies DCF modeling as a core course topic.

Worked example: Assume valuation occurs at time zero, FCFF arrives at each year-end, and the discount rate is 10%. Year-one FCFF is $11 million, worth $11 million / 1.10 = $10 million today. Year-two FCFF is $12.10 million, worth $12.10 million / 1.10² = $10 million. The explicit two-year present value is $20 million before any terminal value.

Watch the distinction: Discounting both flows by one year overvalues the second payment. Count the periods from the valuation date to each cash receipt.

Reference: [1]

38. Estimate terminal value

Terminal value represents operating cash flows after the explicit forecast period. Under a perpetual-growth method, forecast the first cash flow beyond that period and divide it by WACC minus the stable growth rate. The resulting value sits at the end of the final forecast year, so it must then be discounted to the valuation date. The growth rate must be below WACC, and both must use consistent nominal or real terms and currency. A stable-growth assumption should also be consistent with reinvestment: growth generally requires capital spending or working capital. Because terminal value can dominate a DCF, test the sensitivity to both WACC and growth and compare the implied operating multiple with plausible market evidence. The formula is unsuitable if the final forecast cash flow is temporarily abnormal.

Worked example: Assume year-five FCFF is $20 million and can grow sustainably at a hypothetical 2% each year after year five. Year-six FCFF is $20 million × 1.02 = $20.40 million. At an 8% WACC, terminal value at the end of year five is $20.40 million / (8% − 2%) = $340 million. It still needs five years of discounting to obtain today's value.

Watch the distinction: Using year-five cash flow directly in the numerator misses the first post-forecast year's growth. Also, $340 million is a year-five value, not today's value.

Reference: [1]

39. Bridge enterprise and equity value

Enterprise value represents the value of operating assets to the capital providers as a group. Equity value is the residual attributable to shareholders after claims such as debt are considered. In a simple bridge, subtract debt from enterprise value and add excess cash, because excess cash is a nonoperating asset available alongside the operations. Use consistent definitions: cash required to run the business should not automatically be treated as excess, and other claims or nonoperating assets may need separate adjustments when present. Once equity value is calculated, divide by the relevant diluted share count to estimate value per share. A model should display this bridge explicitly so a reader can distinguish an operating valuation change from a financing-balance change. Check whether quoted multiples already use net debt.

Worked example: Assume enterprise value is $500 million, debt is $120 million, and $30 million of cash is genuinely excess to operating needs. Equity value is $500 million − $120 million + $30 million = $410 million. With 10 million relevant shares outstanding, implied value is $410 million / 10 million shares = $41 per share. Operating cash needed by the company was excluded from the $30 million.

Watch the distinction: Dividing $500 million enterprise value by shares gives a price that ignores lenders' claim. Bridge to equity value first, then calculate value per share.

Reference: [1]

40. Apply trading comparables

Trading comparables estimate value from prices investors currently assign to similar public companies. First select peers with reasonably comparable businesses, growth, margins, risk, and accounting policies. Calculate each peer's valuation multiple using matching measures: enterprise value pairs with EBITDA or another pre-financing operating metric, while equity value pairs with earnings attributable to shareholders. Apply a representative peer multiple to the target's measure for the same period, then bridge enterprise value to equity value if needed. Normalize unusual items consistently and check whether reported EBITDA definitions differ. A single multiple does not explain why a target deserves the peer level, so compare the underlying drivers before accepting the result. For example, weaker margins or higher risk may justify a lower multiple even when the businesses sell similar products.

Worked example: Assume selected peers trade at a representative 8× enterprise value to EBITDA multiple. The target has $25 million of EBITDA measured on the same basis. Implied enterprise value is 8 × $25 million = $200 million. If target net debt is $40 million and there are no other bridge adjustments, implied equity value is $200 million − $40 million = $160 million. The multiple gives an indication, not a guaranteed price.

Watch the distinction: Applying an equity-value multiple to EBITDA mixes a shareholder numerator with a pre-financing denominator. Match the metric to the claim being valued.

Reference: [1]

41. Interpret transaction multiples

A precedent transaction multiple relates the price paid for an acquired business to a measure of its financial performance. For EV/EBITDA, first establish enterprise value on a consistent basis, then divide it by EBITDA for the stated period. Check whether that EBITDA is historical or forecast and whether adjustments removed unusual items. Apply the resulting multiple to the same type of EBITDA at the company being valued. Acquisition prices can differ from public trading values because buyers may expect synergies, seek control, or accept different risks and deal terms. A high transaction multiple is therefore evidence to investigate, not a premium to copy automatically. The FMVA program includes precedent transaction analysis within its valuation skills.

Worked example: Suppose an acquisition has an enterprise value of $300 million and the target's historical EBITDA is $30 million. EV/EBITDA is $300 million ÷ $30 million = 10×. Applying 10× to a second company's comparable $20 million EBITDA suggests a $200 million enterprise value. Before using it, check both EBITDA periods and whether growth prospects, synergies, or deal terms explain a different multiple.

Watch the distinction: A tempting shortcut is to call $200 million the second company's equity value. The multiple produces enterprise value; debt and excess cash still need a consistent bridge to equity.

Reference: [1]

42. Reconcile valuation indications

A discounted cash flow model prices forecast cash flows under explicit assumptions, while trading and transaction multiples reflect different sets of observed prices. Put every indication on the same basis, such as enterprise value, before comparing them. Then trace gaps to the drivers: forecast growth, margins, reinvestment, discount rate, peer selection, transaction synergies, and measurement dates. A range can show the spread of credible evidence, but its endpoints need judgment. An outlier supported only by optimistic inputs may deserve less weight; a transaction involving substantial synergies may say little about standalone value. Record the conditions under which each method is persuasive, then state which assumptions would move your conclusion. The same comparison discipline is useful in broader CFA valuation study.

Worked example: Assume three enterprise value indications, all in millions: DCF $240, trading peers $200, and transactions $260. The observed span is $200 million to $260 million. The DCF exceeds trading peers by $40 million, or 20% of the trading indication. Investigate whether its stronger growth or margin forecast supports that premium; transaction synergies may explain why deals imply still more.

Watch the distinction: Averaging all three values to $233.33 million can look objective, but equal weighting hides differences in peer quality, deal terms, and forecast credibility.

Reference: [1]

Financial Planning & Analysis (FP&A)

43. Build a baseline forecast

A baseline extends known performance using a defensible pattern before layering in specific new initiatives or risks. Start by making historical periods comparable: align dates, accounting treatment, currency, and any one-time effects. For a seasonal business, a quarter's share of annual revenue is more informative than a simple annualization. Divide the current quarter's revenue by its typical annual share to estimate a full-year baseline, then compare that result with capacity, orders, and recent trends. If the seasonal mix is changing, treat the historical share as a testable assumption. A baseline is a reference case, not a prediction guaranteed by history. It helps you identify which subsequent changes arise from new commercial assumptions rather than from the calendar.

Worked example: A company earns $20 million in the first quarter, which historically contributes 20% of annual revenue. The seasonal baseline is $20 million ÷ 0.20 = $100 million for the year. Multiplying by four gives only $80 million because it assumes equal quarters. The $100 million estimate is reasonable only if the historical seasonal pattern still applies.

Watch the distinction: Annualizing the latest quarter by four is convenient, but it assumes every quarter contributes equally. Check the seasonal pattern before treating that result as a baseline.

Reference: [1]

44. Forecast from commercial drivers

Revenue becomes easier to challenge when it is built from observable steps rather than one growth percentage. For a lead-based business, a simple tree is leads multiplied by conversion rate multiplied by revenue per converted customer. Define each term carefully: qualified leads may differ from all enquiries, and first-year sales may differ from lifetime value or cash collected. Check that the time periods match and that a customer is counted once. Then test the assumptions against sales capacity, historical conversion, pricing, and customer mix. The driver tree makes a variance diagnostic: fewer leads, lower conversion, and smaller purchases have distinct operational remedies. If revenue contains renewals or repeat purchases, model those separately so new-customer conversion does not carry the entire forecast.

Worked example: Assume 1,000 qualified leads, 20% conversion, and $500 in first-year revenue per new customer. That yields 1,000 × 0.20 = 200 customers and 200 × $500 = $100,000 revenue. At 18% conversion, the same leads produce 180 customers and $90,000 revenue, a $10,000 shortfall. This isolates conversion as the changed driver.

Watch the distinction: Applying the conversion rate to all website visitors when it was measured on qualified leads inflates the forecast. Keep the denominator consistent with the observed rate.

Reference: [1]

45. Explain a revenue variance

Revenue equals units sold times price per unit, so a change in revenue can be split into volume and price effects. Choose a convention before calculating. One useful bridge measures the volume change at budget price, then measures the price change on actual units. The two effects sum exactly to actual revenue minus budget revenue. This sequence assigns the interaction between price and volume to the price step; reversing the sequence gives different component amounts while preserving the total. State the convention so another analyst can reproduce the bridge. Next interpret the result: a favorable price variance can conceal lost customers or a shift toward expensive products. If products differ materially, calculate the bridge by product or separate mix from pure volume.

Worked example: Budget revenue is 100 units × $10 = $1,000. Actual revenue is 90 units × $12 = $1,080. At budget price, selling 10 fewer units reduces revenue by 10 × $10 = $100. The $2 higher price on 90 actual units adds $180. Together, −$100 + $180 = an $80 favorable variance.

Watch the distinction: Calling the full $80 gain a pricing success ignores the 10-unit decline. The price improvement and volume loss have different causes and may imply different decisions.

Reference: [1]

46. Explain a cost variance

A cost increase is not automatically poor spending control. When cost depends on activity, separate the effect of producing or selling more units from the effect of paying more per unit. Under a clear convention, value the activity change at the budget unit cost. Then apply the difference between actual and budget unit cost to actual activity. Those steps reconcile budget cost to actual cost. A higher unit rate may reflect supplier pricing, waste, product mix, or a purchasing choice, so investigate before assigning responsibility. Likewise, extra volume can be desirable if it supports profitable sales. Match the activity measure to the cost driver: materials may follow production units, while commissions follow sales. Fixed costs need a different analysis because their amount does not move proportionally with units.

Worked example: Budget materials cost is 100 units × $4 = $400. Actual cost is 110 units × $5 = $550. The 10 extra units add 10 × $4 = $40 at budget cost. The $1 higher rate on 110 actual units adds $110. The $40 + $110 = $150 increase reconciles to $550 and is unfavorable for cost alone.

Watch the distinction: Comparing $550 with $400 and blaming purchasing for $150 misattributes the extra activity. First separate the $40 volume effect from the $110 unit-rate effect.

Reference: [1]

47. Update a rolling forecast

A forecast should incorporate what has happened and revise what remains. Replace an elapsed period's estimate with its actual result, then re-estimate future periods using current demand, capacity, pricing, and cost information. Keep the original budget as a comparison point; overwriting it erases the record of the initial plan. Calculate both the new full-year outlook and a bridge from the budget, distinguishing the realized variance from revisions to later quarters. Watch for double counting when a delayed sale moves from one period to another: a missed first-quarter order that is expected in the second quarter may alter timing without changing the year. State the update date and the remaining assumptions so the forecast can be assessed as information changes.

Worked example: The original budget is four quarters of $25 million, totaling $100 million. First-quarter actual sales are $22 million. Updated forecasts for quarters two through four are $26 million, $27 million, and $28 million. Full-year revenue is now $22 + $26 + $27 + $28 = $103 million. The first-quarter $3 million shortfall is more than offset by $6 million of later-quarter increases.

Watch the distinction: Adding revised future quarters to the original first-quarter budget would give $106 million and ignore the known $22 million actual result. Replace elapsed estimates with actuals.

Reference: [1]

48. Frame a planning decision

Evaluate a proposed action using incremental effects: revenue gained because of the action, the variable costs needed to earn it, and the additional fixed cost. Contribution margin converts incremental revenue into contribution before the new fixed cost. Divide the fixed cost by the contribution margin to find the revenue needed to break even, provided the margin is expressed as a fraction and capacity is sufficient. Compare the forecast with that hurdle, then identify the uncertain driver most likely to reverse the conclusion. Consider timing, ramp-up, and any displacement of existing sales; a full-year revenue figure cannot automatically support a full-year hire cost if sales arrive late. Present the decision as conditional on explicit assumptions rather than hiding uncertainty in a single profit estimate.

Worked example: A proposed sales hire costs $80,000 for the year and is expected to add $120,000 revenue at a 50% contribution margin. Added contribution is $120,000 × 0.50 = $60,000, leaving a $20,000 shortfall. Break-even incremental revenue is $80,000 ÷ 0.50 = $160,000. The forecast would need $40,000 more revenue at the same margin.

Watch the distinction: Comparing $120,000 revenue directly with an $80,000 salary suggests a gain, but it ignores the variable costs required to earn that revenue.

Reference: [1]

Excel

49. Use efficient workbook navigation

Keyboard navigation saves time only when it preserves control over the selected cells. In a populated row, move to the edge of a data block, extend the selection across the intended periods, and inspect the formula range before accepting an automatic total. Blank cells, hidden columns, and adjacent totals can change where a navigation command lands. Use clear row and column labels so a formula's location has meaning, and keep the total outside its own source range. After copying a formula, check that relative and absolute references moved as intended. A quick reasonableness check should compare the total with its components. These habits support the Excel work described in the FMVA scope and make FMVA practice questions more useful as application exercises.

Worked example: Suppose B2:D2 contain monthly revenue of $120, $80, and $100, all in thousands of dollars. Select B2:D2 and put `=SUM(B2:D2)` in E2. The total is $120 + $80 + $100 = $300 thousand. Inspect the highlighted range: including E2 would create a circular reference, while omitting D2 would understate revenue by $100 thousand.

Watch the distinction: Accepting AutoSum without checking its highlighted range can omit a month after a blank cell or include the total cell. Verify the endpoints before moving on.

Reference: [1]

50. Aggregate with criteria

A conditional sum answers a defined question about records, such as revenue for one region or one period. `SUMIFS` adds values from a sum range only when corresponding cells in each criteria range satisfy their tests. Make those ranges the same size and ensure the labels are consistent; spaces, inconsistent spellings, and text dates can silently exclude records. A single region criterion produces a regional total, while additional criteria can narrow it by month, product, or customer type. Reconcile selected subtotals to a broader total when categories are meant to be exhaustive. This check reveals missing or duplicated labels. Conditional aggregation is useful in models because new rows can flow into the summary when ranges or structured table references cover them.

Worked example: Assume rows 2:4 contain regions North, North, South and sales of $40, $60, and $30 thousand. With regions in A2:A4 and sales in B2:B4, `=SUMIFS(B2:B4,A2:A4,"North")` returns $100 thousand. `=SUM(B2:B4)` returns $130 thousand. The $30 thousand difference is the South record, not an arithmetic error.

Watch the distinction: Using an unfiltered `SUM` for a regional forecast includes every region. A correct grand total can still be the wrong answer to a filtered question.

Reference: [1]

51. Match inputs with lookups

A lookup links a transaction or forecast line to an assumption table through a stable identifier, such as a product code. Use an exact match for codes so a missing product cannot borrow a nearby value. Check whether the key is unique in the source table: if two rows share an identifier, a lookup may return one cost and conceal the conflict. Treat an absent match as a visible error to resolve, rather than replacing it with zero or an arbitrary default. Also check data types and stray spaces when a code appears present but does not match. Once the unit cost is retrieved, multiply it by the correct quantity and verify the result against an independent calculation. This keeps assumptions centralized and changes traceable.

Worked example: A cost table assigns product A $7 per unit and product B $9 per unit. An exact lookup for B returns $9. At 20 B units, modeled cost is 20 × $9 = $180. If B is missing from the table, display a missing-match warning; using A's $7 would report $140 and understate cost by $40.

Watch the distinction: Suppressing a lookup error with zero makes an incomplete assumption table look like free inventory. Investigate missing and duplicate product codes before trusting the cost output.

Reference: [1]

52. Summarize data with a pivot table

A pivot table groups underlying records without changing their values. Start with a tidy source: one transaction per row, a consistent region field, a numeric amount field, and clear headers. Put region in rows and sales in values, then verify that the value setting is Sum rather than Count. Compare the pivot grand total with a direct total from the source. If they disagree, inspect omitted rows, text stored as numbers, filters, and the pivot's source range. Refresh the pivot after the source changes, especially when a new period's records are added. A pivot helps explore the same data by region, product, or month, but each view still needs a definition of what is included.

Worked example: Four transactions, in thousands of dollars, are East $20, East $30, West $15, and West $25. A region pivot sums East to $50 and West to $40. The grand total is $90, matching $20 + $30 + $15 + $25 = $90 from the source. That reconciliation confirms the four records are represented in this view.

Watch the distinction: A pivot displaying four records may be counting transactions instead of summing dollars. Check the value-field setting and reconcile the grand total to the source.

Reference: [1]

53. Build a two-input data table

A two-input data table recalculates one model output across pairs of assumptions. Link its corner cell to the output formula, place values for one input across the top, and values for the other down the side. Assign those axes to the corresponding model input cells. Each interior result then reflects one pair, which lets you see interactions that separate one-variable tests miss. Label units and keep all other assumptions fixed so the comparison has a clear meaning. Before reading the grid, independently calculate at least one cell and confirm that the row and column inputs were not reversed. When profit depends on unit margin and volume, a lower price can overwhelm a volume increase because each additional unit contributes less.

Worked example: Let profit equal units × (price − $6 variable cost) − $200 fixed cost, all dollars. At 100 units and $10 price, profit is 100 × $4 − $200 = $200. At 120 units and $9 price, profit is 120 × $3 − $200 = $160. The 20 extra units do not offset the $1 lower unit margin.

Watch the distinction: Reading only the higher-volume row suggests improved profit. The table must be read as input pairs; price changes the contribution earned on every unit.

Reference: [1]

Data Visualization

54. Choose a chart for the question

First decide whether the reader needs to compare categories, follow change over time, or understand parts of a whole. Bars support category comparisons; a line can show a time trend; a composition chart should make both the total and its parts clear. Use consistent periods, units, and scales, and label what each series measures. When revenue and profit move in opposite directions, two aligned panels or a margin series can reveal the relationship without relying on a confusing dual axis. A chart should make the financial question easier to answer, not merely display the available data. Calculate the relevant ratio alongside absolute amounts because rising revenue can coexist with falling profitability. Highlight the decision-relevant change and keep decorative elements subordinate.

Worked example: Revenue rises from $100 million to $120 million, while profit falls from $20 million to $18 million. Revenue growth is ($120 − $100) ÷ $100 = 20%. Profit margin falls from $20 ÷ $100 = 20% to $18 ÷ $120 = 15%. Paired trends and a clearly labeled margin line reveal that sales growth came with weaker profitability.

Watch the distinction: Showing revenue alone makes the period look unambiguously stronger. The falling profit and five-percentage-point margin decline change the interpretation.

Reference: [1]

55. Design a decision dashboard

A useful dashboard places a small set of measures beside their comparison points and defines how each is calculated. Put the headline result first, then show the drivers needed to interpret it. Actual versus budget is more informative than actual alone; a dollar variance shows size, while a percentage variance shows scale. Pair revenue with a profitability measure so growth is not mistaken for better economics. Use consistent time periods and units, and distinguish percentages from percentage-point changes. If a reader can drill into segments, keep the top-level figures reconcilable to those details. Mark estimates and incomplete periods visibly. The aim is to help a manager notice a gap, locate its driver, and decide what investigation or action follows.

Worked example: A dashboard shows actual revenue of $108 million against a $100 million budget: variance is +$8 million, or +8%. Actual profit margin is 18% against 20% budget, a two-percentage-point shortfall. Implied profit is $108 million × 18% = $19.44 million, below the $20 million budgeted profit. Higher sales did not produce higher profit.

Watch the distinction: A green +8% revenue indicator alone suggests success, but the margin decline leaves profit $0.56 million below budget. Show related measures together.

Reference: [1]

56. Build a variance waterfall

A waterfall begins with a known starting result, applies signed driver effects, and ends at the observed result. Each step must use the same units and the same definition of profit. Favorable drivers increase the running total; unfavorable drivers reduce it. Order the steps in a way that supports the explanation, such as commercial changes before cost changes, but state the variance convention if interacting drivers could be assigned differently. Reconcile the final bar to actual profit before presenting the chart. A residual or unexplained step should be named and investigated rather than concealed. The visual is valuable because it shows how individually material movements can offset each other and leave a small net variance.

Worked example: Budget profit is $40 million. Higher volume adds $6 million, lower price removes $4 million, and higher wages remove $3 million. The running total moves from $40 million to $46 million, then $42 million, then $39 million. Actual profit is $39 million, so the waterfall reconciles to a $1 million unfavorable variance.

Watch the distinction: A chart that ends at $39 million without checking its steps may hide a missing driver. The signed effects must sum exactly to actual minus budget.

Reference: [1]

57. Present an actionable conclusion

A recommendation should connect the modeled result to the assumption that drives it and the decision it affects. State the forecast change in cash, identify the main use of funds, and show the relevant cash requirement. If the forecast breaches a stated working-cash floor, quantify the gap and name feasible responses such as funding, phasing spending, or improving cash generation. Separate the arithmetic from uncertainty: the forecast depends on operating cash, collection timing, and investment cost. Show which assumption would worsen or remove the gap rather than implying the number is certain. Put the conclusion near the evidence so a reader can verify it quickly. The best presentation makes the decision and its sensitivity visible in one pass.

Worked example: Suppose cash is forecast to fall from $30 million to $8 million after a $15 million expansion. The total decline is $22 million, implying $7 million of other net cash outflows under the stated forecast. If management's hypothetical minimum working cash is $10 million, the plan is $2 million short. It needs at least $2 million of funding or an equivalent plan adjustment.

Watch the distinction: Saying only that closing cash is $8 million leaves the decision unclear. Compare it with the stated cash requirement and identify the assumptions behind the shortfall.

Reference: [1]

Qualitative Business Analysis

58. Translate industry conditions

A broad statement such as weaker market demand becomes useful when it is converted into a measurable operating assumption. Define the market in units, estimate its change, then apply a company share assumption to obtain company volume. Keep the market size and share definitions consistent: share of the served market cannot be multiplied by an unrelated industry total. Challenge whether share will remain stable when demand falls, since competitors may change price or capacity. The resulting volume can feed revenue, variable cost, and capacity plans. Record the source and date of the industry observation, the magnitude of the modeled change, and the business evidence for the share assumption. This turns qualitative analysis into a testable forecast rather than a narrative overlay.

Worked example: Assume a market sells 10,000 units and the company holds a 2% share, or 200 units. In a downside case, market demand falls 5% to 10,000 × 0.95 = 9,500 units. At an unchanged 2% share, company volume becomes 9,500 × 0.02 = 190 units. The ten-unit decline follows directly from the market assumption.

Watch the distinction: Applying a 5% market decline while also reducing company share without stating why mixes two separate risks. Model and explain each change explicitly.

Reference: [1]

59. Assess competitive position

A competitor's move can affect your company through several paths: unit volume, selling price, customer retention, or the cost of responding. Select the path supported by the scenario and avoid burying all effects in a single revenue growth rate. Contribution per unit, defined as selling price less variable cost, provides a quick estimate of how lost volume changes profit before fixed costs. Check whether the contribution rate stays valid as volume changes; discounts, production inefficiency, or lost scale may alter it. Then consider responses such as promotion or product improvement as separate cases with their own costs. A competitive advantage matters financially when you can explain which operating driver it protects and how much value that protection may have.

Worked example: Suppose a rival launch is expected to reduce annual sales from 1,000 to 900 units. If contribution remains $12 per unit, contribution falls from 1,000 × $12 = $12,000 to 900 × $12 = $10,800. The $1,200 loss is before any marketing response or change in fixed costs. A response must recover enough contribution to justify its expense.

Watch the distinction: Treating the 100 lost units as a $1,200 revenue loss confuses contribution with sales. The $12 figure already excludes variable cost and measures profit impact before fixed costs.

Reference: [1]

60. Evaluate risks and opportunities

Compare a specific risk with a response using the same activity level and cost basis. First calculate the financial effect if the risk occurs. Then calculate the response's incremental cost and determine which risk it actually reduces. A more reliable supplier may cost more in normal periods while limiting disruption losses; its value depends on how reliably it prevents the event and how likely the event is. Keep those judgments explicit instead of presenting a scenario as certain. If probabilities are credible, compare expected costs; if they are not, show the break-even probability and a range of outcomes. Include nonprice consequences such as delayed sales or quality only when supported, since they can change the decision materially.

Worked example: Assume a disruption would add $2 cost per unit across 4,000 units, a possible $8,000 loss. An alternative supplier adds $1 per unit, or $4,000, and is assumed to prevent that disruption. If those are the only effects, the alternative costs $4,000 less in the disrupted outcome. Its certain $4,000 premium breaks even at a 50% disruption probability: $4,000 ÷ $8,000.

Watch the distinction: Calling the alternative supplier a guaranteed $4,000 saving assumes disruption will occur and be fully prevented. The decision depends on probability and supplier reliability.

Reference: [1]

Official references and further reading

All study guides

Financial Modeling

1. Define the model’s decision

2. Prepare a historical base

3. Separate inputs from formulas

4. Build an operating driver tree

5. Forecast revenue by segment

6. Link direct costs to activity

7. Model operating expenses

8. Forecast depreciation

9. Roll forward fixed assets

10. Forecast receivables

11. Forecast inventory and payables

12. Roll forward debt

13. Handle interest timing

14. Connect profit and tax

15. Roll forward retained earnings

16. Derive operating cash flow

17. Classify investing and financing cash

18. Close the cash balance

19. Diagnose a balance-sheet break

20. Compare coherent scenarios

21. Measure sensitivity and stress

Accounting

22. Read the three statements together

23. Apply accrual accounting

24. Trace a credit sale

25. Reconcile inventory and gross profit

26. Understand noncash depreciation

27. Distinguish capital spending from expense

28. Recognize deferred revenue

29. Separate principal and interest

30. Separate tax expense from tax paid

31. Normalize operating earnings

32. Interpret liquidity and leverage

33. Measure returns on capital

Valuation

34. Choose a valuation method

35. Calculate free cash flow to the firm

36. Calculate a modeled WACC

37. Discount explicit cash flows

38. Estimate terminal value

39. Bridge enterprise and equity value

40. Apply trading comparables

41. Interpret transaction multiples

42. Reconcile valuation indications

Financial Planning & Analysis (FP&A)

43. Build a baseline forecast

44. Forecast from commercial drivers

45. Explain a revenue variance

46. Explain a cost variance

47. Update a rolling forecast

48. Frame a planning decision

Excel

49. Use efficient workbook navigation

50. Aggregate with criteria

51. Match inputs with lookups

52. Summarize data with a pivot table

53. Build a two-input data table

Data Visualization

54. Choose a chart for the question

55. Design a decision dashboard

56. Build a variance waterfall

57. Present an actionable conclusion

Qualitative Business Analysis

58. Translate industry conditions

59. Assess competitive position

60. Evaluate risks and opportunities

Official references and further reading

Frequently Asked Questions

Related Study Guides

Certified Divorce Financial Analyst (CDFA)

Certified Valuation Analyst (CVA)

Chartered Financial Analyst (CFA)