EXCEL FORMULAS

Explanation:Question 1Risk FreeMarket premiumBetaBeta’Market premium3.00%6 00%%0.93.0543% Risk Free rate8400% CAPM cost of Equity#2D12.38IPO138.7D1/PO0.017159337DCF Cost of Equity7.017159337Bond rate premiumCost of Equity4%%Calculate weightsShort term borrowings600.7Current portion of longterm debt97.7Long term Borrowing3625.8Market Capital equityTotal CapitalTotal debt1324.21842022744.2Weights0.19010.8099Debt Interest Rate4%Tax Rate27.50%After Tax Cost of debt2.98.4% Cost of equityDebt TermEquity TermWADC0.55146.802977.35432

Don't use plagiarized sources. Get Your Custom Essay on
EXCEL FORMULAS
Just from $13/Page
Order Essay
Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Order your assignment today!
Ace that class.

Order your paper
Live Chat+1(978) 822-0999EmailWhatsApp