Dilution Calculation Model Template

WSO's free Dilution Calculation model template is coming soon. Stay tuned for more!

This template allows you to calculate the 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.

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 gives you a sneak peek of the template.

More Resources:

We hope this template helps you excel at your job! Please check out the following additional resources to help you advance your career:

• Debt Schedule Template
• Sensitivity Analysis Template
• Leveraged Buyout (LBO) Model Template
• Private Equity Distribution Waterfall Template
• Accretion Calculation Model Template