Dilution Calculation - Model Template

Download WSO's free Dilution Calculation model template below! This template allows you to calculate dilution impact on a stock. The template is plug-and-play, and you can enter your own numbers or formulas to auto-populate output numbers. The template also includes other tabs for other elements of a financial model. You can find the opposite Accretion Calculation model here.

IMPORTANT UPDATE: New Financial Modeling Training Now Available Here.

According to the WSO Dictionary,

"Dilution is a financial concept to represent a decrease in value and can apply to either a transaction or a bond. For both, it refers to the fact that value is lost purely on paper.

In a transaction, dilution is the decrease in Earnings Per Share after a merger or acquisition has taken place. If the Earnings Per Share decreases, then the transaction is usually seen as being a bad one."

A screenshot below shows a sneak peak of the template.

WSO Dilution Calculation Template

Start Discussion

Popular Content See all

The lighter side of IB! (Hopefully)
+38IBby 1st Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 1 in IB-M&A
Making the first move as a woman?
+11OFFby Intern in Investment Banking - Generalist">Intern in IB - Gen
Is Finance the back office of society?
+8OFFby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
JPM vs. CS offer decision
+7IBby Intern in Investment Banking - Generalist">Intern in IB - Gen

Total Avg Compensation

October 2020 Investment Banking

  • Director/MD (17) $704
  • Vice President (49) $326
  • Associates (265) $228
  • 3rd+ Year Analyst (36) $168
  • 2nd Year Analyst (147) $159
  • Intern/Summer Associate (137) $141
  • 1st Year Analyst (583) $129
  • Intern/Summer Analyst (558) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.4
2
Jamoldo's picture
Jamoldo
98.3
3
Secyh62's picture
Secyh62
98.2
4
CompBanker's picture
CompBanker
97.9
5
redever's picture
redever
97.7
6
Addinator's picture
Addinator
97.6
7
frgna's picture
frgna
97.5
8
bolo up's picture
bolo up
97.5
9
NuckFuts's picture
NuckFuts
97.5
10
Edifice's picture
Edifice
97.3