please show work in excel

TABLE 3 Adjusted Present Value (APV) Approach 0% Debt 100% Equity 25% Debt 75% Equity 50% Debt 50% Equity Pure Business Cash Flows EBIT Taxes (@34%) EBIAT Depreciation Capital Expeditures Change in NWC Cashflow 1,485 (505) 980 500 (500) 0 980 1,485 (505) 980 500 (500) 0 980 1,485 (505) 980 500 (500) 980 Unlevered Beta Risk-free Rate Market Premium Unlevered WACC 0.8000 5.000% 6.000% 0.8000 5.000% 6.000% 0.8000 5.000% 6.000% Value of Pure Business Flows Financing Cash Flows Interest Tax Reduction Pre-Tax Cost of Debt 5.000% 5.000% 5.000% Value of Financing Effect Total Value TABLE 3 Adjusted Present Value (APV) Approach 0% Debt 100% Equity 25% Debt 75% Equity 50% Debt 50% Equity Pure Business Cash Flows EBIT Taxes (@34%) EBIAT Depreciation Capital Expeditures Change in NWC Cashflow 1,485 (505) 980 500 (500) 0 980 1,485 (505) 980 500 (500) 0 980 1,485 (505) 980 500 (500) 980 Unlevered Beta Risk-free Rate Market Premium Unlevered WACC 0.8000 5.000% 6.000% 0.8000 5.000% 6.000% 0.8000 5.000% 6.000% Value of Pure Business Flows Financing Cash Flows Interest Tax Reduction Pre-Tax Cost of Debt 5.000% 5.000% 5.000% Value of Financing Effect Total Value