Question

please answer all questions

Question 3 (10 points) If the return on stock A in year 1 was 16 %, in year 2 was 18 %, in year 3 was -3% and in year 4 was 18 %, what was the standard deviation of returns for stock A over this four year period? (Round your answer to 1 decimal place and record without a percent sign. If your final answer is negative, place a minus sign before the number with no space between the sign and the number). Your Answer: Answer Question 4 (10 points) The value of any security to the investor is the of all the __ future cash flows from owning the security discounted at the appropriate discount rate, or rate of return future value: historical: average present value; expected: historical present value: expected: required present value: historical: required future value; expected: average

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

STATS -Microsoft Excel (Product Activation Failed) Review File Home Insert Page Layout Formulas Data View Add-Ins E AutoSum - Cut A A Wrap Text Calibri 11 General E Copy Fill B IU Merge & Center Paste $ % , +.0 .00 Conditional Format Cell Insert Delete Format Sort & Find & Filter Select .00 0 Format Painter Clear Formatting as Table Styles Number Editing Clipboard Font Alignment Styles Cells fx JS356 JO JO JP JR JS JT JU JV JW JX JY JZ KA KB 337 A-E(A) (A-E(A))A2 338 Q.3 YEAR STOCK A 339 1 16 15.25 232.5625 340 2 18 17.25 297.5625 341 3 -3 -3.75 14.0625 342 4 18 17.25 297.5625 343 -0.75 0.5625 TOTAL RETURN = 344 49 12.25 [49/4] 842.31 345 AVERAGE RETURN = E(A) (A-E(A)^2 346 347 SAMPLE STANDARD DEVIATION= 10.2103 SQRT (2(A-E(A))^2/n-1) SQRT(842.31/3) 348 349 SAMPLE STANDARD DEVIATION 10.2 [rounded to 1 decimal] 350 ANSWER 351 352 Q.4 353 2ND OPTION PRESENT VALUE EXPECTED REQUIRED 354 355 356 357 EMV MEAN STDV assignment TREND freq HYPOTHI Sheet2 COV INTERVAL, NORMAL PV FV DIVIDEND DEAR TIME SERIES corr REGRESSION MATRIX range CAMERA Rea erences 120% WA 05:20 #ENG 31-10-2019