Management are considering a project to buy and operate a major item of equipment. Your boss is extremely enthusiastic about the project, arguing that (i) it has a very high rate of retum and acceptable payback period, and (ii) it will definitely add to shareholder value. The equipment costs $375,000, is anticipated to be sold at the end of year 5 for $45,000, and will be depreciated straight line over the five-year period. The equipment will be used to manufacture a new type of electrical switch which will be sold at a price of $1.70 per unit. Expenses associated with this project other than depreciation can be assumed to be 46% of the sales revenue. The relevant discount rate is 12.0% and can be assumed to be the hurdle rate for both the accounting rate of return and the internal rate of return. The sales forecast is given by the following table: Required: 1) Calculate the projected yearly profit for the project. Ensure that your measure of profit is relevant for any (5 marks) appraisal measure as discussed in the lectures/textbook. Present your analysis in the table in section 1, Part A of the template. 2)PrepareatableshowingALLtheprojectsnetcashflows,excludingworkingcapitalrequirements.Presentyour(4marks)analysisinthetableinsection2,PartAofthetemplate. 3) Calculate the accounting rate of return, and show your answer as a percentage with 2 decimal places (e.g. (2 marks) 4)(5marks)Prepareatableofcumulativecashflowssuitableforcalculatingthepaybackperiod,andcalculatethepaybackperiod(templatesection4,PartA). What can you conclude about the project and about the statements made by your boss, based solely on the project's ARR and payback period? Enter your response in template section 5, Part A. Prepare a table of cash flows, discount factors and present values relevant for calculation of the net present value (NPV), and calculate the project's NPV (template section 6, Part A). Calculate the project's internal rate of return (IRR), and show your answer as a percentage with 2 decimal places (e.g. 12.34\%) (template section 7, Part A). Assume that customers take one month to pay, the project requires inventory of $15,000 to be held, that accounts payable attributable to the project has a permanent balance of $10,000, and that working capital requirements are in place at the start of each year. Prepare a table to show the effect of these considerations on the project's cash flows (template section 8, Part A). Comment, in general terms, about how working capital requirements affect the cash flows and the NPV of the project (template section 9, Part A). Based on your analysis, what are your recommendations regarding this project? Do you agree with the comments made by your boss? Why or why not? (template section 10, Part A) Management are considering a project to buy and operate a major item of equipment. Your boss is extremely enthusiastic about the project, arguing that (i) it has a very high rate of retum and acceptable payback period, and (ii) it will definitely add to shareholder value. The equipment costs $375,000, is anticipated to be sold at the end of year 5 for $45,000, and will be depreciated straight line over the five-year period. The equipment will be used to manufacture a new type of electrical switch which will be sold at a price of $1.70 per unit. Expenses associated with this project other than depreciation can be assumed to be 46% of the sales revenue. The relevant discount rate is 12.0% and can be assumed to be the hurdle rate for both the accounting rate of return and the internal rate of return. The sales forecast is given by the following table: Required: 1) Calculate the projected yearly profit for the project. Ensure that your measure of profit is relevant for any (5 marks) appraisal measure as discussed in the lectures/textbook. Present your analysis in the table in section 1, Part A of the template. 2)PrepareatableshowingALLtheprojectsnetcashflows,excludingworkingcapitalrequirements.Presentyour(4marks)analysisinthetableinsection2,PartAofthetemplate. 3) Calculate the accounting rate of return, and show your answer as a percentage with 2 decimal places (e.g. (2 marks) 4)(5marks)Prepareatableofcumulativecashflowssuitableforcalculatingthepaybackperiod,andcalculatethepaybackperiod(templatesection4,PartA). What can you conclude about the project and about the statements made by your boss, based solely on the project's ARR and payback period? Enter your response in template section 5, Part A. Prepare a table of cash flows, discount factors and present values relevant for calculation of the net present value (NPV), and calculate the project's NPV (template section 6, Part A). Calculate the project's internal rate of return (IRR), and show your answer as a percentage with 2 decimal places (e.g. 12.34\%) (template section 7, Part A). Assume that customers take one month to pay, the project requires inventory of $15,000 to be held, that accounts payable attributable to the project has a permanent balance of $10,000, and that working capital requirements are in place at the start of each year. Prepare a table to show the effect of these considerations on the project's cash flows (template section 8, Part A). Comment, in general terms, about how working capital requirements affect the cash flows and the NPV of the project (template section 9, Part A). Based on your analysis, what are your recommendations regarding this project? Do you agree with the comments made by your boss? Why or why not? (template section 10, Part A)