please show work

Trojan, LLC is contemplating a $425,000 investment of equipment that they feel can add $175,000 in revenues in Year \#1, and increase by 2.5% each year thereafter. They estimate variable expenses at 10% of Sales and additional fixed costs would be approximately $50,000 per year. The equipment should last 5 years and have a salvage value of $35,000 at the end of its life. They've decided to use straight line depreciation over the equipment life. Year \# PV of Cash Flows Cumulative PV of NCF Investment Measures: NPV IRR \#REF ! Instructions: 1) Complete the above worksheet using the information provided in the Scenario at the 2) A Yellow box means you need to insert numbers either hard coded or via a simple for 3) An Orange box means you need to derive what goes here by use of an Excel formula. 4) A Green box already has formulas and will update automatically as you complete the other areas. 5) A Grey box of any shade you need not do anything. Some of the inf 6) Explain three things: a) How did you choose your discount rate? b) Should you make this investment? Why? c) What other considerations do you feel are relevant in assessing the results of your