NPV Assignment Version 12 IRR Instructions: 1) Cornplete the above worksheot using the information provided in the scenario at the top fight. 2 A Yellow box means you need to insert numbers either hard coded or via a simple formula 3) An Orange box means you need to derive what goes here by use of an Excel formula 4) A Gieen box already has formulas and will update automatically as you complese the other areas. 5) A Grey box of any shade you nesd not do anything Some of the info is FYL. 6) Explain three things: a) How did you choose your divcount rate? b) Should you make this investenent? Why? c) What onher oonsiderations do you feel are relevant in assessing the results of your work? PCC Corp. is contemplating a $225,000 investment of equipment that they feel can add $75,000 in revenues in Year \#1. and increase by 54 each year thereafter. They estimate variable expenses at 20% of Sales and additional fixed costs would be approximately $11,500 per year. The equipment should last 5 years and have a salvage value of $15.000 at the end of its life. They've decided to use straight line depreciation over the equipment life