[go: up one dir, main page]
Scribd
Upload
107 views1 page

Basic Grenoble Enterprises Cash Budget

This document shows the cash budget for Basic Grenoble Enterprises over three months. In May, sales were $70,000 and there was a cash excess of $8,000. However, in June sales increased to $80,000 but there was a cash deficit of $2,000 requiring $18,000 in additional borrowing. In July, sales further increased to $100,000 but there was still a $2,000 deficit, met by $13,000 in additional borrowing.

Uploaded by

vratislav12
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
107 views1 page

Basic Grenoble Enterprises Cash Budget

This document shows the cash budget for Basic Grenoble Enterprises over three months. In May, sales were $70,000 and there was a cash excess of $8,000. However, in June sales increased to $80,000 but there was a cash deficit of $2,000 requiring $18,000 in additional borrowing. In July, sales further increased to $100,000 but there was still a $2,000 deficit, met by $13,000 in additional borrowing.

Uploaded by

vratislav12
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 1

May June July

Sales 70,000 80,000 100,000


Cash Beginning Balance: 5,000 8,000 5,000
Collections: Neo
Two months ago's Sales (20%) 10,000 12,000 14,000
Last Month's Sales (60%) 36,000 42,000 48,000
Current Sales (20%) 14,000 16,000 20,000
Other Income 2,000 2,000 2,000
Total 62,000 72,000 84,000
Total Cash Available for Disbursement 67,000 80,000 89,000
Purchases 50,000 70,000 80,000
Rent Payment 3,000 3,000 3,000
Salaries and Wages 6,000 7,000 8,000
Total 59,000 80,000 91,000
Cash Excess or (deficit) 8,000 - (2,000)
Financing Methods:
Payment of Cash Dividends - (3,000) Neo
Payment of Loan and Interest - (4,000)
Purchase of Equipment - (6,000)
Payment of Taxes Eon (6,000)
Additional Borrowing (Repayment) - 18,000 13,000
Cash Ending Balance 8,000 5,000 5,000
***Basic Grenoble Enterprise has suficient fund for the month of May but it needs to make
additional borrowings on the months of June and July to meet its cash requirement.
Basic Grenoble Enterprises
Cash Budget

You might also like