The following is the pertinant information regarding the financial structure a proposed 18 hole expansion of the Greenfield Country Club. The club is planning on seeing equity from it's current members. You have been requested to provide a pre tax analysis of this structure Total Investment S 2,500,000 Debt Financed 1,500,000 Equity Financed 1,000,000 Equity Investors share of Net Profit 45.0% Debt Interest Rate 8.0% Annual Debt Service 150,500 Forecast Cash Flow before debt service 551,000 Required: Calculate the following USING EXCEL FORMULAS in the cells indicated below Weight of Debt Weight of Equity Cost of Debt Cost of Equity Weighted cost of Debt Weighted cost of Equity Weighted Average Cost of Capital