cash budget, Corporate Finance

Assignment Help:
You have been asked to prepare a cash budget for Whitborrow plc for the next three months, October, November and December. The Managers are concerned that they may not have sufficient cash to pay for a £150,000 investment in equipment in December. The overdraft has reached its limit £70,000 at the present time - the end of September. Sales during September were a total of £400,000 of which £55,000 was received in cash. £165,000 is expected to be paid on October, with the remainder likely to flow in during November. Sales for the next three months are as follows:

Total sales Cash sales Credit sales

October 450,000 90,000 360,000

November 550,000 110,000 440,000

December 700,000 140,000 560,000

There is a gross profit margin of 40 percent on sales. All cost (materials, labour and other) are paid for on receipt. Only 20 percent of customer sales are expected to be paid for in the month f delivery. A further 70 percent will be paid after one month and the remainder after two months. Labour and other costs amount to 10 percent of sales. Debtor levels at the end of September are £400,000 and the investment in stock is £350,000

Required:

a. Prepare a cash budget for October, November and December, and state if the firm will be able to purchase the new equipment.

b. Recommend action that could be taken to improve the working capital position of Whitborrow.

Related Discussions:- cash budget

Compare the financial system of the mauritius and usa, Question : (a) ...

Question : (a) Compare the financial system of the Mauritius and USA. Give differences between the two systems. (b) One of the facilities given by the financial system is

Finance, Question 5 A company has a total investment of Rs 500,000 in asset...

Question 5 A company has a total investment of Rs 500,000 in assets, and 50,000 outstanding ordinary shares at Rs 10 per share (par value). It earns a rate of 15 per cent on its in

Analytical derivation of the capital asset pricing model, Question: a) ...

Question: a) Provide an analytical derivation of the Capital Asset Pricing Model (CAPM) and supplement your analysis with diagrammatic illustrations where appropriate. b) T

Commercial insurance example, The East Coast Conglomerate Co (ECCC) a small...

The East Coast Conglomerate Co (ECCC) a small manufacturing company is doing a risk management assessment and a total review of their insurance policies. They have asked you,  know

How garch modelling is related to hedging, Question: σ 2 t = β 0 + ...

Question: σ 2 t = β 0 + β 1 σ 2 t - 1 + λ 1 ε 2 t -1 (a) Interpret parameter 1 and 1 in model (1) and derive the long-term unconditional variance. (b) What

Dividend policy, What are the advantages and disadvantages of the alternati...

What are the advantages and disadvantages of the alternative dividend policies of the three companies? Discuss the circumstances under which each managing director might be correct

Prepare a quarterly cash budget, You are the Executive Director for the bra...

You are the Executive Director for the brand new Burkina Faso field office of a U.S.- based not-for-profit organization called Paper for All that distributes academic resources fo

Forecasting demand, The problem considered is that of forecasting demand fo...

The problem considered is that of forecasting demand for single-period products before the period starts. We study this problem for the case of a mail order apparel company that ne

Mr. Sears, Can you hepl me with financial a accounting assignment?

Can you hepl me with financial a accounting assignment?

Time Value of Money, Assume that the average age of the worker is 25 years ...

Assume that the average age of the worker is 25 years old. Typically, retirement is at 65. The firm provides a $2000 monthly payment for 25 years for retirees (i.e., 300 monthly

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