Question
DCorp is projecting a cash balance of $30,000 in its Dec 31, 2021, balance sheet. DCorps schedule of expected collections from customers for the first
DCorp is projecting a cash balance of $30,000 in its Dec 31, 2021, balance sheet.
DCorps schedule of expected collections from customers for the first quarter of 2022 totals $185,000. The schedule of expected payments for direct materials for the first quarter of 2022 totals $43,000.
Other information gathered for the first quarter of 2022 is: Sale of equipment $3,000; Direct labor $70,000; Mfg overhead $35,000; Selling & admin expenses $45,000; and purchase of securities (stocks and bonds as investments) $14,000.
DCorp wants to maintain a balance of at least $25,000 cash at the end of each quarter.
Instructions:
Prepare a cash budget for the first quarter.
DCorp Cash Budget For the Quarter Ending March 31, 2022 | |
| |
Beginning cash balance | 30,000 |
ADD Receipts: | |
|
|
|
|
Total Receipts |
|
Available cash |
|
LESS Disbursements: | |
|
|
|
|
|
|
|
|
|
|
Total Disbursements |
|
Excess of Available Cash over disbursements | 11,000 |
Financing: | |
Add: Borrowings |
|
Less: Repayments |
|
Ending Cash Balance |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started