341 Inc. is cоnsidering the purchаse оf аn аutоmated parts handler for the assembly and test area of its Fairfax, Virginia, plant. The handler will cost $550,000 to purchase. There is also a 5% of that cost for initial equipment installation, which the company can treat as part of the initial investment. If the company undertakes the investment, it will automate part of the semiconductor test area and result in net savings of 6.6% of their revenues every year for the next ten years. The firm’s current annual revenues are $2,000,000 with zero growth forecast for next ten years (that is why this project looks attractive as this is one way they can increase their bottom line – by savings rather than by increasing their sales). Five years into the life of the investment, however, 341 Inc. will have to spend an additional $75,000 to update and refurbish the handler. The initial investment in the handler will be depreciated to zero book value using straight-line depreciation over ten years, and the refurbishing costs will be depreciated over the remaining life of the handler (also using straight-line depreciation). At the end of the project’s life, which is taken as ten years, the handler is expected to sold for $10,000, although its book value will be zero. 341 Inc. ’s tax rate is 35%, and its opportunity cost of capital is 12.0%. Build a DCF model - using the exact same template as given in the attached Spreadsheet - to evaluate the handler’s contribution to firm value. Answer each of the following questions concerning the project in the attached template Spreadsheet and upload your completed spreadsheet as your submission: Question 1: What are the project’s Free Cash Flows? You can assume that the realized savings are net of all costs. Also, compute the NPV and IRR of the project. Question 2: If the project needed an initial Working Capital of $15,000 till year 5, and then $20,000 from Year 5 and later, compute the Free Cash Flows, NPV, and IRR of the project. Note that, at the end of the project, the firm liquidates all of its investment in working capital. Hint: You need to recalculate the FCFs - updating any line items that might need any changes.
Mаtch the indicаted letters tо the lаndmark structures?