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

Find weighted average cost of capital - dividends, Duke Power Corporation h...

Duke Power Corporation has $500 million (face value) of zero-coupon bonds, which will provide 6% return to the bondholders and will mature after 10 years. The stockholders of the c

Merger, The Chocolate ice cream company and the vanilla ice cream company h...

The Chocolate ice cream company and the vanilla ice cream company have agreed to merge and form Fudge Swirl Consolidated.Both companies are exactly alike that are located in differ

Cost of capital, How does cost of capital vary with debt-to-value ratio?

How does cost of capital vary with debt-to-value ratio?

Prepare a memo and journal, 1. You are working as an accountant for ABC Gro...

1. You are working as an accountant for ABC Group Ltd. Your directors have asked you to prepare the necessary consolidation journal entries for the year ended 30 June 2009 (Narrati

What do you understand by the term hedging effectiveness, Question: (a)...

Question: (a) You have just been recruited as risk analyst at the Air Mauritius Limited. Your risk manager is trapped between diverging expectations. He is not sure whether oil

Review of Revenue, Review of Revenue This activity will require you to acc...

Review of Revenue This activity will require you to access at least a portion of the federal budget as well as a state, local and an agency budget. This can be done online. Howeve

Calculate the firm''s corporate cost, Morningside nursing Home, a not-for-p...

Morningside nursing Home, a not-for-profit corporation, is estimating its corporate cost of capital.  Its tax-exempt debt currently requires an interest rate of 6.2 perce

Taxable Income, The tax rates are as shown. Your firm currently has taxable...

The tax rates are as shown. Your firm currently has taxable income of $79,000. How much additional tax will you owe if you increase your taxable income by $30,000? Taxable Income

Calculate the stock rate of distribution, A owns all of the stock of X.  Th...

A owns all of the stock of X.  The stock's basis is $100.  X has a total of current and accumulated earnings and profits of $50.  X distributes $200 cash to A "with respect to his

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