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

T account, I've tried everything im just really lost. I have to enter into ...

I've tried everything im just really lost. I have to enter into T accounts. Common stock $5 stated value (900,000 shares authorized, 620,000 shares issued)................. $3,100,

Primary restriction of making demand, Q. Primary restriction of making dema...

Q. Primary restriction of making demand? The primary restriction of making demand forecasts lies in the fact that they are forecasts and hence their reliability is unknown. Mos

Closing entries, Closing Entries: Expenses Below is a list of accounts with...

Closing Entries: Expenses Below is a list of accounts with corresponding ending balances. Account: Account Balance a.Insurance Expense: $1,300 b.Cash: 750 c.Accounts Receivable: 4,

Evaluate the earnings per share, Q. A ltd. Company has equity share capital...

Q. A ltd. Company has equity share capital of Rs. 5,00,000 divided into shares of Rs. 100 each. It wishes to gain further Rs. 3,00,000 for expansion cum modernization plans. The co

Show the basis of weightings, Q. Show the Basis of weightings? (i) Both...

Q. Show the Basis of weightings? (i) Both costs of capital (Ke and Kd) as well as the WACC have been calculated using current   ex-dividend (ex-interest) market values rather t

Callable preferred stock, Callable Preferred Stock On March 4, 2013, Hein C...

Callable Preferred Stock On March 4, 2013, Hein Corporation issues 1,000 shares of $100 par preferred stock for $125 per share. The stock is not callable by the corporation until 3

Prepare a cash budget, The following information for the six months ended 3...

The following information for the six months ended 31 December 2009 relates to the business of Mr N Morris: a) Opening cash (including bank) balance Rs 1,200 b) Production in unit

What do you mean by fiscal year, Q. What do you mean by Fiscal Year? Fi...

Q. What do you mean by Fiscal Year? Fiscal Year - Period of 12 consecutive months chosen by an entity as its ACCOUNTING period that may or may not be a calendar year. Fixed Ass

Determine straight value and conversion value , Banana Computer has a perpe...

Banana Computer has a perpetual, convertible 7% annual coupon bond outstanding. The bond has a face value of $1,000 and has a conversion price of $40. The required return on an oth

Features of the torrens title system, Answer both parts of this question. E...

Answer both parts of this question. Each part is worth seven and a half marks each. (a) Describe the features of the Torrens Title system of land registration and compare them t

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