Provide fomula for the following question using the excel below.

Q5 empty. Loans approved: N/A Use functions we have used in the tutorials (1 In R16, write a formula that displays how many loans have the decision of Approved. mark) In R17 write a formula that displays the percentage of the total loan applications that are "Low risk. Ensure that this formula will be automatically updated if data elsewhere in the workbook changes (i.e. use the appropriate functions to do the calculation) Approval category Interest rate Monthly interest CRITERIA Category -> Low risk Medium risk Caution Minimum age 18 18 65 Minimum credit score 900 800 700 N.B.: Approximate repayment (monthly) must be less than 50% of applicants' monthly incomes for all approved applicants LOW RISK 6% LOW RISK 6% 7% 7% Medium Risk Medium Risk LOW RISK LOW RISK Interest rates Category Low risk Medium risk Caution Rate 6% 7% 8% DOB Name ncome (monthly Credit score Jackie 11/26/1965 $ 9,035.75 973 $ John 4/6/1992 $ 12,372.50 796 $ Suz 6/20/1959 $ 9,163.83 923 $ Xiao 1/5/1982 $ 9,774.92 794 $ Peter 2/28/1987 $ 10,950.08 875 $ Frank 4/21/1991 $ 12,252.58 881 $ Naomi 10/11/1980 $ 9,141.50 929 $ Murtry 1/9/1981 $ 10,114.58 968 $ Amos 10/7/2004 $ 10,794.17 870 $ Julie 11/4/1953 $ 8,560.00 742 $ Cornelius 4/17/1982 $ 10,325.17 850 $ Morrier 8/21/2006 $ 8,715.08 807 $ Franklin 3/21/1994 $ 9,237.67 866 $ James 2/21/1992 $ 10,076.83 817 $ Manson 10/14/1991 $ 12,308.67 891 $ Lacy 3/15/1978 $ 10,386.42 732 $ Melissa 2/16/2006 $ 6,884.25 718 $ Naomi 6/28/2006 $ 9,333.50 808 $ Jackson 7/17/1990 $ 9,820.92 995 $ Jo 10/16/1993 $ 10,669.25 813 $ Anna 5/4/1974 $ 12,240.92 823 $ Jose 1/18/1960 $ 8,638.08 915 $ Keith 6/27/2007 $ 6,968.17 841 $ Jerry 9/17/2006 $ 10,542.33 738 $ Elaine 7/11/1995 $ 7,465.75 1000 $ Employment Loan Purchase price Deposit Hired Finished decision 359,183.00 $ 230,280.00 3/21/2017 DECLINED 469,192.00 $ 73,600.00 5/12/2014 APPROVED 421,269.00 $ 42,980.00 9/28/2008 8/18/2018 DECLINED 421,626.00 $ 145,860.00 10/9/2007 APPROVED 454,682.00 $ 97,280.00 11/28/2013 11/13/2019 DECLINED 381,844.00 $ 157,410.00 7/18/2006 10/12/2021 APPROVED 308,874.00 $ 92,480.00 4/14/2014 6/9/2018 APPROVED 323,880.00 $ 228,800.00 10/4/2007 APPROVED 346,291.00 $ 199,500.00 8/26/2013 APPROVED 400,000.00 $ 200,000.00 3/21/2015 DECLINED 448,225.00 $ 195,600.00 2/25/2017 APPROVED 365,920.00 $ 152,250.00 11/18/2007 APPROVED 321,072.00 $ 246,960.00 1/10/2008 DECLINED 411,471.00 $ 63,180.00 4/2/2008 APPROVED 384,816.00 $ 224,960.00 12/19/2020 APPROVED 467,811.00 $ 193,200.00 3/13/2019 APPROVED 487,300.00 $ 194,010.00 9/10/2012 DECLINED 347,445.00 $ 280,000.00 3/12/2017 DECLINED 399,452.00 $ 248,160.00 9/27/2010 DECLINED 496,533.00 $ 270,840.00 7/9/2012 3/28/2014 APPROVED 349,852.00 $ 122,360.00 8/25/2014 APPROVED 304,025.00 $ 57,720.00 11/10/2018 APPROVED 422,384.00 $ 45,750.00 4/20/2012 APPROVED 466,069.00 $ 87,300.00 5/28/2019 11/10/2019 DECLINED 404.715.00 $ 205,450.00 5/23/2013 5/24/2018 DECLINED CAUTION Medium Risk Monthly repmt $4,159.21 $3,829.91 $3,275.71 $4,004.15 $3,894.61 $3,804.94 $2,831.93 $3,899.67 $3,851.07 $4,233.56 $4,542.79 $3,656.17 $4,008.00 $3,349.11 $4,302.54 $4,664.05 $4,807.28 $4,427.21 $4,569.51 $5,414.54 $3,331.90 $2,552.45 $3,303.12 $3,904.54 $4,305.29 Medium Risk Medium Risk Medium Risk STATISTICS Loans approved Total Low risk applications (%) LOW RISK Medium Risk Medium Risk LOW RISK