Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The management of Loadshedding Limited has asked you to prepare a cash budget for the months of February to April 2022. The following information is
The management of Loadshedding Limited has asked you to prepare a cash budget for the months of February to April 2022. The following information is available: December January February March April R R R R R Cash Sales 400 000 200 000 350 000 400 000 550 000 Credit Sales 900 000 405 000 450 000 495 000 350 000 Purchases 300 000 300 000 150 000 100 000 150 000 Salaries & wages 100 000 100 000 100 000 100 000 110 000 Rental expense 10 000 10 000 10 000 11 500 11 500 Sundry Expenses 80 000 105 500 85 000 60 000 50 000 Additional Information 1. A negative opening balance of R450 000 2. Interest expense of R10 000 is payable per month 3. Advertising amounts to R2 000 per month. 4. Credit sales are collected as follows: 60% in the month of sale 20% in the month following the sale 20% in the second month following the sale 5. All purchases are on credit: however, they are paid within the month of purchase to obtain a discount of 5% 6. Salaries and wages will double in the month of February as bonuses will be paid to employees. 7. Equipment amounting to R200 000 will be bought in March 2022. 8.Interest income amounting to R35 000 is received every month. 8. Dividends of R100 000 will be received in February 2022. 9. Rent income of R20 500 is received every month. 10. All sundry expenses are paid in cash. . 11. Depreciation is R30 500 per month. 12. Dividends of R150 000 will be declared and paid to shareholders in April 2022 Required: Prepare a cash budget for February, March, and April. Show all necessary schedules Debtors Collection Schedule R R R R Cash budget of Loadshedding Ltd R R R Opening balance Add: Total receipts Cash sales Credit sales Interest Dividends Rent Total cash available Less: Total cash payments Purchases Salaries & wages Rent Interest Advertising Equipment Sundry Expenses Dividends Closing balance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started