Painted Paradise Golf Resort & Spa Banquet Room Renovations Created by Lesa Martin mt Length of Renovations in Days 124 122 Renovations Started 1/6/18 3/15/18 9/10/18 8/1/18 2/15/18 Original Capacity New Capacity 500 100 650 650 5 The Muisca Room 7 The Eldorado Room B The Pueblo Room Technology room 1 LO Technology room 2 Renovations Completed 5/10/18 7/15/18 11/30/18 10/1/18 4/15/18 Quarterly Revenue Prior to Renovations 290,000 575,000 225,000 150,000 75,000 Projected Quarterly Renovation Revenue after Projection Projected Room Renovations Schedule Classification 406,000 Over 805,000 Over 315,000 Under 210,000 Under 105,000 Under 81 650 25 45 61 59 650 650 25 30% 40% 3 Increase in Capacity 4 Increase in Revenue Median Renovation Length 5 in Days 125,000 Loan Information 8 Amount of Loan 9 Annualized Rate C0 Term (in Years) 1 Monthly Payment 29,272 Room Classification O Bronze 250,000 Silver 500,000 Gold 750,000 Platinum ON 10 In cell ko, using a VLOOKUP, create a function to determine the projected room classification based on the projected quarterly revenue after renovations in cell 16. Use the named range Regm Classification when entering this function. Copy this function to the range K7:K10