Category Archives: 1. Excel Financial Models

Stock Price Valuation with Intrinsic PBR and Regression

Excel Template to compare the PBR of Tesla and Toyota and the market valuation of Telecom companies   This Excel pricing model is primarily divided into two parts. The first part is the PBR valuation for Tesla and Toyota, and the second part is the stock price valuation for six telecom companies listed in the […]

Evaluating the Deal Value of Dell’s MBO with EV/EBITDA

Background This Excel template provides a method to value private companies and M&A by using EV/EBITDA. It took the M&A deal of Dell Computer as an example. In 2013, Michael Dell succeeded in the MBO on Dell Computer. At that time, Skylake Private Equity Fund and Microsoft participated helped him as equity co-investors. And more […]

Valuation of Dyson’s stock, a private company, using PER

Background In this Excel, you will see the stock of Dyson, a famous British home appliance company, valued using two types of PER. At the same time, you can learn the method of stock valuation for a private company. To value Dyson, it selected ten companies as comparable firms in the UK stock market. Then, […]

Excel valuation template for early-stage with ‘VC Method’

Background This financial model describes how to value early-stage firms using VC-method when fundraing from a venture capital. It alsoo shows how to calculate the share ratio between existing shareholders and investors. Furthermore, when planning 2nd round fundraising in the future, it explains what variables you should consider if the existing owner wants to maintain […]

Select your currency