2. Loblaw Manufacturing has asked you to create a cash budget in order to deter- mine...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. Loblaw Manufacturing has asked you to create a cash budget in order to deter- mine its borrowing needs for the June to October period. You have gathered the following information. Month Sales Other Payments June 2021 $489,125 $227,500 July 403,812 213,281 August 344,093 199,062 September 264,468 142,188 October 216,125 127,750 November 230,343 April and May sales were $327,031 and $383,906, respectively. The firm collects 20% of its sales during the month, 65% the following month, and 15% two months after the sale. Each month it purchases inventory equal to 55% of the next month's expected sales. The company pays for 40% of its inventory purchases in the same month and 60% in the following month. However, the firm's suppliers give it a 2% discount if it pays during the same month as the purchase. A minimum cash bal- ance of $25,000 must be maintained each month, and the firm pays 4% annually for short-term borrowing from its bank. a. Create a cash budget for June to October 2021. The cash budget should account for short-term borrowing and payback of outstanding loans as well as the interest expense. The firm ended May with a $30,000 unadjusted cash balance. b. Bob Loblaw, the president, is considering stretching out its inventory pay- ments. He believes that it may be less expensive to borrow from suppliers than from the bank. He has asked you to use the Scenario Manager to see what the total interest cost for this time period would be if the company paid for 0%, 10%, 30%, or 40% of its inventory purchases in the same month. The remainder would be paid in the following month. Create a scenario summary, and describe whether the results support Bob's beliefs. 2. Loblaw Manufacturing has asked you to create a cash budget in order to deter- mine its borrowing needs for the June to October period. You have gathered the following information. Month Sales Other Payments June 2021 $489,125 $227,500 July 403,812 213,281 August 344,093 199,062 September 264,468 142,188 October 216,125 127,750 November 230,343 April and May sales were $327,031 and $383,906, respectively. The firm collects 20% of its sales during the month, 65% the following month, and 15% two months after the sale. Each month it purchases inventory equal to 55% of the next month's expected sales. The company pays for 40% of its inventory purchases in the same month and 60% in the following month. However, the firm's suppliers give it a 2% discount if it pays during the same month as the purchase. A minimum cash bal- ance of $25,000 must be maintained each month, and the firm pays 4% annually for short-term borrowing from its bank. a. Create a cash budget for June to October 2021. The cash budget should account for short-term borrowing and payback of outstanding loans as well as the interest expense. The firm ended May with a $30,000 unadjusted cash balance. b. Bob Loblaw, the president, is considering stretching out its inventory pay- ments. He believes that it may be less expensive to borrow from suppliers than from the bank. He has asked you to use the Scenario Manager to see what the total interest cost for this time period would be if the company paid for 0%, 10%, 30%, or 40% of its inventory purchases in the same month. The remainder would be paid in the following month. Create a scenario summary, and describe whether the results support Bob's beliefs.
Expert Answer:
Answer rating: 100% (QA)
To create a cash budget for June to October 2021 we need to project the cash inflows and outflows fo... View the full answer
Related Book For
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank
Posted Date:
Students also viewed these accounting questions
-
Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information. April and May sales...
-
Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information....
-
Giselle Schmidt is an analyst for Allied Medical Waste and she needs to prepare a cash budget in order to determine the optimal time to purchase new Medical Waste Transport Vehicles costing $63,000...
-
Nancy has active modified adjusted gross income before passive losses of $75,000. She has a loss of $5,000 on a rental property she actively manages. How much of the loss is she allowed to take...
-
Anna-Greta Lantto, the assistant controller of Kiruna AB had recently prepared the following quality report comparing 2015 and 2014 quality performances. Just two days after preparing the report,...
-
Determine the slope and displacement at point B. Assume the support at A is a pin and C is a roller. Account for the additional strain energy due to shear. Take E = 29(10 3 ) ksi, I = 300 in 4 , G =...
-
A mass \(m\) is attached at the midpoint of a stretched wire of area of cross-section \(A\), length \(l\), and Young's modulus \(E\) as shown in Fig. 13.29. If the initial tension in the wire is...
-
Henna Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company...
-
The comparative balance sheets (2021, 2020) and the income statement (2021) for Company A are shown below. Additional information from the accounting records follow the statements. Prepare the...
-
Sophie and Daniel have a net income of $70 000 a year. This table shows their expenses. Expense Amount Student loan payments Rent Electricity Gas Water & Sewage Food Family cell phone plan Clothing...
-
For what type of BPM activity is the establishment of BPM foundations and enablement important?
-
What cash flows associated with preferred stock are included in the valuation model equation (8-1)? Why is the valuation model simplified in equation (8-2)? D (1+rps) + D (1+rps) + D% (1 + rps)0 (8-1)
-
Describe the typical triggers associated with each.
-
Describe how the process maturity of an organization influences the BPM implementation scenarios.
-
What are the potential benefits of the Process Selection Matrix and the Process Worth Matrix?
-
In a survey to find the main causes of lateness in a factory's work force, a random sample of 200 employees who were late for work were asked the reason why. The Pareto in Figure 1 shows the results....
-
For the following exercises, find the inverse of the function and graph both the function and its inverse. f(x) = 4 x 2 , x 0
-
You were recently hired to improve the financial condition of Idaho Springs Hardware, a small chain of three hardware stores in Colorado. On your first day the owner, Chuck Vitaska, told you that the...
-
You have decided to investigate a number of exchange-traded funds (ETFs) in an attempt to build a diversified portfolio. You believe that the transportation, consumer goods, energy, financials, and...
-
You are considering an investment in two projects, A and B. Both projects will cost $100,000, and the projected cash flows are as follows: a. Assuming that the WACC is 8%, calculate the payback...
-
Find the acceleration of a fluid particle for the following velocity profiles: (a) \(v_{x}=A\left(1-y^{2} ight) ; v_{y}=0 ; v_{z}=0\) (b) \(v_{x}=A x ; v_{y}=-A y ; v_{z}=0\) (c) \(v_{r}=0 ;...
-
Pervaporation: a case-study problem. Pervaporation refers to removal of the permeate as vapor and represents an intermediate case between purely gas transport and purely liquid transport in a...
-
Develop a simple backmixed model to evaluate the performance of a gas-separation system. Here a feed gas enters a high-pressure chamber with a mole fraction of A of \(x_{\mathrm{Af}}\) and leaves...
Study smarter with the SolutionInn App