A financial report becomes easier to review once every number can be traced back to a particular filing, period and line item. This walkthrough uses a fictional equipment rental company. Its small dataset is designed for calculation and review practice. The final deliverable is a workbook with a filing index, a raw extraction tab, a formula tab and a short review memo.
Lock the version and reconcile the statements
Begin with the issuer's official filing or the regulator's filing system. Record issuer identity, fiscal year end, reporting period, currency, unit, consolidation scope, document date and amendment status. Keep the raw line labels and page numbers. An earnings presentation may use an adjusted measure that has no direct equivalent in the statutory statement. Preserve both versions and reconcile them before comparing values. Save the official filing reference with each extracted number. If a later filing restates a comparative period, label that column as restated and preserve the old value in the extraction history.
Use the balance sheet for positions on a date and the income and cash flow statements for activity over a period. In the fictional file, ending assets are 150 and liabilities are 94, so equity of 56 closes the balance sheet. Operating cash flow is 8, investing cash flow is minus 11, and financing cash flow is 6. With no exchange-rate movement or other adjustments, opening cash of 17 rolls to 20. A statement may reconcile cash and restricted cash together, so align the definition before comparing it with the balance sheet. For a mismatch, check scaling, signs, restricted cash, translation and the scope of consolidation. Save the calculation and the reason for every explicit adjustment on a separate tab.
Calculate ratios with auditable inputs
Suppose annual revenue moves from 100 to 120 and operating profit from 12 to 15 in the same units and for comparable twelve-month periods. Revenue growth is 20 percent and operating margin moves from 12 to 12.5 percent, a change of 0.5 percentage points. Write the inputs and formulas in separate columns and keep the displayed precision distinct from the underlying result. A zero denominator makes a growth rate undefined. When the prior amount is negative, show the signed amounts and describe the change instead of passing a mechanically calculated growth percentage off as a normal comparison. Use separate labels for operating profit, net income and adjusted earnings.
For a quick review, make a table of metric, formula, input cell references, source, expected range and reviewer note. If an automated extractor returns 120,000 alongside 100 in units of millions, stop and normalize based on the original header. If the figures already include thousands separators, verify the decimal convention before parsing. Recalculate one row by hand after import and compare it with the spreadsheet. A reviewer should be able to reproduce the ratio without asking which tab or filing was used.
Compare performance over time and against peers
Put each company's fiscal year end, business mix and accounting presentation at the top of the comparison. A company whose year ends in March should not be assumed to have faced the same seasonal conditions as one reporting to December. Prefer matching periods and label any exceptions. A peer that owns its rental fleet may show different depreciation and lease expense from a firm that leases it. Compare the drivers of a margin difference before drawing a conclusion from the difference itself. For a trend chart, label exceptional changes such as an acquisition, discontinued operation or accounting policy change and attach the relevant note.
Start with two peer rows and three years. List revenue, operating profit, cash from operations and one business measure that explains volume or utilization. Reconcile the issuer-defined business measure to its own definition before placing it beside another company's number. If the measures are not comparable, use separate columns and explain why. The deliverable is a comparison table that includes limitations, not a ranking. When preparing a slide, carry over those limitations with the numbers so the reader can still see which comparisons are provisional.
Investigate earnings quality and read the notes
In the sample, net income increases from 9 to 11 while operating cash flow falls from 14 to 8. Begin a cash bridge using disclosed noncash items and working capital movements. A 7 increase in receivables may help explain part of the divergence, but it does not establish collectability or wrongdoing. Check the receivables aging and allowance, changes in payment terms, major customer exposure and subsequent disclosures. Review any borrowing due soon against the notes on facilities and maturities. Keep the observed difference, plausible explanations and open questions in different columns. Write what evidence would rule out an explanation.
A useful risk memo links each item to a number, its statement and note, an alternative explanation, and a next action. If disclosure is incomplete, request a specific reconciliation or mark the item unresolved. For example, “Operating cash flow fell by 6 while net income rose by 2; the working-capital table attributes part of the change to receivables; obtain the aging table before assessing collection risk.” The memo can flag a question for review without assuming an answer.
Choose a Skill and test it on a small extract
For extraction and ratio checks, seek tools that preserve filing references, units and calculation inputs. For trends, verify that they support fiscal-period alignment. For risk review, choose a tool that links anomalies to disclosed notes and keeps unknowns explicit. Confirm capabilities in the published SkillPI details and source before adoption. A small local analysis tool can help count missing values and duplicate period rows after extraction; those checks do not establish that a source number was transcribed correctly. Provide a toy table with a duplicate row, a missing period and one intentional unit mismatch. Compare the output with your expected findings and manually check one input against the original.
Troubleshooting and FAQ
If income and cash diverge, inspect the cash reconciliation before deciding whether the movement is normal. If a ratio looks unusual, check consolidation scope and fiscal period before editing the formula. If a comparison changes after restatement, preserve the previous output and record exactly which column was refreshed. Keep the method and evidence separate from an investment decision. For terminology and statement structure, see the SEC guide to financial statements.