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.
Long-term contract revenue (input method)
Key formulaWhere Costs incurred to date 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.
Lesson: Revenue recognition in practice and what it means for analysis All Analyzing Income Statements formulas
Basic EPS
Key formulaWhere Preferred dividends = dividends on preferred shares for the period; weighted average shares = each block of shares months outstanding .
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.
Lesson: Basic EPS and the weighted average number of shares All Analyzing Income Statements formulas
Diluted EPS: convertible debt (if-converted)
Key formulaWhere = net income, = preferred dividends, = tax rate, = 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.
Lesson: Diluted EPS: if-converted, treasury stock and antidilution All Analyzing Income Statements formulas
Diluted EPS: options (treasury stock method)
Key formulaWhere = shares under option or warrant, = exercise price, = average market price for the period, = 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.
Lesson: Diluted EPS: if-converted, treasury stock and antidilution All Analyzing Income Statements formulas
Goodwill in an acquisition
Key formulaWhere = 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.
Lesson: Goodwill: recognition, impairment and analysis All Analyzing Balance Sheets formulas
Cash received from customers
Key formulaWhere = change in accounts receivable, = 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.
Lesson: Operating cash flow: the direct method All Analyzing Statements of Cash Flows I formulas
Cash paid to suppliers
Key formulaWhere = cost of goods sold, and = 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.
Lesson: Operating cash flow: the direct method All Analyzing Statements of Cash Flows I formulas
CFO: indirect method
Key formulaWhere = net income; non-cash charges = depreciation, amortisation and similar; = 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.
Lesson: Operating cash flow: the indirect method All Analyzing Statements of Cash Flows I formulas
Free cash flow to the firm (from CFO)
Key formulaWhere = cash flow from operations, = interest expense, = tax rate, = 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 only when interest paid was deducted in CFO; for an IFRS company that classifies interest paid as financing, skip it.
Lesson: Free cash flow to the firm and to equity All Analyzing Statements of Cash Flows II formulas
Free cash flow to equity
Key formulaWhere = 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.
Lesson: Free cash flow to the firm and to equity All Analyzing Statements of Cash Flows II formulas
LIFO to FIFO inventory
Key formulaWhere 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 and deferred tax liabilities by LIFO reserve .
Lesson: The LIFO reserve, LIFO-to-FIFO conversion and LIFO liquidation All Analysis of Inventories formulas
LIFO to FIFO cost of sales
Key formulaWhere , = 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.
Lesson: The LIFO reserve, LIFO-to-FIFO conversion and LIFO liquidation All Analysis of Inventories formulas
Net realisable value
Key formulaWhere 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.
Lesson: Measuring inventory: lower of cost and net realisable value All Analysis of Inventories formulas
IFRS recoverable amount
Key formulaWhere = 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.
Lesson: Impairment of PPE and intangibles All Analysis of Long-Term Assets formulas
US GAAP impairment (two-step test)
Key formulaWhere = 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.
Lesson: Impairment of PPE and intangibles All Analysis of Long-Term Assets formulas
Gain or loss on sale of an asset
Key formulaWhere 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.
Lesson: Derecognition: sale, abandonment, exchange and spin-off All Analysis of Long-Term Assets formulas
Initial lease liability and ROU asset
Key formulaWhere = lease liability, = right-of-use asset, = lease payment at the end of each period, = rate implicit in the lease or the lessee's incremental borrowing rate, = 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.
Lesson: Lessee accounting: the IFRS model and US GAAP finance leases All Topics in Long-Term Liabilities and Equity formulas
Lease interest and principal each period
Key formulaWhere = lease liability at the start of the period, = discount rate, = 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.
Lesson: Lessee accounting: the IFRS model and US GAAP finance leases All Topics in Long-Term Liabilities and Equity formulas
US GAAP operating lease expense
Key formulaWhere = 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.
Lesson: US GAAP operating leases and the effect on ratios All Topics in Long-Term Liabilities and Equity formulas
Defined benefit funded status
Key formulaWhere = defined benefit obligation (present value of benefits earned to date); = 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.
Lesson: Defined contribution and defined benefit pension plans All Topics in Long-Term Liabilities and Equity formulas
IFRS pension expense in profit or loss
Key formulaWhere Service cost = current and past service cost, = 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.
Lesson: Defined contribution and defined benefit pension plans All Topics in Long-Term Liabilities and Equity formulas
Income tax expense
Key formulaWhere Taxes payable = taxable income tax rate (current tax); , = 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.
Lesson: Deferred tax balances and income tax expense All Analysis of Income Taxes formulas
Deferred tax liability (asset item)
Key formulaWhere Carrying amount = balance sheet value of the asset, tax base = its value for tax purposes, = 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.
Lesson: Deferred tax balances and income tax expense All Analysis of Income Taxes formulas
Effective tax rate
Key formulaWhere = 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.
Lesson: Effective, statutory and cash tax rates All Analysis of Income Taxes formulas
Double-declining balance depreciation
Key formulaWhere Life = useful life in years, = cost minus accumulated depreciation at the start of year .
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.
Lesson: Integrated cases: what accounting choices do to the numbers All Financial Reporting Quality formulas
Current, quick and cash ratios
Key formulaWhere = current assets, = current liabilities, = 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.
Lesson: Liquidity ratios and the cash conversion cycle All Financial Analysis Techniques formulas
Cash conversion cycle
Key formulaWhere = days of inventory on hand, = 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.
Lesson: Liquidity ratios and the cash conversion cycle All Financial Analysis Techniques formulas
Five-step DuPont ROE
Key formulaWhere Tax burden , interest burden , 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.
Lesson: Integrated ratio analysis and DuPont All Financial Analysis Techniques formulas
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.
- Introduction to Financial Statement Analysis5 formulas · nos. 1–5
- Analyzing Income Statements21 formulas · 4 key · nos. 6–26
- Analyzing Balance Sheets16 formulas · 1 key · nos. 27–42
- Analyzing Statements of Cash Flows I13 formulas · 3 key · nos. 43–55
- Analyzing Statements of Cash Flows II17 formulas · 2 key · nos. 56–72
- Analysis of Inventories22 formulas · 3 key · nos. 73–94
- Analysis of Long-Term Assets19 formulas · 3 key · nos. 95–113
- Topics in Long-Term Liabilities and Equity17 formulas · 5 key · nos. 114–130
- Analysis of Income Taxes13 formulas · 3 key · nos. 131–143
- Financial Reporting Quality7 formulas · 1 key · nos. 144–150
- Financial Analysis Techniques26 formulas · 3 key · nos. 151–176
- Introduction to Financial Statement Modeling17 formulas · nos. 177–193