PLEASE FILL IN ALL AREAS IN THE EXCEL BOXES AND SHOW THE FORMULAS FOR THE BLUE PLEASE.

Free cash flow valuation. Nabor Industries is considering going public but is unsure of a fair offering price for the company. Before hiring an investment banker to assist in making the public offering, managers at Nabor have decided to make their own estimate of the firm's common stock value. The firm's CFO has gathered data for performing the valuation using the free cash flow valuation model. The firm's weighted average cost of capital is 11%, and it has $1,500,000 of debt and $400,000 of preferred stock in terms of market value. The estimated free cash flows over the next 5 years, 2020 through 2024, are given below. Beyond 2024 to infinity, the firm expects its free cash flow to grow by 3% annually. a. Estimate the value of Nabor Industries' entire company by using the free cash flow valuation model. b. Use your finding in part a, along with the data provided above, to find Nabor Industries' common stock value. c. If the firm plans to issue 200,000 shares of common stock, what is its estimated value per share? Solution a. Estimate the value of Nabor Industries' entire company by using the free cash flow valuation model. b. Use your finding in part a, along with the data provided above, to find Nabor Industries' common stock value. Value of Nabor Industries' Debt Value Nabor Industries' Preferred Stock Value Nabor Industries' Common Stock c. If the firm plans to issue 200,000 shares of common stock, what is its estimated value per share? Value Nabor Industries' Common Stock Shares of common stock outstanding Value per share of common stock