Brady, Inc. is in the process of budgeting cash inflows for the next three months. Cash sales are 10 percent of total sales each month. Historically, sales on account have bee collected as follows: 70 percent in the month of sale, 25 percent in the month after th sale, and the remaining 5 percent two months after the sale. Sales for the next three months are projected as follows: April, $192,000; May, $210,000; and June, $220,000 Accounts receivable on March 31 was $54,000.

Brady, Inc. is in the process of budgeting cash inflows for the next three months. Cash sales are 10 percent of total sales each month. Historically, sales on account have bee collected as follows: 70 percent in the month of sale, 25 percent in the month after th sale, and the remaining 5 percent two months after the sale. Sales for the next three months are projected as follows: April, $192,000; May, $210,000; and June, $220,000 Accounts receivable on March 31 was $54,000.

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

Orange Company has sales of $50,000 in March and $60,000 in April. Forecast sales for May, June, and July are $70,000, $80,000, and $100,000, respectively. The firm has a cash balance of $5,000 on 1 May and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. • The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale • The firm recelves other income of $2,000 per month • The firm's actual or expected purchases, all made for cash, are $50,000, $70,000, and $80,000 for the months of May through July, respectively • Rent is $3,000 per month • Wages and salaries are 10% of the previous month's sales • Cash dividends of $3,000 will be paid in June • Payment of principal and interest of $4,000 is due in June • A cash purchase of equipment costing $6,000 is scheduled in July • Taxes of $6,000 are due in…
McFarland Company makes 70 percent of its sales in cash. Credit sales are collected as follows: 70 percent in the month of sale and 30 percent in the month following the sale. McFarland's budgeted sales for upcoming months follow: $ 24,200 42,000 40,000 38,000 June July August September Required: Compute McFarland's expected cash receipts for August Budgeted Cash Receipts
Given the following information, complete the cash budget: Collections occur one month after the sale. January’s credit sales were $90,000. The firm has a certificate of deposit for $50,000 that matures in April. Salaries are $150,000 a month. The monthly mortgage payment is $20,000. Monthly depreciation is $10,000. Property tax of $35,000 is due in February. Round your answers to the nearest dollar. Enter the disbursements values as positive values. Use a minus sign to enter shortage of cash, negative beginning and ending cash values, if any. Do not leave any cells blank. If the answer is zero, enter "0". February March April Sales $ 170,000 $ 200,000 $ 230,000 Cash sales $ 35,000 $ 20,000 $ 70,000 Collections $ $ $ Other receipts $ $ $ Total cash receipts $ $ $ Salaries $ $ $ Mortgage $ $ $ Other disbursements $ $ $ Total cash disbursements $ $ $ Net…
Dax, Inc., collects its accounts receivable as follows: 30% in the month ofsale, 60% in the next month, and 8% in the second month after the sale; 2%are uncollectible. Budgeted sales for the next four months are March, $16,000; April, $22,000; May, $19,000; and June, $23,000. Budgeted collections forJune area. $20,060.b. $20,380.c. $21,260.d. $21,380.
The Model Company is to begin operations in April. It has budgeted April sales of $70,000, May sales of $74,000, June sales of $80,000, July sales of $82,000, and August sales of $78,000. Note that 10% of each month's sales is expected to represent cash sales; 75% of the balance is expected to be collected in the month following the sale, 17% the second month, 6% the third month, and the balance is expected to be uncollectible. What is the amount of cash to be collected in the month of July?
Mitchell Company had the following budgeted sales for the first half of next year: The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Assume that the accounts recelvable balance on January 1 was $76,000. Of this amount, $60,000 represented uncollected December sales and $16,000 represented uncollected November sales. Glven these data, the total cash collected during January would be: Multiple Choice $138.000 $100,000 $196,000 $197,000
Nestee controller for Mactan Relaters has assembled the following data to assist in the preparation of a cash budget for the third quarter of 2021: Sales- May $100,000 ;June $120,000; July $90,000 ; August $100,000 September $135,000; October $110,000 Each month, 30% of sales are for cash and 70% ore on credit. The collection pattern for credit sales is 20% in the month of sale, 50% in the following month, and 30% in the second month following the sale. Each month the ending inventory exactly equals 50% of the cost of next month's sales. The markup on goods is 25% of cost. Inventory purchases are paid in the month following the purchase. Monthly expenses are as follows: Salaries and wages $10,000; Depreciation $4,000; Utlites $1,000; Other $1,700. Property taxes of $15,000 are due and payable on July 15,2021. Advertising fees of $6,000 must be paid on August 20,2021. A lease on a new storage facility is scheduled to begin on September 2, 2021.Monthly payments are $5,000. The…
Laurey Inc. is working on its cash budget for June. The budgeted beginning cash balance is $45,100. Budgeted cash receipts total $129,000, and budgeted cash disbursements total $134,000. The desired ending cash balance is $60,000. To attain its desired ending cash balance for June, the company needs to borrow:
Company L charges all operating expenses to credit. They pay 70% of their accounts payable in the month following the expense, and 30% two months following the expense. Expenses (all paid for on credit) for the last three months have been provided below: August: $80,000 September: $120,000 October: $94,000 What is the budgeted cash outflow for October?
Nuthatch Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business September, October, and November are $239,000, $319,000, and $424,000, respectively. The company expects to sell 30% of its merchandise for cash. Of sales on account, 80% are expected to be collected in the month of the sale and 20% in the month following the sale. The cash collections expected in November from accounts receivable are projected to be: Ca. $338,520 Ob. $282,100 Oc. $237,440 Od. $192,780
Martinez Company has budgeted sales revenue as follows for the next 4 months: February March April May March sales Past experience indicates that 70% of sales each month are on credit. The remainder are cash sales. Collection of credit sales occurs as follows: 60% in the month of sale, 35% in the month following the sale, and 3% in the second month following the sale. The other 2% is uncollectible. Credit sales Prepare a schedule which shows expected cash receipts from sales for the month of May. April sales MARTINEZCOMPANY Expected Cash Receipts from Sales For the Month Ended May 31 Credit sales $310,000 May sales 245,000 Credit sales 230,000 Cash sales 330,000 Total cash receipts OOONO
Evans Company's cash sales are normally 60% of total sales. Anticipated sales for April and May are $588,000 and $550,000 respectively of the credit sales. 10% are collected in the same month as the sale, 70% are collected during the first month after the sale, and the remaining 20% are collected in the second month. Determine the accounts receivable balance that should be reported on Evan's budgeted balance sheet as of May 31.