In: Finance
Delia Landscaping is considering a new 4-year project. The necessary fixed assets will cost $169,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 $104,000, variable costs of $27,600, and fixed costs of $12,200. The project will also require net working capital of $2,800 that will be returned at the end of the project. The company has a tax rate of 34 percent and the project's required return is 9 percent. What is the net present value of this project?
Net Present value is $ 16,111.90
Year | 0 | 1 | 2 | 3 | 4 |
Fixed asset | $ -1,69,000.00 | ||||
Working Capital | $ -2,800.00 | ||||
Sales | $ 1,04,000.00 | $ 1,04,000.00 | $ 1,04,000.00 | $ 1,04,000.00 | |
Variable cost | $ -27,600.00 | $ -27,600.00 | $ -27,600.00 | $ -27,600.00 | |
Fixed Cost | $ -12,200.00 | $ -12,200.00 | $ -12,200.00 | $ -12,200.00 | |
Depreciation | $ -56,327.70 | $ -75,120.50 | $ -25,028.90 | $ -12,522.90 | |
Profit Before tax | $ 7,872.30 | $ -10,920.50 | $ 39,171.10 | $ 51,677.10 | |
Tax Expense | $ -2,676.58 | $ 3,712.97 | $ -13,318.17 | $ -17,570.21 | |
Net Income | $ 5,195.72 | $ -7,207.53 | $ 25,852.93 | $ 34,106.89 | |
Depreciation | $ 56,327.70 | $ 75,120.50 | $ 25,028.90 | $ 12,522.90 | |
Operating cash flow | $ 61,523.42 | $ 67,912.97 | $ 50,881.83 | $ 46,629.79 | |
Release of working capital | $ 2,800.00 | ||||
Total cash flow | $ -1,71,800.00 | $ 61,523.42 | $ 67,912.97 | $ 50,881.83 | $ 49,429.79 |
Discount factor @ 9% | 1.0000 | 0.9174 | 0.8417 | 0.7722 | 0.7084 |
Present Value | $ -1,71,800.00 | $ 56,443.50 | $ 57,160.99 | $ 39,290.11 | $ 35,017.31 |
Net Present Value | $ 16,111.90 | ||||
Working: | |||||
Depreciation Schedule: | |||||
Year | 1 | 2 | 3 | 4 | |
Cost | $ 1,69,000.00 | $ 1,69,000.00 | $ 1,69,000.00 | $ 1,69,000.00 | |
Depreciation rate | 33.33% | 44.45% | 14.81% | 7.41% | |
Depreciation expense | $ 56,327.70 | $ 75,120.50 | $ 25,028.90 | $ 12,522.90 |