Complete the formula in C6 that will return the intrinsic value of the constant growth stock. Use cell addresses instead of numbers. *(1+ >>( 2 56849 SAWN 101 B Last Dividend Growth Rate Required Return Value C $ 2.00 5% 9% ? D Which formula in C10 calculates the current yield of the bond? A C C 1 23456 7 8 9 10 11 B Bond Valuation Settlement Date 2/15/2018 Maturity Date 2/15/2033 Coupon Rate Required Return Face Value Frequency Basis Current Yield 8% 9% 1000 2 02 0 ? O=(C5*C7)/(PRICE (C3,C4,C5, C6, C7/C7*100,C8,C9)*C7) O=C5*C7/PRICE (C3,C4,C5,C6,C7/C7*100, C8,C9)/100*C7 O=(C5*C7)/(PRICE(C3,C4,C5,C6, C7/C7*100, C8,C9)/100*C7) O=C5*C7/PRICE(C3,C4,C5,C6, C7/C7/100, C8,C9) Suppose that you calculate the future value of $1,500 invested at 12% annually after 5 years with continuous compounding? Which formula in B6 is correct? 1 2 3 Present Value 4 Annual Rate Years: FV 5 6 7 a OB3'EXP(B4*B5) OB4'EXP(B3*B5) OB3*EXP(84+B5) OB5EXP(83*B4) B 1,500 12% 5