WACO Co. - Preparation of a Cash Budget
Not what you're looking for?
Preparation of a cash budget
Use the following information to prepare the July cash budget for the WACO Co. It should show expected cash receipts and cash disbursements for the month and the cash balance expected on July 31.
a. beginning cash balance on July 1: $50,000
b. cash receipts from sales: 30% is collected in the month of sale, 50% in the next month, and 20% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: May (actual), $1,720,000; June (actual), $1,200,000; and July (budgeted), $1,400,000.
c. Payments on merchandise purchases: 60% in the month of purchase and 40% in the month following purchase. Purchase amounts are: June (actual), $700,000; and July (budgeted), $750,000.
d. Budgeted cash disbursements for salaries in July: $275,000
e. Budgeted depreciation expense for July: $36,000.
f. Other cash expenses budgeted for July: $200,000
g. Accrued income taxes due in July: $80,000.
h. Bank loan interest due in July: $6,000
Purchase this Solution
Solution Summary
This solution is comprised of a detailed explanation to use the following information to prepare the July cash budget for WACO Co. It is provided in an attached Excel file.
Purchase this Solution
Free BrainMass Quizzes
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.