Answered step by step
Verified Expert Solution
Question
1 Approved Answer
From the following forecasts of income and expenditure, you are required to prepare a cash budget for ABC Corporation for the months of February to
- From the following forecasts of income and expenditure, you are required to prepare a cash budget for ABC Corporation for the months of February to April 2020.
(12 marks)
Months | Sales (Credit) | Purchase (Credit) | Wages | Manufacturing expenses | Administrative expenses | Selling expenses |
2019 Nov. | 30000 | 15000 | 3000 | 1150 | 1060 | 500 |
Dec. | 35000 | 20000 | 3200 | 1225 | 1040 | 550 |
2020 Jan. | 25000 | 15000 | 2500 | 990 | 1100 | 600 |
Feb. | 30000 | 20000 | 3000 | 1050 | 1150 | 620 |
March | 35000 | 22500 | 2400 | 1100 | 1220 | 570 |
April | 40000 | 25000 | 2600 | 1200 | 1180 | 710 |
Additional information:
- The customers are allowed a credit period of two months.
- A dividend of $ 10000 in payable April.
- Capital expenditure which must be included: 15th Jan. $ 5000, the company will buy a plant and in March and will buy a building on loan and its payment will be done with in monthly instalments of $ 2000 each.
- The creditors are allowing a credit of 2 months.
- Wages are paid on the 1st of the next months.
- Lag in payment of other expenses is one month.
- Balance of cash in hand on 1st Jan. 2020 is $ 15000.
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