CheapMocks Academy · Exam guide

Financial Statement Analysis formula sheet.

By , founder (master's degree in finance) · Published · Updated

Financial Statement Analysis is one of the most heavily weighted Level I topics, and its maths is mostly arithmetic on given statements. The marks sit in EPS, converting between cash flow methods, free cash flow, LIFO and FIFO adjustments, impairment, leases, pensions, deferred taxes and the core ratios. Many questions are really about IFRS versus US GAAP, so learn which way each difference pushes the numbers.

Key formulas
28
All formulas
193
Exam weight
11–14%
PDF
60 pages

PDF · A4 · 60 pages

The full Financial Statement Analysis formula sheet

All 193 formulas at a glance, then each one explained. Downloads come with a subscription or a pass; the free trial does not include them.

The 28 key formulas

The Financial Statement Analysis formulas the exam leans on most, with the symbols, what the result means and the trap to avoid. Every other formula of the topic is explained in the Academy, module by module.

8

Long-term contract revenue (input method)

Key formula
Cumulative revenue=Contract price×Costs incurred to dateEstimated total costs\displaystyle \text{Cumulative revenue} = \text{Contract price} \times \dfrac{\text{Costs incurred to date}}{\text{Estimated total costs}}

Where Costs incurred to date ÷\div estimated total costs = percentage of completion; contract price = total transaction price.

Used when control passes to the customer over time, so revenue follows progress rather than delivery. IFRS and US GAAP share the same five-step model here. Revenue for the year is cumulative revenue to date minus revenue already recognised in earlier years.

Exam tip Exam questions ask for one year's revenue: compute the cumulative figure, then subtract what earlier years already booked, using the latest estimate of total costs.

17

Basic EPS

Key formula
Basic EPS=Net income−Preferred dividendsWeighted average ordinary shares outstanding\displaystyle \text{Basic EPS} = \dfrac{\text{Net income} - \text{Preferred dividends}}{\text{Weighted average ordinary shares outstanding}}

Where Preferred dividends = dividends on preferred shares for the period; weighted average shares = each block of shares ×\times months outstanding ÷12\div 12.

Earnings available to ordinary shareholders per average share in issue. Shares issued or bought back during the year count only for the months they were outstanding, while stock splits and stock dividends are treated as if they happened at the start of the year.

Exam tip Never deduct ordinary (common) dividends, and restate every earlier share block for a split or stock dividend before you weight by time.

20

Diluted EPS: convertible debt (if-converted)

Key formula
Diluted EPS=NI−Pref. div.+Interest (1−t)WASO+Shares from conversion\displaystyle \text{Diluted EPS} = \dfrac{\text{NI} - \text{Pref. div.} + \text{Interest}\,(1 - t)}{\text{WASO} + \text{Shares from conversion}}

Where NI\text{NI} = net income, Pref. div.\text{Pref. div.} = preferred dividends, tt = tax rate, WASO\text{WASO} = weighted average shares outstanding.

The if-converted method assumes the bonds became shares, so the after-tax interest saved goes back into earnings and the new shares join the denominator. Convertible preferred works the same way: add back its dividends instead of interest. A security is included only if it lowers EPS.

Exam tip Check dilution quickly: if after-tax interest divided by the new shares is above basic EPS, the bond is antidilutive and is left out.

21

Diluted EPS: options (treasury stock method)

Key formula
Diluted EPS=NI−Pref. div.WASO+(N−N×XPˉ)×fraction of year\displaystyle \text{Diluted EPS} = \dfrac{\text{NI} - \text{Pref. div.}}{\text{WASO} + \left(N - \dfrac{N \times X}{\bar{P}}\right) \times \text{fraction of year}}

Where NN = shares under option or warrant, XX = exercise price, Pˉ\bar{P} = average market price for the period, WASO\text{WASO} = weighted average shares outstanding.

Exercise proceeds are assumed to buy back shares at the average market price, so only the net new shares dilute. The numerator does not change. Options dilute only when they are in the money, that is when the average price is above the exercise price.

Exam tip Use the average market price for the period, not the year-end price; options with an exercise price at or above it add no shares.

29

Goodwill in an acquisition

Key formula
Goodwill=Acquisition cost−(FV identifiable assets−FV liabilities and contingent liabilities)\displaystyle \text{Goodwill} = \text{Acquisition cost} - (\text{FV identifiable assets} - \text{FV liabilities and contingent liabilities})

Where FV\text{FV} = fair value at the acquisition date of the target's identifiable assets (including identifiable intangibles) and of the liabilities assumed.

Goodwill is the premium paid over the fair value of the net assets acquired. It is not amortised under IFRS or US GAAP but is tested for impairment at least annually. A negative result is a bargain purchase, recognised as a gain in profit or loss.

Exam tip Use the target's fair values, never its book values, and remember that internally generated goodwill is never recognised as an asset.

46

Cash received from customers

Key formula
Cash from customers=Revenue−ΔAR+ΔDeferred revenue\displaystyle \text{Cash from customers} = \text{Revenue} - \Delta\text{AR} + \Delta\text{Deferred revenue}

Where ΔAR\Delta\text{AR} = change in accounts receivable, ΔDeferred revenue\Delta\text{Deferred revenue} = change in unearned revenue (closing minus opening).

The first line of a direct-method cash flow statement and the usual starting point when converting from the indirect method. Rising receivables mean sales were made on credit and not yet collected; rising deferred revenue means cash arrived before the revenue was earned.

Exam tip If receivables went up, cash collected is below revenue; if deferred revenue went up, cash collected is above revenue.

47

Cash paid to suppliers

Key formula
Cash to suppliers=COGS+ΔInventory−ΔAP\displaystyle \text{Cash to suppliers} = \text{COGS} + \Delta\text{Inventory} - \Delta\text{AP}

Where COGS\text{COGS} = cost of goods sold, ΔInventory\Delta\text{Inventory} and ΔAP\Delta\text{AP} = change in inventory and accounts payable (closing minus opening).

Works in two steps: cost of sales plus the inventory build gives purchases, and purchases minus the rise in payables gives cash paid. A typical exam item gives an income statement and two balance sheets and asks for this single line.

Exam tip Get the signs from the logic: building inventory costs cash, while letting payables rise delays cash, so it reduces the amount paid.

49

CFO: indirect method

Key formula
CFO=NI+Non-cash charges−Gains+Losses−ΔOperating assets+ΔOperating liabilities\displaystyle \text{CFO} = \text{NI} + \text{Non-cash charges} - \text{Gains} + \text{Losses} - \Delta\text{Operating assets} + \Delta\text{Operating liabilities}

Where NI\text{NI} = net income; non-cash charges = depreciation, amortisation and similar; Δ\Delta = closing minus opening balance of working capital accounts.

Reconciles accrual profit to operating cash. Gains and losses on asset sales are removed because the whole sale proceeds belong in investing cash flow. IFRS and US GAAP allow both methods; US GAAP preparers using the direct method must still show the indirect reconciliation.

Exam tip An increase in an operating asset (receivables, inventory) is a use of cash and is subtracted; an increase in an operating liability (payables) is added.

60

Free cash flow to the firm (from CFO)

Key formula
FCFF=CFO+Int(1−t)−FCInv\displaystyle \text{FCFF} = \text{CFO} + \text{Int}(1 - t) - \text{FCInv}

Where CFO\text{CFO} = cash flow from operations, Int\text{Int} = interest expense, tt = tax rate, FCInv\text{FCInv} = capital expenditure minus proceeds from fixed asset sales.

Cash left for all providers of capital, debt and equity, after operating needs and fixed investment. After-tax interest is added back because interest goes to lenders, who are among the capital providers. US GAAP always puts interest paid in CFO; IFRS lets companies put it in CFO or financing.

Exam tip Add back Int(1−t)\text{Int}(1-t) only when interest paid was deducted in CFO; for an IFRS company that classifies interest paid as financing, skip it.

61

Free cash flow to equity

Key formula
FCFE=CFO−FCInv+Net borrowing\displaystyle \text{FCFE} = \text{CFO} - \text{FCInv} + \text{Net borrowing}

Where FCInv\text{FCInv} = fixed capital investment net of asset sale proceeds; net borrowing = new debt issued minus debt repaid.

Cash available to ordinary shareholders after operating needs, fixed investment and payments to lenders. It caps what the company can sustainably pay out as dividends and buybacks without new financing.

Exam tip Net borrowing is added when positive and subtracted when the company repaid more debt than it raised.

80

LIFO to FIFO inventory

Key formula
InventoryFIFO=InventoryLIFO+LIFO reserve\displaystyle \text{Inventory}_{\text{FIFO}} = \text{Inventory}_{\text{LIFO}} + \text{LIFO reserve}

Where LIFO reserve = FIFO inventory minus LIFO inventory, disclosed by US GAAP companies that use LIFO.

LIFO is allowed under US GAAP but banned under IFRS, so analysts restate a LIFO company's inventory to FIFO to compare it with FIFO or IFRS peers. With rising costs LIFO leaves older, cheaper costs on the balance sheet and understates inventory, current assets and equity.

Exam tip For a full restatement, equity rises by LIFO reserve ×(1−t)\times (1-t) and deferred tax liabilities by LIFO reserve ×t\times t.

81

LIFO to FIFO cost of sales

Key formula
COGSFIFO=COGSLIFO−(LRend−LRbegin)\displaystyle \text{COGS}_{\text{FIFO}} = \text{COGS}_{\text{LIFO}} - (\text{LR}_{\text{end}} - \text{LR}_{\text{begin}})

Where LRend\text{LR}_{\text{end}}, LRbegin\text{LR}_{\text{begin}} = LIFO reserve at the end and start of the year.

Only the change in the reserve during the year affects cost of sales. In a period of rising costs the reserve grows, so FIFO cost of sales is lower and profit higher than under LIFO. A falling reserve can signal a LIFO liquidation, where old cheap layers flow through and temporarily inflate LIFO margins.

Exam tip Subtract an increase in the reserve and add back a decrease; pre-tax profit under FIFO changes by the same amount with the opposite sign.

82

Net realisable value

Key formula
NRV=Estimated selling price−Costs to complete−Costs to sell\displaystyle \text{NRV} = \text{Estimated selling price} - \text{Costs to complete} - \text{Costs to sell}

Where Estimated selling price in the ordinary course of business, less the costs still needed to finish the goods and to make the sale.

Inventory is carried at the lower of cost and NRV under IFRS and under US GAAP for methods other than LIFO and retail (which use lower of cost or market). A write-down reduces inventory and usually raises cost of sales. IFRS allows a later reversal up to the original write-down; US GAAP never does.

Exam tip A write-down lowers inventory and equity, so it raises inventory turnover and lowers the current ratio in later analysis.

97

IFRS recoverable amount

Key formula
Recoverable amount=max⁡(FV−costs to sell, Value in use)\displaystyle \text{Recoverable amount} = \max(\text{FV} - \text{costs to sell},\ \text{Value in use})

Where FV\text{FV} = fair value of the asset; value in use = present value of the future cash flows the asset is expected to generate.

IFRS uses a one-step test: if carrying amount exceeds recoverable amount, the asset is written down to recoverable amount and the difference is the loss. IFRS allows the loss to be reversed later for PPE and intangibles other than goodwill, but not above the carrying amount the asset would have had without the impairment.

Exam tip Recoverable amount is the higher of the two measures, not the lower.

99

US GAAP impairment (two-step test)

Key formula
If CA>Undiscounted CF:Loss=CA−Fair value\displaystyle \text{If } \text{CA} > \text{Undiscounted CF}: \quad \text{Loss} = \text{CA} - \text{Fair value}

Where CA\text{CA} = carrying amount; undiscounted CF = sum of expected future cash flows from the asset without discounting.

Step one checks recoverability with undiscounted cash flows; only if it fails is the loss measured, against fair value. Because undiscounted flows are large, US GAAP tends to trigger impairments later than IFRS. Impairment losses on assets held for use cannot be reversed under US GAAP.

Exam tip Undiscounted cash flows decide whether there is a loss; fair value decides how big it is. Mixing the two is the classic trap.

102

Gain or loss on sale of an asset

Key formula
Gain (loss)=Proceeds−(Cost−Accumulated depreciation)\displaystyle \text{Gain (loss)} = \text{Proceeds} - (\text{Cost} - \text{Accumulated depreciation})

Where Proceeds = cash received; cost minus accumulated depreciation = carrying amount at the date of sale.

The gain or loss is reported in profit or loss, but the full proceeds are an investing cash inflow, which is why the gain is subtracted in the indirect CFO. Rearranged, proceeds equal carrying amount plus the gain (or minus the loss), a common cash flow question.

Exam tip If the asset was impaired or revalued, use its adjusted carrying amount, not original cost less depreciation.

115

Initial lease liability and ROU asset

Key formula
L0=ROU0=∑t=1nPMT(1+r)t\displaystyle L_0 = \text{ROU}_0 = \sum_{t=1}^{n} \dfrac{PMT}{(1+r)^t}

Where L0L_0 = lease liability, ROU0\text{ROU}_0 = right-of-use asset, PMTPMT = lease payment at the end of each period, rr = rate implicit in the lease or the lessee's incremental borrowing rate, nn = number of payments.

Lessees put almost every lease on the balance sheet at the present value of the payments. IFRS uses one finance-type model for all leases; US GAAP classifies leases as finance or operating, but both start with the same asset and liability. Short-term leases (and low-value assets under IFRS) can stay off balance sheet.

Exam tip If payments are made at the start of each period, value them as an annuity due (BGN mode), which gives a higher liability.

116

Lease interest and principal each period

Key formula
Interestt=Lt−1×r,Principalt=PMT−Interestt,Lt=Lt−1−Principalt\displaystyle \text{Interest}_t = L_{t-1} \times r, \quad \text{Principal}_t = PMT - \text{Interest}_t, \quad L_t = L_{t-1} - \text{Principal}_t

Where Lt−1L_{t-1} = lease liability at the start of the period, rr = discount rate, PMTPMT = lease payment.

Under IFRS and US GAAP finance leases, expense is interest on the liability plus straight-line amortisation of the ROU asset, so total expense is front-loaded. Interest sits below operating profit. The principal part of the payment is a financing outflow; interest is operating under US GAAP and operating or financing under IFRS.

Exam tip Interest always uses the opening liability; the rest of the payment reduces the liability.

119

US GAAP operating lease expense

Key formula
Lease expenset=Interestt+Amortisationt=PMT\displaystyle \text{Lease expense}_t = \text{Interest}_t + \text{Amortisation}_t = PMT

Where PMTPMT = level periodic lease payment; amortisation of the ROU asset is the plug that makes the expense equal the payment.

For a US GAAP operating lease the lessee reports one straight-line lease cost within operating expenses, and the whole payment is an operating cash outflow. Compared with a finance lease, this gives lower operating profit and lower CFO, but higher CFF.

Exam tip Operating lease: whole payment in CFO. Finance lease: only interest can be in CFO, principal goes to CFF, so finance-lease CFO is higher.

122

Defined benefit funded status

Key formula
Net pension liability (asset)=PV of DBO−FV of plan assets\displaystyle \text{Net pension liability (asset)} = \text{PV of DBO} - \text{FV of plan assets}

Where DBO\text{DBO} = defined benefit obligation (present value of benefits earned to date); FV\text{FV} = fair value of plan assets.

Both IFRS and US GAAP report this net amount on the balance sheet. A positive result is a deficit and a net liability; a negative result is a surplus and a net asset. Only defined benefit plans have one, because in a defined contribution plan the employee bears the investment risk.

Exam tip A lower discount rate raises the DBO and so widens a deficit; a higher rate shrinks it.

123

IFRS pension expense in profit or loss

Key formula
Pension expense=Service cost+r×Net pension liabilitybeginning\displaystyle \text{Pension expense} = \text{Service cost} + r \times \text{Net pension liability}_{\text{beginning}}

Where Service cost = current and past service cost, rr = discount rate, net pension liability = DBO minus plan assets at the start of the year.

Under IFRS, profit or loss carries service cost and net interest on the net liability; remeasurements (actuarial gains and losses, actual return minus interest income on assets) go to OCI and are never recycled. US GAAP instead uses an expected return on assets and amortises items from OCI into profit or loss.

Exam tip Past service cost hits profit or loss at once under IFRS, but under US GAAP it goes to OCI and is amortised over time.

133

Income tax expense

Key formula
Income tax expense=Taxes payable+ΔDTL−ΔDTA\displaystyle \text{Income tax expense} = \text{Taxes payable} + \Delta\text{DTL} - \Delta\text{DTA}

Where Taxes payable = taxable income ×\times tax rate (current tax); ΔDTL\Delta\text{DTL}, ΔDTA\Delta\text{DTA} = change in deferred tax liabilities and assets, ending minus beginning.

Reported tax expense is current tax plus deferred tax. A growing DTL means tax has been deferred to later years, so expense exceeds cash tax; a growing DTA means tax was paid ahead of the expense.

Exam tip Watch the signs: an increase in DTL adds to expense, an increase in DTA reduces it.

134

Deferred tax liability (asset item)

Key formula
DTL=(Carrying amount−Tax base)×t\displaystyle \text{DTL} = (\text{Carrying amount} - \text{Tax base}) \times t

Where Carrying amount = balance sheet value of the asset, tax base = its value for tax purposes, tt = tax rate expected to apply when the difference reverses.

Arises when an asset's carrying amount exceeds its tax base, for example when tax depreciation is faster than book depreciation. If the asset's carrying amount is below its tax base, the result is a DTA. For liabilities the logic flips: a warranty provision with a zero tax base creates a DTA.

Exam tip Only temporary differences create deferred taxes; permanent differences such as tax-exempt income never do.

137

Effective tax rate

Key formula
ETR=Income tax expensePretax income\displaystyle \text{ETR} = \dfrac{\text{Income tax expense}}{\text{Pretax income}}

Where ETR\text{ETR} = effective tax rate; income tax expense = current plus deferred tax; pretax income = accounting profit before tax.

Temporary differences alone leave the effective rate equal to the statutory rate. Permanent differences, foreign rates and tax rate changes are what open a gap, and the tax note's reconciliation explains it. Compare with the cash tax rate to see how much tax is being deferred.

Exam tip The denominator is accounting pretax income, not taxable income from the tax return.

146

Double-declining balance depreciation

Key formula
Depreciationt=2Life×Carrying amountt−1,not below salvage value\displaystyle \text{Depreciation}_t = \dfrac{2}{\text{Life}} \times \text{Carrying amount}_{t-1}, \quad \text{not below salvage value}

Where Life = useful life in years, Carrying amountt−1\text{Carrying amount}_{t-1} = cost minus accumulated depreciation at the start of year tt.

An accelerated method: higher expense and lower profit and assets early, the reverse later. The method choice and estimates of life and salvage value are classic levers for managing earnings; a longer life or higher salvage value lowers expense and flatters profit. Straight-line is (cost minus salvage) divided by life.

Exam tip Apply the rate to the full carrying amount without deducting salvage first, and stop once the carrying amount reaches salvage value.

159

Current, quick and cash ratios

Key formula
CACLCash+STI+ReceivablesCLCash+STICL\displaystyle \dfrac{\text{CA}}{\text{CL}} \qquad \dfrac{\text{Cash} + \text{STI} + \text{Receivables}}{\text{CL}} \qquad \dfrac{\text{Cash} + \text{STI}}{\text{CL}}

Where CA\text{CA} = current assets, CL\text{CL} = current liabilities, STI\text{STI} = short-term marketable investments.

Three liquidity tests from loosest to strictest. The quick ratio drops inventory and prepaid expenses because they are hard to turn into cash quickly; the cash ratio also drops receivables. All use ending balance sheet figures.

Exam tip With a current ratio above 1, paying off current liabilities with cash raises the ratio; with a ratio below 1, the same payment lowers it.

161

Cash conversion cycle

Key formula
CCC=DOH+DSO−Days of payables\displaystyle \text{CCC} = \text{DOH} + \text{DSO} - \text{Days of payables}

Where DOH\text{DOH} = days of inventory on hand, DSO\text{DSO} = days sales outstanding, days of payables = number of days taken to pay suppliers; each is 365 divided by the matching turnover.

How long cash is tied up between paying for inventory and collecting from customers. A shorter cycle means less working capital to finance and usually better liquidity; a lengthening cycle can signal slow collections or obsolete stock.

Exam tip Inventory and payables turnover use cost of sales (or purchases); receivables turnover uses revenue. Payables days are subtracted, not added.

172

Five-step DuPont ROE

Key formula
ROE=NIEBT×EBTEBIT×EBITRevenue×RevenueAvg TA×Avg TAAvg equity\displaystyle \text{ROE} = \dfrac{\text{NI}}{\text{EBT}} \times \dfrac{\text{EBT}}{\text{EBIT}} \times \dfrac{\text{EBIT}}{\text{Revenue}} \times \dfrac{\text{Revenue}}{\text{Avg TA}} \times \dfrac{\text{Avg TA}}{\text{Avg equity}}

Where Tax burden NI/EBT\text{NI}/\text{EBT}, interest burden EBT/EBIT\text{EBT}/\text{EBIT}, EBIT margin, total asset turnover and financial leverage; Avg TA = average total assets.

Splits ROE into taxes, interest, operating profitability, efficiency and leverage to show what drove a change. The first three factors multiply to the net profit margin, which gives the three-step version. More debt raises leverage but lowers the interest burden ratio, so ROE rises only if the extra return beats the cost of borrowing.

Exam tip Tax burden equals 1 minus the average tax rate, so a higher tax burden ratio means lower taxes; a lower interest burden ratio means more interest expense.

All 193 formulas, in the Academy

Each learning module in the CheapMocks Academy ends with its formula sheet: every formula of its lessons, numbered as in the PDF and explained the same way. The Academy is included in the free trial.

All formula sheetsFinancial Statement Analysis study guide