cash budget, You have been asked to prepare a cash budget for Whitborrow plc for the next, Corporate Finance

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.

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

cash budget, Corporate Finance

Related Discussions:- cash budget

Capital budgeting and financial modelling, Need assignment help. Finance, n...

Why the discount rate equals opportunity cost of capital, Question: (a)...

Weighted avarage cost of capital, how to calculate cost of equity

Abu dhabi investment authority - adia, ADIA is a government-owned investmen...

Calculate the true share price, GeKay stock is worth $100, or $80, or $60. ...

Impact of cost structure, You are required to provide a report of approx 50...

Bonds, you buy a car for ths 10000000 to be repaid in 3 years, with annua i...

Determining the contributing property, 1. A contributes property to X, a ne...

Calculate each partys net borrowing cost, Question: A U.S company has a...

Estimate net cash flow, Allied Managed Care Company is evaluating two diffe...

Write Your Message!

Featured Services

Online Tutoring

Project Development

Exam Preparation

Course Help

Assignment Help

Popular Subjects

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT