Originally published: 29/12/2017 12:25
Last version published: 11/05/2018 09:42
Publication number: ELQ-98984-2

Company Valuation Excel Model

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

by Eduardo Martínez Pérez
Corporate Finance at NORGESTION

33 reviews987 views|Start the discussion!|download for free

business plan valuation model dcf gordon growth model multiple valuation method h-model asset-based

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

Reviews

- 4.7 / 5 (33 votes)
  - 76%
  - 21%
  - 3%
  - -
  - -
- Rate this Downloadable Best Practice
  Write a review
Salman Waheed, MBA(last updated: 30/12/2020 13:17)
Daniel R. Akiki 653(last updated: 07/10/2020 10:25)
Adib Basbous(last updated: 10/09/2020 07:42)
Ikechukwu Okoli(last updated: 02/07/2020 17:50)
*ban* Arhat Bhagwatkar(last updated: 25/06/2020 13:16)
WalidD(last updated: 31/03/2020 09:48)
Shubham Limje(last updated: 09/03/2020 14:34)
RAFAEL CARCASONA(last updated: 06/03/2020 22:17)
Chalermsak Ninchuawong(last updated: 11/01/2020 06:41)
Aek Ninchuawong(last updated: 08/10/2019 14:45)
Alexandre Thiney(last updated: 01/10/2019 18:22)
Tigran Dokholyan(last updated: 24/07/2019 09:55)
HünkarİVGEN(last updated: 14/07/2019 15:53)
Amir Ganic(last updated: 18/04/2019 15:47)
Virginie Bagot(last updated: 14/02/2019 09:43)
Jerry Stecher(last updated: 11/01/2019 18:58)
Valuation Model
This is very helpful
Sean Spitzer(last updated: 31/12/2018 17:40)
surabhi thakwani(last updated: 24/12/2018 07:52)
Musa Barrieh(last updated: 20/12/2018 10:06)
David Gilley(last updated: 19/12/2018 00:46)
Quan Quach(last updated: 13/12/2018 07:21)
Madina Kobikova(last updated: 25/11/2018 04:23)
Santos Jd(last updated: 06/11/2018 03:52)
Johnny Gold(last updated: 17/08/2018 13:42)
Kibaw Arp(last updated: 09/08/2018 14:23)
Navdeep singh Chopra(last updated: 02/08/2018 05:32)
dasha smirnova(last updated: 22/07/2018 11:09)
Maurice van Sabben(last updated: 02/06/2018 10:51)
Edwin Sitienei(last updated: 31/05/2018 12:45)
Fernando Belda Rodriguez(last updated: 29/05/2018 09:23)