In: Finance
TexMex Food Company is considering a new salsa whose data are
shown below. The equipment to be used would be depreciated by the
straight-line method over its 3-year life and would have a zero
salvage value, and no change in net operating working capital would
be required. Revenues and other operating costs are expected to be
constant over the project's 3-year life. However, this project
would compete with other TexMex products and would reduce their
pre-tax annual cash flows. What is the project's NPV? (Hint: Cash
flows are constant in Years 1-3.) Do not round the intermediate
calculations and round the final answer to the nearest whole
number.
WACC |
10.0% |
Pre-tax cash flow reduction for other products (cannibalization) |
-$5,000 |
Investment cost (depreciable basis) |
$80,000 |
Straight-line depr. rate |
33.333% |
Annual sales revenues |
$66,500 |
Annual operating costs (excl. depr.) |
-$25,000 |
Tax rate |
35.0% |
Time line | 0 | 1 | 2 | 3 | |||
Cost of new machine | -80000 | ||||||
=Initial Investment outlay | -80000 | ||||||
100.00% | |||||||
Sales | 61500 | 61500 | 61500 | ||||
Profits | Sales-variable cost | 36500 | 36500 | 36500 | |||
-Depreciation | Cost of equipment/no. of years | -26666.6667 | -26666.6667 | -26666.6667 | 0 | =Salvage Value | |
=Pretax cash flows | 9833.333333 | 9833.333333 | 9833.333333 | ||||
-taxes | =(Pretax cash flows)*(1-tax) | 6391.666667 | 6391.666667 | 6391.666667 | |||
+Depreciation | 26666.66667 | 26666.66667 | 26666.66667 | ||||
=after tax operating cash flow | 33058.33 | 33058.33 | 33058.33 | ||||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||
=Terminal year after tax cash flows | 0 | ||||||
Total Cash flow for the period | -80000 | 33058.33 | 33058.33 | 33058.33 | |||
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.1 | 1.21 | 1.331 | ||
Discounted CF= | Cashflow/discount factor | -80000 | 30053.02727 | 27320.93388 | 24837.21262 | ||
NPV= | Sum of discounted CF= | 2211 |