The correct answers are in grey but I need an excel formula to receive full correct. The answers in yellow are INCORRECT. Please answer questions 3 and 4 in a formula. Thanks.

Excel File Edit View Insert Format Tools Data Window Help 76% Fri 9:11 PM AutoSave OFF FIN3403 Excel Assignment Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments fx Define Name v Ev Trace Precedents Calculate Now Trace Dependents Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Show Function Used Time Reference Trig Functions Create from Selection Remove Arrows v Formulas Checking Error Calculation Calculate Sheet Options A44 X V fx A B C D E F G H K L M N O P Q R S T 14 IVitn. Pay. $5,452.91 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. 18 $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 Month Savings ($) 1 2,500 2 5,000 3 5,500 4 8,000 5 9,00 6 9,000 7 9,40 1 00 9,900 5,600 10 4,000 11 2,900 12 3,300 Total 74,100 36 38 Question 4 Pyramid Investments offered an investment alternative it says will pay out to you $32,000 at the end of 3 years. 39 To invest, you'll need to deposit $8,000 to their bank account and keep the information super-secret. What is the 40 59% annual return on this investment? 41 4 points 42 13 Directions Questions to Complete + Ready 100% NOV 3.141593 6 P X W