Please include the Excel function/formula used for this question.

4a. Using the groups below, append Status to the table Status Current 30-60 90+ Delinquency 0 Months Delinquent 1-2 Months Delinquent 3 or more Months Delinquent 4b. Loans that are 6 months or more delinquent are in Foreclosure, flag 'Y' or 'N' for each loan's foreclosure status Foreclosure 30 Loan Loan Numbei Seller Name Loan AmountAnnual RateTerm (Years) Payment Payments MadeCurrent Balance Loan Type Agency Delinquency (Months Status 83449837 Shanna's Loan Headquarters 280,000 6.34% 30 $0.00 191 $0.00 VA 2 41209504 Shanna's Loan Headquarters 370,000 4.79% $0.00 322 $0.00 UCONV 25055860 Shanna's Loan Headquarters 210,000 6.14% $0.00 $0.00 USDA 61173887 Shanna's Loan Headquarters 120,000 6.99% $0.00 23 $0.00 VA 5 51398733 Shanna's Loan Headquarters 350,000 5.01% $0.00 154 $0.00 UCONV 6 76906141 Shanna's Loan Headquarters 220,000 4.28% $0.00 $0.00 ICONV 7 49304139 Shanna's Loan Headquarters 330,000 7.99% $0.00 $0.00 USDA 8 23473039 Shanna's Loan Headquarters 160,000 3.78% $0.00 $0.00 USDA 9 53651842 Shanna's Loan Headquarters 370,000 5.65% $0.00 73 $0.00 ICONV 10 77159777 Shanna's Loan Headquarters 240,000 5.67% $0.00 174 $0.00 VA 81 317 30