cash flow work

Jan. (actual)

82 000

47 000

21 000

6000

Feb. (actual)

78 000

42 000

18 500

6500

Mar. (actual)

77 500

40 000

22 000

5750

Apr. Budget

88 000

51 000

22 500

6100

May.Budget

82 500

46 000

21 750

6250

Jun. Budget

79 000

37 000

19 000

6500

You are further informed that:

• 10% of purchases and 20% of sales are for cash

The average collection period of the company is half a month and credit purchases are paid off regularly after one month.

Wages are paid half monthly and the rent, excluded in expenses, is paid monthly

• Cash and bank balance on April 1 was 15 000$ and the company aims to keep it below this figure at the end of every. The excess cash is placed in fixed deposits.

• With all theses informations, please prepare a cash budget for a company for April, May and June.