Exercise 8-11 (Algo) Cash Budget Analysis [L08-8) A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $7,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. 3. Year Cash balance, beginning $4 7 Add collections from customers 105 378 Total cash available 91 Less disbursements: Purchase of inventory 44 28 54 Selling and administrative expenses 32 30 124 Equiprhent purchases 8 8. 19 45 2 2 Dividends 96 Total disbursements Excess (deficiency) of cash available over disbursements Financing: (2) 12 Borrowings (13) Repayments (including interest) * 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
icon
Related questions
Question
**Exercise 8-11 (Algo) Cash Budget Analysis [LO8-8]**

A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $7,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)               | 1  | 2  | 3  | 4  | Year |
|-----------------------------------|----|----|----|----|------|
| **Cash balance, beginning**       | .  | $7 |   . | 105| 378  |
| **Add collections from customers**| .  | 91 |    |    |      |
| **Total cash available**          |    |    |    |    |      |
| **Less disbursements:**           |    |    |    |    |      |
| Purchase of inventory             | 44 | 54 |    |    |      |
| Selling and administrative expenses|   . | 30 |   . |   .| 124  |
| Equipment purchases               | 8  | 2  |    | 2  |      |
| Dividends                         |    |    |    | 2  |      |
| **Total disbursements**           |    |    |    |    |      |
| **Excess (deficiency) of cash available over disbursements** |    | (2)|    |    |      |
| **Financing:**                    |    |    |    |    |      |
| Borrowings                        |    | 8  |    |    |      |
| Repayments (including interest)*  |    |    |    | (13)|      |
| **Total financing**               |    |    |    |    |      |
| **Cash balance, ending**          |    |    |    |    |      |

*Interest will total $1,000 for the year.

**Explanation:**

The table is a quarterly cash budget analysis for a retail company, presented in thousands of dollars, with amounts omitted for certain entries. It includes the beginning cash balance, collections from customers, total cash available, disbursements, and financing details. The table also requires calculation of missing figures and
Transcribed Image Text:**Exercise 8-11 (Algo) Cash Budget Analysis [LO8-8]** A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $7,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) | 1 | 2 | 3 | 4 | Year | |-----------------------------------|----|----|----|----|------| | **Cash balance, beginning** | . | $7 | . | 105| 378 | | **Add collections from customers**| . | 91 | | | | | **Total cash available** | | | | | | | **Less disbursements:** | | | | | | | Purchase of inventory | 44 | 54 | | | | | Selling and administrative expenses| . | 30 | . | .| 124 | | Equipment purchases | 8 | 2 | | 2 | | | Dividends | | | | 2 | | | **Total disbursements** | | | | | | | **Excess (deficiency) of cash available over disbursements** | | (2)| | | | | **Financing:** | | | | | | | Borrowings | | 8 | | | | | Repayments (including interest)* | | | | (13)| | | **Total financing** | | | | | | | **Cash balance, ending** | | | | | | *Interest will total $1,000 for the year. **Explanation:** The table is a quarterly cash budget analysis for a retail company, presented in thousands of dollars, with amounts omitted for certain entries. It includes the beginning cash balance, collections from customers, total cash available, disbursements, and financing details. The table also requires calculation of missing figures and
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education