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. 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 8 94 49 12 2 (1) Quarter (000 omitted) 2 3 59 45 9 2 115 17 110 30 24 2 5 4 33 2 (20) (000 omitted) Year 400 130 55

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. 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 8 94 49 12 2 (1) Quarter (000 omitted) 2 3 59 45 9 2 115 17 110 30 24 2 5 4 33 2 (20) (000 omitted) Year 400 130 55

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

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. 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. GA 1 8 84 92 53 8 2 (1) Quarter (000 omitted) 2 3 63 45 9 2 119 13 120 30 28 2 9 4 29 2 (12) (000 omitted) Year 420 127 55
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 31 (13) (000 omitted) Year 369 98 51
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
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $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 $ 9 87 38 10 2 (2) Quarter (000 omitted) 2 3 48 30 10 2 90 14 99 30 13 2 16 30 2 (17) (000 omitted) Year 348 121 43
A cash budget, by quarters, is given below for a retall company (000 omitted). The company requires a minimum cash balance of at least $6,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 the Quarter 1 (000 omitted) $ 6 S 80 86 43 34 15 Quarter 2 (000 omitted) 2 94 (8) 6 S 53 32 8 2 Quarter 3 (000 omitted) 95 6 104 110 30 18 2 11 Quarter 4 (000 omitter) $ 35 10 2 (10) Year (000 omitted) $ 6 370 118 51 8
are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $26,800. Accounts receivable on April 1 will total $193,200, of which $165,600 will be collected during April and $22,080 will be collected during May. The remainder will be uncollectible. b. Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April $360,000 $ 275,000 $32,000 $ 38,400 $ 73,000 $0 $ 15,400 Required 1 Required 2 May $ 582,000 $ 227,000 $ 32,000 $ 38,400 $ 73,000 $0 $ 15,400 c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise…
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $4,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: Quarter (000 omitted) (000 omitted) 1 2 3 4 Year 6 $ 4 $ 4 $ 4 6 Assessment Tool iFrame 63 96 108 104 369 69 100 112 108 375 Purchase of inventory 47 Selling and administrative expenses 15 530 57 51 31 186 32 30 21 98 Equipment purchases 10 9 22 10 51 Dividends 2 2 2 2 8 Total disbursements Excess (deficiency) of cash available over disbursements 74 100 105 64 343 (5) (1) 7 44 32 Financing: Borrowings Repayments (including interest) * Total financing 9 6 14 (2) (13) (15) 9 6 (2) (13) (1) Cash balance, ending $ 4 $ 4 $ EA 5 31 31 *Interest will total $1,000 for the year.
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $4,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. Quarter (000 omitted) 2 3 (000 omitted) Year Cash balance, beginning $ $ 5 $ $ $ 6 Add collections from customers 63 95 108 369 Total cash available 69 100 375 Less disbursements: Purchase of inventory 47 57 31 Selling and administrative expenses 15 32 30 98 Equipment purchases 10 9 22 51 Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments (including interest)* Total financing 2 2 2 2 74 100 (5) (13) Cash balance, ending $ "Interest will total $1,000 for the year.
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. Fill in the missing amounts. Note: Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign. Quarter (000 omitted) (000 omitted) 1 2 3 4 Year Cash balance, beginning $ 7 Add collections from customers 109 392 Total cash available 89 Less disbursements: * Purchase of inventory 48 58 32 Selling and administrative expenses 45 30 127 Equipment purchases 11 9 23 53 Dividends 2 2 2 2 Total disbursements 114 Excess (deficiency) of cash available over disbursements (2) 7 Financing: Borrowings Repayments (including interest) * Total financing Cash balance, ending "Interest will total $1,000 for the year. 18 (22)
Prime Products hopes to borrow $79,000 on April 1 and repay it plus interest of $1,140 on June 30. The following data are available for the months April through June, during which the loan will be used: a. On April 1, the start of the loan period, the cash balance will be $16,500. Accounts receivable on April 1 will total $190,400, of which $163,200 will be collected during April and $21,760 will be collected during May. The remainder will be uncollectible. b. The company estimates 30% of a month's sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% are bad debts that are never collected. Budgeted sales and expenses for the three- month period follow: Sales (all on account) Merchandise purchases Payroll Lease payments Advertising Equipment purchases Depreciation April May $ 312,000 $ 204,000 $ 24,000 $ 24,800 $ 79,200 $ 428,000 $ 162,000 $ 24,000 $ 24,800 $ 79,200 $ 17,200 $ 17,200 c. Merchandise purchases…
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. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.)
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. 1 Quarter (000 omitted) (000 omitted) 2 3 4 Year Cash balance, beginning $ 9 Add collections from customers 61 103 347 Total cash available 70 Less disbursements: Purchase of inventory 42 52 34 Selling and administrative expenses 32 30 103 Equipment purchases 14 8 17 49 Dividends Total disbursements Excess (deficiency) of cash available over disbursements 2 2 2 94 (8) 14 Financing: Borrowings Repayments (including interest)* Total financing 10 (21)