• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• code

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

Company Valuation Excel Model

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

by Eduardo Martínez Pérez
Corporate Finance at NORGESTIONFollow 37

37 reviews1,085 views|Start the discussion!|Bookmark download for free

business planvaluation modeldcfgordon growth modelmultiple valuation methodh-modelasset-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.8 / 5 (37 votes)

    • 78%
    • 19%
    • 3%
    • -
    • -
  • Rate this Downloadable Best Practice
    

    Write a review

• Алексей Гусев(last updated: 16/09/2021 09:27)
  
• Tuan Nguyen563(last updated: 01/07/2021 08:48)
  
• Fabian Cornejo(last updated: 28/02/2021 14:02)
  
• Rajendra Jagad(last updated: 15/02/2021 20:36)
  
• 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)
  

keyboard_arrow_downShow all