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

Bond valuation, An investor buys a French government, 10-year bond, paying ...

An investor buys a French government, 10-year bond, paying annual coupon of 4.5%. Face value = 1000. The investor is unsure of his investment horizon and considers 5 horizons: 5, 6

What is the cost of the option contract, Question: In view of its inter...

Question: In view of its international operations management, Remo Ltd which is based in USA expects to make a payment of £ 50,000 to a UK supplier for raw materials in six mon

Explain capital asset pricing model, Question 1: Compare and contrast t...

Question 1: Compare and contrast the Capital Asset Pricing Model with that of the Arbitrage Pricing Theory. Question 2: (a) Explain the concept of stock market efficien

Application of priori forecasting, The case company is a mail order/Interne...

The case company is a mail order/Internet apparel retailer operating only in the Netherlands. It divides each year into two selling seasons, spring-summer (December-June) and autum

Estimate the market price, An original United States silver dollar from the...

An original United States silver dollar from the late 1800s consists of about 24 grains of silver.  Suppose that at current prices, the silver content of this coin is worth $2.25.

Capital structure, a)  Use excel of a financial calculator to estimate the ...

a)  Use excel of a financial calculator to estimate the IRR of the following business opportunity:  Initial cost of $100,000, expected pre-tax annual cash flows of $54,000 for the

Answer required ., What will be impact on the operating leverage of a firm,...

What will be impact on the operating leverage of a firm, if it proceeds for additional borrowings?

Consultancy Firm, You work for a major consultancy firms in corporate finan...

You work for a major consultancy firms in corporate finance. Your firm has been approached by one of its major clients to assist them in solving a problem that they have. You have

Efficiency, differentiate between pricing efficiency and allocative efficie...

differentiate between pricing efficiency and allocative efficiency

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