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 …
Why you are making a financial model for your fundraise is wrong
The earlier stage your company is, the less you are able to make any reasonable projections, let alone what key assumptions are for your financial model. Investors don’t invest in numbers as your forecasts will be certainly be wrong, but your thinking in how you came to them is what is worth backing. “No Battle Plan Survives Contact With the …