First, let's calculate Basic EPS:
($120,000,000 − $5,000,000) ÷ 25,000,000 = $4.60 per share
Now for Diluted EPS:
Step 1: Calculate total diluted shares: 25,000,000 + 2,000,000 + 3,000,000 = 30,000,000
Step 2: Apply the diluted EPS formula: ($120,000,000 − $5,000,000) ÷ 30,000,000 = $3.83 per share
The dilution impact: $4.60 − $3.83 = $0.77 per share. That's a 16.7% difference—significant enough that any serious analyst would take notice.
Here's the Excel model showing both calculations:
Figure 2: Diluted EPS calculation comparing basic vs. diluted EPS
Building EPS into Your Financial Models
Understanding the formula is one thing. Building robust EPS calculations into your financial models is another.
Here are some practical tips from the trenches.
Always link to source data. Never hardcode numbers in your EPS formulas. Link directly to your income statement for net income and your equity schedule for share counts. When those numbers update, your EPS calculation updates automatically.
Build flexibility for scenarios. Your model should handle different share count scenarios—what happens if the company issues more shares? What if they buy back shares? Build switches or dropdown menus to toggle between scenarios.
Track the trend. A single year's EPS tells you something. Five years of EPS tells you much more. Build historical EPS data into your models to identify trends. Is EPS growing? Declining? Volatile? The trend matters as much as the absolute number.
Don't forget quarterly EPS. Companies report quarterly, and so should your models. Quarterly EPS helps you track performance between annual reports and catch problems early.
Common EPS Mistakes to Avoid
Even
experienced financial modellers make these errors. Don't be one of them.
- Using the wrong share count. End-of-period shares and weighted average shares are different. EPS uses weighted average—always. Using the wrong number will throw off your entire calculation.
- Forgetting preferred dividends. If a company has preferred stock, you must subtract those dividends. Skip this step, and you'll overstate EPS.
- Ignoring dilution. Focusing only on basic EPS misses half the picture. Always calculate and analyse both basic and diluted EPS.
- Comparing apples to oranges. Be careful when comparing EPS across companies. Different accounting methods, capital structures, and industries make direct comparisons tricky. A tech startup and a mature utility company might both have $2.00 EPS, but the implications are vastly different.
The Limitations of EPS (Yes, There Are Some)
EPS is powerful, but it's not perfect. Every good analyst knows their limitations.
EPS can be manipulated. Companies can boost EPS through share buybacks without actually improving profitability. They can also use accounting tricks to inflate net income temporarily.
EPS ignores cash flow. A company can report strong EPS while burning through cash. Profitable on paper doesn't always mean profitable in reality.
EPS doesn't tell the whole story. It says nothing about debt levels, competitive position, or future growth prospects. Use EPS as one tool in your analytical toolkit, not the only one.
Putting It All Together
Earnings per share might seem like a simple concept, and at its core, it is. Profit divided by shares. But as we've seen, the devil's in the details.
Knowing when to use basic versus diluted EPS, understanding how to build EPS into dynamic financial models, and recognising its limitations separates the good analysts from the great ones.
Whether you're
valuing a company for M&A, analysing investment opportunities, or building executive compensation plans, EPS is there.
It's woven into the fabric of modern finance.
The examples we walked through— the Tech company's basic EPS of $4.00 and GlobalBank's diluted EPS of $3.83—demonstrate exactly how these calculations work in practice. Keep these models handy as templates for your own work.
Understanding EPS is just the beginning. Financial modelling encompasses a vast range of skills—from building three-statement models to conducting sensitivity analyses, from valuation techniques to scenario planning.
If you're ready to take your financial modelling skills to the next level, Redcliffe Training offers
comprehensive financial modelling courses designed for busy finance professionals. Our expert-led programmes cover everything from Excel fundamentals to advanced modelling techniques used by top investment banks and consulting firms.
When you're ready, join thousands of finance professionals who have accelerated their careers with Redcliffe Training.
FAQ
What is the difference between EPS and dividends?
Earnings per share (EPS) measure a company’s profitability by showing how much profit is earned for each share outstanding. Dividends are the portion of those profits that a company chooses to distribute to shareholders in cash or shares. EPS reflects earnings performance, while dividends reflect a payout decision. A company can have high EPS but pay low or no dividends if it reinvests profits, or lower EPS but still pay dividends using retained earnings.