prepare a cash budget, Financial Management

You are presented with the budgeted data shown below for the period November 20X1 to June 20X2 by your firm. It has been extracted from the other functional budgets that have been prepared.

You are also told the following.

a.   Sales are 40% cash, 60% credit. Credit sales are paid two months after the month of sale.

b.   Purchases are paid the month following purchases.

c.   75% of wages are paid in the current month and 25% the following month.

d.  Overheads are paid the month after they are incurred.

e.  Dividends are paid three months after they are declared.

f.   Capital expenditure is paid two months after it is incurred.

g.  The opening cash balance is RO 15,000.

The managing director is pleased with the above figures as they show sales will have increased by more than 100% in the period under review. In order to achieve this he has arranged a bank overdraft with a ceiling of RO 50,000 to accommodate the increased stock levels and wage bill for overtime worked.

 

Nov X1

Dec X1

Jan X2

Feb X2

Mar X2

Apr X2

May X2

Jun X2

 

RO

RO

RO

RO

RO

RO

RO

RO

Sales

80,000

100,000

110,000

130,000

140,000

150,000

160,000

180,000

Purchases

40,000

60,000

80,000

90,000

110,000

130,000

140,000

150,000

Wages

10,000

12,000

16,000

20,000

24,000

28,000

32,000

36,000

Overheads

10,000

10,000

15,000

15,000

15,000

20,000

20,000

20,000

Dividends

 

20,000

 

 

 

 

 

40,000

Capital expenditures

 

 

30,000

 

 

40,000

 

 

a)  Prepare a cash budget for the 6 month period January to June 20X2.

b)  Comment upon your results in the light of your managing director's comments and offer advice.

Posted Date: 2/19/2013 7:25:54 AM | Location : United States







Related Discussions:- prepare a cash budget, Assignment Help, Ask Question on prepare a cash budget, Get Answer, Expert's Help, prepare a cash budget Discussions

Write discussion on prepare a cash budget
Your posts are moderated
Related Questions
Treatment of PER IFRS 3 Business combinations necessitate goodwill on gaining to be calculated at the date control is gained. The second gaining gives ROB a 75% holding and

Give two examples of types of companies likely to have high operating leverage.Find examples other than those cited in the chapter. Long distance electricity generating compani

What are the benefits of the JIT inventory control system? The just-in-time (JIT) inventory control system lesser inventory carrying costs and tends to increase quality.

LENDING RATES IN THE CREDIT MARKET One of the crucial decisions involved while extending loans is the lending rate. Intermediaries will base their lending rate decisions on thr

Financial Management and Materials Department The materials management is of utmost importance in a manufacturing firm and covers the areas such as procurement, storage, mainte

The United States has experienced continuous current account deficits as the early 1980s. What do you think are the major causes for the deficits? What would be the results of cont

Company X is expected to maintain a constant 7% growth rate in their dividends, indefinitely. If company X has a dividend yield of 4%, what is the required return on their shares?

Q. Determinants of Working Capital? Determinants of Working Capital: - The working capital necessity is determined by a large number of factors but generally the following fa

Expalin the basic concept of financial management and Cost of Retained Earnings and External Equity??? Also explain the hoe can ew calculate the external equity? Help me

Assume that we have the following data: C=100+0.50Y Ip=100-20r Mt=0.10Y Ms=100-10r M=80 a. Build the IS-LM function. b. If we assume an increase in Investments by 100 units, p