Reference no: EM133064661
Question - Your friend James saw an opportunity to start a new companycalled 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 preparea 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
|
January 2022
|
February 2022
|
March 2022
|
|
Sales forecast
|
800,000
|
820,000
|
860,000
|
880,000
|
|
Purchases forecast
|
480,000
|
510,000
|
650,000
|
680,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.
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:
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 - 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.
|
Compute the investment turnover and profit margin
: Compute the investment turnover, profit margin, return on investment, and residual income for each division. Assume a 10% hurdle rate
|
|
Explain purpose of financial statement analysis
: Explain the purpose of financial statement analysis for both external and internal users.
|
|
Health profile may also yield results
: Analyze your state, county, or city health department's website (e.g., dhhs.gov). A Google search of your city's "health profile" may also yield results
|
|
What information will she need and why
: Will Natalie need accounting information? If yes, what information will she need and why? How often will she need this information
|
|
Calculate the closing cash balance for march
: 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
|
|
Identifying global issues and appreciating interdependence
: Explain your concern for diversity issues affecting the world marketplace and name the groups of people who are affected by them.
|
|
Compute the individual cost of capital
: The company's preferred stock sells for $42 a share and pays an annual dividend of $4 a share. Compute the individual cost of capital
|
|
Strategic leadership and strategic planning
: Your research: Strategic leadership, crowdsourcing, strategic planning, SWOT analysis, knowledge management, learning organization, systems thinking,
|
|
How much was the goods available for sale during the period
: At the beginning of the year, there was one kayak in inventory costing $500. How much was the goods available for sale during the period
|