Tl;dr: This is a super easy to use VWAP template calculator. With a simple export of volume and prices you can tell the historic trading bands of a company Download the VWAP calculation template What is the use of VWAP calculation ? VWAP has multiple uses. It’s most commonly found in it’s natural habitat of trading. But there are a …
Simple LBO Template Excel Model (Leveraged Buyout)
Tl;dr: A simple LBO template excel model to review the opportunity in acquiring a company with debt. You may have heard about LBOs; where a massive amount of debt is used to buy a company. Some times it works great and the Private Equity firms make out like bandits, but other times things go pear shaped like at RJR Nabisco. What’s …
Accretion dilution model excel template (Stock exchange)
Tl;dr: This is a simple accretion dilution model template excel model to quickly calculate if an acquisition will create value for a public company (or not) Download the accretion dilution model As a public company executive, or banker trying to make a buck for a prospective client, you are always thinking about increasing shareholder value. Why? Well, senior leadership’s bonuses are …
Debt capacity calculator excel model
TL;DR: a debt capacity excel model I made which will calculate how much debt a company can take on depending on your top line projections If you a corporate acquirer, or working in Private Equity / M&A, you will look at potential LBO (leveraged buyout) deal flow and wonder about debt capacity as a matter of course. Sure, you can (and eventually …