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.
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 |
what is assesment? who do the assesment by income tax or sale tax,and when doing the assesment?what is the perod limit of assesment? assesment order sent by income tax or sale tax which form?
Why interest on partner's loan is not transferred to his capital account? What is the logic for transferring it to his current account/ loan account or accrued interest account?
what are the types of leasing and their accounting entries?
Why we Add the net profit in the balance sheet ? Why we shows profit in the liability side of the balance sheet?
Answered but misspelled pl correct ADMINISTRATIVE OVERHEADS -GROSS PROFIT=(ANS.SSOL)
What is Contingent Liabilities?
what is difference between venture capital financing and equity financing?
Distinguish between straight line and diminishing balnce methods in calculating depreciation
what is the difference between shares & debentures
Transfer nett profit of Rs 325000/- to Reserves and Surplus
Expalin about the distinction between Profit and loss a/c and balance sheet
why balance sheet should tally