During the last few years the Hyatt Hotels Corporation has been too constrained by the high cost of capital to make many capital investments. Recently, though, capital costs have been declining, and the company has decided to look seriously at a major expansion program that has been proposed by the marketing department. Assume that you are currently an intern helping the CFO.

a-Your first task is to estimate the Hyatt Hotels Corporation weighted average cost of capital (wacc) and you have been provided with the following most recent data:

• The firm's tax rate =20%
• The Hyatt Hotels Corporation has issued 6% coupon semi-annual payment non-callable bonds, with a maturity date of 17^th of May 2027.The bonds are sold today 17^th of May 2020 at $1022. New bonds would be privately placed with no flotation cost.
• The current price of the firm's preferred stock is $160.10, and the dividend is $10. The Hyatt Hotels Corporation will incur flotation cost of $2 per share on a new issue.
• The Hyatt Hotels Corporation common stock is currently selling at $47.08 per share. Its last dividend (D0)was $1.65,and dividends are expected to grow at 3%in the foreseeable future. The Hyatt Hotels Corporation beta is 0.56 ,the yield on T-bonds is 4% and the average return on the market is 10%.
• The target capital structure is 25% for long term debt, 2% for preferred stock and 73% for common equity. What is The Hyatt Hotels Corporation weighted average cost of capital (WACC)?

b- For the second task you are asked to copy and paste the following table in your EXCEL sheet and then complete it to calculate the Free Cash Flow of the Firm (FCFF)