prepare a list of acceptable projects in which to spend in the first quarter in order to increase the value of

Posted: December 30th, 2021

1. Input the positive cash flows due to production cost savings.. Sales revenues: Years 1-5 $135,000 per year; Years 6—10 $200,000 per year. Operating costs: Years 1—5 $95,000 per year; Years 6—10 $135,000 per year 2. Assume the major maintenance expenditure of $85,000 is made in Year 7.. Complete the five measures at the bottom of the spreadsheet. 3. Using Excel functions, given a hurdle rate calculate the project’s Net Present Value (=NPV) and the Internal Rate of Return (=IRR).4. Calculate the payback period and profitability index.- Provide a recommendation as to whether this project is acceptable.