Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the annual financial information over the period 1997-2016 for General Electric (see excel GEPreview the document). In each column is listed their operating cash

Consider the annual financial information over the period 1997-2016 for General Electric (see excel GEPreview the document). In each column is listed their operating cash flow (OCF), gross profit (GP), operating income (EBIT), net income (NI) and earnings before interest, taxes, depreciation and amortization (EBITDA). The estimated intrinsic value of any asset is the present value of its future cash flows.
Therefore, using a discount rate of 12%, calculate the present value of GE based on its operating cash flow and assuming the first cash flow was not expected to be received for a year (i.e. you're calculating the value one year before the first cash flow is to be received).
Intrinsic Value =
Options for answer include: 202,018 or 205,130 or 207,894 or 209,100 or 209,950 or 210,085.
Now, using the same discount rate, calculate the present value of each of the financial statement metrics. (Round your answers to the nearest whole number and DO NOT include commas or dollar signs)
PV of GP =
PV of EBIT =
PV of NI =
PV of Ebitda =
image text in transcribed
o 27.0. Corinto formou G H I K L M ebidaquestions Home Insert Draw Page Layout Formulas Data Review View the Calibri tady! 12 -A A = 19 Wrap Text General Us Pute B TW AA Morge Carte $ - % 15x fx A B C D E F 1 Source: Compustat (numbers in millions) datadate fyear tic conm OCFGP 19971231 1997 GE GENERAL ELECTRIC CO 14,240 23,907 19981231 1998 GE GENERAL ELECTRIC CO 19,360 28,706 19991231 1999 GE GENERAL ELECTRIC CO 24,593 31 848 20001231 2000 GE GENERAL ELECTRIC CO 22,690 37,342 20011231 2001 GE GENERAL ELECTRIC CO 32,195 37,966 20021231 2002 GE GENERAL ELECTRIC CO 29,488 34,418 20031231 2003 GE GENERAL ELECTRIC CO 30,289 36,980 20041231 2004 GE GENERAL ELECTRIC CO 36.484 82,801 20051231 2005 GE GENERAL ELECTRIC CO 37,641 86,222 20061231 2006 GE GENERAL ELECTRIC CO 30,646 94,477 20071231 2007 GE GENERAL ELECTRIC CO 45,967 105,483 20081231 2008 GE GENERAL ELECTRIC CO 48,601 107527 20091231 2009 GE GENERAL ELECTRIC CO 24,593 89.575 20101231 2010 GE GENERAL ELECTRIC CO 36,123 86,097 20111231 2011 GE GENERAL ELECTRIC CO 33,359 81,274 20121231 2012 GE GENERAL ELECTRIC CO 31,331 78,590 20131231 2013 GE GENERAL ELECTRIC CO 28,579 72,680 20141231 2014 GE GENERAL ELECTRIC CO 27,710 73,369 20151231 2015 GE GENERAL ELECTRIC CO 19,891 36,212 20161231 2016 GE GENERAL ELECTRIC CO (244) 39,688 EBITNI EBITDA 19,825 8,203 23,907 22,846 9,296 28,706 25, 157 10,717 31 848 29,606 12,735 37,342 30,877 13,684 37,966 28,420 14,118 34,418 30,024 15,002 36,980 32,380 16,819 40,765 37,159 16,711 47,110 42,277 20,829 53,224 50,382 22,208 62,740 46 405 17 410 59.988 28.107 11.025 40.843 29,040 11,644 40,802 28,890 14,151 39,807 27,351 13,641 38,312 21,246 13,060 32,719 24,278 15,233 35,350 10,239 (6,127) 16,591 13,628 8,831 20,329 MacBook Air

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions