Please show step by step solution using EXCEl, I need to fully understand how we got the answers

. Dave Porter and Myra Sutcliffe are directing the finance team for Worldwide Adhesives, Inc. They are looking at several investments and acquisitions. Assist them by evaluating the following situations to determine the intrinsic values as directed. Please show all work and provide a brief explanation of how you analyzed the situation.

1. WWA is looking at one of their subsidiaries, Gossamer Glue Company, which has run into difficulties. There have been technological innovations in both products and process that GGC presently does not have access to. The finance team has ascertained the following values:

Free Cash Flows this year $12,247,000

WACC 10.25%

Debt Value $25,000,000

Short-term Investments Value $1,000,000

Preferred Stock Value $6,000,000

Number of Shares 2,800,000

a. Unless new technology is introduced, Gossamer is expecting free cash flows to remain flat for the foreseeable future. Calculate the intrinsic value of GGC, the intrinsic value of its equity and the intrinsic per share value of its stock. (Hint: Constant free cash flows.)

b. Recent competitive reports now indicate that Gossamer should expect free cash flows to fall by 2% per year beginning this year without the introduction of new technology. Calculate the intrinsic value of the company and the per share value of the stock. (Hint: Constant Growth free cash flows.)

c. If new technology is introduced now, Gossamer is expecting free cash flows to increase by 5% per year beginning this year. The new technology would add $10 million to the firm's debt stated above. Calculate the intrinsic value of the company and the per share value of the stock. (Hint: Constant Growth free cash flows.)

d. Compare the intrinsic per share value of the stock in each of the three scenarios. Explain the effect of the added debt in the third scenario.