Question

Assume the risk free rate is 0.0%. The SP500 is considered the market. Six years of annual returns are provided in the table below. Use this information to help answer questions 21-22 SP500 Stock A Stock B 2013 80% 64% 4.8% 2014 4.0% 3.2% 2.4% 1 Year Returns 2015 400% 32.0% 24.0% 2016 15.0% 12.0% 9.0% 2017 200% 16.0% 12.0% 2018 12.0% 9.6% 7.2% 21. Which of the following statements is most likely FALSE: a. The SP500 index has a higher beta than Stock B b. The SP500 index has a higher beta than Stock A c. Stock A has a higher beta than Stock B d. Stock A index has a beta of 0.80 e. The SP500 index has a beta of 1.20 22. Over the past six years, which of the following statements is most likely TRUE: a. The SP500 index has the highest arithmetic average return, but the lowest geometric return b. The SP500 index has the highest arithmetic average return, while Stock A has the lowest geometric return c. The SP500 index has the highest arithmetic average return, while Stock B has the lowest geometric return d. The SP500 index has the lowest geometric average return, while Stock B has the highest arithmetic return e. The SP500 index has the lowest geometric average return, while Stock A has the highest arithmetic return Use the following information about to help answer problems 23-24 TIME 0 5 CFs $ 2,200.00 <?$ 3,279.58 Next Year (T1), you will deposit $2,200.00 in a savings account Over the short term, you will increase the amount you deposit each year by a constant growth rate so that at the end of year 5 T-5) you will make a deposit of $3,279.58 You will make no deposits beyond the $3,279.58 at the end of year 5 (T 5) You earn a rate of return of 12.0% on your savings every year 23. The deposit you will make at the end of year 4 (T-4) is closest to: a. $2,968 b. $3,091 c. $3,346 d. $3,462 e. $3,848 24. The future value of your savings account at the end of year 6 (T6) is closest to a. $13,565 b. $17,790 c. $18,121 d. $19,120 e. $20,459

0 0
Add a comment Improve this question Transcribed image text
Answer #1

21.

Beta is price sensitivity of an assets due to change in market. Thus, Beta of Market always equals to 1 as correlation between market to market is 1.

Option-e is the Answer

The SP500 index has beta of 1.20 is a false statement.

22.

Option-a is Correct.

The SP500 index has the highest arithmetic average, but the lowest geometric average.

Please refer to below spreadsheet for calculation of Beta , arithmetic average and geometric average.

121 2 (21&22) 2013 2014 2015 2016 2017 2018 Arithmetic Average Beta SP500 StockA StockB 0.08 0.06 0.05 0.04 0.03 0.02 0.40 0.32 0.24 0.15 0.12 0.09 0.20 0.16 0.12 0.12 0.10 0.07 1.00 0.80 1.00 4 53% 1.90% For Geometric Average, add 1 to each return to avoid negative, later minus the 1. 2015 2013 2014 2016 2017 2018Geometric Average 6818% 1.026 1.0925% 10 SP500 StockA StockB 1.08 1.06 1.05 1.04 1.03 1.02 0.60 0.68 0.76 1.15 1.12 1.09 1.20 1.16 1.12 1.12 1.10 1.07 12

Formula reference -

H22 2 (21&22) 2013 2014 2015 0.4 0.32 2016 0.15 0.12 0.09 2017 0.2 0.16 0.12 2018 0.12 0.096 0.072 Arithmetic Average UM(C3:H3)/6 UM(C4:H4)/6 MICS:H5)/6 Beta SP500 0.080.04 StockA |0.064 |0.032 StockB 0.0480.024 0.24 ISTDEV S(C3:H3)CORREL(C3:H3,C3:H3)/STDEV S(C3:H3 STDEV.S(C4:H4) CORREL(C3:H3,C4:H4))/STDEV.S(C3:H3) For Geometric Av add 1 to each return to avoid negative, later minus the 1. 2013 2014 2015 2016 2017 2018 Geometric Average EOMEAN(C10:H10)-1 EOMEAN(C11:H11)-1 (C12:H12)-1 10 SP5001+C3 1+D3 1+E3 1+E4 1+E5 1+F3 1+F4 1+F5 1+G3 1+H3 12

23.

Option - a is correct i.e $ 2,968

24.

Option-c is correct i.e $ 18,121

Please find below spreadsheet for calculation of (23). Deposit make at the end of year -4 and (24). Future value of saving account at the end of 6th year.

Formula reference -

E25 14 Deposit | Deposit value at beginning of year | Annual Return at 12% Accumulated Return | Account balance at the end of year (23&24) Time | Deposit | 15 16 17 18 19 20 E16 0.12 E17*0.12 E18 0.12 E19*0.12 E20 0.12 E21 0.12 -E22*0.12 -G16+F17 -G17+F18 -G18+F19 -G19+F20 -G20+F21 G21+F22 -E16+G16 -E17+G17 E18+G18 E19+G19 -E20+G20 E21+G21 E22+G22 2200 2200 0 D17 (1+SE$25)D17 -D18 (1+SE$25) E18+D18 D19* (1+SE$25) E19+D19 3279.58 D20 (1+SE$25) -E20+D20 E21+D21 23 24 25 26 27 Constant Growth rate Rate of Return (C21/C17)A(1/4)-1 0.12

Add a comment
Know the answer?
Add Answer to:
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT