Homework Help is Here – Start Your Trial Now!
Business
Accounting
Create a Cash Budget for January, February, and March

Create a Cash Budget for January, February, and March

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
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 February $70,000 $12,000 $35,000 $30,000 December January $75,000 $15,000 $40,000 $35,000 March Sales Accounts Payable Payroll |Other Disbursements $100,000 $20,000 $50,000 $25,000 $100,000 $20,000 $50,000 $11,000 Create a Cash Budget for January, February, and March
Transcribed Image Text: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 February $70,000 $12,000 $35,000 $30,000 December January $75,000 $15,000 $40,000 $35,000 March Sales Accounts Payable Payroll |Other Disbursements $100,000 $20,000 $50,000 $25,000 $100,000 $20,000 $50,000 $11,000 Create a Cash Budget for January, February, and March
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS