can you make it in excel and put the formulas that you used to resolve it

Intermediate Calculations

Units sold

Sales price per unit

Variable costs per unit

Nonvariable costs

Sales revenue

Required level of net operating working capital

Cash flow due to change in NOWC

Basis for depreciation

Annual equipment depr. rate

Annual depreciation expense

Ending Bk Val: Cost $-$ Accum Dep'rn

Salvage value

Profit $($or loss$)$ on salvage

Tax on profit $($or loss$)$

Net cash flow due to salvage

Intermediate Calculations

Units sold

Sales price per unit

Variable costs per unit

Nonvariable costs

Sales revenue

Required level of net operating working capital

Cash flow due to change in NOWC

Basis for depreciation

Annual equipment depr. rate

Annual depreciation expense

Ending Bk Val: Cost $-$ Accum Dep'rn

Salvage value

Profit $($or loss$)$ on salvage

Tax on profit $($or loss$)$

Net cash flow due to salvage