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

Discounted free cash flow (dfcf) valuation, Benefits FCF is widely used...

Benefits FCF is widely used valuation to estimate enterprise value. It measures the value of free cash flow which organisations generate from daily operating activities. DFCF m

Homework Help, Look back to Section 13–1 (Table 13.2 on p. 329). Suppose th...

Look back to Section 13–1 (Table 13.2 on p. 329). Suppose that Ms. Macbeth’s investment bankers have informed her that since the new issue of debt is risky, debt holders will deman

Net book value, Flower stands whose beneficial life spans a period of eight...

Flower stands whose beneficial life spans a period of eight years was purchased on 1 August  2011 for $12,000.   It can be sold as scrap for $2,000.  The business has a financial y

How does an operating lease compare with a financial lease, Problem: (a...

Problem: (a) Distinguish between Non-Deposit Taking and Deposit-Taking Institutions. Provide two differences between the two types of institutions. (b) Who regulates Depos

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

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 >>?

Evaluate the projects, Consider the subsequent information about four diffe...

Consider the subsequent information about four different projects. Each requires an initial outlay of Rs2,000,000 but the firm only has funds to undertake one project. The firm ha

Cost of Capital, Calculating Cost of Equity. Bohannon Corporation''s common...

Calculating Cost of Equity. Bohannon Corporation''s common stock has a beta of 1.10. If the risk-free rate is 4.5% and the expected return on the market is 12%, what is the company

Illustrate the essential requisites of a promissory note, A promissory note...

A promissory note is an instrument in writing (not being a blank or a currency note) containing an unconditional undertaking, signed by the maker, to pay a certain sum of money onl

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