Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.)

-this is the answer that I entered and it says it is incomplete and I can't figure out why?

Quarter (000 omitted) (000 omitted)
1 2 3 4 Year
Cash balance, beginning $6 $5 $5 $5 $6
Add collections from customers 65 70 96 92 323
Total cash available 71 75 101 97 329
Less disbursements:
Purchase of inventory 35 45 48 35 163
Selling and administrative expenses 28 30 30 25 113
Equipment purchases 8 8 10 10 36
Dividends 2 2 2 2 8
Total disbursements 73 85 90 72 320
Excess (deficiency) of cash available over disbursements (2) (10) 11 25 9
Financing:
Borrowings 7 15 22
Repayments (including interest)* (6) (17) (23)
Total financing 7 15 (17) (1)
Cash balance, ending $5 $5 $5 $8 $8
*Interest will total $1,000 for the year.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

1. Describe the types of power that effective leaders employ

Answered: 1 week ago