Question: For an answer to be graded as correct, you must use an Excel formula: Begin each formula with an = sign. Reference cells, instead of

 For an answer to be graded as correct, you must use

For an answer to be graded as correct, you must use an Excel formula:

Begin each formula with an = sign.

Reference cells, instead of entering values.

Example: =B3+C3

Required: You have the given information about Burgundy Basins, a sink manufacturer. Burgundy is contemplating what for the company is an average-risk investment costing $40 million and promising an annual ATCF of $6.4 million in perpetuity. a. What is the internal rate of return on the investment? b. What is Burgundy's weighted-average cost of capital? Note: Use cell A7 to B17 from the given information to complete this question. You may use the hardcoded number " 1 " in your formulas. No other hardcoded numbers may be used. Round your percentage answer to whole number (i.e., 0.1234 should be considered as 12.) Input area: \begin{tabular}{lr|} \hline Equity shares outstanding & 20,000,000 \\ Stock price per share & $40 \\ Yield to maturity on debt & 7.5% \\ Book value of interest-bearing debt & $320,000,000 \\ Coupon interest rate on debt & 4.8% \\ Market value of debt & $290,000,000 \\ Book value of equity & $500,000,000 \\ Cost of equity capital & 14% \\ Tax rate & 35% \\ Investment & $40,000,000 \\ Annual ATCF & $6,400,000 \\ \hline \end{tabular} Output area: Internal rate of return Weighted-average cost of capital

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!