Question

Silvana Zhang of Sajjad Jafri & Geopeng Li Limited is considering purchasing a new widget making machine. The new machine will replace the existing machine, which has a current market value of $1,000,000. New machine will reduce before tax operating cost by $300,000 per year for 15 years. The old machine is expected to last for another 10 years and will have a salvage value of $100,000 at the end of 10 years. The new machine is expected to last for 15 years and will have a salvage value of $200,000. CCA rate is 20%, tax rate is 30%, and the required rate of return is 15%

She would like to know the maximum price she should pay for the new machine.

Answer 1

Based on the given data, psl find below workings, steps and answer:

First, the cost of New Machine is assumed at 1$ to prepare the base workings; Once the NPV is generated, using GOAL SEEK option, the Maximum cost of New Machine is derived which shall result in the NPV of 0;

Hence, Silvana Zhang can invest maximum of $ 2314870 in the cost of New Machine.

Workings below, using the Cost of New Machine: You may observe, the NPV becomes Zero, when the cost of machine is considered at the derived maximum value of $ 2314870

Computation of Net Present Value (NPV) based on the Discounted Cash flows; The Discounting factor is computed based on the formula: For year 0, the discounting factor is 1; For Year 1, it is computed as = Year 0 factor /(1+discounting factor%) ; Year 2 = Year 1 factor/(1+discounting factor %) and so on;

Next, the cashflows need to be multiplied with the respective years' discounting factor, to arrive at the discounting cash flows;

