I need help with this question i am attatching. Please answer via excel. Thank You.

Question 3 Prepare a DCF Analysis given the followng assumptions: Revenue Growth Cost of Revenue 25% of Revenue Operating Expense 25% Depreciation Expense as 25% of Revenu Tax Rate Working Capital Expense Capex 25% of Revenue Amortization Fees 7.00% 55.00% 17.00% 4.00% 36.00% 1.00% 3.00% 0.00% 7 Year Amortization Risk Free Historical Total Market Return Beta 2.00% 12.60% 1.75x Sources Amount Interest/Expected Return % Capital Bank Loss 180,000 5.00% Corp Bonds 45,000 10.00% Equity 125,000 Total Sources 350,000 0 Interest/Expected return After Tax WACC 3 4 5 20,000 25,000 20,000 97,000 0 Corporate Bond Information Account Outstanding Schedule Payments Interest Payments Total Financing Payments 2 18,000 Bank Loan Information Amount Outstanding Schedule Payments Interest Payment Total Financing Payment 1 0 0 0 45,000 1 2 3 Zero Year's EBITDA Multiple based on Total Sources 4 Total Total Financing Total Debts Outstanding 0 230,000 Revenues Cost of Revenues Operating Expense EBITDA 45,000 Depreciation Fees EBIT Taxes Depreciation and Amortization of fees Working Capital expense Capital Expenditures Free Cash Flow Before Financing Financing Expense Net Cash Flow Exit Terminal Value EBITDA Multiple Method using initial EBITDA multiple (Zero Year) Perpetuity Method (using WACC) with no growth Average of two valuaion Methods Debt Outstanding Equity Value Equity Cash Flows PV Values (for $1) PV1 PV 2 PV3 Total Less Initial Equity Investment Equity NPV Equity IRR 3