V Drink Template Numbers below are adjusted from previous problem, but are similar Modify this template to solve the remaining problems Invesment Outlays Units Sales 200000 Sales Price $ 2.00 Equipment & Shipping $ 500,000.00 Inventory $ 25,000.00 Revenue $ 400,000.00 Operating Cost $ 200,000.00 Tax 40% WAAC 12% Depreciation $ 83,333.33 Year 0 1 2 3 4 5 6 Revenue $ (400,000.00) $400,000.00 $400,000.00 $400,000.00 $400,000.00 $400,000.00 $400,000.00 Operating Cost -$200,000.00 -$200,000.00 -$200,000.00 -$200,000.00 -$200,000.00 -$200,000.00 Depreciation -$83,333.33 -$83,333.33 -$83,333.33 -$83,333.33 -$83,333.33 -$83,333.33 EBIT $ 116,666.67 $ 116,666.67 $ 116,666.67 $ 116,666.67 $ 116,666.67 $ 116,666.67 Taxes on operating income 40% $ 46,666.67 $ 46,666.67 $ 46,666.67 $ 46,666.67 $ 46,666.67 $ 46,666.67 EBIT (1-T) $ 70,000.00 $ 70,000.00 $ 70,000.00 $ 70,000.00 $ 70,000.00 $ 70,000.00 Depreciation $ 83,333.33 $ 83,333.33 $ 83,333.33 $ 83,333.33 $ 83,333.33 $ 83,333.33 Free Cash Flow $ (525,000.00) $ 153,333.33 $ 153,333.33 $ 153,333.33 $ 153,333.33 $ 153,333.33 $ 153,333.33 Cumulative payback $ NPV (371,666.67) $ Payback (218,333.33) $ (65,000.00) $ 88,333.33 $ 241,666.67 $ 395,000.00 IRR Payback