Question: Please help me find NPV, IRR, Payback, and Discount. Please show work, I will make sure to thumbs up. Thank you! 38 Intermediate Calculations 39

Please help me find NPV, IRR, Payback, and Discount. Please show work,I will make sure to thumbs up. Thank you! 38 Intermediate CalculationsPlease help me find NPV, IRR, Payback, and Discount. Please show work, I will make sure to thumbs up. Thank you!

38 Intermediate Calculations 39 Units sold 40 Sales price per unit (excl. depr.) 41 Variable costs per unit (excl. depr.) 42 Nonvariable costs (excl. depr.) 43 Sales revenue 44 Required level of net operating working capital 45 Basis for depreciation 46 Annual equipment depr. rate 47 Annual depreciation expense 48 Ending Bk Val: Cost Accum Dep'rn 49 Salvage value 50 Profit (or loss) on salvage 51 Tax on profit (or loss) 52 Net cash flow due to salvage 53 54 Cash Flow Forecast 55 Sales revenue 56 Variable costs 57 Nonvariable operating costs 58 Depreciation (equipment) 59 Oper. income before taxes (EBIT) 60 Taxes on operating income (40% 61 Net operating profit after taxes 62 Add back depreciation 63 Equipment purchases 64 Cash flow due to change in NOWC 65 Net cash flow due to salvage 66 Net Cash Flow (Time line of cash flows 1,000.00 $17.50 $24,000 1,000.00 1,000.00 1,000.00 $24.00 $ 24.72 $ 25.46 $ $18.03 1,030.00 $ $24,720 $18.57 1,060.90 $ $25,462 $1,000 $ 1,092.73 $26,225 $10,000 19.20% $1,920 $2,880 $10,000 11 .52% $1,152 $10,000 $10,000 20.00% $2,000 $8,000 $10,000 32.00% $3,200 $4,800 $10,000 $1,728 $1,228.00 $491.20 $736.80 Years $ 24,000.00 $24,720.00 25,461.60 S 26,225.45 $(17,500.00) $ (18,025.00) $(18,565.75) $ (19,122.72) $(1,000.00) $ (1,030.00) $ (1,060.90) $(1,092.73) 1,152.00 4,858.00 1,943.20 2,914.80 1,152.00 (2,000.00)$ 3,500.00 $ (1,400.00) $ 2,100.00 $ 2,000.00 $ (3,200.00) $ 2,465.00 $ 986.00) $ 1,479.00 $ 3,200.00 $ 1.920.00) S 3,914.95 $ (1,565.98) S 2,348.97 $ 1,920.00$ ($10,000) -$2,400 $2,6231 $500 $7,189 -$12,400 $4,172 $4,753 $4,345 38 Intermediate Calculations 39 Units sold 40 Sales price per unit (excl. depr.) 41 Variable costs per unit (excl. depr.) 42 Nonvariable costs (excl. depr.) 43 Sales revenue 44 Required level of net operating working capital 45 Basis for depreciation 46 Annual equipment depr. rate 47 Annual depreciation expense 48 Ending Bk Val: Cost Accum Dep'rn 49 Salvage value 50 Profit (or loss) on salvage 51 Tax on profit (or loss) 52 Net cash flow due to salvage 53 54 Cash Flow Forecast 55 Sales revenue 56 Variable costs 57 Nonvariable operating costs 58 Depreciation (equipment) 59 Oper. income before taxes (EBIT) 60 Taxes on operating income (40% 61 Net operating profit after taxes 62 Add back depreciation 63 Equipment purchases 64 Cash flow due to change in NOWC 65 Net cash flow due to salvage 66 Net Cash Flow (Time line of cash flows 1,000.00 $17.50 $24,000 1,000.00 1,000.00 1,000.00 $24.00 $ 24.72 $ 25.46 $ $18.03 1,030.00 $ $24,720 $18.57 1,060.90 $ $25,462 $1,000 $ 1,092.73 $26,225 $10,000 19.20% $1,920 $2,880 $10,000 11 .52% $1,152 $10,000 $10,000 20.00% $2,000 $8,000 $10,000 32.00% $3,200 $4,800 $10,000 $1,728 $1,228.00 $491.20 $736.80 Years $ 24,000.00 $24,720.00 25,461.60 S 26,225.45 $(17,500.00) $ (18,025.00) $(18,565.75) $ (19,122.72) $(1,000.00) $ (1,030.00) $ (1,060.90) $(1,092.73) 1,152.00 4,858.00 1,943.20 2,914.80 1,152.00 (2,000.00)$ 3,500.00 $ (1,400.00) $ 2,100.00 $ 2,000.00 $ (3,200.00) $ 2,465.00 $ 986.00) $ 1,479.00 $ 3,200.00 $ 1.920.00) S 3,914.95 $ (1,565.98) S 2,348.97 $ 1,920.00$ ($10,000) -$2,400 $2,6231 $500 $7,189 -$12,400 $4,172 $4,753 $4,345

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!