From the following information you are to prepare a
Cash Budget for the period from July to December 2008.
(i) The estimated sales and expenses are
as follows:
June
July
Aug.
Sep.
Oct.
Nov.
Dec.
Sales
35,000
40,000
40,000
50,000
50,000
60,000
65,000
Purchases
14,000
16,000
17,000
20,000
20,000
25,000
28,000
Wages & Salaries
12,000
14,000
14,000
18,000
18,000
20,000
22,000
Expenses
5,000
6,000
6,000
6,000
7,000
7,000
7,000
Interest Received
2,000
-
-
2,000
-
-
2,000
Sale of Fixed Assets
-
-
20,000
-
-
-
-
(ii) Sales are 20% in cash and balance on
credit. 50% of the debtors are collected in the month of
sales and the remaining in the next month.
(iii) The time lag in payment of purchases
and expenses is 1 month. However, wages and salaries are
paid fortnightly with a time lag of 15 days.
(iv) The company maintains a minimum cash
balance of Rs. 5,000. The cash balance in excess of Rs.
7,000 is invested in government securities in multiples of
Rs. 1,000. Short falls in cash balance are made good by
borrowing from banks. The interest received as well as paid
is to be ignored.
- 1 Answers
- 3124 Views
- Ignou, I also Faced
- E-Mail Answers
Answer / Rameez Iqbal Khan
Here's a Cash Budget for the period from July to December 2008 based on the provided information:
July:
Beginning Cash Balance: (Assume a cash balance of Rs. 5,000 from June)
- Purchases: 16,000
- Wages & Salaries: 14,000
- Expenses: 6,000
Ending Cash Balance: 5,000 - 36,000 = -31,000 (Cash deficit)
August:
Beginning Cash Balance: (-31,000 from July) + Sales: 40,000
- Purchases: 17,000
- Wages & Salaries: 14,000
- Expenses: 6,000
Ending Cash Balance: 40,000 - 38,000 = 2,000 (Cash surplus)
September:
Beginning Cash Balance: 2,000 from August
+ Sale of Fixed Assets: 20,000 (assuming this sale occurs in September)
- Purchases: 20,000
- Wages & Salaries: 18,000
- Expenses: 6,000
Ending Cash Balance: 40,000 (Cash surplus)
October, November, and December can be calculated similarly. Note that the Interest Received is not included in the cash budget as it is ignored per the given rules.
| Is This Answer Correct ? | 0 Yes | 0 No |
Have you worked with other on team endeavors
what is debit card? n what is credit card? if it is a debit card what will be a transaction in personal account and if it is a credit card what will be the tranction in personal account
Expand C I F
What are intangible Assets?? ASKED 12.12.2008
What is mein Capital market?
Who invented Double entry system of Accounting and when
What I will be done in this case I deduct tds excess than the actuai amount?
What is meant by Capital Loss
What is the difference between govt. company and public ltd. company
Expand A D T A
1. what is responsibility of inword & forward agent ? 2. how to control cash expenses give five step ? 3. what is Vat 3. how many type of depreciation
what is opening brs in tally
Audit 
