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_forwardPlease explain correct option also.arrow_forwardA cash flow budget can be used to A. estimate when and how much money will need to be borrowed during the year B. estimate when and how much debt can be repaid during the year C. estimate when excess cash may be available so plans can be made to invest it D. all of the abovearrow_forward
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?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_forwardThe following four suggestions have been made to improve the company’s cash position. Evaluate the effect on cash flow for each of the four suggestions. After evaluating each suggestion, enter the projected cash balances in the spaces provided. Consider each suggestion separately. Reset cells to their initial values after each new suggestion. Seek agreement with suppliers to extend the credit period to 30 days. This would mean that all current monthly purchases would be paid for in the following month. Raise the unit price from $28 to $30. A price increase will reduce unit sales by 10% each month. Unit purchases will also be reduced by 10%. Put the company’s two salespeople on straight commission. This would reduce fixed marketing and administrative costs to $1,500 per month and raise variable marketing and administrative costs to $7 per unit. Increase the cash discount from 5% to 10%. It is anticipated that this would increase the percentage of customers paying within the discount period to 85%, and those paying the month after the discount period would drop to 8%. Five percent would pay in the following month and 2% would still be uncollectible. What are your recommendations for Sweet Pleasures, Inc.? Consider potential impact on profits as well as cash balances.arrow_forward
- QUESTION 1 Which of the following statements is false about cash budgets? O Cash receipts are calculated by adding up all the cash inflows in a given month O When calculating the cash budget the firm must consider many aspects such as, cash receipts, cash expenses, minimum desired cash balance, and previous loans. O Cash receipts include sales, investment income and interest expenses. All of the above are true QUESTION 2 Based on the data below calculate the company's combined cost? Annual requirements = 7500 units Ordering cost = BD 12 Holding cost BD 0.5 O125 300 45000 150 0000arrow_forwardZero-based budgeting refers to: a. Budgeting from the ground up as though the budget process were being initiated for the first time b. Using prior year’s budget as a bas year and adjusting it based on the experiences of the prior year and the expectations for the coming year c. Budgeting for cash inflows and outflows to time investments and borrowings in a way to maintain bank account with a minimum balance d. Developing budgeted costs from clear-cut measured relationships between inputs and outputs Clear my choicearrow_forwardanswer quick with explanationarrow_forward
- 8. Which of the following expenses would not appear in cash budget? Depreciation expense Marketing expense Interest expense а. b. с. d. Wages expense Information technology has made it easier for Amazon.com's managers to perform all of the following tasks except 9. а. preparing performance reports that identify variances between actual and budgeted revenues and costs. combining individual units' budgets into the companywide budget. sensitivity analyses. removing budgetary slack from the budget. b. с. d. 10. A company prepares a five-year budget. This budget would be considered a(n) strategic budget operational budget master budget flexible budget а. b. с. d.arrow_forwardwhich one is correct please confirm? QUESTION 20 The first step in cash budget preparation is the ____________. a. estimation of the expected cash disbursements b. estimation of cash receipts c. scheduling of disbursements d. estimation of credit salesarrow_forwardThe importance of cash budgets for all types of businesses and individuals cannot be overemphasized. The following six steps to cash flow control are critical. Create a monthly cash flow budget. Determine the amount you need to achieve your business and personal financial goals, including enough to pay taxes and fund your retirement. At the end of each month compare cash inflows and outflows to make necessary adjustments to cash spending or saving. Accounting software can help automate the process. Set aside cash each month to pay your taxes on time. Make quarterly contributions to a retirement account. Establish a line of credit with a bank, or investigate other short-term financing sources, well before you think you’ll need the extra cash. Instructions Assume for item number 2 that a business’s actual cash flows are not enough to achieve its business goals and some necessary adjustments must be made. Name at least four adjustment procedures that businesses can use to equalize cash…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
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning