please do it in excel and show the calculation in details **digits of id number 20** Haval Limited can borrow at an annu

[answerhappygod]

please do it in excel and show the calculation in details
**digits of id number 20**
Haval Limited can borrow at an annual interest rate of 11%
compounded semiannually with a
compensating balance requirement of 4%. It can issue 13% Taka 100
preferred stock at Taka (100
+ Last two digits of your ID Number) where floatation cost is 8%.
The risk free rate is 4.5% and
the market return is 15%. The firm’s beta is 1.12. Tax rate is
30%.
Expected Capital Components and their mix:
Common Equity Taka 2000 million
a. Estimate the cost of debt, cost of preferred stock and cost of
retained earnings.
b. Estimate the WACC.