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

A firm announces intent undertake levered recapitalization, A firm announce...

A firm announces its intent to undertake a levered recapitalization, issuing debt to repurchase a fraction of the outstanding common stock. Upon the announcement, its stock price

Determine the current value of the bond, QUESTION Assume Venture Health...

QUESTION Assume Venture Healthcare sold bonds that a 10 year maturity, a 12% coupon rate with annual payments, and a $1,000 par value. a. Suppose that two years after the bo

Replacement decisions , Your boss is trying to figure out when to replace a...

Your boss is trying to figure out when to replace an important piece of machinery in your main production facility.  The Siemens NR550, costs $5.45 million brand new and generally

What is the minimum accrual rate, Question: Car Maker Ltd is a multinat...

Question: Car Maker Ltd is a multinational. In one of the countries where it is present, current legislation makes it compulsory for companies to pay a gratuity lump sum at ret

Payback rule, one director asks only for the cash flow figures upto and inc...

one director asks only for the cash flow figures upto and including year 2 and applies a 2-year payback rule

Finance, Question 5 A company has a total investment of Rs 500,000 in asset...

Question 5 A company has a total investment of Rs 500,000 in assets, and 50,000 outstanding ordinary shares at Rs 10 per share (par value). It earns a rate of 15 per cent on its in

Determine current stock price, Determine current stock price: 1) IBM ...

Determine current stock price: 1) IBM issued 10-year bonds with a par value of $1,000 and a coupon rate of 10%, paid semiannually. The yield to maturity on this bond is 12%.

Equity financing with debt financing, Seattle Health Plans currently uses z...

Seattle Health Plans currently uses zero debt financing.  Its operating income (EBIT) $1 million, and it pays taxes at a 40 percent rate.  It has $5 million in assests and because

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