Cash budget—Basic ??Grenoble Enterprises had sales of $49,600 in March and $60,200in April. Forecast sales for? May, June, and...

3.9 Ratings (527 Votes)

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.

Cash Budget

		May	June	July	Total
Beginning Cash Balance		$ 4,500	$ 15,676	$ 4,100	$ 4,500
Add: Collection from Customers
Against Cash Sale	22% of Sale	$ 15,356	$ 17,644	$ 21,890	$ 54,890
Next Month	61% of Sale	$ 42,578	$ 48,922	$ 60,695	$152,195
Next to Next Month	17% of Sale	$ 11,866	$ 13,634	$ 16,915	$ 42,415
Add: Other Income		$ 2,500	$ 2,500	$ 2,500	$ 7,500

Total Cash Available	A	$ 76,800	$ 98,376	$106,100	$261,500
Less: Cash Disbursment for:
Purchases		$ 50,400	$ 69,500	$ 79,600	$199,500
Rent Expense		$ 3,500	$ 3,500	$ 3,500	$ 10,500
Wages and Salaries	12% of Previous sale	$ 7,224	$ 8,376	$ 9,624	$ 25,224
Dividend Payment			$ 2,600		$ 2,600
Note and Interest Payment			$ 3,800		$ 3,800
Purchase of Equipment				$ 5,700	$ 5,700
Tax Payment			$ 6,500		$ 6,500

Total Cash Payment	B	$ 61,124	$ 94,276	$ 98,424	$253,824
Ending cash Balance	A-B	$ 15,676	$ 4,100	$ 7,676	$ 7,676

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Other questions asked by students