man han Review Help HN 40 [Protected View - Excel (Unlicensed Product Home Insert Page Layout Formulas Data View Search FCTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing CRIPTION DUTRED Most of the features of Excel ve been drabied. Beactivate ITIONAL INFORMATION you need to make a quick edit before renewing your subscription, learn more about the Office Web Apps. Learn More X C D F G H ANSWERS 3 4 5 0 7 1 ROE is computed as A) Net income attributable to controlling interest/Average equity attributable to controlling interest B) Net income attributable to controlling interest/Net sales C) CRNOA (FLEV XSpread) x NC ratio D) A and B E] A and C 2 The 2016 balance sheet of E.I. du Pont de Nemours and Company shows average DuPont shareholders' equity attributable to controlling interest of $9,996 million, net operating profit after tax of $2,308 million, net income attributable to DuPont of $2,513 million, and common shares issued of 950.084 million Assume the company has no preferred shares issued. DuPont's return on equity (ROE) for the year is: A) 30.70% B] 37.60% 25.10% D] 36.4056 E) There is not enough information to calculate the ratio. 9 The 2017 balance sheet of Staples, Inc. shows total assets of $8,271 million, operating assets of $6,506 million, operating liabilities of $3,527 million, and shareholders' equity of $3,688 million A B) C] D) Staples' 2017 net operating assets are: $11,798 million S 6.566 million $ 4,74 million S 3,039 million Q3 Q4 DO NOT USE or delete a Type here to search o 9:06 PM V17/2020 han Home Hwan (Protected view) - Excel (Unlicensed Product) Insert Page Layout Formes Data Review View Help Search PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's ale to stay in Protected View Enable Editing i SUBSCRIPTION EXPIRED Most of the fears of ecel have been dinabled Beactivate ADDITIONAL INFORMATION you need to make a quick edit before renewing your subscription, learn more about the Office Web Apps Learn More 31 M N E G H 3 The 2017 balance sheet of Staples, Inc. shows total assets of $8,271 million, operating assets of $6,566 million, operating liabilities of $3,527 million, and shareholders' equity of $1,68 million Staples' 2017 net operating assets are: A) $11.798 million B) $ 6,506 million C) S4.M4 million D] $ 3,039 million E) None of the above 4 Mattel Inc.'s 2016 financial statements show operating profit before interest and tax of 5519,233 thousand, net income of $118,022 thousand, provision for income taxes of $91,720 thousand and net nonoperating expense before tax of $109,491 thousand Assume Matter's statutory tax rate for 2016 1 37%, Mattel's 2016 tax shield is A) $ 61,979 thousand B) s 40,512 thousand s 277,510 thousand S 186.460 thousand None of the above 5 The 2016 financial statements of The New York Times Company reveal average shareholders' equity attributable to controlling interest of $837.283 thousand, net operating profit after tax of $48,032 thousand, net income attributable to The New York Times Company of $29,068 thousand, and average net operating assets of $154,414 thousand. A) The company's return on net operating assets (RNOA) for the year is! 3.50% Q2 a 04 DO NOT USE or delete 01 dy 207 PM 9/17/2020 Type here to search 0 Help Enable Editing File Home Indient Formulas Page Layout Data wie See O seuch PROTECTED VIIW Be careful lestrom the Internet can contains. Unless you need to edit it's safe to stay in Protected View i SUSCEPTION EXPLOD Most of the areas of Excel have been dnabled Reactivate ADDITIONAL INFORMATION Iyou need to make a quick edit before renewing your subscription, learn more about the Office Web Apps Learn More 81 X N D M 3 The 2016 financial statements of The New York Times Company reveal average shareholders' equity attributable to controlling interest of $837,283 thousand, net operating profit after tax 36 of $48,032 thousand, net income attributable to The New York Times Company of $29,068 thousand, and average net operating assets of $154,414 thousand. 38 The company's return on net operating assets (RNOA) for the year is: 39 A) 3.50% 400 6.SON 410) 11.60 DI 18.70% 43E There is not enough information to calculate the ratio 4 45 The fiscal 2016 financial statements of Nike Inc. shows net operating profit margin (OPM) of 11.4%, net operating asset turnover (NOAT) of 2.83, return on equity of 30.1%, and adjusted return on assets of 17.1% 46 47 What is the company's nonoperating return? 48 A) 498) 18.70% 14:50 51 Dj 3540% 52 There is not enough information to calculate the ratio. 53 54 The fiscal year-end 2016 financial statements for Walt Disney Co, report revenues of $55,632 million, net operating profit after tax of $9,954 million, 55 net operating assets of $58,603 million. The fiscal year end 2015 balance sheet reports net operating assets of $59,079 million Walt Disney's 2016 net operating profit margin is: 57 A) 16,90% inihan HN 4D Protected Vienl Excel (Unlicensed Product) File Home Insert Page Layout Formulas Reviews View Help PROTECTED VIIW Be carnetul-files from the Internet can contain viruses. Unless you need to edit, it's soles to stay in Protected View Enable Editing SUBSCRIPTION EXPIRED Most of the features of Excel have been ADDITIONAL INFORMATION #you need to make a quick edit before renewing your subscription, learn more about the Office Web Apps. Learn More B1 f D N G H 1 The fiscal 2016 financial statements of Nike Inc. shows net operating profit margin (NOPM) of 11.4%, net operating asset turnover (NOAT) of 3.83, return on equity of 30.1%, and adjusted return on assets of 17.1% 35 7 What is the company's nonoperating return? BA) 11.60 9) 18.70% c) 14.50N 1D) 35.AN There is not enough information to calculate the ratio. The fiscal -end 2016 financial statements for Walt Disney Co. report revenues of $55,632 million, net operating profit after tax of $9,954 million, net operating assets of $58,603 million. The fiscal year-end 2015 balance sheet reports net operating assets of $99,079 million Walt Disney's 2016 net operating profit marginis A) 16.90% 12.50 C) 12.SON D) 11.01 0 There is not enough information to calculate the ratio. Kroger's 2016 financial statements show net operating profit after tax of $2,286 million, net income of $1,975 million, sales of $115, 117 million, and average net operating assets of $13,616 million Kroger's net operating asset turnover for the year is: 12.30 A) B) 6,2 01 Q2 03 04 DO NOT USE or delete ady di 9:08 PM 9/17/2020 Type here to search 0 i SUBSCRIPTION EXPIRED Most of the features of Excel have been dnabled Reactivate ADDITIONAL INFORMATION If you need to make a quick edit before renewing your subscription, learn more about the Office Web Apps. Learn More BI X G B D F H 1 M 6 Walt Disney's 2016 net operating profit margin is: 7 A) 16.9 68 B) 12.50% 9 C) 17. 0 D) 11.70% $1 E) There is not enough information to calculate the ratio. 2 Kroger's 2016 financial statements show net operating profit after tax of $2,286 million, net income of $1,975 million, sales of $115,337 million, and average net operating assets of $18,616 million 3 Kroger's net operating asset turnover for the year is: 5 A) 12.30X 36 B) 8.11 710) 6.2 810) 10.90% 19 ) There is not enough information to calculate the ratio 10 1 The fiscal 2016 financial statements of Nike Inc. shows average net operating assets (NOA) of $8,450 million, average net nonoperating obligations (NNO) 22 of 544,003) million, average total liabilities of $9,014 million, and average equity of $12,483 million 3 The company's 2016 financial leverage (FLEV) is: 14A) -0.477 750) -0.559 260) -0.323 77 D) -0,447 18 E) There is not enough information to determine the ratio. 01 Q2 03 04 DO NOT USE or delete Type here to search 0 0 B D H 1 Selected balance sheet and income statement data follow for The New York Times Company for fiscal 2016 (in thousands). Use the data to calculate the following: 2 3 a. Return on equity (ROE) 4 b. Return on net operating assets (RNOA) 5 c. Return on nonoperating assets 5 7 2016 2016 2016 2015 2016 2015 Battributable to New York Times common stockholders Net Net NOPAT operating operating Common Common 0 assets assets equity equity 1 $29,068 $48,032 $353,696 $355,132 $847,815 $826,751 2 4.3 5 6 b 7 1 2 B Q1 02 Q3 Q4 DO NOT USE or delete eady imran khan HIWACV Protected View Excel Unlicensed Product File Home Incert Page Layout Formulas Data Review View Help Search PROTECTED VIEW Becmetu-flestrom the Internet can contain vies. Unless you need to edit, it's safe to stay in Protected View Enable Iditing SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled ADDITIONAL INFORMATION #you need to make a quick edit before renewing your subscription, learn more about the Office Web Apps Learn More X 19 [19.,"center value",IF19-DO NOT USE or delete'1A"Correct", "Try again!") M D H N E Snap On Incorporated Comodated Statements of Earrings REQUIRED: Foral and 1. Round to one del place Force the and Round to one decimal place Compute met operating profit after tax (NOPAT) for 2016 and 2015. Assume that combined federal and 2016 taxi 2015 tax interval 2016 tax on operating pro 2015 taxon operating profil center vale (Aments in mins) For the fiscal year ended 7 2016 2015 3 Net sales $3.430.40 53.35230 Cost of goods sold - 1,720.30 1,704.50 10 Gross proti 1,709 60 164630 Operating expenses - 105410 - 1,051 20 12 Operating earnings before financial services 6555 5946 13 4 Financial services revenue 2814 2403 15 Financial services expenses -827 -701 16 Operating income from financial services 1982 1702 7 Operating cartines 8542 7648 16 Interest expense 19 Earnings before income taxes 9064 816.7 20 Income tax expense -2443 2212 21 Netamine 6621 595.5 22 23 24 Snap On Incorporated 25 Consolidated Balance Sheets 92 04 DO NOT USE or delete -519 2016 NOPAT Center vake 2015 NOPAT ar va Compute net operating assets (NOA) for 2016 and 2015 2016 NOA Center value 2015 NOA Computertarson net operating si CRNOA) for 2016, 2016RNOA + 100 9:10 PM 9/17/20 AD Type here to search Page Layout Formulas Data Review View Help Search Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing ED Most of the features of Excel have been disabled Reactivate LATION Il you need to make a quick edit before renewing your subscription, learn more about the Office Web Apps. Learn More IF(19","center value",IF(19='DO NOT USE or delete'A6, "Correct", "Try again!")) M N 0 K P R Q U S G F H REQUIRED: For a) and b). Round to one decimal place. For c), use the sign and Round to one decimal place Compute net operating profit after tax (NOPAT) for 2016 and 2015. Assume that combined federal and state statutory tax rates are 37% for fiscal 2016 and 2015. 2016 tax shield Center value 2015 tax shield x D E F G H 20) 186,460 thousand M 36) N None of the above 4 The 2016 financial statements of The New York Times Company reveal average shareholders' equity attributable to controlling interest of $37,283 thousand, net operating profit after tar 6 of $48,032 thousand, net income attributable to The New York Times Company of $29,068 thousand, and average net operating assets of $154,414 thousand -7 The company's return on net operating assets (AOA) for the year ist 99 A 3.58 200) 6.90 11 13.50% 120) 18.70% 10) There is not enough information to calculate the ratio 14 * The fiscal 2016 financial statements of Nike Inc. shows net operating profit margin (NOM) of 11AN, net operating asset turnover (NOAT) of 1.8, return on equity of 30.11, and adjusted return on assets of 17.IN. 16 17 What is the company's monoperating return? 18 A) - 13.00 19 ) 11 0 -14.50% 510) 35.40 52 E) There is not enough information to calculate the ratio. 54 The fiscal year end 2016 financial statements for Walt Disney Co. report revenues of $55,632 million, net operating profit after tax of $9.954 min Q2 03 DO NOT USE or deste Red Type here to search RADO 5:33 PM V11/2020 sanat SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled Reactivate ADDITIONAL INFORMATION Iyou need to make a quick edit before renewing your subscription, learn more about the Office Web Apps Learn More B1 H M N B C D G 53 54 The fiscal year-end 2016 financial statements for Walt Disney Co. report revenues of $55,632 million, net operating profit after tax of $9,954 million, 55 net operating assets of $58,603 million. The fiscal year-end 2015 balance sheet reports net operating assets of $59,079 million. 56 Walt Disney's 2016 net operating profit margin is: (57 A) 16,90% 58 B) 12.50% 59 C) 17.90% 600) 11.01 61 E) There is not enough information to calculate the ratio. 62 Kroger's 2016 financial statements show net operating profit after tax of $2,256 million, net income of $1,975 million, sales of $115,337 million, and average net operating assets of $18,616 million 63 Kroger's net operating asset turnover for the year is: 65 A) 12.30% 66 B) 8.11 67 C) 6.2 68 ) 10.50 090) There is not enough information to calculate the ratio, 20 71 The fiscal 2016 financial statements of Nike Inc. shows average net operating assets (NOA) of $1,450 million average net nonoperating obligations (NNO) 72 of 14,033) million, average total liabilities of 59,014 million, and average equity of $12,481 million The company's 2016 financial leverage (FLEV) 1: 74 A -0.477 75 B) -0.559 02 03 04 DO NOT USE or delete Ready I O Type here to search H B D E K ) 11.70% E) There is not enough information to calculate the ratio. Kroger's 2016 financial statements show net operating profit after tax of $2,286 million, net income of $1,975 million, sales of $115,337 million, and average net Kroger's net operating asset turnover for the year is: A) 12.30% B) 8.11 C) 6.2 D) 10.90% E) There is not enough information to calculate the ratio. The fiscal 2016 financial statements of Nike Inc. shows average net operating assets (NOA) of $8,450 million, average net nonoperating obligations (NNO) of $(4,033) million, average total liabilities of $9,014 million, and average equity of $12,483 million The company's 2016 financial leverage (FLEV) is: A) -0.477 5 B) -0.559 5 C) -0.323 7 D) -0.447 8 E) There is not enough information to determine the ratio. 9 30 31 B2 01 Q2 03 04 DO NOT USE or delete Ready Type here to search 0 HW & Protected View Bocel (Unlicensed Product Home Insert Page Layout Formulas Review View Help Search PROTECTED VIEW Be careful-files from the Internet con contain viruses. Unless you need to edit, it's safe to stay in Protected View og SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled Beactivate ADDITIONAL INFORMATION you need to make a quick edit before rewing your subscription, com more about the Office Web Apps Learn More fo c. Return on nonoperating assets AS A B 1 D Selected balance sheet and income statement data follow for The New York Times Company for fiscal 2016 (in thousands). Use the data to calculate the following 2 3 a. Return on equity (ROE) 4 b. Retium on net operating assets (RNOA) 5 c. Retum on nonoperating assets 6 7 2016 2016 2016 2015 2016 2015 8 attributable to New York Times common stockholders Net 9 NOPAT operating operating Common Common 10 assets assets equity couty $29,068 548032 $353,696 $365,132 5347 015 5826.751 12 14 15 16b 18 19 21 22 23 02 QI 04 DO NOT USE ordet Ready 5 O Type here to search REQUIRED: For a) and b), Round to one decimal place For c) use the % sign and Round to one decimal place Compute net operating profit after tax (NOPAT) for 2016 and 2015. Assume that combined federal and state statutory tax rates are 37% for fiscal 2016 and 2015. 2016 tax shield fx =IF(19.""," x D E F G H 20) 186,460 thousand M 36) N None of the above 4 The 2016 financial statements of The New York Times Company reveal average shareholders' equity attributable to controlling interest of $37,283 thousand, net operating profit after tar 6 of $48,032 thousand, net income attributable to The New York Times Company of $29,068 thousand, and average net operating assets of $154,414 thousand -7 The company's return on net operating assets (AOA) for the year ist 99 A 3.58 200) 6.90 11 13.50% 120) 18.70% 10) There is not enough information to calculate the ratio 14 * The fiscal 2016 financial statements of Nike Inc. shows net operating profit margin (NOM) of 11AN, net operating asset turnover (NOAT) of 1.8, return on equity of 30.11, and adjusted return on assets of 17.IN. 16 17 What is the company's monoperating return? 18 A) - 13.00 19 ) 11 0 -14.50% 510) 35.40 52 E) There is not enough information to calculate the ratio. 54 The fiscal year end 2016 financial statements for Walt Disney Co. report revenues of $55,632 million, net operating profit after tax of $9.954 min Q2 03 DO NOT USE or deste Red Type here to search RADO 5:33 PM V11/2020 sanat SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled Reactivate ADDITIONAL INFORMATION Iyou need to make a quick edit before renewing your subscription, learn more about the Office Web Apps Learn More B1 H M N B C D G 53 54 The fiscal year-end 2016 financial statements for Walt Disney Co. report revenues of $55,632 million, net operating profit after tax of $9,954 million, 55 net operating assets of $58,603 million. The fiscal year-end 2015 balance sheet reports net operating assets of $59,079 million. 56 Walt Disney's 2016 net operating profit margin is: (57 A) 16,90% 58 B) 12.50% 59 C) 17.90% 600) 11.01 61 E) There is not enough information to calculate the ratio. 62 Kroger's 2016 financial statements show net operating profit after tax of $2,256 million, net income of $1,975 million, sales of $115,337 million, and average net operating assets of $18,616 million 63 Kroger's net operating asset turnover for the year is: 65 A) 12.30% 66 B) 8.11 67 C) 6.2 68 ) 10.50 090) There is not enough information to calculate the ratio, 20 71 The fiscal 2016 financial statements of Nike Inc. shows average net operating assets (NOA) of $1,450 million average net nonoperating obligations (NNO) 72 of 14,033) million, average total liabilities of 59,014 million, and average equity of $12,481 million The company's 2016 financial leverage (FLEV) 1: 74 A -0.477 75 B) -0.559 02 03 04 DO NOT USE or delete Ready I O Type here to search H B D E K ) 11.70% E) There is not enough information to calculate the ratio. Kroger's 2016 financial statements show net operating profit after tax of $2,286 million, net income of $1,975 million, sales of $115,337 million, and average net Kroger's net operating asset turnover for the year is: A) 12.30% B) 8.11 C) 6.2 D) 10.90% E) There is not enough information to calculate the ratio. The fiscal 2016 financial statements of Nike Inc. shows average net operating assets (NOA) of $8,450 million, average net nonoperating obligations (NNO) of $(4,033) million, average total liabilities of $9,014 million, and average equity of $12,483 million The company's 2016 financial leverage (FLEV) is: A) -0.477 5 B) -0.559 5 C) -0.323 7 D) -0.447 8 E) There is not enough information to determine the ratio. 9 30 31 B2 01 Q2 03 04 DO NOT USE or delete Ready Type here to search 0 HW & Protected View Bocel (Unlicensed Product Home Insert Page Layout Formulas Review View Help Search PROTECTED VIEW Be careful-files from the Internet con contain viruses. Unless you need to edit, it's safe to stay in Protected View og SUBSCRIPTION EXPIRED Most of the features of Excel have been disabled Beactivate ADDITIONAL INFORMATION you need to make a quick edit before rewing your subscription, com more about the Office Web Apps Learn More fo c. Return on nonoperating assets AS A B 1 D Selected balance sheet and income statement data follow for The New York Times Company for fiscal 2016 (in thousands). Use the data to calculate the following 2 3 a. Return on equity (ROE) 4 b. Retium on net operating assets (RNOA) 5 c. Retum on nonoperating assets 6 7 2016 2016 2016 2015 2016 2015 8 attributable to New York Times common stockholders Net 9 NOPAT operating operating Common Common 10 assets assets equity couty $29,068 548032 $353,696 $365,132 5347 015 5826.751 12 14 15 16b 18 19 21 22 23 02 QI 04 DO NOT USE ordet Ready 5 O Type here to search REQUIRED: For a) and b), Round to one decimal place For c) use the % sign and Round to one decimal place Compute net operating profit after tax (NOPAT) for 2016 and 2015. Assume that combined federal and state statutory tax rates are 37% for fiscal 2016 and 2015. 2016 tax shield fx =IF(19."","