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

Renowned Cola, corporate finance, Financial Accounting Calculate the market...

corporate finance, Financial Accounting Calculate the market value of Renowned Cola''''s debt at year-end 2005. What is the book value of debt? Why do usually use market or book va

The pure-play approach, Hydra Multinational is a vast conglomerate firm inv...

Hydra Multinational is a vast conglomerate firm involved in a wide array of business ventures ranging from satellite radio to cat food.  One of its many divisions, a restaurant cha

Illustration of a recent financial crisis, Question: "The history of ba...

Question: "The history of banking is so deeply littered with disasters that it could not be too hard to establish the causes... Fear, greed, loss of corporate memory, weak mana

Determine the net present value-discount cash flows, Suppose GeKay Inc. has...

Suppose GeKay Inc. has a two-year lease over a small copper deposit; the government acquires all rights to the property at the end of the lease.  It is known that the deposit conta

Evaluate the total working capital, Question: a) NLTF= Mur150m; WCN= ...

Question: a) NLTF= Mur150m; WCN= 146m; Liquidity= 14m b) Balance Sheet has been solidified by loan from the Holding Company. Had the loan not been prov

Determine monthly saving, Determine monthly saving: Based on the follo...

Determine monthly saving: Based on the following information, answer the questions. You consider a retirement plan. The retirement plan will give you $1,000 every month for 1

Divident, Critically appraise how companies set their dividend policies, an...

Critically appraise how companies set their dividend policies, and explain the factors that a company will consider in setting its dividend policy and in determining the level of d

IFRS15, Ask q• Effect of incorrect recognition of revenue on financial repo...

Ask q• Effect of incorrect recognition of revenue on financial reports of IFRS15

EBIT, Firm A has $10,000 in assets entirely financed with equity. Firm B al...

Firm A has $10,000 in assets entirely financed with equity. Firm B also has $10,000 in assets, but these assets are financed by $5,000 in debt (with a 10 percent rate of interest)

Top flop division - forecasting methods, Top-flop division is based on the ...

Top-flop division is based on the idea that the demand percentages of the 'top' and the 'flop' SKUs in a group of SKUs are fairly stable over time. For example, the 33% best-sellin

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