Kelly's Kite Shop, Inc. is thinking of expanding their operations by buying a new machine that designs special aerodynamic cloths for high-end kite flyers. This machine is expected to be operational for four years. During the first year, they expect sales to be $165,000. Further, they expect that over the remaining three years of the project, the sales amount can be increased by 10% each subsequent year. After an in-depth analysis, they have also concluded that costs for the project should always be approximately 55% of sales for each year. Further, the machine is going to be depreciated as a MACRS 3-year property class.
The actual machine will cost $175,000, but Kelly will also have to increase inventories and hire an additional employee to run the machine. Therefore, NWC will have to increase by $60,000 as well. However, you will recover 60% of the increase at the completion of the project. In addition, you feel you can sell the machine for $25,000 at the end.
a).Using all the above information, complete the following table. Round to the nearest dollar. The more work you can neatly show me, the more points you will get in case you have an error.
|
Year 0
|
Year 1
|
Year 2
|
Year 3
|
Year 4
|
|
OCF
|
|
|
|
|
|
|
NCS
|
|
|
|
|
|
|
Change in NWC
|
|
|
|
|
|
|
NCF
|
|
|
|
|
|
b). What is the NPV of this project, given k = 10%? Should you accept or reject?
c). What is the discounted payback period of the project, given k =10%. Round this to 2 decimal places. Should you accept or reject?