Your friend James saw an opportunity to start a new company called Give Me Power (Pty)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your friend James saw an opportunity to start a new company called Give Me Power (Pty) Ltd. Considering load shedding and constant increases in fuel prices, James will buy and resell specialised generators that use solar power to generate electrical energy. James asked you to help him prepare a cash budget and to calculate the closing cash balance as these contribute to the day-to-day financial management and the making of strategic decisions. You received the following information: December 2021 Sales forecast 800 000 Purchases forecast 480 000 James expects cash sales to be 40% of the total sales. The remaining balance will be received as follows: 50% in the month following the cash sales, 30% in the month thereafter and 20% in the third month. . January 2022 February 2022 820 000 860 000 510 000 650 000 James expects purchases to be 20% cash and to pay his creditors 60% in the first month following the purchases and 40% in the month thereafter. Other operating information: . March 2022 880 000 680 000 ● James will need stationery and a computer in January 2022 for a total amount of R50 000. Salaries and wages for December and January will be R120 000 per month, with an increase of 10% from February 2022. Monthly rental for the shop is an agreed amount of R40 000 per month. James has R1 000 000 available to start this business in December 2021. This will be the first month of trade for the company. Required: Round off all calculations to the nearest rand. Calculate the closing cash balance for March 2022 by preparing a cash budget for Give Me Power (Pty) Ltd using the format presented in the prescribed textbook. Your friend James saw an opportunity to start a new company called Give Me Power (Pty) Ltd. Considering load shedding and constant increases in fuel prices, James will buy and resell specialised generators that use solar power to generate electrical energy. James asked you to help him prepare a cash budget and to calculate the closing cash balance as these contribute to the day-to-day financial management and the making of strategic decisions. You received the following information: December 2021 Sales forecast 800 000 Purchases forecast 480 000 James expects cash sales to be 40% of the total sales. The remaining balance will be received as follows: 50% in the month following the cash sales, 30% in the month thereafter and 20% in the third month. . January 2022 February 2022 820 000 860 000 510 000 650 000 James expects purchases to be 20% cash and to pay his creditors 60% in the first month following the purchases and 40% in the month thereafter. Other operating information: . March 2022 880 000 680 000 ● James will need stationery and a computer in January 2022 for a total amount of R50 000. Salaries and wages for December and January will be R120 000 per month, with an increase of 10% from February 2022. Monthly rental for the shop is an agreed amount of R40 000 per month. James has R1 000 000 available to start this business in December 2021. This will be the first month of trade for the company. Required: Round off all calculations to the nearest rand. Calculate the closing cash balance for March 2022 by preparing a cash budget for Give Me Power (Pty) Ltd using the format presented in the prescribed textbook.
Expert Answer:
Answer rating: 100% (QA)
To calculate the closing cash balance for March 2022 we need to consider the forecasted cash flows based on the information provided We will prepare a cash budget for the period from December 2021 to ... View the full answer
Related Book For
Understanding Financial Accounting
ISBN: 978-1118849385
1st Canadian Edition
Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Discussion 7 questions make sure to answer all parts of questions detailed Read the Nasdaq article. Select one of the companies and state why you would be willing to invest in the IPO as part of your...
-
Elaborate the basic functioning of a hydraulic lift. Include the terms pressure, density, and buoyant force in the explanation. Give one example of a hydraulic lift you have encountered.
-
In an attempt to improve operating efficiency, one employee was made responsible for all purchasing, receiving, and storing of supplies. Is this organizational change wise from an internal control...
-
John and his business partner plan make $10,000 profit on their first year of selling cakes. They plan to use 30% of the profits to repay the loan. The rest of the of the profits they are going to...
-
Express the following \(n\) th-order differential equation as a system of \(n\) first-order differential equations: \[a_{n} \frac{d^{n} x}{d t^{n}}+a_{n-1} \frac{d^{n-1} x}{d t^{n-1}}+\cdots+a_{1}...
-
At May 31, 2017, the accounts of Lopez Company show the following. 1. May 1 inventoriesfinished goods $12,600, work in process $14,700, and raw materials $8,200. 2. May 31 inventoriesfinished goods...
-
1. Your client is charged with two counts of theft that relate to two separate incidents. At the first appearance, you receive a disclosure package from the Crown. Upon reviewing the material, you...
-
The Brady & Matthew Camera Company has just come out with their newest professional quality digital camera, the ToughPix1. The company is selling this camera only through its new mobile app at a...
-
A birth-and-death chain has state space X={0, 1, 2,...,n). In one step the state can increase or decrease by at most 1. The current state can be thought of as the size of some population; in a single...
-
Do shareholders have any right to receive a dividend if the corporation is profitable?
-
What are preemptive rights in relation to a corporations shares?
-
What types of negotiable instruments are governed by the Bills of Exchange Act? What is money?
-
What is the appeal of a reverse mortgage on their home to a retired elderly couple?
-
Quality Meat Packers Ltd. has major factories and warehouses from coast to coast. How does this fact complicate the companys collective bargaining with its employees?
-
Sales COGS Gross Profit based on the following information: 2016 2017 2018 1000 1200 1320 600 400 Assume in 2016 variable costs are 300. 32. If volume increases were 6% in 2017 and 3% in 2018, what...
-
(a) Find the equation of the tangent line to f(x) = x 3 at the point where x = 2. (b) Graph the tangent line and the function on the same axes. If the tangent line is used to estimate values of the...
-
The following amounts were reported by Liquid Company in its most recent statement of financial position: Cash ................... $ 40,000 Accounts receivable ............... 130,000 Short-term...
-
On January 1, 2016, Bountee Ltd. leased a machine from Vector Equipment Ltd. The machine had cost Vector $480,000 to manufacture, and would normally have sold for about $600,000. The lease was for 10...
-
The change in retained earnings from the beginning of the year to the end of the year is the result of net earnings minus dividends for the year. These changes are part of the information presented...
-
Using the data in exercise 2, calculate the marginal factor cost. Data from in exercise 2 Using the information in the following table, calculate the marginal revenue product (MRP = MPP MR). Unit of...
-
Suppose the output price falls from \($5\) to \($4\) to \($3\) to \($1\) in exercise 2. How would that change your answers to exercises 2 and 3? Data from in exercise 2 Using the information in the...
-
Using exercise 6, calculate the transfer earnings and economic rent of the third unit of the resource when four units of the resource are employed. Data from in exercise 6 Suppose the resource price...
Study smarter with the SolutionInn App