A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. Quarter 2 3 4 Year Cash balance, beginning.... Add collections trom customers $ ? $ ? $ 6 $ ? $ ? 323 ....... ..... ... 96 - Total cash available.. Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends .. 71 35 45 35 30 30 113 8. 8 10 36 Total disbursements 85 Excess (deticiency) of cash available over disbursements. Financing: Borrowings... Repayments (including interest)" Total financing. (2) ? 15 (2) (17) (2) Cash balance, ending $ ? $ ? $ ? $ ? *Interest wil 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 $5,000 to start each quarter. Quarter 2 3 4 Year Cash balance, beginning.... Add collections trom customers $ ? $ ? $ 6 $ ? $ ? 323 ....... ..... ... 96 - Total cash available.. Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends .. 71 35 45 35 30 30 113 8. 8 10 36 Total disbursements 85 Excess (deticiency) of cash available over disbursements. Financing: Borrowings... Repayments (including interest)" Total financing. (2) ? 15 (2) (17) (2) Cash balance, ending $ ? $ ? $ ? $ ? *Interest wil total $1,000 for the year.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 18E

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…
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…
Ⓒ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…
A cash budget, by quarters, is given below for a retail company. (000 omitted) company requires a minimum cash balance of at least Br 5,000to start each quarter. Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Cash balance, beginning 6 ? ? ? ? Add collections from customers ? ? 96 ? 323 Total cash available 71 ? ? ? ? Less disbursement: Purchase inventory 35 45 ? 35 ? Operating expense ? 30 30 ? 113 Equipment purchase 8 8 10 ? 36 Dividends 2 2 2 2 ? Total disbursement ? 85 ? ? ? Excess (deficiency) of each cash (2) ? 11 ? ? Financing: Borrowing ? 15 - - ? Repayments (including interest) - - ? (17) ? Total financing ? ? ? ? ? Cash balance, ending ? ? ? ? ?
A cash budget is prepared for a retail company. The company requires a minimum cash balance of at least $5,000 to start each quarter. Fill in the missing amounts (Note: Omit 000's in your answers). Quarter 1 3 3 4 Year Cash Balance, Beginning $ 6 Add: Collections from Customers 93 322 Total Cash Available before current financing 66 Deduct Disbursements: Purchase of Inventory 36 46 35 Operating Expenses 33 31 114 Equipment Purchases 10 10 11 35 Dividends 2 2 2 2 Total Disbursements 91…
Required Givi Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-9, LO8-10] [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company's balance sheet as of June 30th is shown below: Assets Cash Accounts receivable. Inventory Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Exercise 8-13 (Algo) Beech Corporation Balance Sheet June 30 Beech's managers have made the following additional assumptions and estimates: 1. Estimated sales for July, August, September, and October will be $240,000, $260,000, $250,000, and $270,000, respectively. 2. All sales are on credit and all credit sales are collected. Each month's credit sales are collected 45% in the month of…
The following information was taken from Nash's Trading Post, LLC cash budget for the month of June Beginning cash balance $51000 Cash receipts 69000 Cash disbursements 87000 If the company has a policy of maintaining an end of the month cash balance of $44000, the amount the company would have to borrow is $11000. $27000. $18000. $0.
CASH BUDGET; REQUIRED: Prepare a schedule showing cash collections during October. Prepare cash disbursements (payments) during October. Assuming that company had $150,000 cash balance as of October 1, calculate cash balance as of October 31. Company’s accounts receivable collection experience is as follows: Cash collected from current month’s sales; terms 1/10 n/30: 20% Cash collected from prior month’s sales (no discount) 65% Cash collected from sales two months ago: 13% Uncollectible receivables 2% Company’s estimated credit sales (company has no cash sales): July $480,000 August 420,000 September 370,000 October 350,000 November 400,000 Company’s…
QUESTION 3: Based on the following assumptions and policies ; a) Prepare the budget for Collectables from Sales! b) Prepare the budget for Purchases! c) Prepare the budget of Cash Payment for Purchases! d) Set the company’s Cash Budget for 2021 BOARD Policies & Assumptions - Company’s projected sales for the three months as followings: Sales Forecast for 2021 January 2021 200.000 USD February 2021 220.000 USD March 2021 240.000 USD - All Sales are credited: %40 of sales are collected as in form of cash. %30 of sales are credited for 1 month and %30 of it for the next month. Rule: 40;30;30 - Accounts Receivables by quarter ending 31/12/2020 amounted to 120.000 USD a) 30.000 USD of Account Receivables belong to November Sales ( 11/2020) b) 90.000 USD of Account Receivables belong to December Sales ( 12/2020) - All purchases are credited: %50 of purchases are paid in advance and %50 of purchases are debited - Projected Inventories by the…
a.At January 1, 2020, Mr. James had accounts receivable of 72,000. At December 31, 2020, accounts receivable is 54,000. Sales revenue for 2020 total 420,000. Compute Mr.James 2020 cash receipts from customers. Cash receipts from customers b. Tedox Corp had January 1 and December 31 balances as follows. 1/1/20, 12/31/20 Inventory 114,000, 136,000 Accounts payable 63,000, 69,000 For 2020, cost of goods sold was 451,000. Compute Tedox 2020 cash payments to suppliers.
Use the following information a. Beginning cash balance on March 1, P72,000. b. Cash receipts from sales, P300,000. с. Budgeted cash disbursements for purchases, 140,000. d. Budgeted cash disbursements for salaries, 80,000. е. Other budgeted cash expenses, 45,000. f. Cash repayment of bank loan, 20,000. Prepare a cash budget for the month ended on March 31 for Mason Company. The budget should show expected cash receipts and cash disbursements for the month of March and the balance expected on March 31.
Lamonte Company reports the following budgeted December 31 adjusted trial balance. 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 Debit $ 54,000 Credit 124,000 68,000 129,000 $ 29,000 38,000 26,000 210,000 64,000 524,000 364,000 12,000 14,000 126,000 $ 891,000 $ 891,000 Exercise 20-28A (Algo) Merchandising: Preparing a budgeted income statement LO P4 Prepare the budgeted income statement for the current year ended December 31. Ignore income taxes. LAMONTE COMPANY Budgeted Income Statement For Year Ended December 31 Gross profit Selling, general and administrative expenses