Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Problem Cash Budget It is annual budget preparation time and the accounting team at Drusilla Inc is preparing the cash budget for the months of
Problem Cash Budget It is annual budget preparation time and the accounting team at Drusilla Inc is preparing the cash budget for the months of January, February, and March. The company has established a $250,000 line of credit with its bank at a 10% annual rate of interest on which borrowings for cash deficits must be made in $1,000 increments. There will not be an outstanding balance on the line of credit loan on December 31, and December 31st cash balance will be $125,000. Principle repayments are to be made in any month in which there is a surplus of cash. Interest is to be paid monthly. Drusilla intends to maintain a minimum balance of $125,000 at the end of each month by either borrowing for deficits below the minimum balance or repaying the loan balance with excess cash. Expected monthly collection and disbursement patterns are shown below: *Collections: 40% of the current month's sales budget and 60% of the previous month's sales budget. *Accounts Payable Disbursements: 15% of the current month's accounts payable budget and 85% of the previous month's accounts payable budget. *All other disbursements occur in the month in which they are budgeted Budget Information December January February March Sales $100,000 $75,000 $70,000 $100,000 Accounts Payable $20,000 $15,000 $12,000 $20,000 Payroll $50,000 $40,000 $35,000 $50,000 Other Disbursements $25,000 $35,000 $30,000 $11,000 Create a Cash Budget for January, February, and March
Problem Cash Budget | ||||
It is annual budget preparation time and the accounting team at Drusilla Inc is preparing the cash budget for the months of January, February, and March. The company has established a $250,000 line of credit with its bank at a 10% annual rate of interest on which borrowings for cash deficits must be made in $1,000 increments. There will not be an outstanding balance on the line of credit loan on December 31, and December 31st cash balance will be $125,000. Principle repayments are to be made in any month in which there is a surplus of cash. Interest is to be paid monthly. Drusilla intends to maintain a minimum balance of $125,000 at the end of each month by either borrowing for deficits below the minimum balance or repaying the loan balance with excess cash. Expected monthly collection and disbursement patterns are shown below: | ||||
*Collections: 40% of the current month's sales budget and 60% of the previous month's sales budget. | ||||
*Accounts Payable Disbursements: 15% of the current month's accounts payable budget and 85% of the previous month's accounts payable budget. | ||||
*All other disbursements occur in the month in which they are budgeted | ||||
Budget Information | ||||
December | January | February | March | |
Sales | $100,000 | $75,000 | $70,000 | $100,000 |
Accounts Payable | $20,000 | $15,000 | $12,000 | $20,000 |
Payroll | $50,000 | $40,000 | $35,000 | $50,000 |
Other Disbursements | $25,000 | $35,000 | $30,000 | $11,000 |
Create a Cash Budget for January, February, and March |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started