I would like to see the excel sheets and formulas to help understand where the numbers are derived.

(15-11) Capital Structure Analysis The Rivoli Company has no debt outstanding, and its financial position is given by the following data: Expected EBIT $600,000 Growth rate in EBIT, 8, 0% Cost of equity, 10% Shares outstanding, n. 200,000 Tax rate, T (federal-plus-state) 25% a. What is Rivoli's intrinsic value of operations (i.e., its unlevered value)? What is its intrinsic stock price? Its earnings per share? b. Rivoli is considering selling bonds and simultaneously repurchasing some of its stock. If it moves to a capital structure with 30% debt based on market values, its cost of equity, r., will increase to 12% to reflect the increased risk. Bonds can be sold at a cost, rj, of 7%. Based on the new capital structure, what is the new weighted average cost of capital? What is the levered value of the firm? What is the amount of debt? c. Based on the new capital structure, what is the new stock price? What is the remain- ing number of shares? What is the new earnings per share