Dilution Calculation Model Template

Calculate the accretion impact on a stock

Author: Matthew Retzloff
Matthew Retzloff
Matthew Retzloff
Investment Banking | Corporate Development

Matthew started his finance career working as an investment banking analyst for Falcon Capital Partners, a healthcare IT boutique, before moving on to work for Raymond James Financial, Inc in their specialty finance coverage group in Atlanta. Matthew then started in a role in corporate development at Babcock & Wilcox before moving to a corporate development associate role with Caesars Entertainment Corporation where he currently is. Matthew provides support to Caesars' M&A processes including evaluating inbound teasers/CIMs to identify possible acquisition targets, due diligence, constructing financial models, corporate valuation, and interacting with potential acquisition targets.

Matthew has a Bachelor of Science in Accounting and Business Administration and a Bachelor of Arts in German from University of North Carolina.

View Profile
Reviewed By: Himanshu Singh
Himanshu Singh
Himanshu Singh
Investment Banking | Private Equity

Prior to joining UBS as an Investment Banker, Himanshu worked as an Investment Associate for Exin Capital Partners Limited, participating in all aspects of the investment process, including identifying new investment opportunities, detailed due diligence, financial modeling & LBO valuation and presenting investment recommendations internally.

Himanshu holds an MBA in Finance from the Indian Institute of Management and a Bachelor of Engineering from Netaji Subhas Institute of Technology.

View Profile
Last Updated:January 31, 2022

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.

Dilution Calculation Model Template

M&A Modeling Course

Everything You Need To Master M&A Modeling

To Help you Thrive in the Most Prestigious Jobs on Wall Street.

Learn More

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: