What is the price to earning, Return to equity ratio and Net Profit Margin. Please show all work

Share Prices

129.96 2019

116.94 2018

98.57 - 2017

Fin 320 excel assigment - Excel Lori Foster LF 0 - 0 X AutoSave of File Home Insert Arial View Draw 10 Page Layout Formulas AA === *On - F Data Review a Wrap Text Merge & Center Arial Help General $ % AutoSum 47 3 Comments 4 Ideas Search - 2 E 8.09 Conditional Format as Cell Formatting Table Styles Styles - Share 0 Sort & Find & Filter - Select Editing Paste BIU - 1 A Fill- Clear Insert Delete Format Clipboard Font Alignment Number Cells Ideas K5 12914000 1815000 14729000 2240000 362000 642000 3244000 -1577000 -20000 16000 - 1581000 1663000 12611000 1177000 13788000 3229000 360000 489000 4078000 370000 5000 -31000 344000 4422000 35 Income (loss) before income taxes - domestic (including U.S 12389000 36 Income (loss) before income taxes - foreign subsidiaries 1555000 37 Income (loss) from continuing operations before income taxe 13944000 38 Current income tax expense (benefit) - federal 14000 39 Current income tax expense (benefit) - state 112000 40 Current income tax expense (benefit) - foreign 824000 41 Total current income tax expense (benefit) 950000 42 Deferred income tax expense (benefit) - federal 1829000 43 Deferred income tax expense (benefit) - state 259000 44 Deferred income tax expense (benefit) - foreign -7000 45 Total deferred income tax expense (benefit) 2081000 46 Income taxes from continuing operations 3031000 47 Net income (loss) from continuing operations 10913000 48 Income from discontinued operations 671000 49 Net income (loss) 11584000 50 Less: net loss (income) attributable to noncontrolling interes 51 Less: net income (loss) from continuing operations attributab 472000 52 Less: net income (loss) from discontinued operations attribu -58000 53 Net income attributable to The Walt Disney Company (Disne 11054000 54 Weighted average common & common equivalent shares ou 1656000 55 Weighted average common & common equivalent shares ou 56 Year end shares outstanding 1783000 57 Earnings (loss) per share from continuing operations - basic 6.3 58 Earnings (loss) per share from discontinued operations - bas 0.37 59 Net earnings (loss) per share - basic 6.68 60 Earnings (loss) per share from continuing operations - diluted 6.27 61 Farninas (loss) per share from discontinued operations - dilu 037 Balance Sheet Income Statement Cash Flow 13066000 468000 9366000 -386000 12598000 1499000 1507000 1488000 8980000 1568000 1578000 1517000 8.4 5.73 + | ! O J -_ 100% Type here to search o te reo 2 + - + 3:33 PM 3/31/2020 1 22 Fin 320 excel assigment - Excel Lori Foster LF 0 - 0 X AutoSave of File Home Insert Draw Page Layout Formulas Data Review View Help Search Arial - 10 -A A === 20 Wrap Text General AutoSum 47 Share 0 Sort & Find & Filter - Select Editing Comments 4 Ideas LA- Paste BIU - B A - = = = = Merge & Center, $ % 48.00 Fill- Clear Insert Delete Format Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment Number Cells Ideas K5 X fax 3244000 -1577000 -20000 16000 -1581000 1663000 4078000 370000 5000 31000 344000 4422000 13066000 468000 9366000 386000 41 Total current income tax expense (benefit) 950000 42 Deferred income tax expense (benefit) - federal 1829000 43 Deferred income tax expense (benefit) - state 259000 44 Deferred income tax expense (benefit) - foreign -7000 45 Total deferred income tax expense (benefit) 2081000 46 Income taxes from continuing operations 3031000 47 Net income (loss) from continuing operations 10913000 48 Income from discontinued operations 671000 49 Net income (loss) 11584000 50 Less: net loss (income) attributable to noncontrolling interes 51 Less: net income (loss) from continuing operations attributab 472000 52 Less: net income (loss) from discontinued operations attribu -58000 53 Net income attributable to The Walt Disney Company (Disne 11054000 54 Weighted average common & common equivalent shares ou 1656000 55 Weighted average common & common equivalent shares ou 1666000 56 Year end shares outstanding 1783000 57 Earnings (loss) per share from continuing operations - basic 6.3 58 Earnings (loss) per share from discontinued operations - bas 0.37 59 Net earnings (loss) per share - basic 6.68 60 Earnings (loss) per share from continuing operations - diluted 6.27 61 Earnings (loss) per share from discontinued operations - dilu 0.37 62 Net earnings (loss) per share - diluted 6.64 63 Dividends per share 1.76 64 Total number of employees 223000 65 Number of common stockholders 850000 66 Foreign currency translation adjustments -396000 67 Balance Sheet Income Statement Cash Flow 12598000 1499000 1507000 1488000 8980000 1568000 1578000 1517000 8.4 5.73 8.36 1.68 201000 854000 -289000 5.69 1.56 199000 871300 - 103000 + | ! 100% + - + 3:33 PM Type here to search O e 99 O J -_ AGO w 1 3/31/2020 E