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

Calculate ß for the intercept-income and noncauc, For this question you wil...

For this question you will use the dataset "murder.xls", which includes: • rate = Murder rate per 100,000 • convictions = Number of convictions divided by number of murders • execu

Theoretical value of shareholding, Q. Theoretical value of shareholding? ...

Q. Theoretical value of shareholding? (i) Theoretical value of shareholding Theoretical ex-rights value = ((No. shares in issue×Market value) + (No. rights shares× righ

What amount does eggers stand to lose, Q. Andy Eggers has invested $150,000...

Q. Andy Eggers has invested $150,000 in a privately held family corporation. The corporation does not do well and must declare bankruptcy. What amount does Eggers stand to lose? a.

Cash flow, Please use the budget information in Assignment 7.1-case to prep...

Please use the budget information in Assignment 7.1-case to prepare the budget in the Excel document Assignment 7.1-budget and cash flow.

Calculate the average issue price of the common stock, Star corporation iss...

Star corporation issued both common and predered stock during 20X6. The stockholders' equity section of the company's balance sheets at the end of 20X6 and 20X5 follow: 20X6 20X5 P

What is reporting currency, 1. What accounting firm performed the audit of ...

1. What accounting firm performed the audit of Zetar's financial statement? 2. What is the address of the company's corporate headquarters? 3. What is the company's reporting

Prepare a balance sheet and trial balance, Requirements: a.   Record the...

Requirements: a.   Record the following transactions in the journal of Howell Consulting. Explanations are not required. b.   Create T accounts for each transaction (Use the

Corporation accounting oversight board, PCAOB - Public Corporation Accounti...

PCAOB - Public Corporation Accounting Oversight Board, a private-sector, non-profit corporation created by Sarbanes-Oxley Act of 2002, to oversee AUDITORs of public companies in or

Determine the budgeted profit for period, Questikon: For Period Wilson ...

Questikon: For Period Wilson Ltd has produced the following budget figures for Product X: For the period, the budgeted fixed overhead is Rs100,000 and the budgeted sales ar

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