(pls use/show excel function for answer)

It plans to purchase a new machine for $1,000,000.00 Depreciation will use the MACRS rates for 4 years: Year 1 Year 2 Year 3 Year 4 20% 32% 19.20% 11.52% Tax rate Net operating working capital/sales First year sales (in units) Sales price per unit Variable cost per unit (excl.depr.) Nonvariable cost (excl. depr.) Inflation in prices and costs Salvage value e WACC for average-risk projects WACC for low-risk projects 1 WACC for high-risk projects 25% 15% 100,000.00 $ 30.00 $ 24.00 $20,000.00 3% $50,000.00 12% 8% 16% Year 0 1 100,000.00 100,000.00 100,000.00 100,000.00 Intermediate Calculations Units sold Sales price per unit (excl. depr.) Variable costs per unit (excl. depr.) Nonvariable costs (excl. depr.) Sales revenue Required level of net operating working capital Basis for depreciation Annual equipment depute Annual depreciation expense Ending Ok Val: Cost-Accum Depen Salvage value Profit (or loss on sale Tax on profit (or los Netcash flow due to salvage Year 0 Cash Flow Forecast Sales revere Variable costs Nonvariable operating costs Depreciation (equipment) Oper. Income before taxes (EBIT) Takes on operating income (25%) Net operating profit after taxes Add back depreciation Equipment purchase Cash flow due to change in NOWC Net cash flow due to salvage Net Cash Flow (Timeline of cash flows