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

Discuss the different forms of financing, Question 1 Explain the concept ...

Question 1 Explain the concept and phases of capital budgeting Question 2 Define and explain the methods of demand forecasting Question 3 Mention the elements o

Determine the operating profit of the firm, 1. The Gulf had sales of  AED 2...

1. The Gulf had sales of  AED 20,000,000 and cost of goods sold of  AED 10,250,000. Selling and administrative expenses represented 8 percent of sales. Depreciation was 5 percent o

Investigate the functions for horizontal asymptotes, Q. Investigate the fol...

Q. Investigate the following functions for both horizontal and vertical asymptotes, x and y-intercepts, and state the domain and range of each and where the function is increasing

State the term- pass through certificates, State the term- Pass Through Cer...

State the term- Pass Through Certificates (PTCs) Pass through Certificates (PTCs) are debt securities which pass through income from debtors through intermediaries to investors

Operating cycle, make an cash conversion cycle of cabbages

make an cash conversion cycle of cabbages

Financial Planning, report on Financial Planning and Forecasting

report on Financial Planning and Forecasting

How to select the pattern of the investment, Q. How to Select the pattern o...

Q. How to Select the pattern of the investment? When the funds have been procured than a decision about the investment pattern is to be taken. The selection of the investment p

Accounting rate of return (arr), Accounting Rate of Return (ARR): This ...

Accounting Rate of Return (ARR): This technique relies on the rate of return every project will earn over its life. It takes the help of accounting profit while calculating the

Multiperiod compounding, where you deposit 1000dollars at the end of each y...

where you deposit 1000dollars at the end of each year for 4 years, what will be the amount of deposits at the end of each year if it is compounded at 12% semi-annually?

Historical weights, Can some one tell me the defination of Historical weigh...

Can some one tell me the defination of Historical weights and how we calculate the historical weight?? And given the diffrence between Historical weight Vs Marginal weights??

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