Sedita Incorporated is working on its cash budget for July. The budgeted beginning cash balance is $17,000. Budgeted cash receipts total $176,000 and budgeted cash disbursements total $175,000. The desired ending cash balance is $47,000. The excess (deficiency) of cash available over disbursements for July will be:

Sedita Incorporated is working on its cash budget for July. The budgeted beginning cash balance is $17,000. Budgeted cash receipts total $176,000 and budgeted cash disbursements total $175,000. The desired ending cash balance is $47,000. The excess (deficiency) of cash available over disbursements for July will be:

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

The following information is provided to assist in the preparation of the Cash Budget for Ding Ltd. for May 2020. The cash balance at 1 May 2020 is $30,000. Budgeted Sales ($) Budgeted Purchases ($) April 170,000 64,000 May 140,000 68,000 All sales are on cash basis and will be collected in the same month the sale is made. All purchases are made on credit and payments are made as follows: 60% of purchases are paid for in the month of purchase. 40% of purchases are paid for in the month following the purchase. The business plans to take out a small business loan of $50,000 at the end of May 2020 and will be repaying it back in July 2020. Selling and administrative expenses each month are $45,000. The selling and administrative expenses include monthly depreciation expense of $6,000. Sales commission is 15% of the total monthly sales, and paid to the staff at the end of every month. Equipment costing $35,000 is expected to be bought in May and paid in…
Use the following information to prepare the September cash budget for PTO Company. Ignore the "Loan activity" section of the budget. a. Beginning cash balance, September 1, $44,000. b. Budgeted cash receipts from September sales, $261,000. c. Direct materials are purchased on credit. Purchase amounts are August (actual), $78,000; and September (budgeted), $106,000. Payments for direct materials follow: 65% in the month of purchase and 35% in the first month after purchase. d. Budgeted cash payments for direct labor in September, $34,000. e. Budgeted depreciation expense for September, $3,300. f. Budgeted cash payment for dividends in September, $54,000. g. Budgeted cash payment for income taxes in September, $10,200. h. Budgeted cash payment for loan interest in September, $1,200. PTO COMPANY Cash Budget September Beginning cash balance Total cash available 0 Total cash payments 0 Ending cash balance $ 0
Midus ind has the following data for the month ended on March 31. Prepare cash budget for the month of March 2021 with expected balance at the end. Beginning cash balance on March 1= $82,000 Cash repayment of bank loan= $18,000 Other budgeted cash expenses= $39,000 Cash receipts from sales= $315,000 Budgeted cash disbursements for salaries=$83,000 Budgeted cash disbursements for purchases=$146,000
The company provides the following information regarding the cash budget for next year: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Beginning cash balance $5,000 $5,000 $5,000 $5,000 Excess (Deficiency) ($3,000) $2,000 ($2,500) $1,000 The company's policy is to start each quarter with a cash balance of $5,000.The company has access to a line of credit in the amount of $50,000 for any short term borrowing needs and pays the loans off as quickly as possible.The company assumes the cash budget for the year will begins with no loans.What is the expected loan balance at the end of Quarter 2 (ignore interest)?
Verle, Inc. has a cash balance of $24,000 on April 1. The company is now preparing the cash budget for the second quarter. Budgeted cash collections and payments are as follows: Cash collections Cash payments: Purchases of direct materials Operating expenses Apr May Jun $24,000 $24,000 $25,000 5,800 4,600 4,600 6,000 3,500 5,300 There are no budgeted capital expenditures or financing transactions during the quarter. Based on the above data, calculate the projected cash balance at the end of May. OA. $60,200 OB. $24,000 OC. $52,100 OD. $55,600
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:
Your Company is working on its cash budget for July. The budgeted beginning cash balance is $46,000. Budgeted cash receipts total $174,000 and budgeted cash disbursements total $175,000. The desired ending cash balance is $50,000. What is the excess (deficiency) of cash available over disbursements for July? Group of answer choices $ 45,000 $221,000 $ 50,000 $ 1,000 $ 47,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)…
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 $9,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:a. $13,000b. $19,000c. None of the given answersd. $5,000e. $16,000
Bagel Company is preparing its cash budget for the upcoming month. The beginning cash balance for the month is expected to be $17,000. Budgeted cash receipts are $87,000, while budgeted cash disbursements are $70,000. Bagel Company wants to have an ending cash balance of $50,000. The excess (deficiency) of cash available over disbursements for the month would be
Soru Muscat Inc. is working on its cash budget for December. The budgeted beginning cash balance is $14,000. Budgeted cash receipts total $127,000 and budgeted cash disbursements total $126,000. The desired ending cash balance is $50,000. How much the company needs to borrow a. $35,000 b. $0 c. $50,000 d. $70,000 tictheiournalentry to assien indirect raw materials to a iob W P
Varughese Incorporated is working on its cash budget for March. The budgeted beginning cash balance is $33,000. Budgeted cash receipts total $182,000 and budgeted cash disbursements total $191,000. The desired ending cash balance is $40,000. The excess (deficiency) of cash available over disbursements for March will be: Multiple Choice O O ($9,000) $24,000 $215,000 $42,000