EBK PRINCIPLES OF MANAGERIAL FINANCE
14th Edition
ISBN: 9780100666757
Author: ZUTTER
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 4.7P
Learning Goal 4
P4-8 Cash receipts A firm has actual sales of $65,000 in April and $60,000 in May. It expects sales of $70,000 in June and $100,000 in July and in August. Assuming that sales are the only source of
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
(Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?
Exercise 2 (Short-Term Finance and Planning)
You are hired as a financial manager and your first task is to establish the cash budget of your firm.
You gathered the following information.
The firm receives all income from sales
Sales estimates (in millions)
Q1 = 1,000; Q2 = 1,250; Q3 = 1,500; Q4 = 2,000; Q1 next year = 1,200
Accounts receivable
Beginning receivables = $3000
Average collection period = 45 days
Accounts payable
Purchases = 60% of next quarter’s sales
Beginning payables = 1,200
Accounts payable period is 45 days
Other expenses
Wages, taxes, and other expense are 25% of sales
Interest and dividend payments are $100
A major capital expenditure of $500 is expected in the second quarter
The initial cash balance is $100 and the company maintains a minimum balance of $50
A 13-44 Analyzing statements of cash flows (Learning Objectives 1, 2, & 3) Sears Holding Corporation (SHLD) announced in April 2016 that it would be closing 68 Kmart and 10 Sears stores during the second half of 2016. The stores it is closing have not been profitable for Sears, and it is looking to improve profitability with the closures. Similarly, Wal-Mart Stores, Inc. (WMT) announced in January 2016 that it would be closing 269 stores worldwide. Again, this move is an effort to increase profitability for Wal-Mart. Sears' fiscal year-end is the Saturday closest to January 31. Following are its statements of cash flows for the most recent three years.
Sears Holding Corporation Statements of Cash Flows (in millions)
Year Ended
Jan.30,2016
Jan.31,2015
Feb. 1,2014
Operating activities:
Net income (loss)
$(1,128)
$(1,810)
$(1,116)
Adjustments to convert to cash basis
(1,039)
423
7
Net cash used by operations
(2,167)…
Chapter 4 Solutions
EBK PRINCIPLES OF MANAGERIAL FINANCE
Ch. 4.1 - Briefly describe the first four modified...Ch. 4.1 - Describe the overall cash flow through the firm in...Ch. 4.1 - Prob. 4.3RQCh. 4.1 - 4-B Why is depreciation (as well as amortization...Ch. 4.1 - Prob. 4.5RQCh. 4.1 - Prob. 4.6RQCh. 4.1 - Prob. 4.7RQCh. 4.2 - Prob. 4.8RQCh. 4.2 - Prob. 4.9RQCh. 4.3 - Prob. 4.10RQ
Ch. 4.3 - Prob. 4.11RQCh. 4.3 - Prob. 4.12RQCh. 4.3 - What is the cause of uncertainty in the cash...Ch. 4.4 - Prob. 4.14RQCh. 4.5 - Prob. 4.15RQCh. 4.5 - Prob. 4.16RQCh. 4.6 - Prob. 4.17RQCh. 4.6 - What is the significance of the plug figure,...Ch. 4.7 - Prob. 4.19RQCh. 4.7 - Prob. 4.20RQCh. 4 - Opener-in-Review The chapter opener described a...Ch. 4 - Learning Goals 2, 3 ST4-1 Depreciation and cash...Ch. 4 - Prob. 4.2STPCh. 4 - Prob. 4.3STPCh. 4 - Prob. 4.1WUECh. 4 - Prob. 4.2WUECh. 4 - Learning Goal 3 E4-3 Determine the operating cash...Ch. 4 - Prob. 4.4WUECh. 4 - Prob. 4.5WUECh. 4 - Prob. 4.1PCh. 4 - Prob. 4.2PCh. 4 - Prob. 4.3PCh. 4 - Learning Goals 2, 3 P4-4 Depreciation and...Ch. 4 - Learning Goal 3 P4-5 Classifying inflows and...Ch. 4 - Prob. 4.6PCh. 4 - Learning Goal 4 P4-8 Cash receipts A firm has...Ch. 4 - Learning Goal 4 P4-9 Cash disbursements schedule...Ch. 4 - Learning Goal 4 P4-10 Cash budget: Basic Grenoble...Ch. 4 - Prob. 4.10PCh. 4 - Prob. 4.11PCh. 4 - Prob. 4.12PCh. 4 - Prob. 4.13PCh. 4 - Learning Goal 4 P4-15 Multiple cash budgets:...Ch. 4 - Prob. 4.15PCh. 4 - Prob. 4.16PCh. 4 - Prob. 4.17PCh. 4 - Prob. 4.18PCh. 4 - Prob. 4.19PCh. 4 - Prob. 4.20PCh. 4 - Prob. 4.21PCh. 4 - Prob. 1SE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- A 13-44 Analyzing statements of cash flows (Learning Objectives 1, 2, & 3) Sears Holding Corporation (SHLD) announced in April 2016 that it would be closing 68 Kmart and 10 Sears stores during the second half of 2016. The stores it is closing have not been profitable for Sears, and it is looking to improve profitability with the closures. Similarly, Wal-Mart Stores, Inc. (WMT) announced in January 2016 that it would be closing 269 stores worldwide. Again, this move is an effort to increase profitability for Wal-Mart. Sears' fiscal year-end is the Saturday closest to January 31. Following are its statements of cash flows for the most recent three years. Sears Holding Corporation Statements of Cash Flows (in millions) Year Ended Jan.30,2016 Jan.31,2015 Feb. 1,2014 Operating activities: Net income (loss) $(1,128) $(1,810) $(1,116) Adjustments to convert to cash basis (1,039) 423 7 Net cash used by operations (2,167)…arrow_forwardQuestion # 2 Sohrab Bicycle Co. shows the following accounting information for next four quarters of year 2016: Sohrab Bicycle Co. shows the following accounting information for next four quarters of year 2016: Quarter-1 Quarter-2 Quarter-3 Quarter-4 Sales in units 400 500 600 700 Price will remain unchanged for the whole year (i.e. Rs. 1500) Cash Collection: Cash Balance at start Rs. 1,000,000 60% cash will be collected for current quarter and 40% will be in the next quarter. Required: Sales budget for the year 2016 and Cash Budgetarrow_forwardQUESTION 3: Based on the following assumptions and policies ; a) Prepare the budget for Collectables from Sales! b) Prepare the budget for Purchases! c) Prepare the budget of Cash Payment for Purchases! d) Set the company’s Cash Budget for 2021 BOARD Policies & Assumptions - Company’s projected sales for the three months as followings: Sales Forecast for 2021 January 2021 200.000 USD February 2021 220.000 USD March 2021 240.000 USD - All Sales are credited: %40 of sales are collected as in form of cash. %30 of sales are credited for 1 month and %30 of it for the next month. Rule: 40;30;30 - Accounts Receivables by quarter ending 31/12/2020 amounted to 120.000 USD a) 30.000 USD of Account Receivables belong to November Sales ( 11/2020) b) 90.000 USD of Account Receivables belong to December Sales ( 12/2020) - All purchases are credited: %50 of purchases are paid in advance and %50 of purchases are debited - Projected Inventories by the…arrow_forward
- Problem 5-2 Rancho, Inc. forecasts the following sales for the second quarter of 2020, as well as actual March sales: March (actual) April May June 2nd Q. Total $3,000 $4,000 $5,000 $6,000 $15,000 In addition: The company makes 60% cash sales and 40% credit sales. It collects all credit sales in the month after the sale. The firm budgets $4,400 for monthly operating expenses. That amount includes $400 for depreciation. The firm pays all of its cash-based expenses in the month incurred. Rancho, Inc. had $100 of cash at March 31, 2020, and it must maintain a minimum $500 cash balance at the end of every month to ensure liquidity. The company has a line of credit with its bank that allows borrowing in $100 increments at 12% interest. All borrowing takes place at the beginning of the month in which the company requires cash. The company must repay principal in hundred dollar increments. The credit facility requires Rancho, Inc. to repay all accrued interest to date whenever…arrow_forwardQUESTION 3 REQUIRED Use the information provided below to prepare the following for Mustang Enterprises for January and February 2024. 3.1 Debtors Collection Schedule 3.2 Cash Budget. INFORMATION The following information was supplied by Mustang Enterprises: 1. Mustang Enterprises expects to have an unfavourable bank balance of R40 000 on 31 December 2023. 2. The monthly sales were projected as follows: 2023 Units November 44 000 December 53 000 2024 Units January 47 000 February 31 000 3. The selling price is R20 per unit (excluding any discounts). All the goods produced each month are expected to be sold in the same month. Sixty percent (60%) of the sales is expected to be on credit and the balance is for cash. Thirty percent (30%) of the cash sales is subject to a discount of 10%. 4. Credit sales are usually collected as follows: 20% in the month of sale, and these debtors receive a 5% discount. 75% in the month after the sale, and the rest is usually written off as bad debts. 5.…arrow_forward23 [Question text] In the month of July, if a firm had a net cash inflow of RM2,000, beginning cash balance of RM5,000 and ending cash balance of RM30,000. How much does the firm need to borrow? Select one: A. RM23,000 B. RM11,000 C. RM12,000 D. RM27,000arrow_forward
- (Learning Objectives 1, 7: Show how to speed up cash flow from receivables;evaluate liquidity through ratios) Geneva Co., Inc., an electronics and appliance chain,reported these figures in millions of dollars:Net sales .........................................Receivables at end of year...............2019$523,1253,8602018$543,1254,510Requirements1. Compute Geneva’s days’ sales in receivables or days’ sales outstanding (DSO) during2019. (For this exercise, use “net sales” for “net credit sales” when calculating ratios.)2. Is Geneva’s DSO long or short? Kurzwel Networks takes 39 days to collect its averagelevel of receivables. Domarko Freight, the overnight shipper, takes 33 days. What causesGeneva’s collection period to be so different?arrow_forwardQuestion ANSWER B ONLY AND CALCULATE TOTAL The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows:Month Cash Sales Sales on Account PurchasesAugust $85,000 $640,000 $420,000September 70,000 550,000 550,000October 88,550 600,000 500,000 November 77,160 800,000 600,000December 174,870 500,000 450,000 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50%…arrow_forwardExercise 7 (Cash Budget Analysis) A cash budget, by quarters, is given below for a retail company. (000 omitted). The company requires a minimum cash balance of P5,000 to start each quarter. Quarter 1 2 3 4 Year Cash balance, beginning..................... P9 P? P? P? P? Add collections from customers….. ? ? 125 ? 391 Total cash available………………. 85 ? ? ? ? Less disbursements: Purchase of inventory….................. 40 58 ? 32 ? Operating expenses…………... ? 42 54 ? 180 Equipment purchases…................ 10 8 8 ? 36 Dividends…………………….. 2 2 2 2 ? Total disbursement………………..…arrow_forward
- Part #2: K Company is planning its cash disbursements for the upcoming months. In June, it anticipates $72,000 in Purchases, $130,000 in Payroll, and $40,000 in Loan Payments. In July, it anticipates $79,000 in Purchases, $140,000 in Payroll, and $35,000 in Loan Payments. In August, it anticipates $80,000 in Purchases, $150,000 in Payroll, and $30,000 in Loan Payments. Purchases are usually paid 40 percent in the current month and 60 percent in the following month. Payroll is paid 80 percent in the current month and 20 percent in the following month. Loan Payments are paid in the month due. Prepare a schedule of cash disbursements for the month of July only.arrow_forwardQuestion 3 Mischa Furniture Stores (“MFS”) is a company that specialises in office furniture based in Windhoek. Due to the effects of Covid-19, it has become very imperative for the company to manage its cash flows effectively. The owner of MFS knows of your skills in management accounting and has requested your service in the preparation of the forth coming quarter’s cash budget. Upon interviews with different departments at MFS, you have ascertained the following information: Budget information for January, February and March 2023 is as follows: January February March N$ N$ N$ Sales 590 000 650 000 750 000 Production costs 300 000 350 000 420 000 Sales and Administration costs 150 000 170 000 200 000 Purchase of non-current assets…arrow_forwardQuestion 2 The following information was extracted from the books of Mvula Ltd ( newly formed company that makes metal boxes). 1. At the start of January Mvula Ltd will have R150 000 cash in the current accoun 2. The Budgeted Sales figures is as follows: January February March Sales R300 000 R400 000 R550 000 These figures are based on orders that customers have already placed with the company after considerable work by the sales team. In order to secure the orders the sales team negotiated payment terms with the customers. Only 10% of customers agreed to pay immediately for the metal boxes. Of the remaining customers, 60% agreed to pay after one month and 40% after two months. Within the metal box industry it is known that 2% of credit customers never pay (because they go out of business or dispute the invoices ) the metal box company has made the decision to reduce the budgeted cash inflow from the credit customers who should pay after two…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY