During the annual budget preparation Tobias Jeans Company created a cash budget for the summer months...

Transcribed Image Text:

During the annual budget preparation Tobias Jeans Company created a cash budget for the summer months (June, July, August). The company has a line of credit at Bluth Bank. They can borrow up to $150,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 company's cash balance on May 31, will be $80,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 $80,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: 45% of the current month's sales budget and 55% of the previous month's sales budget. *Accounts Payable Disbursements: 30% of the current month's accounts payable budget and 70% of the previous month's accounts payable budget. *All other disbursements occur in the month in which they are budgeted Budget Information May June Sales $100,000 $110,000 Accounts Payable $20,000 $30,000 Payroll $60,000 $70,000 Machine Rent $5,000 $5,000 Other Disbursements $20,000 $15,000 Depreciation $6,000 $6,000 Create a Cash Budget for June, July, and August $50,000 $5,000 $20,000 $6,000 July $115,000 $40,000 August $100,000 $40,000 $50,000 $5,000 $5,000 $6,000 During the annual budget preparation Tobias Jeans Company created a cash budget for the summer months (June, July, August). The company has a line of credit at Bluth Bank. They can borrow up to $150,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 company's cash balance on May 31, will be $80,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 $80,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: 45% of the current month's sales budget and 55% of the previous month's sales budget. *Accounts Payable Disbursements: 30% of the current month's accounts payable budget and 70% of the previous month's accounts payable budget. *All other disbursements occur in the month in which they are budgeted Budget Information May June Sales $100,000 $110,000 Accounts Payable $20,000 $30,000 Payroll $60,000 $70,000 Machine Rent $5,000 $5,000 Other Disbursements $20,000 $15,000 Depreciation $6,000 $6,000 Create a Cash Budget for June, July, and August $50,000 $5,000 $20,000 $6,000 July $115,000 $40,000 August $100,000 $40,000 $50,000 $5,000 $5,000 $6,000

Answer rating: 100% (QA)

June Cash Budget Beginning Cash Balance on June 1 80000 as of May 31 Cash Inflows Collections 45 of June Sales Budget 45 110000 49500 55 of May Sales ... View the full answer