Assignment Instructions 2 On the Renovations worksheet in cell G6, enter a formula using an absolute reference to determine the new capacity that the Musica Room will hold based on the capacity in cell F6 and the percentage in cell B13. Copy this formula to the range G7:G10. 3 Assign the named range IncreaseInRevenue to cell B14. 4 In cell 16, enter a formula to determine the projected revenue for the Musica Room based on the revenue figure in cell H6 and the percentage in cell B14. Use the named range in cell B14 when entering this formula. Copy this formula to the range 17:110. 5 In cell D6, enter the DATEDIF date function to determine the length in days of the expected renovation for the Musica Room. Copy this function to the range D7:D10.Assignment Instructions 6 In cell B15, enter the function to calculate the median length of renovations in days. Assign the named range MedianDays to the cell. 7 In cell J6, enter a logical function to display the word Under in the cell if the renovations are going to take fewer than or equal to the median number of days calculated in cell B15; otherwise, have the word Over display. Use the named range for B15 when entering this function. Copy this function to the range J7:J10. 8 In cell B21, enter a function that will calculate the monthly payment for the loan amount in cell B18, based on the Annualized Rate in B19, and the number of years in the Term in cell B20. Display the monthly payment as a positive value.A B C D E F G H K L M Painted Paradise Golf Resort & Spa IN Banquet Room Renovations Created by Lesa Martin Projected Quarterly Renovation Projected Renovations Length of Renovations Original New Quarterly Revenue Prior Revenue after Projection Room Started Renovations Completed in Days Capacity Capacity to Renovations Renovations Schedule Classification The Muisca Room 1/6/18 5/10/18 500 290,000 The Eldorado Room 3/15/18 7/15/18 100 575,000 The Pueblo Room 9/10/18 11/30/18 25 225,000 9 Technology room 1 8/1/18 10/1/18 45 150,000 10 Technology room 2 2/15/18 4/15/18 25 75,000 11 12 13 Increase in Capacity 30% 14 Increase in Revenue 40% Median Renovation 15 Length in Days 16 17 Loan Information 18 Amount of Loar 125,000 19 Annualized Rate 6% 20 Term (in Years) 5 21 Monthly Payment 22 23 Room Classification D Bronze 25 250,000 Silver 26 500,000 Gold 27 750,000 Platinum 28