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 […]
Category Archives: 1. Excel Financial Models
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 […]
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, […]
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 […]