Preparing a Schedule of Cash Collections on Accounts ReceivableKailua and Company is a legal services firm. All sales of legal services are billed to the client (there are no cash sales). Kailua expects that, on average, 20% will be paid in the month of billing, 50%will be paid in the month following billing, and 25% will be paid in the second month following billing. For the next 5 months, the following sales billings are expected:May$84,000June100,800July77,000August86,800September91,000Required:Prepare a schedule showing the cash expected in payments on accounts receivable in August and in September. If an amount box does not require an entry, leave it blank or enter "0". Be sure toenter percentages as whole numbers.

The payments are collected as follows: 20% in the month of billing 50% in the month following the…

Answered: Preparing a Schedule of Cash…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

The management of Marigold Industries estimates that credit sales for August, September, October, and November will be $550,000, $735,000, $885,000, and $480,000, respectively. Experience has shown that collections are made as follows: In month of sale 25% In first month after sale 60% In second month after sale 10% Determine the collections from customers in October and November
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $113,000 November 141,000 December 207,000 The Accounts Receivable balance on September 30 was $76,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…
Prince Charles Island Company has expected sales of $6,000 in September, $10,000 in October, $16,000 in November, and $12,000 in December. Cash sales are 20 percent and credit sales are 80 percent of total sales. Historically, 40 percent of receivables are collected in the month after the sale, and the remaining 60 percent collected two months after. Assume that the company's cash payments for November are $13,000, and December $6,000. The beginning cash balance in November is $5,000, which is the desired minimum balance. a. Prepare a cash receipts schedule for November and December. Sales Credit sales Cash sales Collections in the month after credit sales Collections two months after credit sales Total cash receipts Prince Charles Island Company Cash Receipts Schedule September S Cash receipts Cash payments Net cash flow Prince Charles Island Company Cash Budget November Beginning cash balance Cumulative cash balance. Monthly loan or (repayment). Cumulative loan balance. Ending cash…
Davis and Davis have expected sales of $490, $465, $450, and $570 for the months of January through April, respectively. The accounts receivable period is 28 days. What is the accounts receivable balance at the end of March? Assume a year has 360 days. a. $450 b. $420 c. $440 d. $426
The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year. 04 $480 Sales 01 $ 210 02 $ 270 a. Accounts receivable at the beginning of the year are $480. The company has a 45-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Beginning receivables Sales Cash collections Ending receivables $ Beginning receivables S Sales Cash collections Ending receivables 03 $ 330 Beginning receivables Sales Cash collections Ending receivables Q1 S Q1 480 210 585 105 $ 01 Answer is complete and correct. 480 210 $ 00 480 210 Q2 105 $ 270 b. Accounts receivable at the beginning of the year are $480. The company has a 60-day collection period. Calculate cash collections in each of the four quarters by completing the following: Note: Do not round intermediate calculations and round your answers to the…
Jasper Company has 62% of its sales on credit and 38% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $522,000 for April, $532,000 for May, and $557,000 for June. Total sales for March are $304,900. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Accounts receivable Total cash receipts JASPER COMPANY Schedule of Cash Receipts from Sales April 522,000 May 532,000 June 557,000
Trapp Co. was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $100,000 September 185,000 October 225,000 The company expects to sell 40% of its merchandise for cash. Of the sales on account, one third are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating cash collections of accounts receivable for August, September, and October. For each month's sales on account, enter the collection months in chronological order. Trapp Co. Schedule of Collections of Accounts Receivable For Three Months Ending October 31, 20xX August September October August sales on account: Collected in August Collected in September September sales on account: Collected in September Collected in October October sales on account: Collected in October Totals
Cash collections The treasurer of Homeyra Corp. needs to estimate cash collections from accounts receivable for September, October, and November. Forty percent of the company's customers pay in cash and the rest are credit customers. The collection pattern for the credit customers is 20 percent in the month of sale and 80 percent in the following month. Because of Homeyra's established client base, the company experiences almost zero uncollectible accounts. Estimated total sales for August, September, October, and November follow. Month Sales August $78,000 September 80,000 October 95,000 November 91,000 Determine Homeyra Corp.'s cash collections for September, October, and November. Cash Collections: September $ 32,000 x October $ 0 x November $ 0 x Check
Hernandez Company expects credit sales for January to be $58,000. Cash sales are expected to be $38,000. The company expects credit and cash sales to increase 10% for the month of February. Credit sales are collected in the month following the month in which sales are made. Based on this information, the amount of cash collections in February would be:
J. Lo's Clothiers has forecast credit sales for the fourth quarter of the year: Fourth Quarter September (actual) $ 73,000 October November December $ 63,000 58,000 83,000 Experience has shown that 35 percent of sales are collected in the month of sale, 60 percent are collected in the following month, and 5 percent are never collected. Prepare a schedule of cash receipts for J. Lo's Clothiers covering the fourth quarter (October through December). Credit sales Collections: In month of sales One month after sales Total cash receipts J. Lo's Clothiers September October November December $ 0 $ 0 $ 0
Need help with this
please answer do not image format

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS