PLEASE SHOW FORMULAS !!!!!!

oblem 2-1 Problem 2-2 Problem 2-3 Problem 2-6 POGO Problem 3-1 Problem 3-2 D Given Initial cost of equipment Project and equipment life Salvage value of equipment Working capital requirement Depreciation method Depreciation expense Discount rate Tax rate Straight-Line A Base case Worst case Best Case 12 Table Opt Title Captio Un sales Price per unit Variable cost per unit 21 Headers & Best Case Solution 24 Rows 28 Columns Revenues Variable Fred Expenses Gross profit Depreciation Net operating income Income tax expense Not income Cashow 10 31 2 Table Font Table Outi 14 35 10 3 35 NPV Outline Espected Case Solution Excel formula Gridlines 4 Variable cost Fed Expenses Gross profit Depreciation Net operating income Income tax expense NOPAT Alternat Row & Co Height Width MacBook Air Problem 3-2 Problem 4-1 Table Depreciation Not operating income Income tax expense Not income Cash fow Expected Case 19 Solution Excel formula 42 Table Options Title Caption 46 Headers & Foot Variable cost Fred Expenses Gross pro Depreciation Net operating income Income tax expense NOPAT plus Depreciation : CAPEX less: Working capital investment Froo cash flow 45 Rows Columns NPV 50 Table Font Size Worst C Assuming the negative tax creditained here can used somewhere e carried forward Solution Excel formula in previous column Table Outline 02 Outline Tablet 4 80 56 Variable cost Fred Expenses Gross proft Depreciation Net operating income Income tax experte Nel come Cashow Gridlines Alternating Row NPV Row & Column Size Height Width MacBook Air oblem 2-1 Problem 2-2 Problem 2-3 Problem 2-6 POGO Problem 3-1 Problem 3-2 D Given Initial cost of equipment Project and equipment life Salvage value of equipment Working capital requirement Depreciation method Depreciation expense Discount rate Tax rate Straight-Line A Base case Worst case Best Case 12 Table Opt Title Captio Un sales Price per unit Variable cost per unit 21 Headers & Best Case Solution 24 Rows 28 Columns Revenues Variable Fred Expenses Gross profit Depreciation Net operating income Income tax expense Not income Cashow 10 31 2 Table Font Table Outi 14 35 10 3 35 NPV Outline Espected Case Solution Excel formula Gridlines 4 Variable cost Fed Expenses Gross profit Depreciation Net operating income Income tax expense NOPAT Alternat Row & Co Height Width MacBook Air Problem 3-2 Problem 4-1 Table Depreciation Not operating income Income tax expense Not income Cash fow Expected Case 19 Solution Excel formula 42 Table Options Title Caption 46 Headers & Foot Variable cost Fred Expenses Gross pro Depreciation Net operating income Income tax expense NOPAT plus Depreciation : CAPEX less: Working capital investment Froo cash flow 45 Rows Columns NPV 50 Table Font Size Worst C Assuming the negative tax creditained here can used somewhere e carried forward Solution Excel formula in previous column Table Outline 02 Outline Tablet 4 80 56 Variable cost Fred Expenses Gross proft Depreciation Net operating income Income tax experte Nel come Cashow Gridlines Alternating Row NPV Row & Column Size Height Width MacBook Air