has of its of 10000 and may Cash Budget 3rd 4th SolutionAnsw

has of its of $10,000 and may Cash Budget 3rd 4th

Solution

Answer:

Garden Depot

Cash Budget

1st Q

2nd Q

        3rd Q

    4th Q

Bal. Beg.                   

36000

10,000

102,200

116,200

Cash Receipts         

260000

410000

290000

310000

Total cash available

296000

420000

392200

426200

Less cash disb’ts       

316000

286000

276000

296000

Excess (deficiency)   

-20000

134000

116200

130200

Financing:

Borrowings (beg)       

30,000

Repayment (at end)

-30,000

Interest*                                             

-1800

Total financing

30,000

-31,800

0

0

Ending cash Balance

10,000

102,200

116,200

130,200

Working notes for the above answer

1

Interest:

=$30,000 x 3% x 2 quarter

= $1800

Garden Depot
Cash Budget
	1st Q	2nd Q	3rd Q	4th Q
Bal. Beg.	36000	10,000	102,200	116,200
Cash Receipts	260000	410000	290000	310000
Total cash available	296000	420000	392200	426200
Less cash disb’ts	316000	286000	276000	296000
Excess (deficiency)	-20000	134000	116200	130200
Financing:
Borrowings (beg)	30,000
Repayment (at end)		-30,000
Interest*		-1800
Total financing	30,000	-31,800	0	0
Ending cash Balance	10,000	102,200	116,200	130,200