Please help with the tasks as soon as possible!! thanks!

=Financials!C5/ OU AWNH 2 1. Calculate DSO (Days Sales Outstanding) for Dec 2021 3 2. Create Pivot showing Customers over 90 Days (Largest amount to Smallest) 4 Complete on AR Aging Summary tab 5 3. Use Formula to Fill in Email Address for following Customers: 6 FLA P&E 7 PAYG 8 SWRI 9 4. Use Formula to count how many Reseller Customers are listed 10 5. Calculate Current Ratio for Nov 2021 11 6. Round Jan 2022 Accounts Payable to the nearest dollar 12 7. Use formula to combine Subsidiary with Company Name for following Customers: 13 Heineken 14 RCO 15 QST Inc. 16 8. Calculate the average Sales for Q4 17 9. Highlight all values exceeding $50K (excluding total) using conditional formatting 18 Complete on AR Aging Summary tab 19 10. Sort Customers by Channel Tier (Partner, Reseller, End User) 20 Complete on Customers tab 21 Dec 2021 Amount Jan 2022 Amount 1,628,552.47 726,660.20 1,518,204.66 2,774,801.33 6,648,218.66 1,648,664.70 1,366,665.10 1,653,771.18 2,760,247.11 7,429,348.08 Balance Sheet Financial Row Nov 2021 Amount ASSETS Cash 1,231,739.93 Accounts Receivable (Net) 755,349.37 Unbilled Receivable 1,528,480.34 Other Current Asset 2,723,585.91 1 Total Current Assets 6,239,155.56 Fixed Assets 1 1500 - Property And Equipment 2 Computer Equipment 27.942.88 Accum Depreciation - Computer Equipment (15,470.19) 7 Total Property And Equipment 12,472.70 5 Goodwill & Intangibles 13,527.49 6 TOTAL ASSETS 6,265,155.75 LIABILITIES & EQUITY 3 Current Liabilities Accounts Payable 78,310.19 Other Current Liability 10,979.38 1 Total Current Liabilities 89,289.57 2 Long Term Liabilities 4,658,719.94 3 Equity 1,547,626.37 4 TOTAL LIABILITIES & EQUITY 6,295,635.87 5 5 Income Statement 7 Financial Row Nov 2021 Amount 2 Revenues 98,099.79 27,942.88 (16,106.91) 11,835.98 13,527.49 6,673,582.13 29,160.04 (16,728.55) 12,431.49 13,527.49 7,455,307.07 158,655.85 (42,353.70) 116,302.16 4,668,587.62 1,919,172.47 6,704,062.25 133,795.92 64,780.72 198,576.64 4,678,455.31 2,578,275.12 7,455,307.07 Dec 2021 Amount 273,425.76 Jan 2022 Amount 624,012.42 Customer Project AD BMG Inc. Bay BOM BB LLP BA CC LLC CSC Co. Inc Comp XPs Ltd. Danalytic DP Total A/R Aging Summary Current 2/27/2022 - 3/20/2022 (30) 1/28/2022 - 2/26/2022 (60) 12/29/2021 - 1/27/2022 (90) Before 12/29/2021 (>90) Open Balance Open Balance Open Balance Open Balance Open Balance Total Bala $0.00 $0.00 $61,000.00 $0.00 $0.00 $61.000 $0.00 $22,500.00 $0.00 $0.00 $0.00 $22,500 $0.00 $0.00 $0.00 $0.00 $5,000.00 $5,000 $78,314.20 $34,121.86 $0.00 $0.00 $0.00 $112,436 $0.00 $0.00 $12,769.86 $0.00 $0.00 $12,769 $0.00 $0.00 $0.00 $0.00 $160,600.00 $160,600 $0.00 $48,500.00 $0.00 $0.00 $0.00 $48,500 $172,800.00 $307.200.00 $0.00 $0.00 $0.00 $480,000 $0.00 $15,109.18 $0.00 $0.00 $0.00 $15,109 $0.00 $50,000,00 $0.00 $0.00 $46,250,00 $96,250 $2,500.00 $0.00 $0.00 $0.00 $0.00 $2,500 $0.00 $350,000.00 $0.00 $0.00 $0.00 $350,000 $253,614.20 $827,431,04 $73,769.86 $0.00 $211,850.00 $1,366,665 =Financials!C5/ OU AWNH 2 1. Calculate DSO (Days Sales Outstanding) for Dec 2021 3 2. Create Pivot showing Customers over 90 Days (Largest amount to Smallest) 4 Complete on AR Aging Summary tab 5 3. Use Formula to Fill in Email Address for following Customers: 6 FLA P&E 7 PAYG 8 SWRI 9 4. Use Formula to count how many Reseller Customers are listed 10 5. Calculate Current Ratio for Nov 2021 11 6. Round Jan 2022 Accounts Payable to the nearest dollar 12 7. Use formula to combine Subsidiary with Company Name for following Customers: 13 Heineken 14 RCO 15 QST Inc. 16 8. Calculate the average Sales for Q4 17 9. Highlight all values exceeding $50K (excluding total) using conditional formatting 18 Complete on AR Aging Summary tab 19 10. Sort Customers by Channel Tier (Partner, Reseller, End User) 20 Complete on Customers tab 21 Dec 2021 Amount Jan 2022 Amount 1,628,552.47 726,660.20 1,518,204.66 2,774,801.33 6,648,218.66 1,648,664.70 1,366,665.10 1,653,771.18 2,760,247.11 7,429,348.08 Balance Sheet Financial Row Nov 2021 Amount ASSETS Cash 1,231,739.93 Accounts Receivable (Net) 755,349.37 Unbilled Receivable 1,528,480.34 Other Current Asset 2,723,585.91 1 Total Current Assets 6,239,155.56 Fixed Assets 1 1500 - Property And Equipment 2 Computer Equipment 27.942.88 Accum Depreciation - Computer Equipment (15,470.19) 7 Total Property And Equipment 12,472.70 5 Goodwill & Intangibles 13,527.49 6 TOTAL ASSETS 6,265,155.75 LIABILITIES & EQUITY 3 Current Liabilities Accounts Payable 78,310.19 Other Current Liability 10,979.38 1 Total Current Liabilities 89,289.57 2 Long Term Liabilities 4,658,719.94 3 Equity 1,547,626.37 4 TOTAL LIABILITIES & EQUITY 6,295,635.87 5 5 Income Statement 7 Financial Row Nov 2021 Amount 2 Revenues 98,099.79 27,942.88 (16,106.91) 11,835.98 13,527.49 6,673,582.13 29,160.04 (16,728.55) 12,431.49 13,527.49 7,455,307.07 158,655.85 (42,353.70) 116,302.16 4,668,587.62 1,919,172.47 6,704,062.25 133,795.92 64,780.72 198,576.64 4,678,455.31 2,578,275.12 7,455,307.07 Dec 2021 Amount 273,425.76 Jan 2022 Amount 624,012.42 Customer Project AD BMG Inc. Bay BOM BB LLP BA CC LLC CSC Co. Inc Comp XPs Ltd. Danalytic DP Total A/R Aging Summary Current 2/27/2022 - 3/20/2022 (30) 1/28/2022 - 2/26/2022 (60) 12/29/2021 - 1/27/2022 (90) Before 12/29/2021 (>90) Open Balance Open Balance Open Balance Open Balance Open Balance Total Bala $0.00 $0.00 $61,000.00 $0.00 $0.00 $61.000 $0.00 $22,500.00 $0.00 $0.00 $0.00 $22,500 $0.00 $0.00 $0.00 $0.00 $5,000.00 $5,000 $78,314.20 $34,121.86 $0.00 $0.00 $0.00 $112,436 $0.00 $0.00 $12,769.86 $0.00 $0.00 $12,769 $0.00 $0.00 $0.00 $0.00 $160,600.00 $160,600 $0.00 $48,500.00 $0.00 $0.00 $0.00 $48,500 $172,800.00 $307.200.00 $0.00 $0.00 $0.00 $480,000 $0.00 $15,109.18 $0.00 $0.00 $0.00 $15,109 $0.00 $50,000,00 $0.00 $0.00 $46,250,00 $96,250 $2,500.00 $0.00 $0.00 $0.00 $0.00 $2,500 $0.00 $350,000.00 $0.00 $0.00 $0.00 $350,000 $253,614.20 $827,431,04 $73,769.86 $0.00 $211,850.00 $1,366,665