Question: Please help solve on excel and give formula. Thank You! Excel File Edit View Insert Format Tools Data Window Help 90% Fri 8:28 PM AutoSave

Please help solve on excel and give formula. Thank You!

Excel File Edit View Insert Format Tools Data Window Help 90% Fri 8:28 PM AutoSave OFF FIN3403 Excel Assignment Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments D Wrap Text v Number E Calibri (Body) 14 AA Paste BIUV A Merge & Center v $ Conditional Format Cell Insert Delete Format Sort & Find & Ideas Formatting as Table Styles Filter Select G22 X V fx 2500 P B D E F G H M N O 15 16 Question 3 The Tropic Island Resort prison is looking at alternatives to cut its monthly costs and increase its recently anemic profits. 17 74,100 The Warden would like to pay a judge to guarantee that convicted prisoners in poor health win their appeals and get set free. $42,097 Tropic believes it can realize the monthly cost savings below over the initial year of the plan. What is the present 19 4 points value of the first year's monthly cost savings? Assume a discount rate of 10%. 20 21 Month Savings ($) 10% 22 2,500 -10% 23 24 NOT DONE W N P 5,000 5,500 25 4 8,000 26 5 9,000 27 6 9,000 28 7 9,400 29 8 9,900 30 9 5,600 31 10 4,000 32 11 2,900 33 12 3,300 34 Total 74,100 35 36 37 Directions Questions to Complete + 125% Ready NOV 3.141593 6 P X W
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
