Purchase Solution

Compute the Days in Accounts Receivable at the End Quarter

Not what you're looking for?

Ask Custom Question

See attached Excel document.

Compute the Days in Accounts Receivable amounts for the end of each quarter.

Month Revenues Accounts Receivable at End of Quarter
January $350,000 $275,000
February 375000 290000
March 225000 200000
1st Quarter Total $950,000 $765,000

April $300,000 $270,000
May 320000 310000
June 400000 320000
2nd Quarter Total $1,020,000 $900,000

July $350,000 $335,000
August 275000 250000
September 200000 150000
3rd Quarter Total $825,000 $735,000

October $310,000 $300,000
November 425000 285000
December 290000 240000
4th Quarter Total $1,025,000 $825,000.

Attachments
Purchase this Solution
Solution Summary

The computation is a bit different when you have quarters versus annual amounts. The tutorial shows you how to adjust for this.

Solution Preview

See attached file.

AR turnover is sales/AR. Thus presumes a full year of sales. So, to do it quarterly, ...

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Operations Management

This quiz tests a student's knowledge about Operations Management

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Introduction to Finance

This quiz test introductory finance topics.

View More Free Quizzes
Related BrainMass Solutions

  • Days in Accounts Receivable

    Days in Accounts Receivable end of March are 200,000/7,258.065 = 27.6 days In the way in Quarter 2, the per days sales in June are 400,000/30=13,333.33 Accounts Receivable end of June is 320,000 Days in Accounts Receivable end of June is 320,000/

  • This posting shows to to determine ship methods from ratios.

    An analysis of the days' sales in receivables will immediately show that during the last two weeks of the quarter, the company moving sales out at the end of the quarter will have an extremely high days' sales in receivables during most days of the last

  • Accounting for uncollectible accounts - allowance method

    Dec 31 Recorded uncollectible account expense based on the aging of accounts receivable, as follows: AGE OF ACCOUNTS Accounts Receivable 1-30 days 31-60 days 61-90 days over 90 days $165,000 $97,000

  • Accounts Receivable for Smithe and Wreston Company

    The aging of credit sales is: 30 percent collected in the month of sale 40 percent collected in the month after sale The accounts receivable balance at the end of the previous quarter is $36,000; $30,000 of that amount is uncollected December

  • Components of financial statements in most recent annual report

    Analysis of ratio of sales to income with in first quarter to total ratio of sales to income at the end of the year Accounts Receivable ? Comparison of receivables turnover and days outstanding in current year to previous year ?

  • Multiple Choice Questions on Working Capital

    The accounts receivable period is 45 days and the accounts payable period is 60 days. At the beginning of the first quarter, the firm has an accounts receivable balance of $3,600 and an accounts payable balance of $2,750.

  • Financial Ratios: Intel 2008

    Number of days' sales days Number of days' sale in accounts receivable = ((Accounts receivable at December 27, 2008 + Accounts receivable at December 29, 2007)/2)/(Total credit sales/Number of days per year) Number of days' sale in accounts receivable

  • Reclassification

    Holman's days sales outstanding (Accounts receivable / Average daily credit sales) figures increased steadily in 2011 and then spiked dramatically in 2012, peaking at 120 days in the second quarter.

  • Profitability Measures; Liquidity Measures; Activity Measures; Financial Leverage Measures; Physical Measures

    Compute the following activity measures for the year ended December 29, 2001: 1. Number of days' sales in accounts receivable, based on a 365-day year.

View More Related Solutions