In: Finance
NPV.Grady Precision Measurement Tools has forecasted the following sales and costs for a new GPS system: annual sales of 46,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 35%. What is the annual operating cash flow of the new GPSsystem? Should Grady Precision Measurement Tools add the GPS system to its set of products? The initial investment is $1,440,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 10%.
What is the annual operating cash flow of the new GPS system?
| Calculation of the annual operating cash flow of the new GPS system | |||||||||
| Sales Units | 46000 | ||||||||
| x Selling price per unit | $16.00 | ||||||||
| Sales | $736,000.00 | ||||||||
| Less : Variable Production costs (37%) | $272,320.00 | ||||||||
| Less : Fixed costs of production | $210,000.00 | ||||||||
| Less : Depreciation | $240,000.00 | ||||||||
| Profit before tax | $13,680.00 | ||||||||
| Less : Tax @ 35% | $4,788.00 | ||||||||
| Add : Depreciation | $240,000.00 | ||||||||
| Annual Operating Cash flow | $248,892.00 | ||||||||
| Calculation of net present value of new GPS system | |||||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | |||
| Initial Investment | -$1,440,000.00 | ||||||||
| Operating Cash flow | $248,892.00 | $248,892.00 | $248,892.00 | $248,892.00 | $248,892.00 | ||||
| After tax sale value of GPS system | $331,000.00 | ||||||||
| Net Cash flow | -$1,440,000.00 | $248,892.00 | $248,892.00 | $248,892.00 | $248,892.00 | $579,892.00 | |||
| x Discount factor @ 10% | 1 | 0.90909091 | 0.82644628 | 0.7513148 | 0.68301346 | 0.62092132 | |||
| Present Value | -$1,440,000.00 | $226,265.45 | $205,695.87 | $186,996.24 | $169,996.58 | $360,067.31 | |||
| Net Present Value | -$290,978.54 | ||||||||
| As the net present value of in ew GPS system is negative , Grady Precision Measurement Tools should not add the GPS system to its set of products. | |||||||||
| Working | |||||||||
| Depreciation per year on GPS system using straight line method = [Cost - residual value] / useful life | |||||||||
| Depreciation per year on GPS system using straight line method = [$14,40,000 - $0]/6 years = $2,40,000 | |||||||||
| Calculation of after tax sale value of GPS system | |||||||||
| Sale value of GPS system | $380,000.00 | ||||||||
| Less : Book value of GPS system | $240,000.00 | ||||||||
| Gain on sale of GPS system | $140,000.00 | ||||||||
| Tax @ 35% of Gain | $49,000.00 | ||||||||
| After tax sale value of GPS system [Sale value - Tax] | $331,000.00 | ||||||||