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

Total Avg Compensation

September 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (38) $367
  • Associates (220) $232
  • 2nd Year Analyst (133) $153
  • 3rd+ Year Analyst (30) $147
  • Intern/Summer Associate (103) $143
  • 1st Year Analyst (484) $135
  • Intern/Summer Analyst (376) $82