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

Examine the communication strategies that ncc may adopt, Question: The ...

Question: The National Coach Company (NCC), where you work as Marketing Manager, has agreed on a market development strategy. A key objective is to encourage 40% of car drivers

CURRENT PRICE SHARE, Assume the market returns to be 9% and the risk-free r...

Assume the market returns to be 9% and the risk-free rate to be 1.25%. Assume also that shell has just paid an annual dividend of $1.41 and that dividends will grow at 5% for the f

Balance scorecard, hey i need help creating a balance scorecard how long wi...

hey i need help creating a balance scorecard how long will that take >>?

Explain ethical decision-making, Problem 1: (a) Will a corporation be m...

Problem 1: (a) Will a corporation be morally responsible for its actions? (b) Why do corporations engage in social responsibilities, and what are the potential drawbacks?

Accumulated dividend, It is a dividend on a share of cumulative preferred s...

It is a dividend on a share of cumulative preferred stock that has not still being paid to the shareholder. Accumulated dividends are the product of dividends that are carried forw

Solve it please, Question 1 If the economy booms, RTF, Inc. stock is expec...

Question 1 If the economy booms, RTF, Inc. stock is expected to return 10%. If the economy goes into a recessionary period, then RTF is expected to only return 4%. The probability

Experts averag - forecasting methods, This method simply calculates the ave...

This method simply calculates the average of a number of expert estimates. Let E denote the number of experts, and mn,e denote the forecast of expert e, e =1, ... ,E, for SKU n 2N.

Level of debt in its capital structure, Weaving Ltd is a medium-sized Mauri...

Weaving Ltd is a medium-sized Mauritian knitwear company. It assembles jumpers and other forms of knitwear clothing. Despite an adverse economic background, Weaving Ltd has been do

Financial analysis paper, This assignment is the third part of your course ...

This assignment is the third part of your course project. Using the two companies that are from the same industry, complete the following: Required: 1.Find their latest annual r

Explain the traditional view of credit risk, The traditional view of credit...

The traditional view of credit risk relates to borrowers, firms, individuals, or financial institutions. Nevertheless, more and more specialized finance transactions deal with str

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