This paper circulates around the core theme of Fin-Module 6 Spreadsheet Problem. Part B Day 3..xlsx 15.12 Reacher Technology has consulted together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Fin-Module 6 Spreadsheet Problem. Part B Day 3..xlsx 15.12 Reacher Technology has consulted with… 1 answer below » Fin-Module 6 Spreadsheet Problem. Part B Day 3..xlsx 15.12 Reacher Technology has consulted with investment bankers and determined the interest rate it would pay for different capital structures, as shown below. Data for the risk-free rate, the market risk premium, an estimate of Reacher’s unlevered beta, and the tax rate are also shown below. Part B: what is the weighted average cost of capital at the optimal structure? Information: Percent Before-tax Financed with Cost Debt Debt (wd) (rd) 0% 6.0% 10% 6.1% 20% 7.0% 30% 8.0% 40% 10.0% 50% 12.5% 60% 15.5% 70% 18.0% Input Data Risk-free rate View complete question » Fin-Module 6 Spreadsheet Problem. Part B Day 3..xlsx 15.12 Reacher Technology has consulted with investment bankers and determined the interest rate it would pay for different capital structures, as shown below. Data for the risk-free rate, the market risk premium, an estimate of Reacher’s unlevered beta, and the tax rate are also shown below. Part B: what is the weighted average cost of capital at the optimal structure? Information: Percent Before-tax Financed with Cost Debt Debt (wd) (rd) 0% 6.0% 10% 6.1% 20% 7.0% 30% 8.0% 40% 10.0% 50% 12.5% 60% 15.5% 70% 18.0% Input Data Risk-free rate Market risk premium Unlevered beta Tax rate 4.5% 5.5% 0.8 40.0% Document Preview: 4.4999999999999998E-2
5.5E-2
0.8
0
0.06
0.4
0.1
6.0999999999999999E-2
0.2
7.0000000000000007E-2
0.3
0.08
0.4
0.1
0.5
0.125
0.6
0.155
0.7
0.18
Information:
Percent Financed with Debt (w
d
)
Before-tax Cost Debt (rd)
Input Data
Risk-free rate
Market risk premium
Unlevered beta
Tax rate
15.12
Reacher Technology has consulted with investment bankers and determined the interest rate it would pay for different capital structures, as shown below. Data for the risk-free rate, the market risk premium, an estimate of Reacher’s unlevered beta, and the tax rate are also shown below.
Part B:
what is the weighted average cost of capital at the optimal structure? Attachments: Q.-Attachment….xlsx View less » Sep 17 2015 05:19 PM
