**Cash Budget Analysis for a Retail Company**This document outlines a cash budget, divided by quarters, for a retail company. Cash values are noted in thousands of dollars, and entries with deficiencies or repayments must be marked as negative values. The business mandates a minimum cash balance of $5,000 at the beginning of each quarter.### Quarterly Breakdown:**Quarter 1:**- **Cash balance, beginning:** $6,000- **Add collections from customers:** $0- **Total cash available:** $7,100- **Disbursements:** - Purchase of inventory: $35,000 - Selling and administrative expenses: $30,000 - Equipment purchases: $8,000 - Dividends: $2,000- **Total disbursements:** $85,000- **Excess (deficiency) of cash available over disbursements:** ($2,000)- **Financing:** - Borrowings: $11,000 - Repayments (including interest): Data not specified- **Total financing:** Data not specified- **Cash balance, ending:** Data not specified**Quarter 2:**- **Add collections from customers:** Data not specified- **Disbursements:** - Purchase of inventory: $45,000 - Selling and administrative expenses: $30,000 - Equipment purchases: $8,000 - Dividends: $2,000- **Total disbursements:** Data not specified- **Excess (deficiency) of cash available over disbursements:** $11,000- **Financing:** - Borrowings: $15,000 - Repayments (including interest): Data not specified- **Total financing:** Data not specified- **Cash balance, ending:** Data not specified**Quarter 3:**- **Add collections from customers:** $96,000- **Disbursements:** - Purchase of inventory: Data not specified - Selling and administrative expenses: Data not specified - Equipment purchases: $10,000 - Dividends: $2,000- **Total disbursements:** Data not specified- **Excess (deficiency) of cash available over disbursements:** Data not specified- **

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. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Quarter (000 omitted) (000 omitted) 2 4 Year Cash balance, beginning $ 6 Add collections from customers 96 323 Total cash available 71 Less disbursements: Purchase of inventory 35 45 35 Selling and administrative expenses 30 30 113 Equipment purchases 8 8 10 36 Dividends 2 2 2 Total disbursements 85 Excess (deficiency) of cash available over |disbursements Financing: (2) 11 Borrowings 15 Repayments (including interest)* (17) Total financing 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 $5,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.) Quarter (000 omitted) (000 omitted) 2 4 Year Cash balance, beginning $ 6 Add collections from customers 96 323 Total cash available 71 Less disbursements: Purchase of inventory 35 45 35 Selling and administrative expenses 30 30 113 Equipment purchases 8 8 10 36 Dividends 2 2 2 Total disbursements 85 Excess (deficiency) of cash available over |disbursements Financing: (2) 11 Borrowings 15 Repayments (including interest)* (17) Total financing Cash balance, ending *Interest will total $1,000 for the year.

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

h1
am. 116.
Please don't give image format and fast answering
Do not give solution in imagr
Do not give solution in image
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
Please don't give image format
do not give solution in image
Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-9, LO8-10] Skip to question [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: Beech Corporation Balance Sheet June 30 Assets Cash $ 86,000 Accounts receivable 138,000 Inventory 75,000 Plant and equipment, net of depreciation 229,000 Total assets $ 528,000 Liabilities and Stockholders’ Equity Accounts payable $ 90,000 Common stock 351,000 Retained earnings 87,000 Total liabilities and stockholders’ equity $ 528,000 Exercise 8-12 (Algo) Beech’s managers have made the following additional assumptions and estimates: Estimated sales for July, August, September, and October will be $400,000, $420,000, $410,000, and $430,000,…
Am. 1113.
Hardev
! Required information [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget. Budgeted sales and cash payments follow: July $ 56,000 August $ 72,000 September $ 56,000 Budgeted sales Budgeted cash payments for Direct materials 15,560 3,440 19,600 12,840 2,760 16,200 13,160 2,840 16,600 Direct labor Overhead Sales to customers are 20% cash and 80% on credit. Sales in June were $53,500. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $47,000 in cash and $4,400 in loans payable. A minimum cash balance of $47,000 is required. Loans are obtained at the end of any month when the preliminary cash balance is below $47,000. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. Any preliminary cash balance above $47,000 is used to repay loans at month-end. Expenses are paid in the month incurred and consist of sales…