Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone please explain how (what formulas to use) to get the yellow and green cells based on the included data? The yellow cells are
Can someone please explain how (what formulas to use) to get the yellow and green cells based on the included data? The yellow cells are what I need to input, and the green cells I need to calculate. Thank you!
Coleman Technologies Inc. Cost of Capital Coleman Technologies is considering a major expansion program that has been proposed by the company's information technology group. Before proceeding with the expansion, the company must estimate its cost of capital. You are an assistant to Jerry Lehman, the financial vice president. Your first task is to estimate Coleman's cost of capital. Lehman has provided you with the following data, which he believes may be relevant to your task. You have been provided the following information: The firm's tax rate is 25%. The current price of Coleman's 12% coupon, semiannual payment, noncallable bonds with 15 years remaining to maturity is $1,153.72. Coleman does not use short-term, interest-bearing debt on a permanent basis. New bonds would be privately placed with no flotation cost. The current price of the firm's 10%,$100.00 par value, quarterly dividend, perpetual preferred stock is $111.10. Coleman's common stock is currently selling for $50.00 per share. Its last dividend (D0) was $4.19, and dividends are expected to grow at a constant annual rate of 5% in the foreseeable future. Coleman's beta is 1.2, the yield on T-bonds is 7%, and the market risk premium is estimated to be 6%. For the bond-yield-plusrisk-premium approach, the firm uses a risk premium of 4%. Coleman's target capital structure is 30% debt, 10% preferred stock, and 60% common equity. Target Capital Structure Debt Preferred Equity Total Capital 0% \begin{tabular}{l|l|l|l|} \hline Debt & 0% & Pv= \\ \hline Wd & & l= ? \\ \hline Rd & Pmt= \\ \hline tax rate & N= \\ \hline cost of debt & Fv= \\ \hline & & \\ \hline & & \\ \hline & & \\ \hline Preferred & 0% & Dp \\ \hline Wp & 0% & Pp = \\ \hline Rp & & Rp = \\ \hline cost of preferred & & \\ \hline & 0.00% & risk premium \\ \hline Equity & & Re \\ \hline We & & \\ \hline Re & & \\ \hline cost of equity & & \\ \hline \end{tabular} For Rd (cost of debt), you have to get the yield to maturity. Don't forget this is a semiannual bond; check your payments, periods, and interestStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started