Can you please explain this question a-d? Best if it is in excel and the solutions are explained so I can learn how to solve this. Thanks!

4. A corporation's securities have the following betas and market values: Beta Market Value ($) Debt 0.1 100,000 Preferred 0.4 200,000 Common 1.5 100,000 Calculate the following figures given a riskless interest rate of 10% and market risk pre- mium of 5%: a. Discount rates for each security. b. The asset beta for the corporation. c. The weighted average cost of capital. d. The discount rate for the unlevered assets