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 =

I am sorry the image is upside down. I can't figure out how to properly upload it. Any help on this question is much appreciated !!!

image text in transcribed

Share C Insert 2X Delete El Format Styles X Sole Sandides J AutoSaver OBES . ebitdaquestions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 A = = Wrap Text General BI O A EE E Merge & Conte $ % 988 38 Formatia 15 x fe A B C D E F G H I 1 Source: Compustat (numbers in millions) 2 datadate fyear tic conm OCF GP EBIT NI EBITDA 19971231 1997 GE GENERAL ELECTRIC CO 14,240 23,907 19,825 8,203 23,907 19981231 1998 GE GENERAL ELECTRIC CO 19,360 28,706 22,846 9,296 28,706 19991231 1999 GE GENERAL ELECTRIC CO 24,593 31,848 25,157 10,717 31,848 20001231 2000 GE GENERAL ELECTRIC CO 22,690 37,342 29,606 12,735 37,342 20011231 2001 GE GENERAL ELECTRIC CO 32,195 37,966 30,877 13,684 37,966 20021231 2002 GE GENERAL ELECTRIC CO 29,488 34,418 28,420 14,118 34,418 20031231 2003 GE GENERAL ELECTRIC CO 30,289 36,980 30,024 15,002 36,980 20041231 2004 GE GENERAL ELECTRIC CO 36,484 82,801 32,380 16,819 40,765 20051231 2005 GE GENERAL ELECTRIC CO 37,641 86,222 37,159 16,711 47,110 20061231 2006 GE GENERAL ELECTRIC CO 30,646 94,477 42,277 20,829 53,224 20071231 2007 GE GENERAL ELECTRIC CO 45,967 105,483 50,382 22,208 62,740 20081231 2008 GE GENERAL ELECTRIC CO 48,601 107,527 46,405 17,410 59,988 20091231 2009 GE GENERAL ELECTRIC CO 24,593 89,575 28,107 40,843 20101231 2010 GE GENERAL ELECTRIC CO 36,123 86,097 29,040 11,644 40,802 20111231 2011 GE GENERAL ELECTRIC CO 33,359 81,274 28,890 14,151 39,807 20121231 2012 GE GENERAL ELECTRIC CO 31,331 78,590 27,351 13,641 38,312 20131231 2013 GE GENERAL ELECTRIC CO 28,579 72,680 21,246 13,060 32,719 20141231 2014 GE GENERAL ELECTRIC CO 27,710 73,369 24,278 15,233 35,350 20151231 2015 GE GENERAL ELECTRIC CO 19,891 36,212 10,239 (6,127) 16,591 20161231 2016 GE GENERAL ELECTRIC CO (244) 39,688 13,628 8,831 20,329 Sheet1 + Share C Insert 2X Delete El Format Styles X Sole Sandides J AutoSaver OBES . ebitdaquestions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 A = = Wrap Text General BI O A EE E Merge & Conte $ % 988 38 Formatia 15 x fe A B C D E F G H I 1 Source: Compustat (numbers in millions) 2 datadate fyear tic conm OCF GP EBIT NI EBITDA 19971231 1997 GE GENERAL ELECTRIC CO 14,240 23,907 19,825 8,203 23,907 19981231 1998 GE GENERAL ELECTRIC CO 19,360 28,706 22,846 9,296 28,706 19991231 1999 GE GENERAL ELECTRIC CO 24,593 31,848 25,157 10,717 31,848 20001231 2000 GE GENERAL ELECTRIC CO 22,690 37,342 29,606 12,735 37,342 20011231 2001 GE GENERAL ELECTRIC CO 32,195 37,966 30,877 13,684 37,966 20021231 2002 GE GENERAL ELECTRIC CO 29,488 34,418 28,420 14,118 34,418 20031231 2003 GE GENERAL ELECTRIC CO 30,289 36,980 30,024 15,002 36,980 20041231 2004 GE GENERAL ELECTRIC CO 36,484 82,801 32,380 16,819 40,765 20051231 2005 GE GENERAL ELECTRIC CO 37,641 86,222 37,159 16,711 47,110 20061231 2006 GE GENERAL ELECTRIC CO 30,646 94,477 42,277 20,829 53,224 20071231 2007 GE GENERAL ELECTRIC CO 45,967 105,483 50,382 22,208 62,740 20081231 2008 GE GENERAL ELECTRIC CO 48,601 107,527 46,405 17,410 59,988 20091231 2009 GE GENERAL ELECTRIC CO 24,593 89,575 28,107 40,843 20101231 2010 GE GENERAL ELECTRIC CO 36,123 86,097 29,040 11,644 40,802 20111231 2011 GE GENERAL ELECTRIC CO 33,359 81,274 28,890 14,151 39,807 20121231 2012 GE GENERAL ELECTRIC CO 31,331 78,590 27,351 13,641 38,312 20131231 2013 GE GENERAL ELECTRIC CO 28,579 72,680 21,246 13,060 32,719 20141231 2014 GE GENERAL ELECTRIC CO 27,710 73,369 24,278 15,233 35,350 20151231 2015 GE GENERAL ELECTRIC CO 19,891 36,212 10,239 (6,127) 16,591 20161231 2016 GE GENERAL ELECTRIC CO (244) 39,688 13,628 8,831 20,329 Sheet1 +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Excel For Auditors

Authors: Bill Jelen, Dwayne K. Dowell

1st Edition

ISBN: 1932802169, 978-1932802160

More Books

Students also viewed these Accounting questions

Question

- What are the best pricing strategy and policy for our operation?

Answered: 1 week ago