Company Valuation Excel Model
Originally published: 29/12/2017 12:25
Last version published: 11/05/2018 09:42
Publication number: ELQ-98984-2
View all versions & Certificate
certified

Company Valuation Excel Model

Valuation of a company based to its Business Plan 2015-2018

Description
The document introduces the valuation of a company, based on its 2015-2018 Business Plan.

This model was prepared in November 2015 as consequence of the release of the Company's Business Plan.

The model contemplates the analysis of the annual accounts (IS, Balance Sheet and CF).

The methodologies applied to assess its fair value have been:
1. Discount Cash Flow Method.
2. Multiple valuation Method.
3. Gordon Growth Model and H-Model Methods.
4. Asset-Based Valuation Method.

In the end, there is a summary of the result of all valuation methods.

The aim of this model was to assess the fair value of a particular company.

The model is very straightforward where no KPIs or hypothesis but those from the Business Plan have been considered. This model could be adapted to any company very easily.

I hope you enjoy it and would be delighted to receive feedback.

This Best Practice includes
1 Excel Financial Model

Eduardo Martínez Pérez offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.8 / 5 (39 votes)

please wait...