Solve in Excel Please, how to get correct values!

Capital Structure Analysis The Rivoli Company has no debt outstanding, and its financial position is given by the following data: a. What is Rivoli's intrinsic value of operations (i.e., its unlevered value)? Round your answer to the nearest dollar. $ What is its intrinsic stock price? Its earnings per share? Round your answers to the nearest cent. Intrinsic stock price: \$ Earnings per share: \$ b. Rivoli is considering selling bonds and simultaneously repurchasing some of its stock. If it moves to a capital structure with 35% debt based on market values, its cost of equity, rs, will increase to 11% to reflect the increased risk. Bonds can be sold at a cost, rd, of 6%. Based on the new capital structure, what is the new weighted average cost of capital? Round your answer to three decimal places. x% What is the levered value of the firm? What is the amount of debt? Do not round intermediate calculations. Round your answers to the nearest dollar. Levered value of the firm: $ x Debt: \$ x c. Based on the new capital structure, what is the new stock price? Do not round intermediate calculations. Round your answer to the nearest cent. $ x What is the remaining number of shares? Do not round intermediate calculations. Round your answer to the nearest whole number. X shares What is the new earnings per share? Do not round intermediate calculations. Round your answer to the nearest cent. $ x