Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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 3 0 ? - 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. \begin{tabular}{|lrr|rrrr} Mom \& Pop Inc. & & 2021 ? & 2020 ? & & 2019 \\ \hline Net Sales & $ & 7,300 & $ & 6,205 & $ & 5.840 \\ \hline Accounts Receivable & $ & 660 & $ & 620 & $ & 570 \end{tabular} Formula Days Sales in Recelvables = Average Accounts Receivable Average Daily Sales Step 1 Calculate "average Accts Recelvable" for 2021 add the ending AR for 2021 plus the ending AR of 2020 , then divide by 2 \begin{tabular}{|l|l|} Acct Rec 2021 & Acct Rec 2020 \\ \hline \end{tabular} Average A R = divide by 2 Step 2 Calculate "average Daily Sales" for 2021 take the total sales for 2021, divide by 365 days to get a "daily average" Net Sales 2021 Avg Dly Sales divide by 365 Average Daily Sales Step 1 Calculate "average Accts Receivable" for 2021 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 A R = Step 2 Calculate "average Daily Sales" for 2021 take the total sales for 2021, divide by 365 days to get a "daily average" Net Sales 2021 Avg Dly Sales divide by 365 Step 3 Divide Average AR (from step 1) by Avg Daily Sales (from step 2) to get "Days Sales in AR" Step 4 Use the tab at bottom to go to "Week 13 Lab part 2 ? & calculate the formula for 2020. Which is betth

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Jan Williams, Sue Haka, Mark Bettner, Joseph Carcello

15th Edition

0077328701, 9780077328702

More Books

Students also viewed these Accounting questions

Question

1. Too reflect on self-management

Answered: 1 week ago

Question

Food supply

Answered: 1 week ago