URGENT !

For this part of the final project, you will be given a scenario in which you are asked to illustrate your financial computation and analysis skills. This part of the assessment addresses the following course outcomes. Compute financial ratios, time value, variables, and returns using industry standard tools for optimizing financial success Analyze corporate financial data for multiple companies in evaluating past and future financial performances Part II Prompt For this section of your employment exam, you will select two companies . First Company will be DISNEY.

For present stock information and reports please use Yahoo Financials

https://finance.yahoo.com/quote/DIS/history?p=DIS

SIX FLAGS - please find the stock data for Six Flags in the Yahoo Finances website provided below.

https://finance.yahoo.com/quote/SIX/history?p=SIX

You will be responsible for collecting, synthesizing, and making decisions regarding both companies. After evaluating these companies' financial data, you will then decide which company's stock is the better investment. This section of your employment examination must be submitted in two parts.

Part A will contain the workbooks that house all of your quantitative data and formulas, along with any of the information that is relevant for your chosen companies.

Part B will contain your answers to the questions asked below, composed in a cohesive manner. If you are referring to data that is found within the workbooks in

Part A, be sure to include a citationfor example, "rate of return is 3.570 USD (E64, WB2)," where E64 is the cell that the calculation took place in and WB2 is designating "workbook 2." This ensures that your instructor can quickly and accurately check data entry, formula use, and financial calculations. Your submission must address the following critical elements: I. Preparing the Workbooks A. Download the annual income statements, balance sheets, and cash flow statements for the last three completed fiscal years for your chosen companies. This information must be included in your final submission. (Please find images attached with the Disney reports )

B. Prepare a worksheet for each of the companies to display their financial data for the last three fiscal years. Ensure your data is accurate and organized. Include these worksheets as a workbook in your final submission.

C. Find historical stock prices for both companies and add this information to the respective spreadsheets. Consider the appropriate date range you should use. II. Three-Year Returns A. What is the three-year return on the stock price of the first company (Company A)? ( Use Yahoo Finance data ) How is the stock performing? Ensure that you use the appropriate formula in your spreadsheets to calculate the three-year return on the given company's stock price.

B. What is the three-year return on the stock price of the second company (Company B)? How is this stock performing? Ensure that you use the appropriate formula in your spreadsheets to calculate the three-year return on your chosen company's stock price.

C. How do these two stocks compare in terms of three-year returns? What does this indicate about these two companies? III. Financial Calculations A. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the price-to-earnings ratio for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula.

B. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the debt-to-equity ratios for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula.

C. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the return-on-equity ratios for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula.

D. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the earnings per share for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula.

E. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the profit margins for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula.

F. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the free cash flows for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula.

IV. Industry Averages

A. Obtain current industry averages of three of the financial calculations above for both companies and add this information to your spreadsheet for comparison. Ensure the accuracy and organization of your data.

B. In this context, how is each company's financial health? How do these two companies compare to one another? Consider the appropriate date range you should use.

V. Performance Over Time

A. Analyze the performance of the Company A over time. What financial strengths and weaknesses does this company have? Consider addressing the free cash flows and ratios you calculated earlier.

B. Analyze the performance of your Company B over time. What financial strengths and weaknesses does this company have? Consider addressing the free cash flows and ratios you calculated earlier.

C. Analyze how the data differ between these two companies. Why do you think this is? Consider addressing the free cash flows and ratios you calculated earlier.

VI. Investment

A. Are the companies considered growth or value companies? Why?

