The following is the pertinant information regarding the financial structure for the Hops Along Brew Pub. You have been requested to provide a pre tax analysis of this structure Total Investment Debt Financed Equity Financed Equity Investors share of Net Profit Debt Interest Rate Annual Debt Service Forecast Cash Flow before debt service 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 $ 5,000,000 $ 3,000,000 $ 2,000,000 50.0% 7.5% $ 290,000 $ 1,050,000