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

Project Help, 1. Use the bond price, yield-to-maturity, and quantity availa...

1. Use the bond price, yield-to-maturity, and quantity available you collected for each bond in Component 2 for this project to estimate an average current bond price and an averag

Valuation as determined by a multiple of EBITDA, is cash considered to be a...

is cash considered to be additive to this method of valuation?

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

Capital structure, what is the separation theorem? what are majour implicat...

what is the separation theorem? what are majour implications for financial decision making

Assinment, Profit for the year R3 million R4 million Gross dividends...

Profit for the year R3 million R4 million Gross dividends R1.5 million R2 million Market value per ordinary share R4 R1.60 Number of ordinary shares 5

How could phoenix activity be addressed, Q. How could phoenix activity be a...

Q. How could phoenix activity be addressed? A range of actions have been suggested to mitigate phoenix activity. These suggested actions were selected on the basis of: - pr

#titlefiscal policy.., Ask question #Minimum 100 words aapplicability of al...

Ask question #Minimum 100 words aapplicability of allocation function of fiscal policy#

Do mergers encourage the formation of new banks, Do mergers encourage the f...

Do mergers encourage the formation of new banks? A: Yes. The rise in the number of new banks in the second half of the 1990s coincides with a surge in merger activity in the

What are the consequences of a budget deficit, Question 1: (i) How do ...

Question 1: (i) How do economists go about studying the economics of the public sector? Describe the four stages of analysis (ii) The level of government intervention dif

Determinants of growth of a company in financial terms, Determinants of gro...

Determinants of growth - Profit Margin Dividend Policy   Financial Policy Total asset Turnover

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