In: Finance
Down Under Boomerang, Inc., is considering a new 3-year expansion project that requires an initial fixed asset investment of $1.296 million. The fixed asset falls into the 3-year MACRS class (MACRS Table) and will have a market value of $100,800 after 3 years. The project requires an initial investment in net working capital of $144,000. The project is estimated to generate $1,152,000 in annual sales, with costs of $460,800. The tax rate is 31 percent and the required return on the project is 16 percent. The net cash flow in Year 0 is $ the net cash flow in Year 1 is $ the net cash flow in Year 2 is $ and the net cash flow in Year 3 is $ . The NPV for this project is $ . (Do not include the dollar signs ($). Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places. (e.g., 32.16)) |
a. | |||||||||||||
The Net Cash flow in Year 0 | $ -14,40,000.00 | ||||||||||||
Working: | |||||||||||||
Initial Fixed Asset Investment | $ 12,96,000 | ||||||||||||
Initial investment in net working capital | $ 1,44,000 | ||||||||||||
The net Cash flows in Year 0 | $ -14,40,000 | ||||||||||||
b. | |||||||||||||
The Net cash flow in year 1 | $ 6,10,834.61 | ||||||||||||
Working: | |||||||||||||
i. | Depreciation Schedule | ||||||||||||
Year | Costs (1) | Depreciation rate (2) | Depreciation Expense (3) | Accumulated Depreciation (4) | Ending Book Value (5)= (1) -(4) | ||||||||
1 | $ 12,96,000 | 33.33% | $ 4,31,957 | $ 4,31,957 | $ 8,64,043 | ||||||||
2 | $ 12,96,000 | 44.45% | $ 5,76,072 | $ 10,08,029 | $ 2,87,971 | ||||||||
3 | $ 12,96,000 | 14.81% | $ 1,91,938 | $ 11,99,966 | $ 96,034 | ||||||||
ii. | Annual Sales | $ 11,52,000 | |||||||||||
Annual Cost | $ -4,60,800 | ||||||||||||
Depreciation Expense | $ -4,31,957 | ||||||||||||
Profit Before Tax | $ 2,59,243 | ||||||||||||
Tax Expense | $ -80,365 | ||||||||||||
Net Income | $ 1,78,878 | ||||||||||||
Depreciation Expense | $ 4,31,957 | ||||||||||||
Annual Cash flow | $ 6,10,835 | ||||||||||||
c. | |||||||||||||
The Net cash flow in Year 2 | $ 6,10,834.61 | ||||||||||||
d. | |||||||||||||
Net Cash fllow in Year 3 | $ 8,54,157.02 | ||||||||||||
Working: | |||||||||||||
i. | Sale Proceeds | a | $ 1,00,800 | ||||||||||
Book Value | b | $ 96,034 | |||||||||||
profit on sale | c=a-b | $ 4,766 | |||||||||||
Tax on Profit on sale | d=c*31% | $ 1,478 | |||||||||||
After tax sale proceeds | a-d | $ 99,322 | |||||||||||
ii. | |||||||||||||
Annual operating cash flow | $ 6,10,835 | ||||||||||||
After Tax Sale of Fixed Assets | $ 99,322 | ||||||||||||
Release of workig capital | $ 1,44,000 | ||||||||||||
Net Cash flow | $ 8,54,157 | ||||||||||||
e. | |||||||||||||
The NPV for this project is | $ 87,753.43 | ||||||||||||
Working: | |||||||||||||
Year | Cash flow | Discount factor | Present Value | ||||||||||
0 | $ -14,40,000 | 1.0000 | $ -14,40,000.00 | ||||||||||
1 | $ 6,10,835 | 0.8621 | $ 5,26,581.56 | ||||||||||
2 | $ 6,10,835 | 0.7432 | $ 4,53,949.62 | ||||||||||
3 | $ 8,54,157 | 0.6407 | $ 5,47,222.25 | ||||||||||
Net Present value | $ 87,753.43 | ||||||||||||