Question
In preparation for the quarterly cash budget, the following revenue and cost information have been compiled. Month Sales Purchases August 1700 4400 September 1900 3500
In preparation for the quarterly cash budget, the following revenue and cost information have been compiled.
Month | Sales | Purchases |
August | 1700 | 4400 |
September | 1900 | 3500 |
October | 1400 | 1600 |
November | 1200 | 880 |
December | 1400 | 440 |
Prepare:
1- A Schedule of Projected Cash Receipts for the months of October, November, and December.
2- A Schedule of Projected Cash Disbursements for the months of October, November, and December.
3- A Cash Budget for the months of October, November, and December.
The firm collects 20 percent of sales for cash, and collects 50 percent of its sales one month later, and collects the remaining 30 percent two months after sales.
Interest income of $330 on marketable securities will be received in December.
Dividends income of $268 on marketable securities will be received in December.
The firm pays cash for 10 percent of its purchases, and pays 30 percent the following month, and the remaining 60 percent two months after purchase.
The firm pays monthly salaries of $1340
The firm pays dividends of $1390 at the end of December.
the firm pays interest of $200 at the end of December.
The firm intends to make a $1440 cash purchase of fixed assets in November.
The firm has a beginning cash balance in October of $1256 and maintains a minimum cash balance of $7000.
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