In: Finance
Delia Landscaping is considering a new 4-year project. The necessary fixed assets will cost $203,000 and be depreciated on a 3-year MACRS and have no salvage value. The MACRS percentages each year are 33.33 percent, 44.45 percent, 14.81 percent, and 7.41 percent, respectively. The project will have annual sales of $140,000, variable costs of $37,900, and fixed costs of $13,050. The project will also require net working capital of $3,650 that will be returned at the end of the project. The company has a tax rate of 40 percent and the project's required return is 11 percent. What is the net present value of this project?
| Step-1:Calculation of Operating cash flow for the year | ||||||||||
| Year | 1 | 2 | 3 | 4 | ||||||
| Sales | $ 1,40,000 | $ 1,40,000 | $ 1,40,000 | $ 1,40,000 | ||||||
| Variable cost | -37,900 | -37,900 | -37,900 | -37,900 | ||||||
| Fixed Costs | -13,050 | -13,050 | -13,050 | -13,050 | ||||||
| Depreciation | -67,660 | -90,234 | -30,064 | -15,042 | ||||||
| Profit Before tax | 21,390 | -1,184 | 58,986 | 74,008 | ||||||
| Tax Expense | -8,556 | 473 | -23,594 | -29,603 | ||||||
| Net Income | 12,834 | -710 | 35,391 | 44,405 | ||||||
| Depreciation | 67,660 | 90,234 | 30,064 | 15,042 | ||||||
| Operating cash flow | 80,494 | 89,523 | 65,456 | 59,447 | ||||||
| Working: | ||||||||||
| Depreciation Schedule: | ||||||||||
| Year | Cost | Depreciation rate | Dereciation Expense | |||||||
| 1 | 2,03,000 | 33.33% | 67,660 | |||||||
| 2 | 2,03,000 | 44.45% | 90,234 | |||||||
| 3 | 2,03,000 | 14.81% | 30,064 | |||||||
| 4 | 2,03,000 | 7.41% | 15,042 | |||||||
| Step-2:Calculation of net present value | ||||||||||
| Year | 0 | 1 | 2 | 3 | 4 | Total | ||||
| Operating cash flow | $ 80,494 | $ 89,523 | $ 65,456 | $ 59,447 | ||||||
| Fixed Asset | $ -2,03,000 | |||||||||
| Net Working capital | $ -3,650 | |||||||||
| Release of net working capital | $ 3,650 | |||||||||
| Cash flow | $ -2,06,650 | $ 80,494 | $ 89,523 | $ 65,456 | $ 63,097 | |||||
| Discount factor | 1.0000 | 0.9009 | 0.8116 | 0.7312 | 0.6587 | |||||
| Present Value | $ -2,06,650 | $ 72,517 | $ 72,659 | $ 47,861 | $ 41,564 | $ 27,951 | ||||
| Thus, | ||||||||||
| Net Present Value is | $ 27,951 | |||||||||