During the annual budget preparation Tobias Jeans Company created a cash budget for the summer months...
Fantastic news! We've Found the answer you've been seeking!
Question:
![](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/04/6431228ef1c5b_1680941694302.jpg)
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
Expert Answer:
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
Related Book For
Survey Of Accounting
ISBN: 9781260575293
6th Edition
Authors: Thomas Edmonds, Christopher Edmonds, Philip Olds
Posted Date:
Students also viewed these finance questions
-
Altec Manufacturing Inc. is a company that manufactures and sells a single product, which they call an Altec. For planning and control purposes they utilize a monthly master budget, which is usually...
-
D Hawk entered the market in early 2018. D Hawk manufactures camera drones, selling primarily to retailers. D Hawk is pleased with its financial performance over its first few years of operations,...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The number of males per 100 females, age 70 or over, in the United States for some recent years is shown in the following table. (a) Plot the data, letting t be the years since 1970. (b) Would a...
-
What is required to decompose a cluster entity type in preparation for mapping to a logical schema?
-
But maybe the BMIs of all the participants changed during the four-week period. We can calculate the change in BMI for each participant in the study, and then compare the mean change for the 41 maids...
-
One area that fast-food restaurants compete with one another is with the service time for the drive-through window. The following data show the drive-through service times, in minutes, for a random...
-
Poke a hole in a piece of cardboard and hold the cardboard horizontally in the sunlight (as in Figure 1.6). Note the image of the Sun that is cast below. To convince yourself that the round spot of...
-
A Trustee's statement of realization and liquidation is presented below: Assets to be realized: Accounts receivable $15,000, Inventory $41,000, Equipment $88,000. Assets acquired: None. Liabilites...
-
1. If you were Ethney, how would you try to conduct yourself at the oil company? Would you act differently from your normal personality? Do you think your approach would be successful? Why? 2. What...
-
What is good to write back to a discussion board that says: Quantitative risk analysis uses verifiable data to analyze the effects of risk and assigns a numerical value to those risks. Qualitative...
-
IV. Normal Distribution 9. IQ scores are said to be normally distributed with a mean of 100 and a standard deviation of 15. Label the normal curve below and then answer the questions that follow. a....
-
Manually determine the range, variance, and standard deviation of the set of numbers. Show the computations: a. 3, 8, 10, 14, 9, 10, 12, 21, 5, 13, 11, 10 b. 232, 212, 151, 325, 142, 132, 142, 236,...
-
Alex and Bess have been in partnership for many years. The partners, who share profits and losses on a 70:30 basis, respectively, wish to retire and have agreed to liquidate the business. Liquidation...
-
1 Frequency Domain Analysis 1. Given an input u(t) = cos(t) + 2 sin(5t) cos(5t) which is a sum of a lower frequency signal and a higher-frequency noise. Determine the feasible range of time constant...
-
A motor supplies a constant torque or twist of M = 120 lb ft to the drum. If the drum has a weight of 30 lb and a radius of gyration of ko = 0.8 ft, determine the speed of the 15-lb crate A after it...
-
22. El 1 de abril de 2021, BBC Co. adquiri un 30% de las acciones de LTI Inc. por $100,000. Esta cantidad incluye $40,000 que representa el exceso del valor justo en el mercado (fair value) sobre el...
-
Make an argument that Williams had a right to delay the closing until after August 1.
-
At the beginning of Year 2, Better Corp.s accounting equation showed the following accounts and balances: Better Corp. completed the following transactions during Year 2: 1. Purchased land for $5,000...
-
During Year 1, Chung Corporation earned $8,000 of cash revenue and accrued $5,000 of salaries expense. Required Record the events in general ledger accounts under an accounting equation before...
-
Astro Corporation was started with the issue of 2,000 shares of $5 par stock for cash on January 1, Year 1. The stock was issued at a market price of $12 per share. During Year 1, the company earned...
-
To understand the complexity of e-commerce and its many facets. LO.1
-
Which industry stands to benefit most from e-commerce? LO.1
-
Describe the pattern in the normal probability plot of the residuals. What does this mean?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App