Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Month June 2021 Collections Payments $483125 $227500 July 403812 213281 August 344093 199062 Septembe 264468 145188 216125 127750 235343 October November 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 balance 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 (Analysis 8 pts). b) Bob Loblaw, the president, is considering stretching out its inventory payments. 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 belief (Analysis, Identify and Access Needed Information & Use Information Effectively to Accomplish a Specific Purpose 12 pts). 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. Month June 2021 Collections Payments $483125 $227500 July 403812 213281 August 344093 199062 Septembe 264468 145188 216125 127750 235343 October November 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 balance 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 (Analysis 8 pts). b) Bob Loblaw, the president, is considering stretching out its inventory payments. 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 belief (Analysis, Identify and Access Needed Information & Use Information Effectively to Accomplish a Specific Purpose 12 pts).
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Company - Canadian tireFrom cost - control perspective, what are some of the challenges ( risks ) that thecompany faces and how the management overcome these challenges? refer to company's official...
-
Green and White Company reported the following monthly data: Units produced Direct materials Sales price Direct labor Variable overhead Fixed overhead Variable selling and administrative expenses...
-
A pension fund manager is considering two mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund. The probability distribution of the risky funds is as...
-
The ResultSet object can be created by either executing the or method, which means that the ResultSet instance cannot be created or used without executing a query operation first. a. executeQuery(),...
-
The effects of a tariff on imported kumquats can be divided into the following categories: tariff revenues received by the treasury ($8 million); increased use of resources to produce more kumquats...
-
Using linear interpolation, determine the value of (P / A, 61/2%,10)from the compound interest tables. Compute this same value using the equation. Why do the values differ?
-
Gilded Question. In 1923, one ounce of gold costs 380 French francs (FRF). If at the same time one ounce of gold could be purchased in Britain for GBP4.50, what was the exchange rate between the...
-
Only one firm produces and sells soccer balls in the country of Wiknam, and as the story begins, international trade in soccer balls is prohibited. The following equations describe the monopolists...
-
Follow the instructions below. (a) Rewrite the decimal in the sentence below as a percentage. The value had decreased to 0.067 of the purchase price. (b) Rewrite the percentage in the sentence below...
-
A transformer with a turns ratio a = Np/Ns = 12 has a load of 2.2 kW applied to the secondary. If 120 V is applied to the primary, determine: a. The reflected impedance at the primary. b. The primary...
-
Does the success of Tesla fit the first/early mover concepts presented by Suarez (2018)? How do you explain the success of Tesla in light of the extremely low quality ratings? Does the success of...
-
what is data flow diagram? why do system analysts use data flow diagram?
-
Indigo Company reports the following costs and expenses in May. Factory utilities. $18,400 Direct labor $83,280 Depreciation on factory equipment 15,120 Sales salaries 55,120 Depreciation on delivery...
-
A helium nucleus of mass m = 6.64 x 10-27 kg and charge q- 3.20 x 10-19 C is in a constant electric field of magnitude E calculate the nucleus' acceleration and its displacement after 1.50 s if it...
-
In your own words, describe why relational database management system (RDBMS) is important in an Android Application? (200 Words)
-
TOPIC - Solving a two-dimensional (2D) mesh in Matlab Consider the two-dimensional (2D) mesh of the steel structure depicted in Figure for which we have the following data: 1) Modulus of elasticity...
-
Show that the peak of the black body spectrum as a function of ? is given by eq. (22.14) kg T Wmax = 2.82
-
Frontier Company, a successful efforts company, owns a working interest in an oil field in Oklahoma. The field has been producing for a number of years and is expected to be producing for another 10...
-
Solar Petroleum owns 100% of the working interest in the Bearcat Field in West Texas. The field has been producing and is expected to produce for 10 more years. Events have occurred that indicate...
-
Baseline Petroleum, a successful efforts company, entered the oil and gas business in 2014 with the acquisition of one field. Baseline proved the field during 2014. At the end of 2014, prices were...
Study smarter with the SolutionInn App