How to Build an Equity Schedule
Executive Summary
Key Takeaways
- ✓ An equity schedule rolls forward common stock and APIC, treasury stock, and retained earnings separately, since each is driven by a different set of transactions.
- ✓ Retained earnings rolls forward as opening balance plus net income less dividends, the same linkage described on the Statement Linking Mechanics guide.
- ✓ Treasury stock increases when shares are repurchased and decreases when they are reissued (for example, on option exercise), and is presented as a contra-equity account.
- ✓ The diluted share count roll-forward should be built alongside the equity schedule, since issuances, buybacks, and option exercises affect both simultaneously.
Institutional Definition¶
An equity schedule rolls forward each component of shareholders' equity — common stock and additional paid-in capital, treasury stock, and retained earnings — from an opening balance through the period's activity to a closing balance, and is typically built alongside a parallel roll-forward of the diluted share count used in per-share calculations. This guide walks through the build component by component.
Step 1: Common Stock and Additional Paid-In Capital (APIC)¶
Opening Common Stock + APIC
+ New Share Issuances (at issue price)
+ Stock-Based Compensation Expense (non-cash, credited to APIC)
+ Option Exercise Proceeds
= Closing Common Stock + APIC
Common stock is typically recorded at par value, with the excess over par recorded in additional paid-in capital. This balance increases when new shares are issued for cash, when stock-based compensation expense is recognized (a non-cash credit to APIC offsetting the expense on the income statement), and when options are exercised, generating both new shares and cash proceeds. It generally does not decrease outside a formal capital reduction, which is uncommon for most operating companies.
Step 2: Treasury Stock¶
Opening Treasury Stock (Contra-Equity, Negative Balance)
- Share Repurchases (at repurchase price)
+ Reissuance of Treasury Shares (e.g. for option exercises)
= Closing Treasury Stock
Treasury stock represents shares the company has repurchased and holds, rather than formally retiring, and is presented as a contra-equity account — a negative balance that reduces total shareholders' equity. It increases in magnitude (becomes more negative) when shares are bought back, and decreases in magnitude when treasury shares are reissued, most commonly to satisfy option exercises without issuing entirely new shares. See Treasury Stock Method for how treasury share repurchases connect specifically to diluted share count calculations.
Step 3: Retained Earnings Roll-Forward¶
Opening Retained Earnings
+ Net Income
- Dividends Declared/Paid
= Closing Retained Earnings
This is the same linkage described in Statement Linking Mechanics: retained earnings increases by the period's net income from the income statement and decreases by any dividends. Confirm this line references the income statement's net income directly rather than being entered or estimated independently — a disconnected retained earnings line is one of the most common causes of an out-of-balance balance sheet.
Step 4: Total Shareholders' Equity¶
Total Shareholders' Equity = Common Stock + APIC + Treasury Stock (negative) + Retained Earnings
This total feeds directly into the balance sheet's equity section and, together with total liabilities, must equal total assets in every period.
Step 5: The Diluted Share Count Roll-Forward¶
Alongside the dollar-value equity schedule, build a parallel roll-forward of the share count itself:
Opening Basic Shares Outstanding
+ New Shares Issued
- Shares Repurchased
+ Net Dilutive Effect of Options/Warrants (Treasury Stock Method)
+ Net Dilutive Effect of Convertible Securities (If-Converted Method, where applicable)
= Closing Diluted Share Count
The same transactions driving the dollar-value equity schedule — issuances, buybacks, option exercises — also drive the share count, and the two should be built together so a reviewer can confirm they remain consistent: a buyback reducing treasury stock's cash balance should correspond to the same number of shares removed from the diluted count. See Diluted Share Count for the full mechanics of the treasury stock and if-converted methods used to calculate the dilutive adjustment.
Common Errors¶
| Error | Description | Risk |
|---|---|---|
| Retained earnings not linked to net income | Roll-forward broken or hardcoded rather than pulling from the income statement | Balance sheet fails to reflect the income statement's actual result |
| Share count and dollar-value schedules built independently | A buyback reflected in treasury stock but not in the diluted share count, or vice versa | Per-share metrics become inconsistent with the equity schedule's actual activity |
| Stock-based compensation expensed but not credited to APIC | Non-cash comp expense reduces net income without a corresponding equity increase | Balance sheet fails to balance |
| Treasury stock presented as a positive balance | Sign convention error in the contra-equity account | Total equity overstated |
| Option exercise proceeds omitted from common stock/APIC | Cash received on exercise not reflected in the equity roll-forward | Equity schedule understates the actual cash and equity impact of exercises |
Best Practices¶
Build the dollar-value equity schedule and the diluted share count roll-forward side by side, so that every transaction affecting one is checked against the other in the same pass. Link retained earnings directly to the income statement's net income line, and confirm the balance sheet balances after the equity schedule is complete, not only after the debt and working capital schedules are checked. Present treasury stock as a clearly labelled contra-equity account, consistent with standard presentation.
Continue Reading¶
Prerequisites¶
- Financial Statements in Financial Modelling — the parent pillar
- Balance Sheet
Related Glossary¶
Related Technical Guides¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What are the main components of an equity schedule?
Common stock and additional paid-in capital (APIC), treasury stock, and retained earnings — each rolled forward separately from an opening balance through the period's activity to a closing balance.
How does common stock and APIC change during a period?
It increases when new shares are issued (for cash, in an acquisition, or on conversion of a convertible security) and generally does not decrease except in a formal capital reduction, which is uncommon outside specific restructuring or jurisdictional contexts.
What is treasury stock and how does it roll forward?
Treasury stock represents shares the company has repurchased and holds rather than retiring. It increases (as a larger contra-equity deduction) when shares are bought back, and decreases when treasury shares are reissued, for example to satisfy option exercises, described further on the Treasury Stock Method glossary page.
How does retained earnings roll forward in the equity schedule?
Opening retained earnings plus net income for the period, less any dividends declared or paid, equals closing retained earnings — the same linkage described in full on the Statement Linking Mechanics technical guide.
Why should the diluted share count roll-forward be built alongside the equity schedule?
Because the same transactions — new issuances, buybacks, and option exercises — affect both the dollar-value equity schedule and the diluted share count simultaneously, and building them together makes it easier to confirm the two stay consistent with each other.
What is the treasury stock method's role in the share count roll-forward?
The treasury stock method calculates the net dilutive effect of in-the-money options and warrants by assuming they are exercised and the proceeds used to repurchase shares at the current market price, described in full on the Treasury Stock Method glossary page.
What is a common structural error in an equity schedule?
Retained earnings not linked to the income statement's net income line, or the diluted share count not updated to reflect a buyback or issuance that has already been reflected in the dollar-value equity schedule, causing the two to become inconsistent with each other.
Related Articles
Financial Statements in Financial Modelling
The income statement, balance sheet, and cash flow statement are the three financial statements that together describe a company's or project's performance, financial position, and cash movements. In a financial model, these are not three independent outputs — they are dynamically linked, so that a single change in an assumption flows correctly through all three, and the balance sheet balances in every period as a direct consequence of that linkage rather than as a plug engineered to force it. This page is the hub for the Knowledge Centre's financial statements content: what each statement represents, how a three-statement model integrates them, where financial-statement mechanics anchor broader industry models, and how a structural audit tests statement integration for the errors that most commonly break it.
Balance Sheet
The balance sheet is a snapshot of a company's or project's financial position at a single point in time, structured around the accounting identity Assets equal Liabilities plus Equity. In a financial model, one line — typically cash or a revolving credit facility — is designated the balancing mechanic, absorbing the residual funding surplus or shortfall the rest of the model produces so the identity holds exactly in every period. A balance sheet that fails to balance is the single most diagnostic signal that a model's statement linkage contains a structural error.
Three-Statement Model
A three-statement model is a financial model in which the income statement, balance sheet, and cash flow statement are dynamically linked into a single integrated system, so that a change in any assumption flows through correctly to all three, and the balance sheet balances in every forecast period as a direct consequence of that linkage rather than as a plug engineered to force it. It is the structural foundation most other financial models — DCF, LBO, project finance — are built on top of.
Treasury Stock Method
The treasury stock method is the standard approach for calculating the dilutive effect of options and warrants on a company's diluted share count. It assumes that all in-the-money options and warrants are exercised, generating cash proceeds equal to the number of options exercised multiplied by their strike price, and that those proceeds are then used to repurchase shares at the current market price. Because the repurchase price is below the exercise proceeds' notional share equivalent only when the strike price is below market price, the method produces a net addition to shares outstanding that is smaller than the gross number of options exercised. The treasury stock method is the standard basis for diluted share count in an enterprise-to-equity value bridge.
Diluted Share Count
Diluted share count is the number of shares used as the divisor when converting total equity value into value per share, and it differs from basic shares outstanding by including the potential dilutive effect of options, warrants, convertible debt, and convertible preferred stock. Options and warrants are incorporated using the treasury stock method; convertible securities are incorporated using the if-converted method, which also requires adding back the interest or dividend the company would no longer pay if conversion occurred. Using the correct diluted share count is the final step in a DCF's enterprise-to-equity value bridge, and understating dilution is a common source of overstated value per share.
Statement Linking Mechanics
Statement linking mechanics are the specific formulas and connections that turn three independently understandable statements into one integrated three-statement model. This guide walks through each linkage step by step: net income flowing to retained earnings and to the top of the cash flow statement, the sign conventions that govern working-capital adjustments, capex and debt movements connecting the statements, and the final ending-cash-to-balance-sheet tie-out that confirms the whole structure holds together. It closes with the specific linking errors most responsible for an out-of-balance model.