I have attached screenshots of the instructions for the assignment I am working on. I need help calculating Nominal payback, Discounted payback, Net Present Value, Internal Rate of Return.

If someone can give me an example or formula for this based on the content I have attached that would be great! You don't have to use the exact numbers from the attachments, I just need help understanding how to input the data provided into the proper formulas. Thanks in advance for your time and consideration.

The company has been growing steadily over the past 5 years, and the financials and future prospects look good. Your CEO has asked you to run the numbers. After doing some digging into the business, you have gathered information on the following: o The estimated purchase price for the equipment required to move the operation in-house would be $500,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed in the amount of $25,000 per year starting in year 0 and through all 5 years of the project to support production. 0 The current spending on this component (i.e. annual spend pool) is $875,000. The estimated cash flow savings of bringing the process in-house is 20% or annual savings of $175,000. This includes the additional labor and overhead costs required. 0 Your company has access to a credit line and could borrow the funds at a rate of 6%. 0 Finally, the equipment required is anticipated to have a somewhat short useful life, as a new wave of technology is on the horizon. Therefore, it is anticipated that the equipment will be sold after five years for $25,000. (i.e. the terminal value). Input from Stakeholders As part of your research, you have sought input from a number of stakeholders. Each has raised important points to consider in your analysis and recommendation. Some of the points and assumptions are purely financial. Others touch on additional concerns and opportunities. 1. Ann, your colleague from Accounting, recommends using the base assumptions above: 5-year project life, flat annual savings, and 10% discount rate. Ann does not feel the equipment will have any terminal value due to advancements in technology. 2. Steve from Sales is convinced that this capability would create a new revenue stream that could significantly offset operating expenses. He recommends savings that grow each year: 5-year project life, 10% discount rate, and a 10% compounded annual savings growth in years 2 through 5. In other words, instead of assuming savings stay flat, assume that they will grow by 10% in year 2, and then grow another 10% over year 2 in year 3, and so on. 3. Ellen from Engineering believes we use a higher Discount Rate because of the risk of this type of project. As such, she is recommending a 5-year project life and flat annual savings. Ellen suggests that even though the equipment is brand new, the updated production process could have a negative impact on other parts of the overall manufacturing costs. She argues that, while it is difficult to quantify the potential negative impacts, to account for the risk, a 14% discount rate should be used. Peter, the Product Manager, is convinced the new capability will allow better control of quality and on-time delivery, and that it will last longer than 5 years. He recommends using a 7 Year Equipment Life (which means a 7-year project and savings life), flat annual savings, 10% discount rate. In other words, assume that the machine will last 2 more years and deliver 2 more years of savings. Peter also feels the equipment will have an estimated terminal value of $15,000 at the end of its 7year useful life. Owen, the head of Operations, is concerned that instead of stabilizing the supply chain, it will just add another process to be managed, and will distract from the core competencies the company currently has. He feels the company should focus on improving communication and supply chain management with its current vendor, and he feels confident he can negotiate a discount of 5% off of the annual outsourcing cost of $875,000 if he lets it be known they are considering taking over this step of the process. As there is little risk associated with Owen's proposal due to no upfront capital requirements, a lower risk-free discount rate of 7% would be appropriate. (NOTE: because there is no \"investment\Using the data presented above (and ignoring the extraneous information), for this profit and supply chain improvement project, calculate each of the following (where applicable): 0 Nominal Payback 0 Discounted Payback 0 Net Present Value 0 Internal Rate of Return Scenario Nominal Payback Discounted Payback Net Present Value Internal Rate of Return