Use the Excel solver (sheet below) tool to calculate the recovery time with interest for each of the options. Replace ? with the correct answer. Order your options from best to worst. Report your responses and a picture of each of the three solver windows you used to generate the recovery time for each of the options in your working document. The MARR = 10%.

Option A Option B Option C 10% 10% 10% ? ? ? 300 000 450 000 150 000 MARR = Payback period with interest = Initial investment Annual savings Gradient VAN = 55 000 80 000 45 000 -5 000 0 O O o 0 Option A Option B Option C 10% 10% 10% ? ? ? 300 000 450 000 150 000 MARR = Payback period with interest = Initial investment Annual savings Gradient VAN = 55 000 80 000 45 000 -5 000 0 O O o 0