Maizes Pty (Ltd) is currently planning their cash requirements for the next quarter, April 2020 to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Maizes Pty (Ltd) is currently planning their cash requirements for the next quarter, April 2020 to June 2020. The company sells baking supplies on credit, leading to a constant flow of sales and payments from debtors with occasional large inflows when goods are supplied for large contracts. The aging report on the accounting system of the company gives the following breakdown of collections from debtors: 10% one month after the sales have taken place 90% two months after the sales have taken place Sales for the following quarter are estimated as follows: R1 500 000 in April R400 000 in May R400 000 in June Further to this, e-mails from other branches and sales personnel indicate that the company can expect payments from large contracts worth R100 000 in April, R30 000 in May and R200 000 in June. The sales for February was R300 000 and R500 000 for March. Variable costs related to sales equal 90% of the selling price; and the company has fixed expenses estimated at R200 000 every month. The company had a cash balance of R40 000 at the end of March 2020. The company uses a R2 000 000 revolving credit facility to finance cash shortfalls that costs 1% per month and on which interest is paid on the closing balance of the facility every month, in the next month. Required: Compile a cash budget for Maizes Pty (Ltd) for April to June 2020 and clearly indicate what amount of financing the company will require every month, as well as the cost thereof. Maizes Pty (Ltd) is currently planning their cash requirements for the next quarter, April 2020 to June 2020. The company sells baking supplies on credit, leading to a constant flow of sales and payments from debtors with occasional large inflows when goods are supplied for large contracts. The aging report on the accounting system of the company gives the following breakdown of collections from debtors: 10% one month after the sales have taken place 90% two months after the sales have taken place Sales for the following quarter are estimated as follows: R1 500 000 in April R400 000 in May R400 000 in June Further to this, e-mails from other branches and sales personnel indicate that the company can expect payments from large contracts worth R100 000 in April, R30 000 in May and R200 000 in June. The sales for February was R300 000 and R500 000 for March. Variable costs related to sales equal 90% of the selling price; and the company has fixed expenses estimated at R200 000 every month. The company had a cash balance of R40 000 at the end of March 2020. The company uses a R2 000 000 revolving credit facility to finance cash shortfalls that costs 1% per month and on which interest is paid on the closing balance of the facility every month, in the next month. Required: Compile a cash budget for Maizes Pty (Ltd) for April to June 2020 and clearly indicate what amount of financing the company will require every month, as well as the cost thereof.
Expert Answer:
Answer rating: 100% (QA)
To create a cash budget for Maizes Pty Ltd for April to June 2020 we will need to project the cash i... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
However, some applications require the ability to store objects of multiple unrelated types. In this question the aim is to store Integer objects alongside LinkedList objects. MOREOVER DETAILS -----...
-
Choose the best answer: Class Participation Exams Homework TABLE OF MS265 ASSIGNMENTS AS OD 1/1/2023 100 50 25 25 50 100 100 Quizes Group Project 1 Group Project 2 Final Exam O a data value O a...
-
Ruthven Manufacturing Ltd is preparing a master budget for the first quarter of the financial year ending 31 March 2021, and has compiled the following data. 1. The firm sells a single product at a...
-
True or False The slope of the line 2y = 3x + 5 is 3.
-
Show how you would use Suzuki reactions to synthesize these products from the indicated starting materials. You may use any additional reagents you need. (a) (b) Br
-
3 A team used the Ping Man robot to test golf balls. At one point, there was a mixed up that caused the team to end up with 20 unmarked balls in a basket. They knew that 7 balls were Snell MTB-X, 3...
-
Which of the following information system functions focuses on the identification of problems and projects for computer processing? (a) user support (b) programming (c) operations (d) systems analysis
-
1. What overall changes could you recommend to the executive team at Egans about its HR practices? 2. What are the pros and cons of Egans performance appraisal system? Do you think it identifies the...
-
"I know that it's the thing to do," insisted Pamela Kincaid, vice president of finance for Colgate Manufacturing. "If we are going to be competitive, we need to build this completely automated...
-
Roadrunner Bookstore uses the perpetual inventory system. Roadrunner Bookstore is owned by Tina Smith. The company had the following transactions for the month of September. Sep 1 Sep 2 Sep 4 Sep 5...
-
a. An investor has $5,000 invested in a stock which has an estimated beta of 1.2, and another $15,000 invested in the stock of the company for which she works (Her total portfolio is worth $20,000)....
-
How can companies design their organizational structures to be more adaptable and agile in the face of rapidly changing market conditions and technological advancements ?
-
Company X raises $100,000 by issuing a combination of equity and taking out a bank loan. Equity makes up 75% of the total funds raised and 10,000 shares of common stock were sold. If the total APIC...
-
A 41 b AB ta B mm D P BC Bar ABC has a rectangular cross-section of a by b, where a = 270 mm and b = 89 mm. Rod BD has a diameter of 17 mm. Both members are made of a material with Young's Modulus of...
-
: What are the key considerations when integrating organizational structures during a merger or acquisition, and how can companies manage cultural differences to ensure a successful transition ?
-
Elle wanted to order candy online. Company A is offering ( 21)/(2) pounds of chocolate for $32.50, while Company B is offering ( 23)/(4) pounds of the same chocolate for $35.00. Which company is...
-
Caddy Shack Constructions PTY. LTD. purchased $4,400 worth of timber from The Giant Hardware Store. The owner of Caddy Shack Constructions PTY. LTD. rang The Giant Hardware Store to complain that...
-
On April 29, 2015, Auk Corporation acquires 100% of the outstanding stock of Amazon Corporation (E & P of $750,000) for $1.2 million. Amazon has assets with a fair market value of $1.4 million (basis...
-
Sales taxes account for _________ state and local tax revenue than property taxes.
-
The United States relies _________ heavily on incomebased taxes than most other developed countries in the world.
-
At the federal level, _________ half of taxes are from personal income taxes and corporate income taxes.
Study smarter with the SolutionInn App