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.
-
Energy is generated in the sun and other stars by fusion. One of the fusion cycles, the protonproton cycle, consists of the following reactions: 1 H + 1 H 2 H + + + v e 1 H + 2 H 3 He + Followed...
-
Ingrid Legal Services has collected the following data for the December 31 adjusting entries: a. Each Friday, Ingrid Legal Services pays employees for the current weeks work. The amount of the weekly...
-
The flowrate in the clay-lined channel \((n=0.025)\) shown in Fig. P10.54 is to be \(300 \mathrm{ft}^{3} / \mathrm{s}\). To prevent erosion of the sides, the velocity must not exceed \(5 \mathrm{ft}...
-
You are provided with the following information from the equity section of Tingwick Ltd.'s balance sheet on December 31, 2016: Preferred shares-authorized, 5,000,000 shares; outstanding 2,000,000...
-
Write a program to build a text histogram of the distribution of letter frequencies in an input string. Get input from the user using the provided code, which uses lower () to convert the string to...
-
Rick, a second-year accounting student has charged various friends and acquaintances a $80 fee to prepare their individual income tax returns. Matt, an accounting graduate, obtains two free personal...
-
A drawer holds 4 red hats and 4 blue hats. what is probability of getting exactly 3 red hats or 3 blue hats when taking out 4 hats randomly out of drawer and immediately returning every hat to drawer...
-
Three of the nurses in the cardiac outpatient clinic are enrolled in an MPH program. They want to investigate whether a patients ethnicity or race influences the quality and quantity of care received...
-
Consider a swap with these features: maturity is five years, notional principal is \(\$ 100\) million, payments occur every six months, the fixed-rate payer pays a rate of \(9.05 \%\) and receives...
-
Donald Singleton is an investment banker for a regional firm. One of his clients, Dolby Manufacturing, Inc., is a private company that will be making an initial public offering of 20 million shares...
-
The geriatrics inpatient unit has experienced a significant amount of nursing staff turnover. In the last 12 months, seven of the 29 permanent RN staff members have left. In addition, the number of...
-
Suppose you bought a stock index futures contract for 200 and were required to put up initial margin of \(\$ 10,000\). The value of the contract is 200 times the \(\$ 500\) multiple, or \(\$...
-
#5 A couple is buying their dream house for $494,050.00. They will put 20.00% down and finance the rest with a 30.00-year mortgage with monthly payments. The bank has offered them a loan with 5.28%...
-
(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...
-
Due to the Covid recession of 2020, the U.S. government budget changed from smaller deficits to very large deficits. What impact would this have on the net exports and private sector balances, all...
-
Verify the log-likelihood in equation (16.4) for the Tobit model. In L = = In { 1-0 (x-di)} 1:y=di 122. + (y; - x) 02 (16.4) i:y;>di
-
Verify the likelihood in equation (16.5) for the two-part model. n2. (16.5) -(-)-(-2)/02 L = [] {(p;)" (1 p; )'-'} [[ ( i=1 ri=1
Study smarter with the SolutionInn App