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. Based on this information, what is the firm's optimal capital structure and what is the weighted average cost of capital at the optimal structure? Fill in formulas in the yellow cells to find the optimum capital structure. Additional: Similar to Figure 15-7 (pg. 633), graph the Cost of Capital for the A-T Cost of Debt, Cost of Equity, and NACC (all on y-axis) vs. the DebtrValue Ratio (x-axis) in the space below: Hint: holding the "CTRL" butten, highlight the four columns (no labels) of data above; click the insert tab; choose a scatter diagram with data points connected by lines Idditional: using the (hypothetical) free cash flow stream below, calcuate and graph the NPVs ( y-axis) against the variou Debt/Value Ratios ( x-axis) in the space below (similar to Figure 15-8): What do you observe when comparing the two plots above? 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. Based on this information, what is the firm's optimal capital structure and what is the weighted average cost of capital at the optimal structure? Fill in formulas in the yellow cells to find the optimum capital structure. Additional: Similar to Figure 15-7 (pg. 633), graph the Cost of Capital for the A-T Cost of Debt, Cost of Equity, and NACC (all on y-axis) vs. the DebtrValue Ratio (x-axis) in the space below: Hint: holding the "CTRL" butten, highlight the four columns (no labels) of data above; click the insert tab; choose a scatter diagram with data points connected by lines Idditional: using the (hypothetical) free cash flow stream below, calcuate and graph the NPVs ( y-axis) against the variou Debt/Value Ratios ( x-axis) in the space below (similar to Figure 15-8): What do you observe when comparing the two plots above