The cash budget for the first three quarters of the company is given below (000 omitted). The company requires a minimum cash balance of $5,000 to start each quarter. If necessary, the company will borrow money from its bank to maintain this balance. The company will pay no interest in Quarters 1, 2, and 3. It will repay as much of its borrowings as possible as soon as it has more than $5,000 in cash in a given quarter. Suppose the company starts the first quarter with no bank debt. How much total bank debt does the company expect to have at the end of the third quarter? Cash Budget Quarter (000 omitted) 1 2 3 Cash balance, beginning $9 ? Add collections from customers 88 126 Total cash available ? ? Less disbursements: Purchase of inventory 55 Selling and administrative expenses 41 Equipment purchases 7 Dividends 2 Total disbursements ? ? Excess (deficiency) of cash available over disbursements Financing: ? Borrowings ? Repayments Total financing ? Cash balance, ending ? 65 45 10 2 ? ? ? ? ? ? ? 88 ? 65 51 10 2 ? ? ? ? ? ?

The cash budget for the first three quarters of the company is given below (000 omitted). The company requires a minimum cash balance of $5,000 to start each quarter. If necessary, the company will borrow money from its bank to maintain this balance. The company will pay no interest in Quarters 1, 2, and 3. It will repay as much of its borrowings as possible as soon as it has more than $5,000 in cash in a given quarter. Suppose the company starts the first quarter with no bank debt. How much total bank debt does the company expect to have at the end of the third quarter? Cash Budget Quarter (000 omitted) 1 2 3 Cash balance, beginning $9 ? Add collections from customers 88 126 Total cash available ? ? Less disbursements: Purchase of inventory 55 Selling and administrative expenses 41 Equipment purchases 7 Dividends 2 Total disbursements ? ? Excess (deficiency) of cash available over disbursements Financing: ? Borrowings ? Repayments Total financing ? Cash balance, ending ? 65 45 10 2 ? ? ? ? ? ? ? 88 ? 65 51 10 2 ? ? ? ? ? ?

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 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)?
Here are some important figures from the budget of Nashville Nougats, Incorporated, for the second quarter of 2022: April May June $399,000$ 348,000 $436,000 176,000 164,000 197,000 Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2022, credit sales were $326,000. Cash collections from credit sales Total cash available Cash disbursements Using this information, complete the following cash budget. Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. Purchases Wages, taxes, and expenses Interest Equipment purchases 79,400 9,100 31,500 Total cash…
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash ba of $7,000 to start each quarter. Required: Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus Quarter (000 omitted) (000 omitted) 1 2 3 4 Year Cash balance, beginning $ 7 $ 7 Add collections from customers 84 88 105 378 Total cash available 91 95 Less disbursements: Purchase of inventory 44 54 28 Selling and administrative expenses Equipment purchases 41 32 30 124 8 8 19 45 Dividends 2 2 2 2 Total disbursements 95 96 Excess (deficiency) of cash available over disbursements (2) (1) 12
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $3,000 to start each quarter. Required: Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments (including interest)* Total financing Cash balance, ending *Interest will total $1,000 for the year. Quarter 1 (000 omitted) $ 9 97 54 7 2 (5) Quarter 2 (000 omitted) 64 45 9 2 120 12 Quarter 3 (000 omitted) 124 30 29 2 12 Quarter 4 (000 omitted) 30 2 (12) Year (000 omitted) 431 137 55
am. 116.
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $43,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. July Cash receipts Cash payments $ 94,000 122,000 August September $120,000 108,900 $ 159,000 136,400 Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Answer is not complete. MOTORS CORPORATION Cash Budget July August September Beginning cash balance $ 43,000 $ 30,000 $ 30,000 Add: Cash receipts 94,000 120,000…
The Hubbard Corporation is a distributor of hair care products and is ready to start the third quarter, in which its peak sales occur. The company has requested a $100,000, 90-day loan from its bank to help them meet their cash requirements for the third quarter. Since Hubbard Corporation has experienced difficulty in paying off their loans in previous years, the loan officer has requested the company prepare a cash budget for the third quarter. The following data has been gathered by the staff. On July 1, 2021, the beginning of the third quarter, the company will have a cash balance of $75,000. Actual sales for the last 2 months and budgeted sales for the third quarter (all sales are on account). Month Amount in Dollars ($) May (actual) 500,000 June (actual) 480,000 July (budgeted) 520,000 August (budgeted) 550,000 September (budgeted) 600,000 Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month…
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $4,000 to start each quarter. Required: Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends Total disbursements Excess (deficiency) of cash available over disbursements. Financing: Borrowings Repayments (including interest) * Total financing Cash balance, ending *Interest will total $1,000 for the year. $ 1 6 69 47 10 2 (5) Quarter (000 omitted) 2 3 57 32 9 2 100 6 108 30 22 2 7 4 31 2 (13) (000 omitted) Year 369 98 51
The fourth option is $16,600 needed, below $12,400 available.
Holiday Tree Farm has a cash balance of $34 and a short-term loan balance of $180 at the beginning of Qt. The net cash inflow for the first quarter is $36 and for the second quarter there is a net cash outflow of $48. All cash shortfalls are funded with short-term debt. The firm pays 2 percent of its prior quarter's ending loan balance as interest each quarter. The minimum cash balance is $20. What is the short-term loan balance at the end of Q2? Multiple Choice $184.3 $179.2 $138.6 $128.4 $1931
The Hubbard Corporation is a distributor of hair care products and is ready to start the third quarter, in which its peak sales occur. The company has requested a $100,000, 90-day loan from its bank to help them meet their cash requirements for the third quarter. Since Hubbard Corporation has experienced difficulty in paying off their loans in previous years, the loan officer has requested the company prepare a cash budget for the third quarter. The following data has been gathered by the staff. On July 1, 2021, the beginning of the third quarter, the company will have a cash balance of $75,000. Actual sales for the last 2 months and budgeted sales for the third quarter (all sales are on account). Month Amount in Dollars ($) May (actual) 500,000 June (actual) 480,000 July (budgeted) 520,000 August (budgeted) 550,000 September (budgeted) 600,000 Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month…
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $8,000 to start each quarter. Required: Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign. Cash balance, beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments (including interest) * Total financing Cash balance, ending *Interest will total $1,000 for the year. $ 1 S 70 42 14 2 (8) Quarter (000 omitted) 2 3 52 32 8 2 94 10 103 30 17 2 14 4 34 2 (21) (000 omitted) Year 347 103 49