Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem Cash Budget During the annual budget preparation Mercurtainment Company created a cash budget for the summer months (June, July, August). The company has a

Problem Cash Budget
During the annual budget preparation Mercurtainment Company created a cash budget for the summer months (June, July, August). The company has a line of credit at Chevy Chase Bank. They can borrow up to $250,000 at an annual rate of interest of 10%. They can only borrow in increments of $1,000. So far for the year they have not had to borrow anything from the line of credit, so the outstanding balance on the loan will be zero on May 31. The companys cash balance on May 31, will be $130,000. If they do end up borrowing from the line of credit, they will pay the back as much as possible as soon as they can since interest is charged and must be paid monthly. They do have to maintain a minimum cash balance of $125,000 at the end of each month. If they are below that, they must borrow from the line of credit, but if they are above that they can repay any loan balance with excess cash. Expected monthly collection and disbursement patters are shown below:
*Collections: 60% of the current month's sales budget and 40% of the previous month's sales budget.
*Accounts Payable Disbursements: 25% of the current month's accounts payable budget and 75% of the previous month's accounts payable budget.
*All other disbursements occur in the month in which they are budgeted
Budget Information
May June July August
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
Machine Rent $5,000 $5,000 $5,000 $5,000
Other Disbursements $20,000 $30,000 $25,000 $6,000
Depreciation $10,000 $10,000 $10,000 $10,000
Create a Cash Budget for June, July, August

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For Decision Makers

Authors: Peter Atrill, Eddie McLaney

10th Edition

1292409185, 9781292409184

More Books

Students also viewed these Accounting questions

Question

Understand the department managers key role in employee retention

Answered: 1 week ago