Sheet1 Sheet Sheet Sheet4 Case 12A-Cash FIow Estimation. Sales Price nnation: Cranfield, Inc. ash oper Cost inflation: 0.00% Rate 40% Depreciation Schedule Basis MACRS Deprec End of Yr nvestment Outlay near 0 Yea Expense Book Value Freight 3 45.00% 207,000 l01,200 Installation: 3 69.000 12.200 4 Depreciation Basis CF due to NOWC: Total Outlay Year 0 Yea Year Year Year 4 Project Cash Flows: Unit Price Unit Sales 400,000 Revenues SK00 000 Fixed Operating Costs 100,000 Variable operating Costs 25 500,000 Total operating costs 6000000 Depreciation ISL 00 Net Cannibalization Enects Before-tax Oper Income (EBIT) 2R200 Taxes Net operating Profit Aner Taxes 16.20 51,800 Plus Depreciation 168,720 Net Operating Cash Flow Salvage value Book Value Gain on Salvage Value Taxes on Gain on SV Net Salvage CF Recovery of Net WK Cap. Termination Cash Flow Project Net Cash Flow S16N. Deci n M NPV MIRR Payback Only variable costs are inflated fixed costs remain constant: Base year Yro Sheet1 Sheet Sheet Sheet4 Case 12A-Cash FIow Estimation. Sales Price nnation: Cranfield, Inc. ash oper Cost inflation: 0.00% Rate 40% Depreciation Schedule Basis MACRS Deprec End of Yr nvestment Outlay near 0 Yea Expense Book Value Freight 3 45.00% 207,000 l01,200 Installation: 3 69.000 12.200 4 Depreciation Basis CF due to NOWC: Total Outlay Year 0 Yea Year Year Year 4 Project Cash Flows: Unit Price Unit Sales 400,000 Revenues SK00 000 Fixed Operating Costs 100,000 Variable operating Costs 25 500,000 Total operating costs 6000000 Depreciation ISL 00 Net Cannibalization Enects Before-tax Oper Income (EBIT) 2R200 Taxes Net operating Profit Aner Taxes 16.20 51,800 Plus Depreciation 168,720 Net Operating Cash Flow Salvage value Book Value Gain on Salvage Value Taxes on Gain on SV Net Salvage CF Recovery of Net WK Cap. Termination Cash Flow Project Net Cash Flow S16N. Deci n M NPV MIRR Payback Only variable costs are inflated fixed costs remain constant: Base year Yro