The question is completing the Excel file for part A years 0- 5 and for Part B: 0-3 and answering what NPV and IRR are.

Modern Machine, Inc., is considering a new 5-year project that requires an initial fixed asset investment of 654 million. The fixed asset will be depreciated using MACRS for its 5-year life, after which it can be sold for 300 million. The project is estimated to generate 990 million in annual sales, with costs of 90 million, each year. The tax rate is 34 percent, and the WACC is 10 percent. The project requires an initial investment in net working capital at initiation of the project of $15 million, with additional increases of $5 million at years 2 &3 (this total investment of NWC returns to the firm at the completion of the project, year 5). In addition to the purchase of the machine and change in net working capital, management has determined that the new machine will require an opportunity cost of $150 million at initiation (this will also be a cash inflow at the end of the project).

Year	0	1	2	3	4	5
Cost of New Machine
Accum. Depreciation
Book Value of Machine
Opportunity Cost
Net Working Capital Balance
Change in NWC
Salvage Value of Machine
Tax on Sale of Machine
Cap. Ex. & NWC
Add'l Sales Revenue
Add'l Operating Costs
Depreciation
EBIT
Tax (34%)
Net Income
Cash Flow from Operations (OCF)
Cap. Ex. & NWC
Total Incremental CF of Project
What is the NPV and IRR of this project?
Discount Rate
NPV
IRR

Modern Machine has the alternative of investing in a 3-year machine that costs 540 million, requires the same opportunity cost, a 10 million increase in NWC at initiation and a 5 million investment at time 2. This machine will increase sales by 200 million and costs by 180 million, each year.

**The highlighted cells should have numbers, the rest formulas**
Cash Flow of Cap. Budg.	Project B
Year	0	1	2	3
Cost of New Machine
Accum. Depreciation
Book Value of Machine
Opportunity Cost
Net Working Capital Balance
Change in NWC
Salvage Value of Machine
Tax on Sale of Machine
Cap. Ex. & NWC
Add'l Sales Revenue
Add'l Operating Costs
Depreciation
EBIT
Tax (34%)
Net Income
Cash Flow from Operations (OCF)
Cap. Ex. & NWC
Total Incremental CF of Project
What is the NPV and IRR of this project?								What is the NPV and IRR of the 3-year machine?
Discount Rate
NPV
IRR

MACRS Table
3 Year Life		33.30%	44.40%	14.80%	7.50%
5		20.00%	32.00%	19.20%	11.50%	11.50%	5.80%
7		14.30%	24.50%	17.50%	12.50%	8.90%	8.90%	8.90%	4.50%
10		10.00%	18.00%	14.40%	11.50%	9.20%	7.40%	6.60%	6.60%	6.60%	6.60%	3.10%

Part A. Modern Machine, Inc., is considering a new 5-year project that requires an initial fixed asset investment of 654 million. The fixed asset will be depreciated using MACRS for its 5-year life, after which it can be sold for 300 million. The project is estimated to generate 990 million in annual sales, with costs of 90 million, each year. The tax rate is 34 percent, and the WACC is 10 percent. The project requires an initial investment in net working capital at initiation of the project of $15 million, with additional increases of $5 million at years 2 &3 (this total investment of NWC returns to the firm at the completion of the project, year 5). In addition to the purchase of the machine and change in net working capital, management has determined that the new machine will require an opportunity cost of $150 million at initiation (this will also be a cash inflow at the end of the project). Part B.

Modern Machine has the alternative of investing in a 3-year machine that costs 540 million, requires the same opportunity cost, a 10 million increase in NWC at initiation and a 5 million investment at time 2. This machine will increase sales by 200 million and costs by 180 million, each year. The question is completing the Excel file for part A years 0- 5 and for Part B: 0-3