I need help with these five questions

I need the best fiance tutor

B D E F G H 4 Question 1 5 What is the formula on cell B12 that will allow you to calculate the total stock return from Jan 2017 to June 2017? B C D E F G 10 Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 11 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 12 Total Return ? 6 7 8 9 a) =B11-G11/G11 b) =B11-(G11/G11) c) =B11/G11-G11/B11 d) =B11/G11-1 e) =(B11/G11-G11)/B11 10 11 12 14 Ticker 15 ORCL 16 CAGR B C D E F G 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 50.14 45.39 44.96 44.61 42.59 40.11 ? 13 Question 2 14 What is the formula in cell B16 that will allow you to calculate the compound annual 15 growth rate from Jan 2017 to June 2017? 16 a) =(B15/61541/4)-1 17 b) =B15/G1541/4-1 18 c) =(B15/G15) (1/5)-1 19 d) =(B15/( G1541/4))-1 20 e) =(B15/G15) (1/4)+1 21 22 Question 3 23 What formula in cell B21 will allow you to calculate the average annual stock return ng the GEOMEAN function from Jan 24 2017 to June 2017? 25 a) =GEOMEAN(B19:F19) 26 b) GEOMEAN(B20:F20)-1 27 c) GEOMEAN(B20:F20) 28 d) =GEOMEAN(B19:F19)-1 29 e) GEOMEAN(B20:F20)+1 E A B C D F G 18 Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 19 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 20 Relative Return 110.46% 100.96% 100.78% 104.74% 106.18% 21 Geometric Mean ? F 6 13 Question 2 14 What is the formula in cell B16 that will A B C D F allow you to calculate the compound annual 14 Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 15 growth rate from Jan 2017 to June 2017? 15 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 16 a) =(B15/G1541/4)-1 16 CAGR ? 17 b) =B15/G1541/4-1 18 c) =(B15/15) (1/5)-1 19 d) =(B15/(G1541/4))-1 20 e) =(B15/G15) (1/4)+1 21 22 Question 3 23 What formula in cell B21 will allow you to A D E 18 Ticker calculate the average annual stock return 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 19 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 using the GEOMEAN function from Jan 20 Relative Return 110.46% 100.96% 100.78% 104.74% 106.18% 24 2017 to June 2017? 21 Geometric Mean 25 a) GEOMEAN(B19:F19) 26 =GEOMEAN(B20:F20)-1 27 c) GEOMEAN(B20:F20) 28 d GEOMEAN(B19:F19)-1 29 e) GEOMEAN(B20:F20)+1 30 31 Question 4 32 What formula in cell B26 will allow you to B D E F G calculate the arithmetic mean stock return 23 Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 33 from Jan 2017 to June 2017? 24 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 34 a) =SUM(B25:F25)/5 25 Relative Return 10.46% 0.96% 0.78% 4.74% 6.18% 35 b) =(B25+C25+D25+E25+F25)/5 26 Average Return ? 36 c) =AVERAGE(B25:F25) 37 d) None of the above 38 e) a, b, and c 39 40 Question 5 41 Tiny charts that are intended to be presented as a "word in a line of text or next to data 42 in a table are called: 43 a) Embedded charts 44 b) Column charts 45 c) Scatter charts 46 d) Sparkline charts 47 e) Pie charts 48 A 14 Ticker 15 ORCL 16 CAGR B C. D E F G 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 50.14 45.39 44.96 44.61 42.59 40.11 ? 18 Ticker 19 ORCL 20 Relative Return 21 Geometric Mean B C D F G 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 50.14 45.39 44.96 44.61 42.59 40.11 110.46% 100.96% 100.78% 104.74% 106.18% ? 13 Question 2 14 What is the formula in cell B16 that will allow you to calculate the compound annual 15 growth rate from Jan 2017 to June 2017? 16 a) =(B15/ 615^1/4)-1 17 b) =B15/G1541/4-1 18 c) =(B15/615) (1/5)-1 19 d) =(B15/(G1541/4))-1 20 e) =(B15/G15) (1/4)+1 21 22 Question 3 23 What formula in cell B21 will allow you to calculate the average annual stock return using the GEOMEAN function from Jan 24 2017 to June 2017? 25 a) GEOMEAN(B19:F19) 26 b) GEOMEAN(B20:F20)-1 27 c) GEOMEAN(B20:F20) 28 d) GEOMEAN(B19:F19)-1 29 e) GEOMEAN(B20:F20)+1 30 31 Question 4 32 What formula in cell B26 will allow you to calculate the arithmetic mean stock return 33 from Jan 2017 to June 2017? 34 a) SUMB25:F25)/5 35 b) =(B25+C25+D25+E25+F25)/5 36 c) =AVERAGE(B25:F25) 37 d) None of the above 38 e) a, b, and c 39 A 23 Ticker 24 ORCL 25 Relative Return 26 Average Return B D E F G 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 50.14 45.39 44.96 44.61 42.59 40.11 10.46% 0.96% 0.78% 4.74% 6.18% 7 4 Question 1 5 What is the formula on cell B12 that will allow you to calculate the total stock return from Jan 2017 to June 2017? A B INC C D E F. 6 10 Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 11 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 12 Total Return ? 6 7 8 LO 9 =B11-G11/G11 b) =B11-(G11/G11) c) =B11/G11-G11/B11 d) =B11/G11-1 e) =(B11/G11-G11)/B11 10 11 12 14 Ticker 13 Question 2 14 What is the formula in cell B16 that will allow you to calculate the compound annual 15 growth rate from Jan 2017 to June 2017? 16 a) =(B15/615^1/4)-1 17 b) B15/G15^1/4-1 18 c) =(B15/G15)^(1/5)-1 19 d) =(B15/(G15^1/4))-1 e) =(B15/615)^(1/4)+1 21 B C E F G 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 50.14 45.39 44.96 44.61 42.59 40.11 15 ORCL 16 CAGR 20