asap, with solution

Q16. Part 2 Question (10 marks) You are considering two investment opportunities, which require the same cash outlay today. ABC will pay you $8,000 each year for 15 years, with the first payment occurring one year from today. XYZ will pay you $3,000 each year in perpetuity. The first payment will occur one year from today. At which discount rate will you be indifferent between the two opportunities? You will need to use Excel Solver or financial calculators. Follow these steps. step 1: Clearly state what your "change variable" is in Solver. step 2: Write down the equation for your objective. step 3: Clearly state your goal. step 4: Use Solver and find your answer. Example: You solve x^2 - 2*x +1 = using Solver. The change variable is x. The equation for the objective cell is x^2-2*x +1 Your goal: find x such that the objective cell has a value of 0. Show your work. No work, no credits. A correct answer with no justification or work will get a maximum of 1% of the mark