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

Priori forecasting, Chang and Fyffe (1971) assume that a ?rm has a ''long-r...

Chang and Fyffe (1971) assume that a ?rm has a ''long-run sales history of individual seasonal-style-goods SKUs or groups of such SKUs''. They propose to estimate demand by using r

Annuities, You are considering the purchase of a deferred annuity that will...

You are considering the purchase of a deferred annuity that will pay $10,000 a year at the end of each year for 20 years, to you or a desgnated survivor. (sure thing) Payments wil

Book value of equity, Book Value of Equity: This is the measure used by ow...

Book Value of Equity: This is the measure used by owners of common shares in a firm to determine the level of safety associated with each individual share after all debts are paid

Capital Expenditure Decisions and Investment Criteria, Question 1: Capital ...

Question 1: Capital Expenditure Decisions and Investment Criteria (30 MARKS) In recent years Morten Ltd, a company that manufactures and markets a range of p

MBA, how the knowledge of corporate finance helps thea multinational compan...

how the knowledge of corporate finance helps thea multinational company to take decision about mergers and acquisition

Explain how the crank-nicolson scheme, Solution of the Black-Scholes model ...

Solution of the Black-Scholes model is obtained through a transformation into a heat equation. The general one-dimensional heat equation is given by where α > 0 is a consta

Evaluate accounting method, Question 1: Collect a current annual report (2...

Question 1: Collect a current annual report (2009) of an Australia listed company. Select the firm that reported the following assets. Select BOTHtypes of assets. Proper

Describe the term value management, Problem: (a) Describe the term "Va...

Problem: (a) Describe the term "Value Management" and what are the related benefits in applying such principles in a project?  In your opinion, how will Value Management

Corporate identity in marketing, a) Describe what you understand by corpora...

a) Describe what you understand by corporate identity in marketing. b) Show how corporate identity is normally visibly manifested. c) Management has delegated you the role o

Calculate the rate of return, Question: A. Explain in details two secur...

Question: A. Explain in details two securities quoted at par and two securities quoted on a discount. B. Calculate the return on a deposit of £ 1,000,000 bearing an annual

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