In: Finance
The risk management system for loss control that is being evaluated is for a chemistry lab safety shower call back alarm. The equipment and its installation are estimated to cost $400,000. The useful life is 14 years without any salvage value at the end of the useful life. Insurance premium reductions of $50,000 per year have been negotiated. Loss reduction is expected to amount to a savings of at least $75,000 per year. The alarm connection has an annual fee of $1500 associated with the system. Maintenance of the shower alarm call back is expected to be $1,000 during the first 7 years of the systems useful life and $1500 for the remaining 7 years. The chemical research and development company are in the 35% corporate tax rate. The cost of capital (or appropriate discount rate) for this project is 10%. What is the NPV of the project? Would you accept or reject this project. Justify your answer.
| Initial cost | = | $400,000 | ||||||||
| Depreciation | = | Initial cost/life | ||||||||
| = | $400,000/14 | |||||||||
| = | $ 28,571.43 | |||||||||
| Calculation of cashflow | ||||||||||
| (a) | (b) | (c.) | (d) | (.e)=a-b-c-d | (f)=e*35% | (g)=e-f | (h)=g+d | (i) | (j)=h*i | |
| Years | Saving | Insurance premium | Maintenance | Depreciation | Profit | Tax | Net profit | Cashflow | PVF@10% | PV | 
| 1 | 75000 | 50000 | 1000 | 28571.43 | -4571.43 | -1600.0005 | -2971.43 | 25600 | 0.909091 | 23272.73 | 
| 2 | 75000 | 50000 | 1000 | 28571.43 | -4571.43 | -1600.0005 | -2971.43 | 25600 | 0.826446 | 21157.03 | 
| 3 | 75000 | 50000 | 1000 | 28571.43 | -4571.43 | -1600.0005 | -2971.43 | 25600 | 0.751315 | 19233.66 | 
| 4 | 75000 | 50000 | 1000 | 28571.43 | -4571.43 | -1600.0005 | -2971.43 | 25600 | 0.683013 | 17485.14 | 
| 5 | 75000 | 50000 | 1000 | 28571.43 | -4571.43 | -1600.0005 | -2971.43 | 25600 | 0.620921 | 15895.59 | 
| 6 | 75000 | 50000 | 1000 | 28571.43 | -4571.43 | -1600.0005 | -2971.43 | 25600 | 0.564474 | 14450.53 | 
| 7 | 75000 | 50000 | 1000 | 28571.43 | -4571.43 | -1600.0005 | -2971.43 | 25600 | 0.513158 | 13136.85 | 
| 8 | 75000 | 50000 | 1500 | 28571.43 | -5071.43 | -1775.0005 | -3296.43 | 25275 | 0.466507 | 11790.97 | 
| 9 | 75000 | 50000 | 1500 | 28571.43 | -5071.43 | -1775.0005 | -3296.43 | 25275 | 0.424098 | 10719.07 | 
| 10 | 75000 | 50000 | 1500 | 28571.43 | -5071.43 | -1775.0005 | -3296.43 | 25275 | 0.385543 | 9744.607 | 
| 11 | 75000 | 50000 | 1500 | 28571.43 | -5071.43 | -1775.0005 | -3296.43 | 25275 | 0.350494 | 8858.733 | 
| 12 | 75000 | 50000 | 1500 | 28571.43 | -5071.43 | -1775.0005 | -3296.43 | 25275 | 0.318631 | 8053.394 | 
| 13 | 75000 | 50000 | 1500 | 28571.43 | -5071.43 | -1775.0005 | -3296.43 | 25275 | 0.289664 | 7321.267 | 
| 14 | 75000 | 50000 | 1500 | 28571.43 | -5071.43 | -1775.0005 | -3296.43 | 25275 | 0.263331 | 6655.698 | 
| Total | 187775.3 | |||||||||
| NPV | = | Sum of PV of inflow-Initial outflow | ||||||||
| = | $187775.3-$400,000 | |||||||||
| = | $ (212,224.70) | |||||||||
| We will not accept the project since NPV is negative.It will decrease the value of the firm | ||||||||||
| There may be little differnce due to decimal places | ||||||||||
| Please upvote the answer | ||||||||||
| If you have any doubt,please ask | ||||||||||