Prepare cash budget for three months, Financial Accounting

Assignment Help:

QUESTION 1:

PART A

You  are  given with  the  following information relating to Rooney PLC. The accountant is currently developing the budget for the next three months ending 30 June 2010.

Month

Sales (Rs)

Materials (Rs)

Wages (Rs)

Overheads(Rs

February

14000

9600

3000

1 700

March

15000

9000

3000

1 900

April

16000

9200

3200

2000

May

17,000

10,000

3 600

2,200

June

18000

10400

4000

2300

(a) The credit terms are as given: 10% sales are cash, 50% of the cred it sales are collected next month and the balance in the following month,

(b) For the subsequent items of expenditure, the credit terms are as follows: Materials - 2 months, Wages - 1 month, Overheads - 1 month.

(c) Cash and bank balance on 1st April 2010 is expected to be $6 000

(d) Other relevant information:

(i) Machinery and Plant will be installed in February 2010 at a cost of $96,000. The monthly instalments of $2 000 is payable as from April onwards

(ii) A dividend of 5% on the ordinary share capital of $200 0 00 will be paid on 1st June.

(iii) An advance receipt of $9 000 is expected in June and will relate to the sale of vehicles.

(iv) Dividends from investments amounting to $1 000 are to be received in May.

(v) An advance payment of income tax is to be paid in June of $2 000.

Required:

Create cash budget for three months ending 30 June 2010.

PART B

Since cash is important for the survival of any business, it is often suggested to develope a cash budget, as it is no use budgeting for product ion and for sales if, during the budget period, the business runs out of cash funds.

Required:

Explain four advantages why cash budgets should be prepared?


Related Discussions:- Prepare cash budget for three months

Compute gross income from sales, 1. Ben lost his job when his employer move...

1. Ben lost his job when his employer moved its plant. During the year, he collected unemployment benefits for three months, a total of $1,800. While he was waiting to hear from pr

Process of abc analysis - inventory control, Process of ABC Analysis •...

Process of ABC Analysis • Classification:   On the origin of expected use, the items of inventory are categorized according to their categories and per unit Price of each item

Shorter compounding period, In our discussion so far, we have supposed that...

In our discussion so far, we have supposed that the compounding is done yearly, here let us see the case where compounding is complete more often.  In such case the equation (1) is

Write up the necessary ledger accounts, Question: Agatha Co. is a tradi...

Question: Agatha Co. is a trading company making up its accounts regularly to 31 December each year. At 01 January 2005 the following balances existed in the records of Agat

Review, objective of working capital management and profitability

objective of working capital management and profitability

Partnership, Definition: A partnership is defined as “the relationship ...

Definition: A partnership is defined as “the relationship that subsists between two or more persons carrying on a business in common with a view to making a profit.” (Partnersh

Evaluate price earnings ratio, Q. Evaluate Price Earnings Ratio? The P/...

Q. Evaluate Price Earnings Ratio? The P/E ratio is in general regarded as an important ratio for equity investors. The P/E for a company may be utilizing as a basis for compari

Quarterly cash dividends are planned, Given the information that follows, d...

Given the information that follows, draw a cash budget for the XYZ Store for the first six months of 2012. Every prices and costs remain constant. Sales are 80% for credit

What do you mean by operating agreement, Q. What do you mean by Operating A...

Q. What do you mean by Operating Agreement? Operating Agreement - Agreement, generally a written document which sets out the rules by which a LIMITED LIABILITY COMPANY (LLC) is

Assess the liquidity and solvency of the company, Students are to prepare a...

Students are to prepare and report as a financial advisor to an investor as to whether the public company selected is a suitable investment for the investor. In preparing the essay

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd