Diluted EPS Calculator (GAAP) Excel Template
Diluted EPS Calculator (GAAP) Excel Template
Interactive Excel Financial Model
Download, customize, and integrate into your own analysis
What's Included
- Interactive financial model with live Excel formulas
- All formulas visible and fully editable
- Professional formatting with color-coded inputs & outputs
- Formula reference sheet with variable definitions
- Step-by-step instructions sheet
- Compatible with Microsoft Excel 2016 and later
Download Template
Price range: $0.00 through $20.00
Calculate Basic & Diluted EPS under GAAP with Treasury Stock Method and If-Converted Method. Live Excel formulas per ASC 260.
Online Calculator vs Excel Template
| Feature | Online | Excel |
|---|---|---|
| Instant use — no download | ✓ | — |
| Works offline | — | ✓ |
| Customize formulas & layout | — | ✓ |
| Save & share with colleagues | — | ✓ |
| Integrate into your own models | — | ✓ |
| Print-ready formatting | — | ✓ |
About This Template
Calculate basic and diluted earnings per share under GAAP standards with this Diluted EPS Calculator Excel template. Whether you're analyzing equity compensation impact, preparing financial statements, or evaluating convertible securities, this template automates the Treasury Stock Method and If-Converted Method calculations per ASC 260.
What You Can Calculate
This template computes eight key outputs for comprehensive EPS analysis:
- Basic EPS - Net income available to common shareholders divided by weighted average shares
- Diluted EPS - EPS including all dilutive securities that pass anti-dilution tests
- Dilution Amount & Percentage - The reduction from basic to diluted EPS
- Treasury Stock Net Shares - Incremental shares from in-the-money options
- After-Tax Interest Add-Back - Interest savings from convertible bond conversion
- Dilutiveness Indicators - Whether options and bonds are dilutive or anti-dilutive
Required Inputs
Enter these values in the blue input cells:
- Income Statement Data - Net Income, Preferred Dividends, Weighted Average Common Shares
- Stock Option Details - Options Outstanding, Exercise Price, Average Market Price
- Convertible Bond Terms - Face Value, Interest Rate, Shares on Conversion
- Tax Rate - Corporate tax rate for after-tax interest calculations
Methodology
The template follows ASC 260 requirements for diluted EPS:
- Treasury Stock Method for options: Net Shares = Options - (Proceeds / Market Price)
- If-Converted Method for bonds: Add back after-tax interest, add conversion shares
- Sequential Anti-Dilution Testing per ASC 260-10-45-18 through 45-20
Assumptions & Limitations
- Single reporting period calculation (no interim adjustments)
- One option tranche and one convertible bond issue
- Weighted average shares pre-computed by user
- Bonds assumed issued at par for full period
- Does not cover RSUs, convertible preferred, or two-class method
Frequently Asked Questions
Simply change the input values in the blue cells and the results update instantly. You can compare outcomes by copying the Calculator sheet, entering different assumptions on each copy, and reviewing side-by-side. All formulas remain live so you can trace the calculation logic.
Yes. Duplicate the option or bond input rows, add corresponding TSM or If-Converted calculation rows, and adjust the Diluted EPS formula to aggregate all dilutive securities. The existing formulas show the pattern to follow.
Link the Net Income cell to your income statement, Weighted Average Shares to your share count model, and Bond Face Value to your debt schedule. The EPS outputs will flow through automatically. You can also reference the Diluted EPS cell in valuation metrics like P/E ratios.
A fully interactive financial model with live Excel formulas, an Instructions sheet with usage guide, and a Formula Reference sheet with variable definitions and model assumptions. All formulas are visible and editable.
Microsoft Excel 2016 or later. The template uses standard Excel formulas only — no macros, VBA, or add-ins required.
Yes. All cells are fully editable. You can modify any formula, add your own calculations, change formatting, or integrate the model into your existing spreadsheets.
The online calculator runs in your browser for quick calculations. This Excel template gives you a portable, offline financial model you can customize, save, share with colleagues, and integrate into your own analysis.
This template is provided for educational and personal use. You may use it in your own professional analysis and presentations. Redistribution or resale of the template itself is not permitted.
You can re-download the latest version from your account or by requesting a new download link. Free downloads are limited to 5 per email address per month.
