Rose is considering a project which requires new equipment at a cost of $170,000. The equipment has a 3-year tax life and will be depreciated by the MACRS method. When the project closes down at the end of the third year, it is expected to sell for $50,000 before taxes. To launch the project new working capital of $30,000 is required; it is expected to be fully recovered at the end of the project's life. Project revenues of $115,000 and operating costs of $65,000 apart from depreciation are forecast. No inflation is expected. The firm faces a tax rate of 35% and the project has a discount rate of 11%. The MACRS rates for a 3-yr project are: 33.33%, 44.45%, 14.81%, and 7.41% for years 1 through 4, respectively. Answer the following questions in a new Excel tab, placing the company name at the top of the page. Use this information to answer the following five questions. Show all inputs and steps that you used to arrive at your answers.

Question 1: What is the initial outlay for the project?

Question 2: What is the operating cash flow for each year of the project?

Question 3: What is the amount of the terminal value (ie not including the operating cash flow) that occurs in the last year of the project life?

Question 4: What is the NPV and MIRR of the project?

Question 5: Would you accept the project? Explain?

ansver the Questions asked in the problem. Shoy the steps in your solution below the question (starting in row 29); highlight your answer below, and place it in the designated spot for each (rows 9 - 27) Question 1: _That is the initial outlay for the project? Outlay = Question 2: That is the operating cash flot for each year of the project? T1 T2 T3 continue as needed Operating CF: Question 3: _That is the arount of the terrinal value (ie not including the operating cash flow) that occurs in the last year of the project life? Terrinal Val= Question 4: That is the NPV and IIRR of the project? HPV = TIRR= Question 5: Tould you accept the project? Explain? Accept or Reject? Fynlain