VIEW Week 13 Lab part 1 problem Week 13 Lab part 2 problem Evaluating Accounts Receivable Performance Companies offer trade credit to make it easier for customers to do business with them but how can a company check whether receivables are being paid in a timely fashion? Imagine that a company has terms of "Net 30"-we would expect most receivables to be paid close to 30 days. How can we check? And can we tell if it's getting worse? Required Compute the 'days sales in receivables' for 2021 using the formula below, then click on the tab at bottom to go to part 2 of the worksheet and do the same for 2020. The computation for "Days Sales in AR" for 2020 is the "part 2" tab at bottom. The following data is taken from the records of Mom & Pop Inc. Mom & Pop Inc. Net Sales Accounts Receivable Formula Days Sales in Receivables = Step 1 Calculate "average Accts Receivable" for 2021 $ 55 2021 2020 2019 7,300 $ 6,205 $ 660 $ 620 55 5,840 $ 570 Average Accounts Receivable Average Daily Sales add the ending AR for 2021 plus the ending AR of 2020, then divide by 2 Acct Rec 2021 Acct Rec 2020 divide by 2 Average AR = Step 2 Calculate "average Daily Sales" for 2021 take the total sales for 2021, divide by 365 days to get a "daily average" DEC Net Sales 2021 Avg Dly Sales divide by 365 3263 Step 1 Calculate "average Accts Receivable" for 2021 Average Daily Sales add the ending AR for 2021 plus the ending AR of 2020, then divide by 2 Acct Rec 2021 Acct Rec 2020 divide by 2 Average AR = Step 2 Calculate "average Daily Sales" for 2021 Step 3 Step 4 take the total sales for 2021, divide by 365 days to get a "daily average" Net Sales 2021 Avg Dly Sales divide by 365 Divide Average AR (from step 1) by Avg Daily Sales (from step 2) to get "Days Sales in AR" Days Sales in Receivables = Avg Accts Rec Avg Daily Sls Days Sls in AR == Use the tab at bottom to go to "Week 13 Lab part 2" & calculate the formula for 2020. Which is bette