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?

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?

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

Sales are budgeted at $360,000 for November, $370,000 for December, and $350,000 for January. . Collections are expected to be 40% in the month of sale and 60% in the month following the sale. • The cost of goods sold is 60% of sales. • The company desires an ending merchandise inventory equal to 20% of the cost of goods sold in the following month. Payment for merchandise is made in the month following the purchase. • The November beginning balance in the accounts receivable account is $71,000. • The November beginning balance in the accounts payable account is $258,000. Required: a. Prepare a Schedule of Expected Cash Collections for November and December. b. Prepare a Merchandise Purchases Budget for November and December. Complete this question by entering your answers in the tabs below. Required A Required B Prepare a Schedule of Expected Cash Collections for November and December. Sales Schedule of Expected Cash Collections Accounts receivable November sales December sales Total…
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…
A company is preparing its cash budget for the upcoming quarter. The company's sales are expected to be $500,000 in January, $600,000 in February, and $700,000 in March. The company's cost of goods sold is 60% of sales. The company's beginning cash balance is $50,000, and the company desires to maintain a minimum cash balance of $25,000. What is the company's budgeted cost of goods sold for February? $360,000 $540,000 $450,000 $350,000
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…
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…
jagdish
Palermo Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $500,000 for April and $575,000 for May. Cost of goods sold is expected to be 70% of sales. The company’s desired ending inventory is 18% of the following month’s cost of goods sold. Compute the required purchases for April.
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 been collected as follows: 70 percent in the month of sale, 25 percent in the month after the 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.
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?
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.
Develop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $150,000, $180,000, and $60,000 (June, July, August) The current month's sales are $120,000 (May) Cost of goods sold equals 65% of sales Lease payment= 22,000 per month The company is required to pay an installment of $120,000 for a note (debt) The cash position at the end of the current month is $80,000 The target cash balance is $50,000 Assume that 60% of sales are collected in the month sold and the remaining collected in the following month.