The cash balance, May 31, 20X4, is $15,000. Sales proceeds are collected as follows: 80% the month of sale, 10% the second month, and 10% the third month. Accounts receivable are $44,000 on May 31, 20X4, consisting of $20,000 from April sales and $24,000 from May sales. Accounts payable on May 31, 20X4, are $145,000. Carlson Company pays 25% of purchases during the month of purchase and the remainder during the following month. All operating expenses requiring cash are paid during the month of recognition, except that insur- ance and property taxes are paid annually in December for the forthcoming year. Prepare a cash budget for June. Confine your analysis to the given data. Ignore income taxes. Sales Inventory, May 31 Purchases Available for sale Inventory, June 30 Cost of goods sold Gross margin Operating expenses Wages Utilities $290 192 242 202 S 36 Advertising Depreciation Office expenses Insurance and property taxes Operating income

The cash balance, May 31, 20X4, is $15,000. Sales proceeds are collected as follows: 80% the month of sale, 10% the second month, and 10% the third month. Accounts receivable are $44,000 on May 31, 20X4, consisting of $20,000 from April sales and $24,000 from May sales. Accounts payable on May 31, 20X4, are $145,000. Carlson Company pays 25% of purchases during the month of purchase and the remainder during the following month. All operating expenses requiring cash are paid during the month of recognition, except that insur- ance and property taxes are paid annually in December for the forthcoming year. Prepare a cash budget for June. Confine your analysis to the given data. Ignore income taxes. Sales Inventory, May 31 Purchases Available for sale Inventory, June 30 Cost of goods sold Gross margin Operating expenses Wages Utilities $290 192 242 202 S 36 Advertising Depreciation Office expenses Insurance and property taxes Operating income

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

During March, Sam Company had cash sales of $35,000 and sales on account of $210,000. In April, payments on account totaled $175,000. The journal entry prepared by Sam to record the March sales would include a debit to: A. Cash for $35,000, debit to accounts receivable for $210,000, and credit to sales revenue for $245,000 B. Cash for $35,000, debit to deferred revenue for $210,000, and credit to sales revenue for $245,000 C. Cash for $35,000, debit to accounts payable for $210,000, and credit to sales revenue for $245,000 D. Cash and credit to sales revenue for $35,000
Eastern Auto Parts Inc. has 20 percent of its sales paid for in cash and 80 percent on credit. All credit accounts are collected in the following month. Assume the following sales: January February March April $ 82,000 72,000 117,000 62,000 Sales in December of the prior year were $92,000. Prepare a cash receipts schedule for January through April. Sales Cash receipts: Cash sales Prior month's credit sales Total cash receipts Eastern Auto Parts Inc. February January $ 80,000 $ March 81,000 $ April 106,000
from the following data of nature’s herbs company, prepare a sales forecast and schedule of cash receipts for the company covering the last quarter of the year. based on past experience, 20% of sales are collected in the month of sales, 70% in the following month, and 10% are never collected. nature’s herbs company has forecast credit sales for the fourth quarter of the year: september (actual) p 100,000 fourth quarter: october 80,000 november 70,000 december 120,000
Jasper Company has 57% of its sales on credit and 43% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $524,000 for April, $534,000 for May, and $559,000 for June. Total sales for March are $307,500. 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 May Collections of prior period sales Total cash receipts 524,000 ***** 534,000 June 559,000
Jasper Company has 56% of its sales on credit and 44% for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $523,000 for April, $533,000 for May, and $558,000 for June. Total sales for March are $305,700. 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 May Collections of prior period sales Total cash receipts S S $ $ $ $ June
Nonna's Re-Appliance Store collects 52% of its accounts receivable in the month of sale and 37% in the month after the sale. Given the following sales, how much cash will be collected in February? Round to the nearest penny, two decimal places. Month Sales Nonna's Re-Appliance Store data December $20,688 January $62,044 February $69,259
Page Company makes 30% of its sales for cash and 70% on account. 60% of the credit sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month Total sales Total cash receipts in Month 4 will be: Multiple Choice $27,230. $47,900. 1 2 3 $ 60,000 $ 70,000 $50,000 $30,000 £36 230
ABC Company manufactures and sells lighting fixtures. Estimated sales for the next three months are; September – $350,000 October – $500,000 November – $400,000 Sales for August were $400,000. All sales are on account, ABC Company estimates that 60% of the accounts receivable are collected in the month of sale with the remaining 40% collected the following month. The units sell for $30 each. The cash balance for September 1 is $100,000. Generally, 60% of purchases are due and payable in the month of purchase with the remainder due the following month. Purchase cost per unit for materials is $18. The company maintains an end-of-the-month inventory of 1,000 units plus 10% of next month's unit sales. In addition to the information given, selling and administrative expenses paid in cash are $120,000 per month. Requirement: Prepare a monthly cash budget for September and October for ABC Company.
Graham Potato Company has projected sales of $12,000 in September, $15,000 in October, $22,000 in November, and $18,000 in December. Of the company's sales, 30 percent are paid for by cash and 70 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December. Also assume Graham's cash payments for November and December are $18,500 and $11,000, respectively. 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. Graham Potato Company Cash Receipts Schedule Sales Credit sales Cash sales One month after sale Two months after sale Total cash receipts September October November December
Pardee Company makes 30% of its sales for cash and 70% on account. 60% of the account sales are collected in the month of sale, 25% in the month following sale, and 12% in the second month following sale. The remainder is uncollectible. The following information has been gathered for the current year: Month 1 2 3 4 Total sales $78,000 $80,000 $68,000 $48,000 Total cash receipts in Month 4 will be: A. 38,780 B.68,000 C.53,180 D.50,600
Karim Corp. requires a minimum $9,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $9,400, and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow. July August September Cash receipts $ 25,000 $ 33,000 $ 41,000 Cash payments 29,500 31,000 33,000 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $9,400 Total cash available Preliminary cash balance Ending cash…
Halifax Shoes has 30% 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 $75,000 in June, $65,000 in July, and $90,000 in August? NOTE: Enter amounts rounded to the nearest whole dollar. Cash sales Cash for collections the month of sale Cash for collections the month after sale Cash for collections two months after sale TOTAL cash receipts S S LA