In: Finance
NPV. Grady Precision Measurement Tools has forecasted the following sales and costs for a new GPS system: annual sales of 44,000 units at $16 a unit, production costs at 37% of sales price, annual fixed costs for production at $ 210,000. The company tax rate is 30%. What is the annual operating cash flow of the new GPS system? Should Grady Precision Measurement Tools add the GPS system to its set of products? The initial investment is $1,430,000 for manufacturing equipment, which will be depreciated over six years (straight line) and will be sold at the end of five years for $ 380,000. The cost of capital is 12%. What is the annual operating cash flow of the new GPS system?
| Time line | 0 | 1 | 2 | 3 | 4 | 5 | 6 | |
| Cost of new machine | -1430000 | |||||||
| =Initial Investment outlay | -1430000 | |||||||
| Unit sales | 44000 | 44000 | 44000 | 44000 | 44000 | 44000 | ||
| Profits | =no. of units sold * (sales price - variable cost) | 443520 | 443520 | 443520 | 443520 | 443520 | 443520 | |
| Fixed cost | -210000 | -210000 | -210000 | -210000 | -210000 | -210000 | ||
| -Depreciation | Cost of equipment/no. of years | -238333.333 | -238333.33 | -238333.33 | -238333.33 | -238333.3 | -238333.3 | |
| =Pretax cash flows | -4813.33333 | -4813.3333 | -4813.3333 | -4813.3333 | -4813.333 | -4813.333 | ||
| -taxes | =(Pretax cash flows)*(1-tax) | -3369.33333 | -3369.3333 | -3369.3333 | -3369.3333 | -3369.333 | -3369.333 | |
| +Depreciation | 238333.3333 | 238333.333 | 238333.333 | 238333.333 | 238333.33 | 238333.33 | ||
| =after tax operating cash flow | 234964 | 234964 | 234964 | 234964 | 234964 | 234964 | ||
| +Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 266000 | ||||||
| +Tax shield on salvage book value | =Salvage value * tax rate | 0 | ||||||
| =Terminal year after tax cash flows | 266000 | |||||||
| Total Cash flow for the period | -1430000 | 234964 | 234964 | 234964 | 234964 | 234964 | 500964 | |
| Discount factor= | (1+discount rate)^corresponding period | 1 | 1.12 | 1.2544 | 1.404928 | 1.57351936 | 1.7623417 | 1.9738227 |
| Discounted CF= | Cashflow/discount factor | -1430000 | 209789.2857 | 187311.862 | 167242.734 | 149323.87 | 133324.88 | 253803.95 |
| NPV= | Sum of discounted CF= | -329203.4114 | ||||||
Do not buy as NPV is negative