User Account

All Pages

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

When does a macss application event occur, Problem: (a) The Mauritius ...

Problem: (a) The Mauritius Automated Clearing and Settlement System (MACSS) is the Mauritian Real-time Gross Settlement (RTGS) system. (i) Outline briefly the concept of R

RISK, Calculate arithmetic returns and risk-premium of stocks. Describe the...

Calculate arithmetic returns and risk-premium of stocks. Describe the stock market behavior. Calculate expected return, variance and standard deviation for individual stocks and po

Short term finance, mystore retail has about $200 000 in credit sales each ...

mystore retail has about $200 000 in credit sales each month.mystore factors all these invoices at a 5% fee.what is the effective annual (%) cost of this action?

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

Explain capital asset pricing model, Question 1: Compare and contrast t...

Question 1: Compare and contrast the Capital Asset Pricing Model with that of the Arbitrage Pricing Theory. Question 2: (a) Explain the concept of stock market efficien

What risks do the finance house and bank face, Question : a) What are ...

Question : a) What are the rationales for interest and currency swaps? b) A finance house and a bank each have a $1billion balance sheet. The finance house has lent out at

Cost of equity, Data:  RF = 4%      Market Risk Premium = 6% GeKay Inc. ...

Data:  RF = 4%      Market Risk Premium = 6% GeKay Inc. is an all-equity firmwith an equity beta of 0.4 and yearly EBIT of $1,000,000 that is expected to continue "forever" (in

Dividend policy, the managing directors of three profitable listed companie...

the managing directors of three profitable listed companies discussed their company''s dividend policies. company A has deliberately paid no dividends for the past five years. comp

Equal division - forecasting methods, Equal division divides M equally over...

Equal division divides M equally over the SKUs in N. Thus, There are two main reasons for including this simplistic approach. First, the approach is used by the case compan

Differentiate fully speculation and arbitraging, Question: (a) With th...

Question: (a) With the help of illustrative and numerical examples differentiate fully speculation and arbitraging in the context of foreign exchange. (b) Shirley, a trade

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd