In: Finance
Maria is evaluating an idea to open her own business. The initial investment is 34 estimated to be $100,000. The investment horizon is 5 years. She will use a 5-year straight-line depreciation schedule, with an ending book value of zero for the assets. The salvage value for the assets at the end of the project is $20,000. The initial working capital requirement is $10,000 and the working capital remains to be $10,000 each year. Maria expects to generate the revenues of $80,000 with the costs of $30,000 each year during the 5-year time period. The tax rate is 20%. Compute the net present value (NPV) for this investment using the required return of 12%.
Time line | 0 | 1 | 2 | 3 | 4 | 5 | |
Cost of new machine | -100000 | ||||||
Initial working capital | -10000 | ||||||
=Initial Investment outlay | -110000 | ||||||
Sales | 80000 | 80000 | 80000 | 80000 | 80000 | ||
Profits | Sales-variable cost | 50000 | 50000 | 50000 | 50000 | 50000 | |
-Depreciation | Cost of equipment/no. of years | -20000 | -20000 | -20000 | -20000 | -20000 | |
-working capital to be maintained | -10000 | -10000 | -10000 | -10000 | -10000 | ||
=Pretax cash flows | 20000 | 20000 | 20000 | 20000 | 20000 | ||
-taxes | =(Pretax cash flows)*(1-tax) | 16000 | 16000 | 16000 | 16000 | 16000 | |
+Depreciation | 20000 | 20000 | 20000 | 20000 | 20000 | ||
=after tax operating cash flow | 36000 | 36000 | 36000 | 36000 | 36000 | ||
reversal of working capital | 60000 | ||||||
+Proceeds from sale of equipment after tax | =selling price* ( 1 -tax rate) | 16000 | |||||
+Tax shield on salvage book value | =Salvage value * tax rate | 0 | |||||
=Terminal year after tax cash flows | 76000 | ||||||
Total Cash flow for the period | -110000 | 36000 | 36000 | 36000 | 36000 | 112000 | |
Discount factor= | (1+discount rate)^corresponding period | 1 | 1.12 | 1.2544 | 1.404928 | 1.57351936 | 1.7623417 |
Discounted CF= | Cashflow/discount factor | -110000 | 32142.85714 | 28698.9796 | 25624.0889 | 22878.6508 | 63551.808 |
NPV= | Sum of discounted CF= | 62896.38432 |