Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 210,000 $ 281,000 $360,000 $ 251,000 cash balance Required: Prepare the company's cash budget for the upcoming fiscal year. Note: Repayments and interest should be indicated by a minus sign. 3rd Quarter $ 240,000 $ 241,000 The company's beginning cash balance for the upcoming fiscal year will be $26,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. 4th Quarter $ 260,000 $ 261,000 Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year

Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter $ 210,000 $ 281,000 $360,000 $ 251,000 cash balance Required: Prepare the company's cash budget for the upcoming fiscal year. Note: Repayments and interest should be indicated by a minus sign. 3rd Quarter $ 240,000 $ 241,000 The company's beginning cash balance for the upcoming fiscal year will be $26,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. 4th Quarter $ 260,000 $ 261,000 Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter4: Internal Control And Cash

Section: Chapter Questions

Problem 66.1C

See similar textbooks

Similar questions

Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements 1st Quarter 2nd Quarter 3rd Quarter $ 320,000 $ 372,000 $ 370,000 $ 332,000 Beginning cash balance Total cash receipts Total cash available Total cash disbursements The company's beginning cash balance for the upcoming fiscal year will be $27,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Required: Prepare the company's cash budget for the upcoming fiscal year. Note: Repayments, interest, and cash deficiencies should be…
PREPARE CASH BUDGET FOR YEAR 2021 Use the format if necessary as a guide: Cash Balance, January 1, 2021 Add: Collection from Customers Total Cash Available Less: Disbursements Payments for Material Purchases Direct Labor Factory Overhead Selling and Administrative Expenses Equipment purchase Tax Expenses Dividends Total Disbursements Excess (deficiency) of cash available over disbursements Investing: Long-term Investment Increments Interest Receivable Total Cash used in Investing Financing: Borowwings Repayments Interest Paid Total Financing Cash Balance, Ending
Kat Ltd.'s September balance sheet contains the following information: Cash Accounts receivable. Allowance for doubtful accounts Merchandise inventory $ 37,500 (dr) 126,000 (dr) 2,800 (cr) 26,250 (dr) Management has designated $37,500 as the firm's minimum monthly cash balance. Other information about the firm and its operations is as follows: a. Sales revenues of $350,000, $420,000, and $312,500 are expected for October, November, and December, respectively. All goods are sold on account. b. The collection pattern for accounts receivable is 60% in the month of sale, 39% in the month following the month of sale, and 1% uncollectible, which is set up as an allowance. c. Cost of goods sold is 60% of sales revenues. d. Management's target ending balance of merchandise inventory is 10% of the current month's budgeted cost of goods sold. e. All accounts payable for inventory are paid in the month of purchase. f. Other monthly expenses are $49,250, which includes $3,500 of depreciation and…
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…
QS 20-24 (Algo) Manufacturing: Cash budget LO P2 Using the following information: a. Beginning cash balance on March 1, $76,000. b. Cash receipts from sales, $308,000. c. Cash payments for direct materials, $140,000. d. Cash payments for direct labor, $79,000. e. Cash payments for overhead, $37,000. f. Cash payments for sales commissions, $7,000 g. Cash payments for interest, $170 (1% of beginning loan balance of $17,000) h. Cash repayment of loan, $17,000. Prepare a cash budget for March for Gado Company. Total cash available GADO COMPANY Cash Budget March
Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts cash payments $ 528,000 410,000 January February March $469,300 351,300 533,000 Kayak requires a minimum cash balance of $40,000 at each month-end. Loans taken to meet this requirement charge 1%, interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $40,000 is used to repay loans at month-end. The company has a cash balance of $40,000 and a loan balance of $80,000 at January 1 Prepare monthly cash budgets for January, February, and March. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign.) Answer is not complete. KAYAK COMPANY Cash Budget January February March
Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs • Raw materials purchases are paid and • Accounts payable for raw materials, beginning balance $12 per unit $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 •Direct labor cost per hour •Direct labor hour per unit $15 per hour 0.2 hour per unit $2 per hour $60,000 •Variable MOH rate…
January February March Sales $100,000 $121,000 $165,000 Manufacturing costs 42,000 52,000 59,000 Selling and administrative expenses 29,000 33,000 36,000 Capital expenditures 40,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 65% are expected to be collected in full in the month following the sale and the remainder the following month. Depreciation, insurance, and property tax expense represent $8,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in June, and the annual property taxes are paid in October. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. All sales and administrative expenses are paid in the month incurred. Current assets as of January 1 include cash of $38,000, marketable securities of $54,000, and accounts receivable of $116,000 ($88,000 from December sales and $28,000 from November…
ⒸPR 22-5A Cash Budget Obj. 5 The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: Sales Manufacturing costs Selling and administrative expenses Capital expenditures September $250,000 150,000 42,000 October $300,000 180,000 48,000 Answer Check Figure: November deficiency, $(8,500) 2. November $315,000 185,000 51,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the…
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. Beginning cash balance on June 1, P85,300. b. Cash receipts from sales, P519,500. Budgeted cash disbursements for purchases, P274,500. C. d. Budgeted cash disbursements for salaries, P96,300. e. Other budgeted cash expenses, P58,300. f. Cash repayment of bank loan, P33,300. g. Budgeted depreciation expense, P35,300. Use the above information to determine the ending cash balance to be reported on the month ended June 30 cash budget.
Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: July August $160,000 $185,000 $200,000 66,000 82,000 105,000 51,000 120,000 40,000 46,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent $12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Sales Manufacturing costs Selling and administrative expenses Capital expenditures June Current assets as of June 1 include cash of $42,000,…