The total of all the discounted cash flows is equal to its respective Project NPV of the Cash Flows;

Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Terminal -1 Currency in $ Project Cost of New Machine Salvage Value - New Machine Book Value Salvage Value - Old Machine 2,00,000 0 10,00,000 3,00,000 3,00,000 0 0 Gross Profit Depreciation EBIT Tax @ 30% Net Income 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 2,00,000 -60,000 1,40,000 9,99,999 1 Free Cash Flows (Net Income + Depreciation) Discounting Factor Discounted Cash Flow Cumulative Discounted Cash Flow Discounting Factor Net Present Value 2,10,000 0.8696 1,82,609 11,82,608 2,10,000 0.7561 1,58,790 13,41,398 2,10,000 0.6575 1,38,078 14,79,476 2,10,000 0.5718 1,20,068 15,99,545 2,10,000 0.4972 1,04,407 17,03,952 2,10,000 0.4323 90,789 17,94,741 2,10,000 0.3759 78,947 18,73,687 2,10,000 0.3269 68,649 19,42,337 2,10,000 0.2843 59,695 20,02,032 2,10,000 2,10,000 2,10,000 2,10,000 2,10,000 2,10,000 1,40,000 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 51,909 45,138 39,251 34,131 29,679 25,808 14,961 20,53,941 20,99,079 21,38,329 21,72,460 22,02,139 22,27,947 22,42,908 9,99,999 9,99,999 15% 22,42,908 10% 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # Depreciation Applied CCA 30% Class 10 for depreciating the asset #: Net Value of Asset GOAL SEEK: NPV Cost of New Machine 0 -26,72,304

Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Terminal -26,72,304 Currency in $ Project Cost of New Machine Salvage Value - New Machine Book Value Salvage Value - Old Machine 2,00,000 1,05,776 10,00,000 Gross Profit Depreciation EBIT Tax @ 30% Net Income 3,00,000 -2,67,230 32,770 -9,831 22,939 3,00,000 -4,81,015 -1,81,015 54,304 -1,26,710 3,00,000 -3,84,812 -84,812 25,444 -59,368 3,00,000 -3,07,849 -7,849 2,355 -5,495 3,00,000 -2,46,280 53,720 -16,1161 37,604 3,00,000 -1,97,024 1,02,976 -30,893 72,083 3,00,000 -1,57,619 1,42,381 -42,714 99,667 3,00,000 -1,26,095 1,73,905 -52,171 1,21,733 3,00,000 -1,00,876 1,99,124 -59,737 1,39,387 3,00,000 -80,701 2,19,299 -65,790 1,53,509 3,00,000 -64,561 2,35,439 -70,632 1,64,808 3,00,000 -51,649 2,48,351 -74,505 1,73,846 3,00,000 -41,319 2,58,681 -77,604 1,81,077 3,00,000 -33,055 2,66,945 -80,0831 1,86,861 3,00,000 -26,444 2,73,556 -82,067 1,91,489 94,224 -28,267 65,957 Free Cash Flows (Net Income + Depreciation) Discounting Factor Discounted Cash Flow Cumulative Discounted Cash Flow Discounting Factor Net Present Value -16,72,304 1 -16,72,304 -16,72,304 15% 2,90,169 0.8696 2,52,321 -14,19,983 3,54,304 0.7561 2,67,905 -11,52,078 3,25,444 0.6575 2,13,984 -9,38,094 3,02,355 0.5718 1,72,872 -7,65,221 2,83,884 0.4972 1,41,140 -6,24,081 2,69,107 0.4323 1,16,342 -5,07,738 2,57,286 0.3759 96,723 -4,11,015 2,47,829 0.3269 81,016 -3,30,000 2,40,263 0.2843 68,298 -2,61,702 2,34,210 0.2472 57,893 -2,03,809 2,29,368 0.2149 49,301 -1,54,508 2,25,495 0.1869 42,147 -1,12,361 2,22,396 0.1625 36,146 -76,215 2,19,917 0.1413 31,081 -45,135 2,17,933 0.1229 26,783 -18,352 1,71,733 0.1069 18,352 0 0 10% 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # Depreciation Applied CCA 30% Class 10 for depreciating the asset #: Net Value of Asset GOAL SEEK: NPV Cost of New Machine 0 -26,72,304

Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Terminal -1 Currency in $ Project Cost of New Machine Salvage Value - New Machine Book Value Salvage Value - Old Machine 2,00,000 0 10,00,000 3,00,000 3,00,000 0 0 Gross Profit Depreciation EBIT Tax @ 30% Net Income 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 0 3,00,000 -90,000 2,10,000 3,00,000 -90,000 2,10,000 -3,00,000 3,00,000 0 3,00,000 -90,000 2,10,000 2,00,000 -60,000 1,40,000 6,99,999 1 Free Cash Flows (Net Income + Depreciation) Discounting Factor Discounted Cash Flow Cumulative Discounted Cash Flow Discounting Factor Net Present Value 2,10,000 0.8696 1,82,609 8,82,608 2,10,000 0.7561 1,58,790 10,41,398 2,10,000 0.6575 1,38,078 11,79,476 2,10,000 0.5718 1,20,068 12,99,545 2,10,000 0.4972 1,04,407 14,03,952 2,10,000 0.4323 90,789 14,94,741 2,10,000 0.3759 78,947 15,73,687 2,10,000 0.3269 68,649 16,42,337 2,10,000 0.2843 59,695 17,02,032 2,10,000 2,10,000 2,10,000 2,10,000 2,10,000 2,10,000 1,40,000 0.2472 0.2149 0.1869 0.1625 0.1413 0.1229 0.1069 51,909 45,138 39,251 34,131 29,679 25,808 14,961 17,53,941 17,99,079 18,38,329 18,72,460 19,02,139 19,27,947 19,42,908 6,99,999 6,99,999 15% 19,42,908 10% 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # Depreciation Applied CCA 30% Class 10 for depreciating the asset #: Net Value of Asset GOAL SEEK: NPV Cost of New Machine 0 -23,14,870

Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Terminal -23,14,870 Currency in $ Project Cost of New Machine Salvage Value - New Machine Book Value Salvage Value - Old Machine 2,00,000 91,628 10,00,000 Gross Profit Depreciation EBIT Tax @ 30% Net Income 3,00,000 -2,31,487 68,513 -20,554 47,959 3,00,000 -4,16,677 -1,16,677 35,003 -81,674 3,00,000 -3,33,341 -33,341 10,002 -23,339 3,00,000 -2,66,673 33,327 -9,998 23,329 3,00,000 -2,13,338 86,662 -25,998 60,663 3,00,000 -1,70,671 1,29,329 -38,799 90,530 3,00,000 -1,36,537 1,63,463 -49,039 1,14,424 3,00,000 -1,09,229 1,90,771 -57,231 1,33,540 3,00,000 -87,383 2,12,617 -63,785 1,48,832 3,00,000 -69,907 2,30,093 -69,028 1,61,065 3,00,000 -55,925 2,44,075 -73,2221 1,70,852 3,00,000 -44,740 2,55,260 -76,578 1,78,682 3,00,000 -35,792 2,64,208 -79,2621 1,84,945 3,00,000 -28,634 2,71,366 -81,4101 1,89,956 3,00,000 -22,907 2,77,093 -83,128 1,93,965 -3,00,000 1,08,372 -32,512 75,860 Free Cash Flows (Net Income + Depreciation) Discounting Factor Discounted Cash Flow Cumulative Discounted Cash Flow Discounting Factor Net Present Value -16,14,870 1 -16,14,870 -16,14,870 15% 2,79,446 0.8696 2,42,997 -13,71,873 3,35,003 0.7561 2,53,310 -11,18,563 3,10,002 0.6575 2,03,832 -9,14,731 2,90,002 0.5718 1,65,810 -7,48,922 2,74,002 0.4972 1,36,227 -6,12,695 2,61,201 0.4323 1,12,924 -4,99,770 2,50,961 0.3759 94,346 -4,05,425 2,42,769 0.3269 79,362 -3,26,063 2,36,215 0.2843 67,147 -2,58,916 2,30,972 0.2472 57,093 -2,01,823 2,26,778 0.2149 48,744 -1,53,079 2,23,422 0.1869 41,759 -1,11,320 2,20,738 0.1625 35,876 -75,444 2,18,590 0.1413 30,893 -44,551 2,16,872 0.1229 26,652 -17,898 1,67,488 0.1069 17,899 0 0 10% 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # 20% on # Depreciation Applied CCA 30% Class 10 for depreciating the asset #: Net Value of Asset GOAL SEEK: NPV Cost of New Machine 0 -23,14,870