Answered step by step
Verified Expert Solution
Link Copied!

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:

  1. 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.
  2. Suppliers are to allow one months credit. November & December 2012 purchases were Ghc 20,000 and Ghc 16,000 respectively
  3. Interest will be paid at the end of the month in which they are incurred and depreciation is accounted in their respective months
  4. 50% of Machinery sold in the month will be received in that month and the remaining amount spread evenly over the next 11months
  5. 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

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

Step: 3

blur-text-image

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

Cases In Auditing

Authors: Josephine Maltby

2nd Edition

1853963127, 978-1853963124

More Books

Students also viewed these Accounting questions