prepare a cash budget, Financial Management

Assignment Help:

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.


Related Discussions:- prepare a cash budget

Calculate average annual return, Q. Calculate Average Annual Return? An...

Q. Calculate Average Annual Return? An investor buys a bond in 1978 maturity in 1980 at Rs.900. It has a maturity value of 10 years and par value of Rs. 1000. It fetches RS.90

Agency mortgage-backed securities, Agency Mortgage-Backed Securities ...

Agency Mortgage-Backed Securities (AMBS) are securities that are backed by the mortgage loans. These securities include mortgage passthrough securities, stripped

Major linen purchase on open account, that the business has far fewer linen...

that the business has far fewer linens than it needs, so he makes a major linen purchase on open account. Which of the following terms refers to the fact that partners Ma and Runni

Debenture, Debenture A kind of debt instrument that is not secured by p...

Debenture A kind of debt instrument that is not secured by physical any asset or collateral is known as debenture. Debentures are backed by the general creditworthiness and sta

Lien, A legal claim on exact assets which were used to make loan secure.

A legal claim on exact assets which were used to make loan secure.

Return on common equity finance basics, At the end of the fiscal year endin...

At the end of the fiscal year ending June 30, 2003, Microsoft reported common equity of $64.9 billion on its balance sheet, with $49.0 billion invested in financial assets (in the

Credit control - account receivable management, Q. Credit control - account...

Q. Credit control - account receivable management? Once credit has been established it is important to review outstanding accounts on a regular basis so overdue accounts can be

WACC, The following is the existing capital structure of Company XYZ Ltd. O...

The following is the existing capital structure of Company XYZ Ltd. Ordinary shares at Shs.10 par 1,000,000 Retained 800,000 12% preference shares Shs.10 par 400,000 16% loan Shs.1

Agency policy theorem, How might management try to solve the problems foun...

How might management try to solve the problems found in agency theorem

Pay back method, Ask I have included a simple capital investment problem wh...

Ask I have included a simple capital investment problem which is in Course Documents. We are going to use the same numbers for several classes and look at some of the ways that cap

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