Concept explainers
a.
To prepare: A monthly cash budget for the last 6 months of 2015.
Working capital:
Working capital speculation is the measure of cash, require to extend business, meet here and now business obligations and cover costs of doing business.
Cash budget:
A money spending plan is an estimation of the money inflows and outpourings for a business over a particular timeframe. This financial plan is utilized to evaluate whether the substance has adequate money to work.
b.
To prepare: The monthly estimated required financing or excess fund.
c.
To determine: The effect on the cash budget, if cash budget is prepared under the assumptions and steps which make the financial requirement valid under the assumptions.
d.
To determine: The changes in the current and debt ratio during the year with calculation and explain whether the changes in the ratios affect the ability of the firm to get bank credit.
To determine: The sensitivity analysis that shows the effect of the two factors on the maximum loan requirement.
Trending nowThis is a popular solution!
Chapter 16 Solutions
Fundamentals of Financial Management (MindTap Course List)
- CASH BUDGETING Rework problem 15-10 using a spreadsheet model. After completing parts a through d, respond to the following: If Bowers customers began to pay late, collections would slow down, thus increasing the required loan amount. If sales dedined, this also would have an effect on the required loan. Do a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement. 15-10 CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain. e. f. g. h.arrow_forwardReview the completed master budget and answer the following questions: Is Ranger Industries expecting to earn a profit during the next quarter? If so, how much? Does the company need to borrow cash during the quarter? Can it make any repayments? Explain. (Carefully review rows 74 through 80.)arrow_forwardCash Budgeting Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high. Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,400 per month, and the rent is $2,100 per month. In addition, she must make a tax payment of $14,000 in December. The current cash on hand (on December 1) is $600, but Koehl has agreed to maintain an average bank balance of $6,500 - this is her target cash balance. (Disregard the amount in the cash register,…arrow_forward
- Cash Budgeting Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high. Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,900 per month, and the rent is $2,100 per month. In addition, she must make a tax payment of $10,000 in December. The current cash on hand (on December 1) is $850, but Koehl has agreed to maintain an average bank balance of $7,000 - this is her target cash balance. (Disregard the amount in the cash register,…arrow_forward15 Problem 8-25 (Static) Cash Budget with Supporting Schedules; Changing Assumptions [LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 600,000 $ 900,000 $ 500,000 $ 400,000 Cost of goods sold 420,000 630,000 350,000 280,000 Gross margin 180,000 270,000 150,000 120,000 Selling and administrative expenses: Selling expense 79,000 120,000 62,000 51,000 Administrative expense* 45,000 52,000 41,000 38,000 Total selling and administrative expenses 124,000 172,000 103,000 89,000 Net operating income $ 56,000…arrow_forwardWhich of the following statements is true about a cash budget? Question 35 options: Cash budget provides a means of estimating how long it will take for a product to reach the break-even point and, therefore, how much money will be needed to launch a new product. Cash budget summarizes the cash flows into and out of a firm over a period of time. Cash budget focuses on the importance of maximizing a product’s per unit contribution. Cash budget helps an entrepreneur understand the concept of EBITDA break-even and how to calculate this point for each product a business’s produce.arrow_forward
- Cash Budget; Income Statement; Balance Sheet; Changing Assumptions Refer to the data for Minden Company in Problem 8-19. The company is considering making the following changes to the assumptions underlying its master budget: 1. Sales are budgeted for $220,000 for May. 2. Each month’s credit sales are collected 60% in the month of sale and 40% in the month following the sale. 3. The company pays for 50% of its merchandise purchases in the month of the purchase and the remaining 50% in the month following the purchase. All other information from Problem 8-19 that is not mentioned above remains the same. Required: Using the new assumptions described above, complete the following requirements; 1. Calculate the expected cash collections for May. 2. Calculate the expected cash disbursements tor merchandise purchases for May. 3. Prepare a cash budget for May. 4. Using Schedule 9 as your guide, prepare a budgeted income statement for May. 5. Prepare a budgeted balance sheet as of May 31.arrow_forwardQuestion Content Area Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 $4,780,000 Quarter 2 5,280,000 Quarter 3 5,700,000 Quarter 4 8,420,000 In Shalimar’s experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are $5,280,000 and for the fourth quarter of the current year are $7,620,000. Required: Question Content Area 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. Quarter Cash Sales Credit Sales 3, current year $fill in the blank 43aa7d03501507c_1 $fill…arrow_forwardCash Budget—Financing Effects You are a relatively recent hire to Hartz & Co., a local manufacturer of plumbing supply products. You have been asked to prepare a condensed statement ofcash flows for the months of November and December of the current year for presentation to thecompany’s management.Assume the cash balance at November 1 will be $75,000. It is the company’s policy to maintaina minimum cash balance of $50,000 at the end of each month. Cash receipts (from cash salesand collection of accounts receivable) are projected to be $525,000 for November and $450,000for December. Cash disbursements (sales commissions, advertising, delivery expense, wages,utilities, etc.) prior to financing activity are scheduled to be $450,500 in November and $550,000in December.Short-term borrowing, when needed, is done at the beginning of the month in increments of$1,000. The annual interest rate on any such loans is estimated to be 12%. Interest on any outstanding short-term loans is paid in…arrow_forward
- ash Budgeting Dorothy Koehl recently leased space in the Southside Mall and opened a new business, Koehl's Doll Shop. Business has been good, but Koehl frequently runs out of cash. This has necessitated late payment on certain orders, which is beginning to cause a problem with suppliers. Koehl plans to borrow from the bank to have cash ready as needed, but first she needs a forecast of how much she should borrow. Accordingly, she has asked you to prepare a cash budget for the critical period around Christmas, when needs will be especially high. Sales are made on a cash basis only. Koehl's purchases must be paid for during the following month. Koehl pays herself a salary of $4,800 per month, and the rent is $3,000 per month. In addition, she must make a tax payment of $10,000 in December. The current cash on hand (on December 1) is $300, but Koehl has agreed to maintain an average bank balance of $7,000 - this is her target cash balance. (Disregard the amount in the cash register, which…arrow_forwardQuestion Content Area Budgeted Cash Collections, Budgeted Cash Payments Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale35 percent of credit sales in the first subsequent month20 percent of credit sales in the second subsequent month5 percent of credit sales in the third subsequent monthThe forecast for both cash and credit sales is as follows. January $185,000 February 185,000 March 192,000 April 196,000 May 200,000 Required: 1. What is the forecasted cash inflow for Ragman Company for May?$fill in the blank 1 2. Due to deteriorating economic conditions, Ragman Company has now decided that its cash forecast should include a bad debt adjustment of 2 percent of credit sales, beginning with sales for the month of April. Because of this policy change, what will…arrow_forward13 Problem 8-28 (Static) Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-7, LO8-8] Westex Products is a wholesale distributor of industrial cleaning products. When the treasurer of Westex Products approached the company’s bank late in the current year seeking short-term financing, he was told that money was very tight and that any borrowing over the next year would have to be supported by a detailed statement of cash collections and disbursements. The treasurer also was told that it would be very helpful to the bank if borrowers would indicate the quarters in which they would be needing funds, as well as the amounts that would be needed, and the quarters in which repayments could be made. Because the treasurer is unsure as to the particular quarters in which bank financing will be needed, he has assembled the following information to assist in preparing a detailed cash budget: Budgeted sales and merchandise purchases for next year, as well as actual sales and purchases…arrow_forward
- Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781285867977Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning