Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SamZuu Company is location in Ghana. The forecast information for the five months ending 31 May 2013 is: January Ghc000 February Ghc000 March Ghc000 April
SamZuu Company is location in Ghana. The forecast information for the five months ending 31 May 2013 is:
| January Ghc000 | February Ghc000 | March Ghc000 | April Ghc000 | May Ghc000 | June |
Sales | 20 | 16 | 28 | 26 | 30 | 24 |
Purchases | 12 | 16 | 18 | 14 | 12 | 15 |
Machinery | - | - | 40 | - | - | 50 |
Depreciation | 5 | 4 | 3 | 2 | 1 | 1 |
Interest paid | 4 | 4 | 3 | 3 | 5 | 2 |
Further Information:
- On average 30% of each months sales is expected to be for cash. Further 50% will be given one months credit. The rest will be given two months credit. All money will be received when due.
- Suppliers are to allow one months credit. November & December 2012 purchases were Ghc 20,000 and Ghc 16,000 respectively
- Interest will be paid at the end of the month in which they are incurred and depreciation is accounted in their respective months
- 50% of Machinery sold in the month will be received in that month and the remaining amount spread evenly over the next 11months
- The overdraft facility 13/12/2012 was Ghc (3,400)
Required:
Prepare a detail forecast month to month cash budget for the five(5) months ending 30 May 2013
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