Question

Atlantic Manufacturing is considering a new investment project that will last for four years. The delivered and installed cost of the machine needed for the project is $22971 and it will be depreciated according to the three-year MACRS schedule. The project also requires an initial increase in net working capital o

I am having a difficult time understanding this can someone show me how to calculate the MACRS. and can show me how to do this on an excel spreadsheet. thank you.Atlantic Manufacturing is considering a new investment project that will last for four years. The delivered and installed cost of the machine needed for the project is $22971 and it will be depreciated according to the three-year MACRS schedule. The project also requires an initial increase in net working capital of $308. Financial projections for sales and costs are in the table below. In addition, since sales are expected to fluctuate, NWC requirements will also fluctuate. The end-of-year NWC requirements are included below (hint: these NWC capital requirements DO NOT represent the change in NWC for the period). The $0 requirement for NWC at the end of year 4 means that all NWC is recovered by the end of the project. The corporate tax rate is 35% and the required return on the project is 12%.

Year	1	2	3	4
Sales	$11821	$12604	$13663	$10811
Costs	2176	2560	3330	1276
NWC Requirements	329	359	216	0

What is the project’s NPV?

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE