a)

b)

c)

please use excel and elaborate which formula you used and how you plugged it in to get your answer. thanks in advance!

You are estimating the correct rate for a small company's bond with a maturity of 20 years. You estimate the real risk-free rate is 0.5%, the maturity risk premium on a 20 year bond is 2.2%, and the expected average inflation over the 20 years is 1.9%. You estimate the company's default risk premium is 2.2% and due to the expected infrequent trading the liquidity risk premium for the bond is 0.4%. What is the expected rate on the bond? Express in DECIMALS, not %, so 5.22% should be.0522.. Sneech Inc. has total assets of 10,761. On Sneech's Income statement Operating profits are 1,076, Net Income is 638 and Revenues are 4,822. What is Sneech's Total Asset Turnover? (As always, report your answer in 4 decimal places. Spider Corp has a beta of 1.3. The risk-free rate is 1.9% and the market risk premium is 4.4%.(Note market risk premium is rm- rf) What is the required return on Spider's stock according to the CAPM? (Express in decimals up to four places example .0576)