'

Question 9 O pts In the 4th quarter of 2018, Dick's Sporting Goods has the highest ROE but one of the lowest profit margins. How is this possible? (1 pt) The firm has a high TATO The firm has high FATO The firm's ACP is high The firm's equity is high O Management expenses are low Question 13 O pts On Wednesday 2-Jan, Lowe's is removed from the index and replaced with Google. Calculate the new unbiased divisor. (1pt) a) Insert the variables into the appropriate formula. b) Solve for the divisor = Question 11 O pts Calculate the dollar value of a 149.76 decline in the Dow Jones Industrial Averages. Use the information in Table 4. (0.5pt) a) Write the formula needed b) Insert the appropriate variables into the formula and solve. Question 12 O pts Assume Lowe's, Dillard's, Exxon and Microsoft comprise all the firms in a price- weighted index. If the index value is 325.62, what is the divisor? (1 pt) a) Insert the variables into the appropriate formula. b) Solve for the divisor = Question 14 O pts Assume Lowe's, Dillard's, Exxon and Microsoft comprise all the firms in a value- weighted index. The beginning index value was 50 in 2000 and the divisor was 1,245,916,374 at that time and no changes have ever been made. Calculate the value-weighted index for Wednesday 2-Jan. (1pt) Question 15 O pts On Wednesday 2-Jan, Lowe's was removed and replaced with Google. Calculate the new divisor for the value-weighted index. (1pt) Share 4 AYO. Comments S Ceneral - Sort! Filter Ideas Sensitivity Find & Select L M N AutoSaveFF SUE PS#1Data(FIN3520) - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Verdana 11 A A = = = Wraa Text ansert Delete Peste 3 B IV H A E Merge & Center $ % , B Conditional Format cell Formatting as Table Styles Format X M18 xv fx C D E F G H I J K Table 1 FINANCIAL DATA 2 Information is relevant for the dose of trade on Today YTD 52-Week Symbol Close Chg Vol PE Wednesday 02-Jan-2019 High Low %Chg High Low 1. Google (end Q4 2018) GOOG 1181.69 1178.98 1181 3.43 5487488 33.48 5.38 1214.16 894.58 Year end 2018 31.98 2. Lowe's (end Q4 2018) LOW 46.89 42.1546.29 -2.67 6714273 22.04 -6.58 54.08 35.73 Year end 2018 32.57 3. Dick's Sporting Goods (end Q4 2018) DKS 56.12 5 2.24 | 52.5 -1.54 1739515 20.11 -9.64 | 67.49 23.92 Year end 2018 13.24 4. Dillard's (end Q4 2018) DDS 88.42 85.558 7.3 -0.98 576540 11.23 -10.19 9 3.33 48.91 Year end 2018 8.18 5. Exxon Mobil (end Q4 2018) 96.05 87.89 92.16 -3.03 16787758 14.93 -0.25 | 96.05 72.16 Year end 2018 12.04 6. Microsoft (end Q4 2018) MSFT 37.84 31.93 37.84 1.67 85553718 13.86 1.15 48.98 27.42 Year end 2018 12.45 16 For ease, assume the volume of trade is equal to the total number of shares outstanding, Profitability ROE PM 0.15501 0.0866 0.13114 0.078 0.16633 0.043 0.20176 0.0505 0.37699 0.0541 0.19162 0.0313 0.18596 0.0554 0.14695 0.0445 0.18425 0.086 0.15632 0.0972 0.35925 0.2817 0.32641 0.2619 Efficiency TATO 1.1911 1.1078 1.8734 1.9186 1.5795 1.3778 1.67 1.58 1.93 1.61 1.09 1.21 AutoSave OFF AA S PS#1Data(FIN3520) - Saved to my Mac OD General Wrap Text Insert Delete 470 T-24 - Sort & Find & X Filter Select Merge & Center $ % 8 9 Conditional Format Formatting as Table Cell Styles Format I J K L M N O P Q YTDI %Chg 5.38 52-Week High Low 1214.16 894.58 Home Insert Draw Page Layout Formulas Data Review View Verdana 11 A A = = = Paste Bruv va A z M18 x fx G H Table 1 Information is relevant for the close of trade on Vol? PE Wednesday 02-Jan-2019 1. Google (end Q4 2018) 487488 33.48 Year end 2018 31.98 2. Lowe's (end Q4 2018) '14273 22.04 Year end 2018 32.57 3. Dick's Sporting Goods (end Q4 2018) 39515 20.11 Year end 2018 13.24 4. Dillard's (end Q4 2018) 76540 11.23 Year end 2018 8.18 5. Exxon Mobil (end Q4 2018) 787758 14.93 Year end 2018 12.04 6. Microsoft (end Q4 2018) 553718 13.86 Year end 2018 12.45 ? For ease, assume the volume of trade is equal to th -6.58 54.08 35.73 -9.64 | 67.49 23.92 | Profitability ROE PM 0.15501 0.0866 0.13114 0.078 0.16633 0.043 0.20176 0.0505 0.37699 0.0541 0.19162 0.0313 0.18596 0.0554 0.14695 0.0445 0.18425 0.086 0.15632 0.0972 0.35925 0.2817 0.32641 0.2619 Efficiency | Leverage TATO EM 1.1911 1.5028 1.1078 1.5177 1.8734 2.0648 1.9186 2.0824 1.5795 4.4118 1.3778 4.4434 1.67 2.01 1.58 2.09 1.93 1.1101 1.61 0.9989 1.09 1.17 1.21 1.03 -10.1993.3348.91 -0.25 96.05 72.16 Year 1.15 48.98 27.42 3.89 AutoSave OFF ASSES PS#1Data(FIN3520) - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View 11 = = = dov General - A A A E ab Wrap Textv Merge & Center - $ v % e Paste A17 Verdana (Body) B I Uv fx A x E F G B C D Today is 2-Jan-2019 End of 4th Quarter 2018 Results Table 2 Nm Symbol Close Vol S*Q 50331942 1547159777 5 1. Dillard's (end Q4 2018) 6 2. Exxon Mobil (end Q4 2018) 3. Lowe's (end Q4 2018) 8 4. Microsoft (end Q4 2018) DDS 87.3 XOM 92.16 LOW 46.29 MSFT 37.84 Added Later GOOG 1180.97 576540 16787758 6714273 85553718 3237352689 N 0009 3. Google (end Q4 2018) 9 099 AutoSave OFF sv JE S = Review = = a View v Es alle Wrap Te Merge F G H Home Insert Draw Page Layout Formulas Data Verdana (Body) v 11 v A = Paste B I U v av A A10 x fx A B C D E 1 Table 3 T-BILL QUOTATIONS Maturity Bid Asked Asked Yld 3 1/4/19 1.015 1.005 -0.005 1.019 4 1/11/19 1.005 0.995 -0.025 1.009 1/18/19 1.09 1.08 -0.033 1.096 a 1/25/19 1.168 1.158 0.005 1.176 2/1/191.183 1.173 0.003 1.191 2/8/19 1.21 1.2 0.008 1.22 2/15/19 | 1.21 1.2 0.008 1.22 Chg AutoSave OFF A S SE- PS#1Data(FIN3520) Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View ) - Delete v Format Formatting as Table Styles Verdana 16 AA = = = Wrap Text General Paste BIUBA EE Merge & Center $ % A1 x fx Table 4 U.S. STOCK INDEXES F G H 1 Table 4 U.S. STOCK INDEXES DAILY Index Divisors High YTD % Low Close % Chg Chg DE I J K L M N O 52 WEEK Chg High Low 3-yr % Chg %Chg DJIA (30) DJ Mid Cap (20) 1.09 1.65 20.6 7.9 23837 19122 | 24.7 10038 8783.7 9. 1 3317 20:11 1,2 10.2 2 Composite Nasdaq 100 0.49 0.26 28.4 6912.4 5251.1 28.5 32.1 6422.6 4734.1 31.8 13 14 500 Index 100 Index Mid Cap 400 SmallCap 600 Dow Jones 0.145233969 23849.6 23617.1 23836.71 255.93 0.16463028 9757.65 9591.59 9754.03 158.8 Nasdaq Stock Market 6914.19 6866.21 6912.36 33.84 6426.04 6385.32 6422.56 16.59 Standard & Poor's 2627.69 2605.44 2627.04 25.62 1158.89 1149.08 1158.57 11.46 1880.52 1858.88 1880.26 24.15 | 938.13 923.16 937.77 | 15.59 New York Stock Exchange 12523.6 12409.6 12520.23 129.45 8025.68 7907.09 8020.67 112.2 14209.5 14102 14192.05 102.64 10848.6 10785.9 10834.66 91.71 Other U.S Indexes 1456.84 1442.94 1456.56 13.99 1536.63 1514.15 1536.43 23.12 1558.12 1542.98 1557.9 15.61 554.77 547.62 554.72 7.1 0.98 1.00 1.30 1.69 17.3 16.9 13.2 11.9 2627 2191.1 1158.6 966.28 1880.31623.3 937.77 808.59 19.2 19.2 15.3 15.1 8.3 8.1 9.2 11.5 Composite Financial Health Care Energy 1.04 1.42 0.73 0.85 13.2 15.2 19.2 -5.8 12520 10818 8020.76703.5 14364 | 11568 11770 9782.9 15.7 19.6 20.8 1.5 4.6 5.9 5.1 -5.1 Russell 1000 Russell 2000 Russell 3000 Value Line 0.97 1.53 1.01 1.30 17.3 13.2 17 9.6 1456.6 1216.1 1536.41313.8 1557.9 1303.1 554.72 496.6 19 8 .2 15.7 9.4 18.8 8.3 113.6 Table 1 Table Table 3 Table