Prepare a Cash Budget for J Car & Sons Company
Not what you're looking for?
How do I prepare a cash budget? Also, I'd like to demonstrate if the company meets their minimum cash requirement of $10,000.
-------
J. Car & Sons Company has gathered the following information:
April 30 ending cash balance $25,000
Dividends paid in May $12,000
Cash expenditures in May for operating expenses $36,800
Depreciation expense in May $4,500
Cash collections in May $99,000
Merchandise purchases paid in cash in May $66,200
Purchase equipment for cash in May $17,500
J. Car & Sons Company desires to keep minimum cash balance of $10,000.
Purchase this Solution
Solution Summary
This solution prepares a cash budget including transactions with dividends, cash expenditures, operating expenses, depreciation expense, cash collections, merchandise purchases and equipment purchases. It also explains if the company is meeting their minimum cash requirement in an Excel file.
Solution Preview
See excel file attached.
CAR AND SONS COMPANY
CASH BUDGET FOR THE MONTH OF MAY
Details Amount
Cash Receipts
Beginning cash balance $25,000
Cash collected from account receivable $99,000 ...
Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
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.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.