Royal Industries is contemplating on buying a new moulding machine at Rs 50 lakh, with an additional working capital requirement of Rs 10 lakh. The machine is expected to have an economic useful life of 5 years, with no salvage value. The firm follows the straight-line method of depreciation and the same is accepted for tax purposes. The machine is expected to generate an incremental increase in the before tax cash operating income of Rs 20 lakh (in real terms) per year for a period of 5 years. The relevant tax rate is 35 per cent. Inflation is expected to be 6 per cent per year and the firm’s cost of capital in real terms is 10 per cent. Advise the company whether the machine should be purchased. Show your NPV calculation in real terms. Assume the working capital requirement will remain unchanged throughout the period, in spite of inflation.
(d) Release of working capital (at year-end 5) \, Rs 10,00,000
\, (X) Discount factor at 0.06 (at year-end 5) \frac{(×) 0.747}{}
\, Cash inflows (real) \, 7,47,000
\, (X) Discount factor at 0.10 (at year-end 5) \frac{(×) 0.621}{}
\, Present value \frac{4,63,887}{}
(iii) Total present value
\, (a) Rs 49,28,300 + (c) Rs 11,29,796 + (d) Rs 4,63,887 \frac{65,21,983}{}
(iv) Net present value (Rs 65,21,983 – Rs 60,00,000) \, 5,21,983
Recommendation: The company should purchase the machine as the NPV of real cash flows is positive.
(i) Cash\> outflows | |
Rs 50,00,000 | Cost of moulding machine |
10,00,000
|
Additional working capital |
\frac{60,00,000}{} | |
(ii) CFAT\> and \>Present \>value | |
20,00,000 | (a) Incremental cash operating income |
7,00,000
|
Less taxes (0.35) |
13,00,000 | CFAT (t = 1 – 5) |
(×) 3.791
|
(X) PV factor of annuity for 5 years (0.10) |
49,28,300
|
Present value |
(b) Tax savings due to depreciation | |
10,00,000 | Depreciation (Rs 50 lakh/5 years) per year |
(×) 0.35
|
(X) Tax rate (0.35) |
3,50,000 | Tax savings per year for 5 years |
Total\>PV \, |
PVF\>at\>0.10 \, |
CFAT\>(Real) \, |
Discount/Deflated\>at 0.06\>rate\>of\>inflation* |
Tax\>savings (Nominal\>CFAT) |
Year \, |
Rs 3,00,015 | 0.909 | Rs 3,30,050 | 0.943 | Rs 3,50,000 | 1 |
2,57,299 | 0.826 | 3,11,500 | 0.890 | 3,50,000 | 2 |
2,20,794 | 0.751 | 2,94,000 | 0.840 | 3,50,000 | 3 |
1,89,328 | 0.683 | 2,77,200 | 0.792 | 3,50,000 | 4 |
1,62,360
|
0.621 | 2,61,450 | 0.747 | 3,50,000 | 5 |
11,29,796 | Present value |
*As per Table A-3
Table A-3 The Present Value of One Rupee
10\% | 9\% | 8\% | 7\% | 6\% | 5\% | 4\% | 3\% | 2\% | 1\% | Year |
.909 | .917 | .926 | .935 | .943 | .952 | .962 | .971 | .980 | 0.990 | 1 |
.826 | .842 | .857 | .873 | .890 | .907 | .925 | .943 | .961 | 0.980 | 2 |
.751 | .772 | .794 | .816 | .840 | .864 | .889 | .915 | .942 | .971 | 3 |
.683 | .708 | .735 | .763 | .792 | .823 | .855 | .888 | .924 | .961 | 4 |
.621 | .650 | .681 | .713 | .747 | .784 | .822 | .863 | .906 | .951 | 5 |
.564 | .596 | .630 | .666 | .705 | .764 | .790 | .837 | .888 | .942 | 6 |
.513 | .547 | .583 | .623 | .665 | .711 | .760 | .813 | .871 | .933 | 7 |
.467 | .502 | .540 | .582 | .627 | .677 | .731 | .789 | .853 | .923 | 8 |
.424 | .460 | .500 | .544 | .592 | .645 | .703 | .766 | .837 | .914 | 9 |
.386 | .422 | .463 | .508 | .558 | .614 | .676 | .744 | .820 | .905 | 10 |
.350 | .388 | .429 | .475 | .527 | .585 | .650 | .722 | .804 | .896 | 11 |
.319 | .356 | .397 | .444 | .497 | .575 | .625 | .701 | .789 | .887 | 12 |
.290 | .326 | .368 | .415 | .469 | .530 | .601 | .681 | .773 | .879 | 13 |
.263 | .299 | .340 | .388 | .442 | .505 | .577 | .661 | .758 | .870 | 14 |
.239 | .275 | .315 | .362 | .417 | .481 | .555 | .642 | .743 | .861 | 15 |
.218 | .252 | .292 | .339 | .394 | .458 | .534 | .623 | .728 | .853 | 16 |
.198 | .231 | .270 | .317 | .371 | .436 | .513 | .605 | .714 | .844 | 17 |
.180 | .212 | .250 | .296 | .350 | .416 | .494 | .587 | .700 | .836 | 18 |
.164 | .194 | .232 | .227 | .331 | .396 | .475 | .570 | .686 | .828 | 19 |
.149 | .178 | .215 | .258 | .312 | .377 | .456 | .554 | .673 | .820 | 20 |
.135 | .164 | .199 | .242 | .294 | .359 | .439 | .538 | .660 | .811 | 12 |
.123 | .150 | .184 | .226 | .278 | .342 | .422 | .522 | .647 | .803 | 22 |
.112 | .138 | .170 | .211 | .262 | .326 | .406 | .507 | .634 | .795 | 23 |
.102 | .126 | .158 | .197 | .247 | .310 | .390 | .492 | .622 | .788 | 24 |
.092 | .116 | .146 | .184 | .233 | .295 | .375 | .478 | .610 | .780 | 25 |
.057 | .075 | .099 | .131 | 174 | .231 | .308 | .412 | .552 | .742 | 30 |
.036 | .049 | .068 | .094 | .130 | .181 | .253 | .355 | .500 | .706 | 35 |
.022 | .032 | .046 | .067 | .097 | .142 | .208 | .307 | .453 | .672 | 40 |
.014 | .021 | .031 | .048 | .073 | .111 | .171 | .264 | .410 | .639 | 45 |
.009 | .013 | .021 | .034 | .054 | .087 | .141 | .228 | .372 | .608 | 50 |
20\% | 19\% | 18\% | 17\% | 16\% | 15\% | 14\% | 13\% | 12\% | 11\% | Year |
.833 | .840 | .847 | .855 | .862 | .870 | .877 | .885 | .893 | .901 | 1 |
.694 | .706 | .718 | .731 | .743 | .756 | .769 | .783 | .797 | .812 | 2 |
.579 | .593 | .609 | .624 | .641 | .658 | .675 | .693 | .712 | .731 | 3 |
.482 | .499 | .516 | .534 | .552 | .572 | .592 | .613 | .636 | .659 | 4 |
.402 | .419 | .437 | .456 | .476 | .497 | .519 | .543 | .567 | .593 | 5 |
.335 | .352 | .370 | .390 | .410 | .432 | .456 | .480 | .507 | .535 | 6 |
.279 | .296 | .314 | .333 | .354 | .376 | .400 | .425 | .452 | .482 | 7 |
.233 | .249 | .266 | .285 | .305 | .327 | .351 | .376 | .404 | .434 | 8 |
.194 | .209 | .225 | .243 | .263 | .284 | .308 | .333 | .361 | .391 | 9 |
.162 | .176 | .191 | .208 | .227 | .274 | .270 | .295 | .322 | .352 | 10 |
.135 | .184 | .162 | .178 | .195 | .215 | .237 | .261 | .287 | .317 | 11 |
.112 | .124 | .137 | .152 | .168 | .187 | .208 | .231 | .257 | .286 | 12 |
.093 | .104 | .116 | .130 | .145 | .163 | .182 | .204 | .229 | .258 | 13 |
.078 | .088 | .099 | .111 | .125 | .141 | .160 | .181 | .205 | .232 | 14 |
.065 | .074 | .084 | .095 | .108 | .123 | .140 | .160 | .183 | .209 | 15 |
.054 | .062 | .071 | .081 | .093 | .107 | .123 | .141 | .163 | .188 | 16 |
.045 | .052 | .060 | .069 | .080 | .093 | .108 | .125 | .146 | .170 | 17 |
.038 | .044 | .051 | .059 | .069 | .081 | .095 | .111 | .130 | .153 | 18 |
.031 | .037 | .043 | .051 | .060 | .070 | .083 | .098 | .116 | .138 | 19 |
.026 | .031 | .037 | .043 | .051 | .061 | .073 | .087 | .104 | .124 | 20 |
.022 | .026 | .031 | .037 | .044 | .053 | .064 | .077 | .093 | .112 | 21 |
.018 | .022 | .026 | .032 | .038 | .046 | .056 | .068 | .083 | .101 | 22 |
.015 | .018 | .022 | .027 | .033 | .040 | .049 | .060 | .074 | .091 | 23 |
.013 | .015 | .019 | .023 | .028 | .035 | .043 | .053 | .066 | .082 | 24 |
.010 | .013 | .016 | .020 | .024 | .030 | .038 | .047 | .059 | .074 | 25 |
.004 | .005 | .007 | .009 | .012 | .015 | .020 | .026 | .033 | .044 | 30 |
.002 | .002 | .003 | .004 | .006 | .008 | .010 | .014 | .019 | .026 | 35 |
.001 | .001 | .001 | .002 | .003 | .004 | .005 | .008 | .011 | .015 | 40 |
.000 | .000 | .001 | .001 | .001 | .002 | .003 | .004 | .006 | .009 | 45 |
.000 | .000 | .000 | .001 | .001 | .001 | .001 | .002 | .003 | .005 | 50 |
30\% | 29\% | 28\% | 27\% | 26\% | 25\% | 24\% | 23\% | 22\% | 21\% | Year |
.769 | .775 | .781 | .787 | .794 | .800 | .806 | .813 | .820 | .826 | 1 |
.592 | .601 | .610 | .620 | .630 | .640 | .650 | .661 | .672 | .683 | 2 |
.455 | .466 | .477 | .488 | .500 | .512 | .524 | .537 | .551 | .564 | 3 |
.350 | .361 | .373 | .384 | .397 | .410 | .423 | .437 | .451 | .467 | 4 |
.269 | .280 | .291 | .303 | .315 | .328 | .341 | .355 | .370 | .386 | 5 |
.207 | .217 | .227 | .238 | .250 | .262 | .275 | .289 | .303 | .319 | 6 |
.159 | .168 | .178 | .188 | .198 | .210 | .222 | .235 | .249 | .263 | 7 |
.123 | .130 | .139 | .148 | .157 | .168 | .179 | .191 | .204 | .218 | 8 |
.094 | .101 | .108 | .116 | .125 | .134 | .144 | .155 | .167 | .180 | 9 |
.073 | .078 | .085 | .092 | .099 | .107 | .116 | .126 | .137 | .149 | 10 |
.056 | .061 | .066 | .072 | .079 | .086 | .094 | .103 | .112 | .123 | 11 |
.043 | .047 | .052 | .057 | .062 | .069 | .076 | .083 | .092 | .102 | 12 |
.033 | .037 | .040 | .045 | .050 | .055 | .061 | .068 | .075 | .084 | 13 |
.025 | .028 | .032 | .035 | .039 | .044 | .049 | .055 | .062 | .069 | 14 |
.020 | .022 | .025 | .028 | .031 | .035 | .040 | .045 | .051 | .057 | 15 |
.015 | .017 | .019 | .022 | .025 | .028 | .032 | .036 | .042 | .047 | 16 |
.012 | .013 | .015 | .017 | .020 | .023 | .026 | .030 | .034 | .039 | 17 |
.009 | .010 | .012 | .014 | .016 | .018 | .021 | .024 | .028 | .032 | 18 |
.007 | .008 | .009 | .011 | .012 | .014 | .017 | .020 | .023 | .027 | 19 |
.005 | .006 | .007 | .008 | .010 | .012 | .014 | .016 | .019 | .022 | 20 |
.004 | .005 | .006 | .007 | .008 | .009 | .011 | .013 | .015 | .018 | 21 |
.003 | .004 | .004 | .005 | .006 | .007 | .009 | .011 | .013 | .015 | 22 |
.002 | .003 | .003 | .004 | .005 | .006 | .007 | .009 | .010 | .012 | 23 |
.002 | .002 | .003 | .003 | .004 | .005 | .006 | .007 | .008 | .010 | 24 |
.001 | .002 | .002 | .003 | .003 | .004 | .005 | .006 | .007 | .009 | 25 |
.000 | .000 | .001 | .001 | .001 | .001 | .002 | .002 | .003 | .003 | 30 |
.000 | .000 | .000 | .000 | .000 | .000 | .001 | .001 | .001 | .001 | 35 |
.000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | 40 |
.000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | 45 |
.000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | .000 | 50 |