E8-33. Cash balance The following budgeted May cash information is available for Salado Corp.: $336,000 56,200 82,000 8,000 7,000 4,100 35,000 47,000 Net after-tax income. Depreciation expense. Accrued income tax expense Increase in Accounts Receivable for month. Decrease in Accounts Payable for month Estimated bad debts expense Dividends declared in May.. Dividends paid in May If Salado's May 1 cash balance is $23,000, what is the company's budgeted May 31 cash balance?

E8-33. Cash balance The following budgeted May cash information is available for Salado Corp.: $336,000 56,200 82,000 8,000 7,000 4,100 35,000 47,000 Net after-tax income. Depreciation expense. Accrued income tax expense Increase in Accounts Receivable for month. Decrease in Accounts Payable for month Estimated bad debts expense Dividends declared in May.. Dividends paid in May If Salado's May 1 cash balance is $23,000, what is the company's budgeted May 31 cash balance?

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.2C

See similar textbooks

Similar questions

You are provided with the following information taken from Sage Hill Inc's March 31, 2027, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1 2 3. 5. 6. 7. Additional information concerning Sage Hill Inc. is as follows. Gross profit is 24% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April $18.840 $47.100 $62460 $12,280 72.700 23.120 37,100 123,400 22,910 Sales are both cash and credit, Cash collections expected in April are: 152.900 12.320 (40% of $47.100) (60% of $72,700) Half of a month's purchases are paid for in the month of purchase and half in the following month Cash disbursements expecte Purchases March Purchases April $22,910 28,910 $51820 Cash operating costs are anticipated to be $12,110 for the month of April. Equipment costing $2,530 will be purchased for cash in April. The company wishes to maintain a minimum cash balance of $12,240. An…
Cash balanceThe following budgeted May cash information is available for Salado Corp.: Net after-tax income $201,600 Depreciation expense 33,720 Accrued income tax expense 49,200 Increase in Accounts Receivable for month 4,800 Decrease in Accounts Payable for month 4,200 Estimated bad debts expense 2,460 Dividends declared in May 21,000 Dividends paid in May 28,200 If Salado’s May 1 cash balance is $13,800, what is the company’s budgeted May 31 cash balance? $Answer
The following information pertains to Omega Projects Ltd for the three months ended 31 December 2020. Actual Budgeted October November December R R R Revenue (20% for cash and 80% on credit) 360 000 380 000 400 000 Purchases (10% for cash 90% on credit) 240 000 280 000 320 000 Salaries and wages paid 40 000 60 000 60 000 Cash expenses 24 000 28 000 32 000 Depreciation 2 000 2 000 2 000 Additional information: It is expected that debtors will settle their accounts as follows: 20% in the month of invoice 70% in the month after the month of invoice, and 5% in the second month after the month of The remaining 5% is usually written off as bad Trade creditors are paid in the month after the purchases at a discount of 5%. 50% of the salaries and wages are weekly wages. Because wages are paid weekly, usually 10% of the wages are paid in the month following the month in which they were…
Kayak Co. budgeted the following cash recelpts (excluding cash recelpts from loans recelved) and cash payments (excluding cash payments for loan principal and Interest payments) for the first three months of next year. Cash Cash Receipts $519,eee payments $464,7ee 358, 208 524, еее January February 412,5ee March 464,eee According to a credlt agreement with Its bank, Kayak requires a minimum cash balance of $40,000 at each month-end. In return, the bank has agreed that the company can borrow up to $140,000 at a monthly Interest rate of 1% , pald on the last day of each month. The interest is computed based on the beginning balance of the loan for the month. The company repays loan principal with any cash In excess of $40,000 on the last day of each month. 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 wlth minus…
The controller of Ultramint Company wishes to improve the company's control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2008. June 30, 2008 cash balance ... Dividends to be declared on July 15* Cash expenditures to be paid in July for operating expenses Amortization expense.... Cash collections to be received ... $ 90,000 24,000 73,600 9,000 178,000 112,400 41,000 50,000 Merchandise purchases to be paid in cash Equipment to be purchased for cash. …….. Ulramint Company wishes to maintain a minimum cash balance of .... *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: Prepare a cash budget for the month ended July 31, 2008, indicating how much, if anything, Ultramint will need to borrow to meet its minimum cash requirement.
Sonoma Housewares Inc. Cash Budget For the Three Months Ending July 31 May June July Estimated cash receipts from: Cash sales $ $ Collection of accounts receivable Total cash receipts $ Estimated cash payments for: Manufacturing costs Selling and administrative expenses Capital expenditures Other purposes: Income tax Dividends Total cash payments Cash increase or (decrease) $ bala at beginning Cash balance at end of month Minimum cash balance Excess (deficiency) $
Required information [The following information applies to the questions displayed below.] Lamonte Company reports the following budgeted December 31 adjusted trial balance. Debit $ 52,200 122, 200 66, 200 127,200 Cash Accounts receivable Merchandise inventory Equipment Accumulated depreciation-Equipment Accounts payable Loan payable Common stock Retained earnings (beginning year balance) Sales Cost of goods sold Loan interest expense Depreciation expense Salaries expense Totals LAMONTE COMPANY Budgeted Income Statement For Year Ended December 31 Gross profit Selling, general and administrative expenses 362,200 10, 200 12, 200 124, 200 $ 876,600 Prepare the budgeted income statement for the current year ended December 31. Ignore income taxes. $ Credit 0 0 $ 27,200 36,200 24, 200 205,500 61,300 522, 200 $ 876,600
Prepare the cash budget for January and February of Gilmore Company using the following data: February P42,100 January Cash Receipts Cash Disbursements Beginning Cash Balance Ending P46,500 P38,320 P37,220 P5,210 As per computation Required Cash Balance (Minimum) P12,000 P12,000
You are provided with the following information taken from Wildhorse Inc.'s March 31, 2025, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1. 2. 3. 4. 5. Additional information concerning Wildhorse Inc. is as follows. 6. 7. Gross profit is 25% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April Purchases March $48,200 $19,280 42,420 $61,700 Purchases April $11,600 70,700 20,180 36,010 Sales are both cash and credit. Cash collections expected in April are: (40% of $48,200) (60% of $70,700) 120,800 22,560 154,500 11.680 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte $22,560 28,320 $50,880 Cash operating costs are anticipated to be $12,630 for the month of April. Equipment costing $2,560 will be purchased for cash in April. The company wishes to maintain a minimum cash balance…
Budgeted net income for 2009 is P 19,500. Included in the budgeted income statement is depreciation of P 12,500. The changes in the trade current accounts are:Accounts Receivable (P 5,000)Merchandise Inventory P 7,000Accounts Payable P 6,000Accrued Expenses (P 2,000) Budgeted cash inflow (outflow) from operating activities must bea. P 38,000 b. (P 1,000) c. P 34,000 d. (P3,000)
You are provided with the following budget information for Trent Company, effective as of its April 30, 2021 year-end. Accounts payable 834 Accounts receivable 810 Buildings, net of accumulated depreciation 3,537 Cash 770 Common stock 900 Cost of goods sold 2,500 Current portion of long-term debt 450 Depreciation expense Dividends paid during the year 335 475 Equipment, net of accumulated depreciation 1,220 Income tax expense 265 Income taxes payable 265 Interest expense 400 Inventory 967 Land 1,600 Long-term debt Prepaid expenses 3,500 12 Retained earnings, beginning 1,600 Service revenue 9,600 Selling expenses 310 Debt investments 1,200 Salaries and wages expense 700 Salaries and wages payable 222 Instructions: Prepare an income statement for Trent Company for the year ended April 30, 2022. What is budgeted net income?
ere are some important figures from the budget of Crenshaw, Inc., for the second quarter of 2019. April May June Credit sales $ 689,000 $ 598,000 $ 751,000 Credit purchases 302,000 282,000 338,000 Cash disbursements Wages, taxes, and expenses 137,000 129,000 179,000 Interest 15,600 15,600 15,600 Equipment purchases 53,500 6,600 248,000 The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2019, credit sales were $561,000. Using this information, complete the following cash budget: (Do not round intermediate calculations and round your answers to the nearest whole number,…