Marcel Company projects the following sales for the first three months of the year: $13,500 in January, $12,200 in February, and $10,500 in March. The company expects 60% of the sales to be cash and the remainder on account Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Roum to the nearest dollar. Read the requirements. Requirements 1. Prepare a schedule of cash receipts for Marcel for January, February, and March. What is the balance in Accounts Receivable on March 31? 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31? Print Done rouroury USI PORVO February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March - X at is the balance in Accounts Receivable on March 31? (If an input field is not used, leave the rch 10500 rch Total 36200 Total

Marcel Company projects the following sales for the first three months of the year: $13,500 in January, $12,200 in February, and $10,500 in March. The company expects 60% of the sales to be cash and the remainder on account Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Roum to the nearest dollar. Read the requirements. Requirements 1. Prepare a schedule of cash receipts for Marcel for January, February, and March. What is the balance in Accounts Receivable on March 31? 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31? Print Done rouroury USI PORVO February-Credit sales, collection of February sales in February February-Credit sales, collection of February sales in March - X at is the balance in Accounts Receivable on March 31? (If an input field is not used, leave the rch 10500 rch Total 36200 Total

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

Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,304, $36,973, and $39,905, respectively. Round to the nearest penny, two decimal places.
Suits Inc. expect to sell 8,500 units for $190 each in January, 2,500 suits for $200 each in February and 4,700 suits in March for $210 each. Sales revenue is collected 75% in the month of sales, and 20% the next month. (5% of sales are never collected.) Jan. 1 accounts receivable are $290,000. It is expected that 80% of the Jan. 1 receivable swill be collected, and the rest will never be collected. Cost of Goods sold is 70% of sales revenue. Cost of goods sold is paid 60% in the month of sale and 40% in the next month. There are accounts payable of $240,000 on Jan. 1. Our cash balance on Jan. 1 is $60,000. We want to keep a minimum cash balance of $50,000 at the end of each month. We can borrow at the beginning of any month in increments of $10,000. The interest rate is 12% annually, i.e. 1% a month. Interest is paid monthly at the end of the month. Prepare a monthly schedule of cash receipts, cash disbursements and borrowing and interest payments (if required) for January and…
Assume receivables of $20,000 at the start of the January are all collected during the month; if sales for January and February are $400,000 and $300,000 respectively; the company typically receives payment from 20% of its customers within the same month, 60% the following month, and the remaining 20% by the end of the second following month, how much would accounts receivable be at the end of February?
Neon Inc.’s forecast sales for July is $72,000. It has $15,000 in accounts receivable at the end of June. 30% of its total sales are expected to be cash sales. Of the remaining 70%, 80% are expected to be collected in the month of the sale and the remaining 20% in the month following the sale. Determine the amount of accounts receivable at the end of July. Group of answer choices $79,200 $61,920 $10,080 $40,320
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
Graham Company projects the following sales for the first three months of the year: $10,600 in January: $14,600 in February; and $16,300 in March. The company expects 80% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round to the nearest dollar. Read the requirements. Requirement 1. Prepare a schedule of cash receipts for Graham for January, February, and March. What is the balance in Accounts Receivable on March 31? (If an input field is not used, leave the input field empty. Do not enter a zero.) Cash Receipts from Customers Total sales Cash Receipts from Customers: Accounts Receivable balance, January 1 January-Cash sales January-Credit sales, collection of January sales in January January-Credit sales, collection of January sales in February February-Cash sales February-Credit sales, collection of February sales in…
Office World Inc. has “cash and carry” customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 40% pay their accounts in the month of sale, while the remaining 60% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $700,000 November 650,000 December 500,000 The Accounts Receivable balance on September 30 was $290,000. Prepare a schedule of cash collections from sales for October, November, and December. Enter all amounts as positive numbers. Office World Inc.Schedule of Collections from SalesFor 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: Collected in October fill in the blank 4 October sales on…
Jasper Company has 70% of its sales on credit and 30% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $525,000 for April, $535,000 for May, and $560,000 for June. Total sales for March are $500,000. Prepare a schedule of cash receipts from sales for April, May, and June. Sales Cash receipts from: Cash sales JASPER COMPANY Schedule of Cash Receipts from Sales April COUNT Collections of prior period sales Total cash receipts $ 525,000 367,500 May 535,000 June 560,000
Halifax Shoes has 33% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $85,447 in June, $65,772 in July, and $85,928 in August? Round to the nearest penny, two decimal places
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
PLEASE ANSWER WITHIN 30 MINUTES.
Dolman's, an elite clothier, expects its November sales to be 30% higher than its October sales of $200,000. Purchases were $100,000 in October and are expected to be $150,000 in November. All sales are on credit and are collected as follows: 30% in the month of thé sale and 70% in the following month. Purchases are paid 25% in the TL