Attachment # 00011436 - Module_4_-_Multiples_Based_Enterprise_Valuation_-_Possible_Template.xlsx
Module_4_-_Multiples_Based_Enterprise_Valuation_-_Possible_Template.xlsx (16.98 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
(in millions)Solution LegendDownloaded dataFormula/Calculation/Analysis requiredPeer Companies:Peer 1Peer 2Peer 3Your CompanyTickerPERIOD ENDINGFrom Income Statement and Balance SheetBalance SheetInsert Relevant Items hereIncome StatementCalculated MultiplesEV/EBITDA MultipleP/E MultipleMarket to Book MultiplePrice/Revenue MultipleYour Company ValuationEnterprise Value based on EV/EBITDA multiplePlus: Your Company CashLess: Your Company Interest-bearing debtTotal Equity value based on EBITDAVA Shares Outstanding (millions)Equity value per shareEquity value per share based on P/E multipleTotal Equity value based on P/E multiplePlus: Your Company Interest-bearing debtLess: Your Company Cash and equivalentsEnterprise value based on P/E multipleEquity value per share based on MTB RatioTotal Equity value based on MTB ratioEnterprise value based on MTB ratioEquity value per share based on P/Revenue ratioTotal Equity value based on P/Revenue ratioEnterprise value based on P/Revenue ratio
Multipes Based Enterprise Valuation

Multipes Based Enterprise Valuation

Question # 00664760 Posted By: kbetts Updated on: 03/24/2018 06:03 PM Due on: 03/30/2018
Subject Finance Topic Finance Tutorials:
Question
Dot Image

This Assignment use IBM

  1. Choose peer companies for IBM and download their relevant financial data. You don't have to download entire financial statements — only the items used in multiples valuation

  2. Using approach similar to the one described in this module's Excel file, find valuation multiples (ratios) of peer companies.

  3. Estimate your company's equity value and enterprise value

I suggest starting from the "Multiples Valuation Template" in Module 4 Excel file and adjust it accordingly

Dot Image
Attachments
Module_4_-_Multiples_Based_Enterprise_Valuation_-_Possible_Template.xlsx (16.98 KB)
Tutorials for this Question
  1. mac123
    Tutorial # 00663788 Posted By: mac123 Posted on: 03/24/2018 07:48 PM
    Puchased By: 3
    Tutorial Preview
    The solution of multiple base valution...
      Get the Solution
    Attachments
    Solution-00663788.zip (88 KB)
Whatsapp Lisa