Can you solve al of this cell and show formulaCan y

Based on the case below please construct the Transaction Sources & Uses and calculate the WACC Phatchance Hotel Properties, Inc. Jack Von Crook, a hotel investor, is in the process of purchasing Phatchance Hotel Properties, Inc. ("PHP"). PHP operates two hotels in Miami, Florida with total of 800 rooms. He is anticipated to complete the necessary renovations on these properties by December 31, 2019 and open its doors for business on January 1st, 2020. The estimated total cost of both properties is $300 million, plus additional $30 million for renovations. PHP estimated 2019 EBITDA of $40 million and outstanding debt of $40 million. Capital Raising: Jack needs capital to purchase and renovate the two properties as well as refinance its current debt outstanding. Jack will invest $90 million of equiy. He received an approval for the bank loan for 3x 2019 EBITDA and the rest of the financing will be paid in Corporate Bonds. The pricing is as follows: Bank Loan @ 5.0% Fixed Rate, Corporate Bonds @ 8.0% Fixed Rate and the Equity expected return is calculated based on CAPM with risk free rate of 1.0%, beta of 2x and equity market return of 10.0% Transaction Uses Amount write the whole number (.e. 200,000,000 for $200 million) TAX RATE=1 22.0% Transaction Sources Amount ($ million) % Capital WACC Interest /Expected Return Interest Expected Return After Tax % Bank Loan Corporate Bonds Equity Total