Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your friend James saw an opportunity to start a new company called Give Me Power (Pty) Ltd. Considering load shedding and constant increases in

Your friend James saw an opportunity to start a new company called Give Me Power (Pty) Ltd. Considering load

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Financial Accounting

Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald

1st Canadian Edition

1118849388, 9781119048572, 978-1118849385

More Books

Students also viewed these Finance questions

Question

What is the FASBs conceptual framework?

Answered: 1 week ago