XYZ company is preparing its cash budget for the first quarter of the year. It has $10,000 in cash at the beginning of the period. Cash collections from customers for the quarter are budgeted at $28,000. Cash payment during the quarter for inventory purchases are budgeted at $25,000. The desired cash balance at the end of the quarter is $11,000. Other operating expenses for the quarter are budgeted at $20,000, which includes $3,000 depreciation. Cash expenses are paid in the month incurred. How much borrowing will the company need during the quarter? Select one: O a. None of the given answers b. $21,000 O c. $15,000 d. $7,000 O e. $18,000

XYZ company is preparing its cash budget for the first quarter of the year. It has $10,000 in cash at the beginning of the period. Cash collections from customers for the quarter are budgeted at $28,000. Cash payment during the quarter for inventory purchases are budgeted at $25,000. The desired cash balance at the end of the quarter is $11,000. Other operating expenses for the quarter are budgeted at $20,000, which includes $3,000 depreciation. Cash expenses are paid in the month incurred. How much borrowing will the company need during the quarter? Select one: O a. None of the given answers b. $21,000 O c. $15,000 d. $7,000 O e. $18,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

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.
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:
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.
The Panda Company has budgeted its activity for October according to the following information: Sales are budgeted at $392,000 and all sales are for cash. All purchases of merchandise inventory are for cash. Merchandise inventory was $150,000 on September 30 and the planned merchandise inventory on October 31 is $140,000. All merchandise is sold at 40% above cost. The selling and administrative expenses are budgeted at $92,000 for the month. All of these expenses are paid for in cash except for depreciation of $12,000. What is the budgeted net income 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
Bright Minds Toy Company prepared the following sales budget for the second quarter. Projected sales for each of the first three months of operations are as follows: Sales Budget Cash Sales April 130,000 470,000 Sales on Account 600,000 Multiple Choice Bright Minds expects to collect 70% of the sales on account in the month of sale, 20% in the month following the sale, and the remainder in the second month following the sale. What is the ending accounts receivable balance that would be reported on the pro forma balance sheet prepared as of June 30? O O O $202,700 $149,500 $344.000 May 83,000 512,000 595,000 $106,400 June 155,000 505,000 660,000
B. Mahmoud Repair Company is preparing its budget for the first quarter of 2021. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2021 are: November 2020, $120,000; December 2020, $110,000; January 2021, $140,000; February 2021, $160,000; March 2021, $170,000. Purchases on landscaping supplies (direct materials) are paid 40% in the month of purchase and 60% the following month. Actual purchases for 2020 and expected purchases for 2021 are: December 2020, $21,000; January 2021, $20,000; February 2021, $22,000; March 2021, $27,000. Instructions (a) Prepare the following schedules for each month in the first quarter of 2021 and for the quarter in total: (1)…
Tucker Inc. had the following budgeted sales for the first half of the current year: Cash Sales Credit SalesJanuary $70,000 $340,000February 50,000 190,000March 40,000 135,000April 35,000 120,000May 45,000 160,000June 40,000 140,000The 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: Collections on credit sales: 60% in month of sale 30% in month following sale 10% in second month following sale There is no beginning accounts receivable balance. The total cash collected by Tucker Inc. during January would be: The total cash collected by Tucker Inc. during February would be: The total cash collected by Tucker Inc. during March would be: The total cash collected by Tucker Inc. during April would be: The total cash collected by Tucker Inc. during May would…
Miles Manufacturing has prepared the following sales budget for the first four months of the year: SALES: January - 20,000February - 22,000March - 25,000April - 21,000 Miles estimates that it will begin the year with 3,000 units in inventory. The company wants to end each month with inventory equal to 25% of the next month's projected sales. Prepare a production budget for each month: January, February and March. Show your work!
Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 45,000 for January, 55,000 for February, and 50,000 for March. Cost of goods sold is $14 per unit. Other expense information for the first quarter follows. Prepare a budgeted income statement for this first quarter. (Round expense amounts to the nearest dollar.) Commissions . 8% of sales dollars Advertising 15% of sales dollars Interest 5% annually on a $250,000 note payable Tax rate . 30% Rent . . . . . . . . . . . . . . . . $14,000 per month Office salaries . . . . . . . . $75,000 per month Depreciation $40,000 per month
Schuepfer Incorporated bases its selling and administrative expense budget on budgeted unit sales. The sales budget shows 3,500 units are planned to be sold in March. The variable selling and administrative expense is $4.00 per unit. The budgeted fixed selling and administrative expense is $35,850 per month, which includes depreciation of $5,000 per month. The remainder of the fixed selling and administrative expense represents current cash flows. The cash disbursements for selling and administrative expenses on the March selling and administrative expense budget should be: Multiple Choice $49,850 $44,850 $30,850 $14,000
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 $245,000, $311,000, and $413,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: a. $231,280 O b. $187,740 Oc. $329,784 Od. $274,820