Templates

Diluted EPS Workbook

Weighted average shares by days, the treasury stock method for options, warrants, RSUs and performance units quarter by quarter with the year-to-date weighting, the if-converted method for convertible notes and preferred stock, the two-class allocation to participating restricted shares, and the sequencing test for every quarter, the six and nine months and the year: eight tabs, one fictional company, no macros.

Enter your own share events, prices and instruments. The workbook takes basic EPS of $1.63 to diluted EPS of $1.55 on 57,944,444 diluted shares, builds 1,524,718 year-to-date incremental shares from the quarterly computations, adds back $4,050,000 of after-tax interest on convertible notes, excludes a preferred stock whose incremental EPS of $2.0000 is antidilutive, and shows why the same notes dilute one quarter and not the six months. A Checks tab runs 70 checks against the book.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 164 free models.

Diluted_EPS_Workbook.xlsx (30 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind the workbook: The Earnings Per Share Handbook, PDF and paperback, with the full case, the controls and the checklists.

What is in the workbook

Inputs
the shaded assumptions: shares at the start of the year and the dates and sizes of the offering, the option exercises and the repurchase; days per quarter; income from continuing and discontinued operations by quarter; the Series A terms; the common dividend; the restricted shares; average prices by quarter; options, warrants, RSUs and PSUs with exercise prices and unrecognized cost; the notes' principal, conversion rate, interest and tax rate.
Shares
the weighted average common shares by quarter, for the six and nine months and for the year, by days, with the event-by-event computation and the month-based alternative.
Treasury stock method
proceeds, shares bought back and incremental shares for each instrument and each quarter, and the year-to-date weighted averages built from the quarterly figures, with the annual-average-price computation shown for comparison.
Convertible variants
the notes' incremental EPS by period, the conversion spread shares if the principal had to be paid in cash, and the Series A conversion.
EPS by period
for each quarter, the six months, the nine months and the year: the numerator, the two-class allocation of distributed and undistributed earnings, basic EPS for continuing operations and net income, the sequencing of options and units, the notes and the Series A with the inclusion test at each step, and diluted EPS for continuing operations, discontinued operations and net income.
Retroactive adjustments
the 2-for-1 split variant, the rights offering bonus factor and the stock dividend variant.
Disclosure
the share and numerator reconciliations for the year and the table of excluded securities, generated by formula.
Checks
each figure printed in the book recomputed and compared with the book, with a single result cell that reads ALL CHECKS OK when every check passes with Tallowmere's inputs.

Every assumption is shaded in a light color on the Inputs tab; every other cell is a formula, with no macros, no links to other files and no circular references. Every ratio is guarded against an empty divisor. Replace the inputs with your own company's figures; the Checks tab will then show differences from the book by design.

From The Earnings Per Share Handbook. To read: diluted EPS, calculated step by step · the two-class method, worked · the if-converted method after ASU 2020-06.