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

Yield to worst, Now we can calculate the yield for each possible call...

Now we can calculate the yield for each possible call or put date. In addition, we can also calculate the yield to maturity. The lowest yield of all these possibl

Role of the public expenditure management system, Question : (a) The ro...

Question : (a) The role of the Public Expenditure Management System (PEMS) is to allocate and use resources responsively, efficiently and effectively'. Briefly explain the abo

Explain about baumol model, Q. Explain about Baumol Model? Baumol Model...

Q. Explain about Baumol Model? Baumol Model: - Baumol model is a mechanism of cash management which is used to determine optimum cash balance. Optimum cash balance is resolute

Advantages and disadvantages of closed end country funds, Discuss the advan...

Discuss the advantages and disadvantages of closed-end country funds or CECFs relative to the American Depository Receipts or ADRs as a means of international diversification. An

Illustrate report on cash flow budget, Q. Illustrate report on cash flow bu...

Q. Illustrate report on cash flow budget? The cash flows The principal reason why certain statistics were not included in the cash flows is that they are incremental cash

Performance budget, Performance budget: it involves evaluation of the perf...

Performance budget: it involves evaluation of the performance of the organization in the context of both overall and specific objectives of the organization. As per the National I

Forward contracts, Forward Contracts: The origin of forward contracts i...

Forward Contracts: The origin of forward contracts is lost in history. Some authors suggest that, it was India where these contracts took birth, while some others suggest that

APR and EAR, Assume a bank charges a 15.5% APR (annual percentage rate) on ...

Assume a bank charges a 15.5% APR (annual percentage rate) on credit card holder compounds quarterly. What EAR (effective annual rate) is the bank is charging? What if they change

Are there any ways to analyze and value seasonal businesses, Are there any ...

Are there any ways to analyze and value seasonal businesses? Seasonal businesses can be valued by discounting flows using annual data, but this needs some adjustments. The righ

Credit risk, A bond investor is always exposed to credit risk. Credit...

A bond investor is always exposed to credit risk. Credit risks can be classified into three types. They are: Default Risk Credit Spread Risk

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