Answered step by step
Verified Expert Solution
Question
1 Approved Answer
nright Company expects to have a cash balance of $64,380 on January 1, 2014. These are the relevant monthly budget data for the first two
nright Company expects to have a cash balance of $64,380 on January 1, 2014. These are the relevant monthly budget data for the first two months of 2014.
1. | Collections from customers: January $89,380, February $164,380. | |
2. | Payments to suppliers: January $58,380, February $93,380. | |
3. | Wages: January $31,608, February $41,608. Wages are paid in the month they are incurred. | |
4. | Administrative expenses: January $22,608, February $25,608. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. | |
5. | Selling expenses: January $16,608, February $21,608. These costs are exclusive of depreciation. They are paid as incurred. | |
6. | Sales of short-term investments in January are expected to realize $13,608 in cash. Enright has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $38,380. |
Prepare a cash budget for January and February.
ENRIGHT COMPANY Cash Budget For the Two Months Ending February 28, 2014
Jan Feb
Beginning Cash Balance | 64,380 | ? |
Add Cash Receipts | ||
Collections from Customers | 89,380 | 164,380 |
Sale of Short Term Investments | 13,608 | 0 |
Total Receipts | 102988 | 164,380 |
Total Available Cash | ? | ? |
Less Cash Disbursements | ||
Wages | 58,380 | 58,380 |
Payments to Suppliers | 31,608 | 41,608 |
Administrative Expenses | 21,608 | 24608 |
Selling Expenses | 16,608 | 21,608 |
Total Disbursements | ? | ? |
Excess (Deficiency) of Available Cash Over Disbursements | ? | ? |
Add Borrowings | 0 | ? |
Less Repayments | 0 | 0 |
Ending Cash Balance I answered most of the question. Can anyone help me:) | ? | ?
|
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