Question
In: Accounting
From the following data, prepare a cash budget for the three months ending 31st December,2019  
- From the following data, prepare a cash budget for the three months ending 31st December,2019
(1)
|
Months |
Sales (AED) |
Materials (AED) |
Wages (AED) |
Overheads (AED) |
|
September |
10000 |
5000 |
1000 |
200 |
|
October |
20000 |
4000 |
1000 |
200 |
|
November |
25000 |
3000 |
2500 |
200 |
|
December |
10000 |
4200 |
2000 |
300 |
(2) Credit terms are:
(a) sales/debtors- 50% sales are on cash basis, 50% of the credit sales are collected next month.
(b) Creditors
- for materials- 1 months
- for wages- Same months
- for overheads – 1month
(3) Cash balance on 1st October, 2019 is expected to be AED 5000.
.
Note: Answers should be Kindly in Word or Excel Format
Solutions
Expert Solution
Hope you understood the solution. If you have any doubt please leave your doubt in the comment section so that I can clarify your doubt.
Thank you.
ekkarill92 answered 3 years agoRelated Solutions
From the following data prepare the balance sheet of X Ltd., as on 31st December, 1999....
From the following data prepare the balance sheet of X
Ltd., as on 31st December, 1999.
Current ratio 2.5;
Quick ratio 1.5;
Net working capital Rs.3,00,000
Gross profi t ratio 20%
Fixed Assets turnover ratio 2 times
Stock turnover ratio (Cost of sales/ Closing stock) 6
times.
Average Collection period 2 months
Super quick ratio .25
Fixed Assets to shareholders equity .8
Reserves and surpluses to share capital .5
Debt equity ratio .2
Prepare a Statement of Cash Flow for the year ending 2019 from the following information. 2018...
Prepare a Statement of Cash Flow for the year ending 2019 from
the following information.
2018
2019
Cash
85,000
27,000
Accounts Receivable
95,000
80,000
inventory
130,000
134,000
prepaid expenses
9,500
9,000
land
89,700
130,000
PP&E
295,500
256,700
accumulated depr
-30,000
-13,000
total assets
674,700
623,700
accounts payable
98,000
77,000
accrued liabilities
54,000
70,000
bonds payable
110,000
60,000
common stock
100,000
101,000
retained earnings
312,700
315,700
674,700
623,700
PP&E with a historical cost of $50,000 and a net book value
of...
Use the following information to prepare a cash budget for December. The cash balance on December...
Use the following
information to prepare a cash budget for December.
The cash balance on
December 1 is $53,400.
Actual sales for
October and November and expected sales for December are as
follows:
October
November
December
Cash
sales
$
77,000
$
81,200
$
87,800
Sales on
account
$
435,000
$
538,000
$
644,000
Sales on account are
collected over a three-month period as follows: 20% collected in
the month of sale, 60% collected in the month following sale, and
18%...
Freewheel is in the process of preparing its master budget for the six months ending December...
Freewheel is in the process of preparing its master budget for
the six months ending December 19X2. The balance sheet for the year
ended 30 June 19X2 is estimated to be as follows: Cost Deprec prov
NBV
Fixed assets 140.000 14.000 126.000
Current assets
Stock 25.000
Trade debtors 24.600
Bank 3.000
Net current liabilities 52.600
Creditors Amount falling due within one year
Trade creditors 25.000
Other creditors 9.000
34.000
Net current assets 18.600
Total assets less current liabilities 144.600
Capital...
text Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements...
text Prepare Cash Budget For 3 Months Brewster Corporation
expects the following cash receipts and disbursements during the
first quarter of 2016 (receipts exclude new borrowings and
disbursements exclude interest payments on borrowings since January
1, 2016) January February March Cash receipts $290,000 $310,000
$280,000 Cash disbursements 270,000 350,000 290,000 The expected
cash balance at January 1, 2016, is $72,000. Brewster wants to
maintain a cash balance at the end of each month of at least
$70,000. Short-term borrowings at...
At the beginning of the 2010 school year, Britney Logan decided to prepare a cash budget for the months of September, October, November, and December.
At the beginning of the 2010 school year, Britney Logan decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:Cash balance, September 1 (from a summer job) . . . . . . . . . . . . . . . . . ....
7aresh company has these accounts on 31st december 2019: Cash of $9,380 Wage Expense of $300...
7aresh company has these accounts on 31st december 2019:
Cash of $9,380
Wage Expense of $300
Accounts Payable of $8,900
Cost of Goods Sold of $5,900
Unearned Revenue of $1,170
Gain on Sale of Equipment of $120
Inventory of $6,230
Sales Revenue of $7,510
Interest Expense of $1,280
Common Stock (no par value) of $4,610
Rent Revenue of $1,230
Retained Earnings of $2,030
Depreciation Expense of $365
Prepaid Insurance of $2,100
as of december 31st 2019, provide 7aresh's journal entry
The following information relates to ABC Ltd., for the year ended 31st December, 2019.
The following information
relates to ABC Ltd., for the year ended 31st December,
2019.
Sales……………………………………………………………….. Rs.2,000,000.
EBID ………………………………………………………………. 40% of sales.
Ordinary Shares capital of par value Rs.10/each………………
Rs.800,000.
8% Preference shares Capital of par value Rs.100/ each……….
Rs.500,000.
10% Bonds payable of par value Rs.1000/each………………….
Rs.400,000.
Reserves and surplus………………………………………………Rs.250,000.
Current liabilities…………………………………………………..Rs.250,000.
Tax rate is 30%.
Market price of share is Rs.20 each.
Dividend payout ratio is 60%.
Required; Compute and comments
on each of the following ratios
a)Earning per...
R. Sedeno had the following assets and liabilities on 31st December, 2019. Items
R. Sedeno had the following assets and liabilities on
31st December, 2019.
Items
$
Items
$
Cash
100
Bank
2,180
Stock
5,900
Petty
Cash
120
Furniture and
Fittings
6,800
Equipment
3,200
Motor
Vehicle
17,500
Premises
40,000
Debtors:
Creditors:
L.
Robertson
1,900
T. Hosein 250
H.
Henry
520
N. Akua
1,200
Transactions during the month of January 2020 were as
follows:
1 Paid N.
Akua’s account less 5% discount by cheque.
2 Bought
$20 stamps and $40...
R. Sedeno had the following assets and liabilities on 31st December, 2019. Items
R. Sedeno had the following assets and liabilities on
31st December, 2019.
Items
$
Items
$
Cash
100
Bank
2,180
Stock
5,900
Petty
Cash
120
Furniture and
Fittings
6,800
Equipment
3,200
Motor
Vehicle
17,500
Premises
40,000
Debtors:
Creditors:
L.
Robertson
1,900
T. Hosein 250
H.
Henry
520
N. Akua
1,200
Transactions during the month of January 2020 were as
follows:
1 Paid N.
Akua’s account less 5% discount by cheque.
2 Bought
$20 stamps and $40...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
ADVERTISEMENT