Disney (Walt) Co. (The) (NYS: DIS) Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date Currency Audit Status Consolidated Scale Cash & cash equivalents Accounts receivable Other receivables Allowance for doubtful accounts Receivables Inventories Television costs & advances Deferred income taxes Prepaid expenses Other current assets Other current assets Total current assets Film & television costs Investments Attractions, buildings & improvements Leasehold improvements Furniture, fixtures & equipment Land improvements Attractions, buildings & equipment, at cost Accumulated depreciation Parks, resorts & other property, at net Projects in progress Land Parks, resorts & other property, net Intangible assets, net Goodwill Receivables Prepaid expenses Other non-current assets Other assets Total assets Accounts payable Payroll & employee benefits Other accounts payable & accrued liabilities Accounts payable & other accrued liabilities Current portion of borrowings 10/01/2016 USD Not Qualified Yes Thousands 4610000 8458000 760000 153000 9065000 1390000 1208000 449000 244000 693000 16966000 6339000 4280000 27930000 830000 16912000 4598000 50270000 26849000 23421000 2684000 1244000 27349000 6949000 27810000 1651000 229000 460000 2340000 92033000 6860000 1747000 523000 9130000 3687000 Unearned royalties & other advances Total current liabilities Commercial paper U.S. medium-term notes Foreign currency denominated debt Capital Cities/ABC debt Other borrowings Total long-term borrowings - Disney Co. International Theme Parks borrowings Hong Kong Disneyland Resort (HKDL) - borrowings Total borrowings Less current portion Borrowings Deferred income taxes Pension & postretirement medical plan liabilities Other long-term liabilities Other long-term liabilities Common stock Retained earnings (accumulated deficit) Market value adjustments for investments Market value adjustments for cash flow hedges Unrecognized pension & postretirement medical expense Foreign currency translation & other accumulated other compre Accumulated other comprehensive income (loss) Stockholders' equity subtotal Treasury stock, at cost Total The Walt Disney Company shareholder's equity Noncontrolling interests Total equity 4025000 16842000 1521000 16827000 448000 107000 180000 19083000 1087000 20170000 3687000 16483000 3679000 5184000 2522000 7706000 35859000 66088000 26000 -25000 -3651000 -329000 -3979000 97968000 54703000 43265000 4058000 47323000 10/03/2015 USD Not Qualified Yes Thousands 4269000 7613000 563000 157000 8019000 1571000 1170000 767000 469000 493000 962000 16758000 6183000 2643000 21556000 769000 16068000 4352000 42745000 24844000 17901000 6028000 1250000 25179000 7172000 27826000 1589000 211000 621000 2421000 88182000 5504000 1797000 543000 7844000 4563000 09/27/2014 USD Not Qualified Yes Thousands 3421000 7428000 548000 154000 7822000 1574000 1061000 497000 425000 376000 801000 15176000 5325000 2696000 21539000 757000 15701000 4266000 42263000 23722000 18541000 3553000 1238000 23332000 7434000 27881000 1485000 212000 645000 2342000 84186000 5371000 1769000 455000 7595000 2164000 3927000 16334000 2430000 13873000 447000 108000 159000 17017000 319000 17336000 4563000 12773000 4051000 3940000 2429000 6369000 35122000 59028000 13000 334000 -2497000 -271000 -2421000 91729000 47204000 44525000 4130000 48655000 3533000 13292000 50000 13713000 530000 110000 184000 14587000 253000 14840000 2164000 12676000 4098000 3481000 2461000 5942000 34301000 53734000 100000 204000 -2196000 -76000 -1968000 86067000 41109000 44958000 3220000 48178000 \fDisney (Walt) Co. (The) (NYS: DIS) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date 10/01/2016 Currency USD Audit Status Not Qualified Consolidated Yes Scale Thousands Revenues - services 47130000 Revenues - products 8502000 Total revenues 55632000 Cost of services (exclusive of depreciation & amortization) 24653000 Cost of products (exclusive of depreciation & amortization) 5340000 Selling, general, administrative & other expenses 8754000 Depreciation & amortization 2527000 Total costs & expenses 41274000 Restructuring & impairment charges 156000 Venezuela foreign currency translation gain (loss) Gain (loss) on sale of property & other Other income/(expense), net Other income (expense), net Interest expense 354000 Interest & investment income 94000 Interest income (expense), net -260000 Equity in the income of investees 926000 Income (loss) before income taxes - domestic (including U.S. e 14018000 Income (loss) before income taxes - foreign subsidiaries 850000 Income (loss) before income taxes 14868000 Current income tax expense (benefit) - federal 3146000 Current income tax expense (benefit) - state 154000 Current income tax expense (benefit) - foreign 533000 Total current income tax expense (benefit) 3833000 Deferred income tax expense (benefit) - federal 1172000 Deferred income tax expense (benefit) - state 100000 Deferred income tax expense (benefit) - foreign -27000 Total deferred income tax expense (benefit) 1245000 Income taxes 5078000 Net income (loss) 9790000 Less: net loss (income) attributable to noncontrolling interests -399000 Net income attributable to The Walt Disney Company (Disney) 9391000 Weighted average common & common equivalent shares outsta 1629000 Weighted average common & common equivalent shares outstan 1639000 Year end shares outstanding 1600000 Net earnings (loss) per share - basic 5.76 Net earnings (loss) per share - diluted Dividends per share Total number of employees Number of common stockholders Foreign currency translation adjustments 5.73 1.42 195000 890200 -156000 10/03/2015 USD Not Qualified Yes Thousands 43894000 8571000 52465000 23191000 5173000 8523000 2354000 39241000 53000 265000 148000 -117000 814000 12825000 1043000 13868000 4182000 333000 525000 5040000 82000 -52000 -54000 -24000 5016000 8852000 -470000 8382000 1694000 1709000 1600000 4.95 09/27/2014 USD Not Qualified Yes Thousands 40246000 8567000 48813000 21356000 5064000 8565000 2288000 37273000 140000 -143000 77000 35000 -31000 294000 317000 23000 854000 11376000 870000 12246000 2932000 206000 600000 3738000 409000 81000 14000 504000 4242000 8004000 -503000 7501000 1740000 1759000 1707000 4.31 4.9 1.81 185000 903854 -272000 4.26 0.86 180000 958420 - Six Flags Entertainment Corp (NYS: SIX) Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date Currency Audit Status Consolidated Cash & cash equivalents Accounts receivable, gross Less: allowance for doubtful accounts Accounts receivable, net Inventories Prepaid expenses & other current assets Deferred income taxes Total current assets Land Land improvements Buildings & improvements Rides & attractions Equipment Property & equipment, at cost Accumulated depreciation Total property & equipment, net Debt issuance costs Restricted-use investment securities Deposits & other assets Goodwill Intangible assets, net of accumulated amortization Total other assets Total assets Accounts payable Accrued compensation, payroll taxes & benefits Accrued insurance reserves Accrued interest payable Other accrued liabilities Deferred income Current portion of long-term debt Total current liabilities Term loan Notes HWP refinance loan Net premiums (discount) Deferred financing costs Long-term debt, gross 12/31/2015 USD Not Qualified Yes 99760000 66203000 2400000 63803000 21535000 42879000 227977000 221665000 199515000 270758000 941550000 229276000 1862764000 664610000 1198154000 5386000 3036000 7211000 630248000 356428000 1002309000 2428440000 25570000 46583000 40796000 19555000 34714000 97334000 7506000 272058000 696500000 800000000 29667000 -3281000 -17358000 1505528000 Less current portion Long-term debt Other long-term liabilities Deferred income taxes Total noncurrent liabilities Total liabilities Redeemable noncontrolling interests Common stock Capital in excess of par value Retained earnings (accumulated deficit) Currency translation adjustment Cash flow hedges Defined benefit plans Income taxes Accumulated other comprehensive income (loss), net of tax Total Six Flags Entertainment Corporation stockholders' equity (d Total stockholders' equity (deficit) 7506000 1498022000 58150000 140273000 1696445000 1968503000 435721000 2289000 1041710000 -953225000 -24800000 -1598000 -49772000 9612000 -66558000 24216000 24216000 12/31/2014 USD Not Qualified Yes 73884000 58823000 21099000 44705000 102413000 300924000 227983000 191307000 268425000 903304000 206598000 1797617000 579511000 1218106000 19062000 2471000 4750000 630248000 359358000 1015889000 2534919000 19315000 37463000 41276000 19542000 36176000 71598000 6301000 231671000 570544000 800000000 30187000 -5215000 1395516000 12/31/2013 USD Not Qualified Yes 169310000 51609000 22172000 39006000 71761000 353858000 227335000 177654000 264853000 857426000 189707000 1716975000 485292000 1231683000 23821000 1823000 4268000 630248000 362113000 1022273000 2607814000 24464000 29277000 50771000 19598000 25988000 60443000 6269000 216810000 576366000 800000000 30673000 -6436000 1400603000 6301000 1389215000 65396000 187197000 1641808000 1873479000 437545000 2323000 983317000 -702116000 -12198000 -726000 -52585000 5880000 -59629000 223895000 223895000 6269000 1394334000 39934000 145830000 1580098000 1796908000 437569000 2371000 842488000 -438825000 -1710000 -301000 -19705000 -10981000 -32697000 373337000 373337000 Six Flags Entertainment Corp (NYS: SIX) Exchange rate used is that of the Year End reported date As Reported Annual Cash Flow Report Date 12/31/2015 Currency USD Audit Status Not Qualified Consolidated Yes Net income (loss) 192855000 Depreciation & amortization 107411000 Reorganization items, net Stock-based compensation 56233000 Interest accretion on notes payable 856000 Loss on debt extinguishment 6557000 Amortization of debt issuance costs 4518000 Other adjustments, including loss on disposal of assets 17278000 Loss (gain) on sale of investee Accounts receivable -6072000 Inventories, prepaid expenses & other current assets 306000 Deposits & other assets -2465000 Accounts payable, deferred income, accrued liabilities & other lo 41775000 Accrued interest payable 13000 Deferred income tax expense (benefit) 54496000 Net cash provided by operating activities before reorganization a Net cash used in reorganization activities Net cash flows from operating activities 473761000 Additions to property & equipment -114370000 Property insurance recovery 173000 Purchase of identifiable intangible assets -29000 Purchase of restricted-use investments, net -565000 Maturities of restricted-use investments Proceeds from sale of Dick Clark Productions, Inc (DCP), net Proceeds from sale of assets 5123000 Net cash flows from investing activities -109668000 Repayment of borrowings -710565000 Proceeds from borrowings 834250000 Payment of debt issuance costs -11916000 Net proceeds from issuance of common stock 40531000 Stock repurchases -245114000 Payment of cash dividends -200957000 Purchase of HWP Development, LLC (HWP) ownership interes Purchase of redeemable noncontrolling interest -1552000 Noncontrolling interest distributions -38165000 Net cash flows from financing activities -333488000 Effect of exchange rate on cash -4729000 Increase (decrease) in cash & cash equivalents Cash & cash equivalents at beginning of period Cash & cash equivalents at end of period Cash paid for interest Cash paid for income taxes 25876000 73884000 99760000 70818000 14975000 12/31/2014 USD Not Qualified Yes 114034000 108107000 140038000 1221000 4748000 1672000 -10031000 -7764000 -5744000 -486000 13293000 -56000 33291000 392323000 392323000 -108660000 850000 -49000 -648000 10031000 148000 -98328000 -6308000 38840000 -195353000 -184300000 -19000 -38012000 -385152000 -4269000 12/31/2013 USD Not Qualified Yes 156873000 128075000 -180000 27034000 1252000 789000 4285000 10320000 -22146000 -2062000 473000 12147000 17239000 34915000 369014000 -332000 368682000 -101853000 -75000 -621000 16000 230000 -102303000 -6276000 -2660000 30860000 -523589000 -176171000 -9554000 -288000 -37452000 -725130000 -1147000 -95426000 169310000 73884000 67145000 16772000 -459898000 629208000 169310000 52268000 13768000 Six Flags Entertainment Corp (NYS: SIX) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date 12/31/2015 Currency USD Audit Status Not Qualified Consolidated Yes Theme parks admissions 687819000 Theme park food, merchandise & other revenue 500190000 Sponsorship, licensing & other fees 59133000 Accommodations revenue 16796000 Total revenue 1263938000 Operating expenses (excluding depreciation & amortization) 465219000 Selling, general & administrative expenses 234810000 Costs of products sold 100709000 Depreciation 104788000 Amortization 2623000 Gain (loss) on disposal of assets -9882000 Gain (loss) on sale of investee Interest expense 76205000 Interest income 302000 Gain (loss) on debt extinguishment -6557000 Other income (expense), net -223000 Income (loss) from continuing operations before reorganization Reorganization items, net Income (loss) from continuing operations before income taxes 238416000 Income (loss) from continuing operations before income taxes 24808000 Income (loss) from continuing operations before income taxes 263224000 Current U.S. federal income taxes -119000 Current foreign income taxes 9656000 Current state & local income taxes 6336000 Total current income taxes 15873000 Deferred U.S. federal income taxes 61583000 Deferred foreign income taxes -2399000 Deferred state & local income taxes -4688000 Total deferred income taxes 54496000 Income tax expense (benefit) 70369000 Income (loss) from continuing operations before discontinued o 192855000 Income (loss) from discontinued operations Net income (loss) 192855000 Net loss (income) attributable to noncontrolling interests -38165000 Net income (loss) attributable to Six Flags Entertainment Corpo 154690000 Net income (loss) applicable to Six Flags Entertainment Corpo Weighted average shares outstanding - basic 93580000 Weighted average shares outstanding - diluted Year end shares outstanding Income (loss) per share from continuing operations - basic Income (loss) per share - discontinued operations - basic Net income (loss) per share - basic Income (loss) per share from continuing operations - diluted Income (loss) per share - discontinued operations - diluted Net income (loss) per share - diluted Dividends per common share Number of full time employees Number of seasonal employees Number of common stockholders Foreign currency translation adjustments 97981000 91550851 1.65 1.65 1.58 1.58 2.14 1900 42000 61 -8195000 12/31/2014 USD Not Qualified Yes 641535000 460131000 57250000 16877000 1175793000 437431000 310955000 90515000 105449000 2658000 -5860000 10031000 73057000 468000 -356000 160011000 -57000 6260000 7028000 13231000 31757000 46000 1488000 33291000 46522000 113489000 545000 114034000 -38012000 76022000 76022000 94477000 12/31/2013 USD Not Qualified Yes 602204000 448547000 42179000 17000000 1109930000 417482000 189218000 86663000 113682000 14393000 -8579000 75044000 899000 -789000 -1234000 203745000 -180000 203925000 9868000 2818000 12686000 39077000 -1123000 -3039000 34915000 47601000 156324000 549000 156873000 -38321000 118552000 118552000 96940000 98139000 92937619 0.79 0.01 0.8 0.76 0.01 0.77 1.93 1900 39000 55 - 100371000 94857347 1.21 0.01 1.22 1.17 0.01 1.18 1.82 1900 39000 63