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

Building blocks of a pass-through security, The main aim of securitiz...

The main aim of securitization that was initiated in the late sixties was to resolve problems of mismatch and protect the US mortgage financing system from macroe

What is the importance of investigation of incidents, Q. What is the import...

Q. What is the importance of investigation of incidents? 1. Incident investigation is the process of identifying the underlying causes of incidents and implementing steps to pr

Risk and return of portfolio, Portfolios are simply combinations of differe...

Portfolios are simply combinations of different securities. The characteristics of investments do differ when we possess them in combinations or portfolios. As we shall see, an ass

What is accumulated depreciation?, What is accumulated depreciation? De...

What is accumulated depreciation? Depreciation is the provision of an asset's initial cost over time.  Accumulated depreciation is the sum of all the depreciation expense that

Wcr expense ratios, Scenario:  ABC Company sells widgets in three varietie...

Scenario:  ABC Company sells widgets in three varieties (blue, red, and yellow) but has lost money for the past three years.  Competitive intelligence shows the Company's products

Determine the value of most common cash flow pattern stock, Name two patter...

Name two patterns of cash flows for a share of common stock. How does the market determine the value of the most common cash flow pattern for common stock? Cash flows for a sha

Describe the direct costs and variable costs, Question : (a) A project ...

Question : (a) A project must have a useful purpose. Therefore, as a project is evaluated, the team should determine the requirements of the local community and industry. These

What do you mean by treasury bills, Q. What do you mean by Treasury Bills? ...

Q. What do you mean by Treasury Bills? Treasury bills (TBs) are short-term government securities. The usual practice in India is to sell treasury bills at a discount and redeem

Eoq inventory model primary variable, What are the primary variables being ...

What are the primary variables being balanced in the EOQ inventory model?  Explain The primary variables mortal balanced in the EOQ model are ordering costs and carrying costs.

Explain implement budget-financial delegations, 1: How will you inform your...

1: How will you inform your managers and supervisors about budgets, reporting requirements and financial delegations? 2: What mechanism you will implement to ensure that there a

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