Preparation of budgets and working capital management

Assignment Help Financial Management
Reference no: EM13840324 , Length:

Question 1

Investment appraisal

The following information relates to three possible capital expenditure projects that are being considered by Wilson plc. Due to capital rationing, only one of the three projects can be pursued.

 

Project A

Project B

Project C

 

£

£

£

Initial cost

175,000

195,000

190,000

Expected life

5 years

5 years

5 years

Scrap value expected

5,000

8,000

4,000

Expected cash inflows:

 

 

 

End of year 1

75,000

95,000

50,000

2

65,000

65,000

60,000

3

60,000

45,000

65,000

4

55,000

45,000

66,000

5

50,000

45,000

57,000

Additional information:

i. Wilson plc estimates its cost of capital to be 18%.
ii. £34,000 depreciation is charged to Project A each year.
iii. £37,400 depreciation is charged to project B each year.
iv. £37,200 depreciation is charged to Project C each year.

Required

(a) Calculate for each project:

i) The payback period

ii) The net present value

iii) The accounting rate of return using average investment

(b) Explain which of the three investments should be accepted based on the results of each of the three capital expenditure appraisal techniques.

(c) Identify and evaluate the non-discounting techniques used in part (a).

Question 2

Financial Statement Analysis

Below is a link to Carr's Milling Industries Plc's annual report for the year ending 2014.

https://investors.carrsgroup.com/archive/Annual_Report_2014.pdf

With reference to appropriate ratios and contextual analysis, including comparative performance with one other UK retailer, please assess the company's performance in a formal report, intended for existing stockholders in the company.

You should select and calculate three financial ratios for use in each of the following aspects of financial performance and position:

- Profitability
- Liquidity
- Efficiency
- Capital structure
- The investors' specific perspective

Question 3

Earnings per share

At 1 July 2013, Radcliffe plc had 1 million £1 ordinary shares in issue. On 1 March 2014, Radcliffe plc made a 1 for 4 rights issue for £3.70 per share. The market price of one Radcliffe plc ordinary share at that date, immediately before the rights issue, was £4.30. Profit attributable to ordinary equity holders for the year ended 30 June 2014 was £1,333,000.

a) Calculate Radcliffe plc's consolidated basic earnings per share for the year ended 30 June 2014.

On 1 July 2013 Baker plc issued 1 million 5% convertible redeemable preference shares at par (nominal value £1 each). The preference shares are redeemable at par for cash on 30 June 2017, or are convertible into 200,000 new £1 ordinary shares at that date. The preference dividend is paid on 30 June each year. Profit after tax is £406,617. Interest charge for year ended 30 June 2014 for the redeemable convertible preference shares is £65,258. The number of £1 ordinary shares in issue at 30 June 2013 is 4 million.

b) Calculate the basic EPS and the diluted EPS and explain its relevance to the ordinary shareholders.

c) Critically evaluate the use of earnings per share as a guide to investor decision making.

Question 4

Preparation of budgets and working capital management

Dilber Ltd is a small retail business that operates in the United Kingdom. The company was formed in December 2014 and commenced its new year on 1 January 2015 with £25,000 in share capital. Dilber Ltd also has £14,000 in the bank and £15,000 of finished goods stock for resale. This information had already been recorded in the accounting records of Dilber Ltd. Dilber Ltd had debentures of £4,000 as at 1 January 2015.

The company has agreed a bank overdraft facility of up to £15,000.

The following transactions had been budgeted for the first 6 months of 2015.

Sales of goods to debtors in the 6 months to June 2015 were expected to be £160,000 in total, and transacted as follows:


Jan   Feb   Mar   Apr   May   Jun 

£   £   £   £   £   £  
Sales  20,000 18,000 20,000 25,000 32,000 45,000

Gross profit margins are always 35% of sales and it was Dilber Ltd's policy to have sufficient finished goods stock at the end of each month to service the following month's cost of sales. The sales forecast for July 2015 was £55,000.

Purchases of goods for resale in the six months to June 2015, based on the above information, were £114,750 and were budgeted to be as follows:


Jan   Feb   Mar   Apr   May   Jun 

£   £   £   £   £   £  
Purchases     9,700 13,000 16,250 20,800 29,250 25,750

Other transactions:

- Plant and equipment was to be purchased for cash, £10,000, in January 2015, and £20,000 in June 2015.

- The plant and equipment depreciation for the 6 month period is included in the other operating costs, below;

- Director's salary £2,000 per month was to be paid in cash January to June 2015;

- Sales assistant's wages £1,000 per month was to be paid in cash January to June 2015;

- Other operating costs, £2,200 per month, include depreciation on plant and equipment, £100 per month. The cash operating expenses were to be paid in cash, each month, January to June 2015;

- Corporation tax of £652 was to be paid in June 2015;

- Bank finance charges of £15 were to be incurred in February 2015;

- Debtors were budgeted to pay in full one month after the month of the sale. In this respect sales made in January 2015, for example, would be paid for in February 2015

- Creditors were to be paid in full, two months after the purchase of stock. In this respect purchases of stock made in January 2015 would be paid for in March 2015.

- A dividend of £1,400 was to be paid during June 2015.

Required:

(a) For the 6 months period to June 2015, produce the following for Dilber Ltd

(i) A monthly cash budget;

(ii) A budgeted income statement for the year ended 30 June 2015; and

(iii) A budgeted statement of financial position as at 30 June 2015

The cash flow forecast must indicate the cash in hand or overdrawn at the end of each month.

(b) Dilber Ltd is concerned about its management of working capital. Prepare a short set of briefing notes entitled ‘How to improve the working capital position of Dilber Ltd outlining three strategies for improving the working capital position.

Question 5

Working Capital Management and Variance Analysis

Cost volume profit (CVP) analysis can be useful in helping to support a number of important decisions.

However, the CVP technique can only be a very simplistic analysis of short-term cost behaviour and suffers from a number of limitations.

Required

Evaluate the CVP technique and explain the limitations of its use in the context of both the different interpretations of the CVP technique offered by the economist's model of CVP and other limitations.

Verified Expert

Reference no: EM13840324

Questions Cloud

What should ron johnson do : What should ron Johnson do? Should he abandon the "fair and square" policy and revert to high-lo pricing? Why ang why not? High lo pricing and why not? How do consumers from price perceptions? How does sales promotion influence this price perception?..
Explain any ethical consideration that you took into account : Explain any ethical considerations that you took into account and why they were taken into account. Explain any insights or conclusions you had as a result of writing the report
Edgar received a text message from groupon : Edgar received a text message from Groupon this morning, letting him know about an opportunity to take a series of 5 horseback riding lessons at a nearby stable for $199, a value of $400. Edgar has always wanted to try horseback riding, so he bought ..
Dissertation about current oil price crisis : Dissertation about current OIL Price Crisis. Strategic business, Financial decisions, Past (why), present and future of the oil&Gas industry. Big enterprise, who win who loss.
Preparation of budgets and working capital management : Evaluate the CVP technique and explain the limitations of its use in the context of both the different interpretations of the CVP technique offered by the economist's model of CVP and other limitations.
Find equilibrium wage differential between safe and risk job : Suppose, Worker 1 has a reservation price of 41 cents; worker 2s reservation price is 42 cents; worker 3s reservation price is 43 cents, and so on. There are 150 jobs in firms without air purification systems, and this number is fixed. Thus, the dema..
Firms short-run average total cost function : If a firm’s short-run average total cost function and its short run variable cost function satisfy: SAC(200, w, r, K) = 16, SAVC(200, w, r, K) = 12, SAVC(400, w, r, K) = 16, at a specific wage w, a specific rental rate r, and specific fixed capital l..
Consider the current situation and prevailing political : Consider the current situation and prevailing political and economic conditions in Brazil, a BRIC country. As a manager who has been considering investment in Rio de Janeiro, how do you assess the political and economic risks at this time?
More effective comparing with the tools of fiscal policy : Which one is more effective comparing with the tools of fiscal policy?

Reviews

Write a Review

Financial Management Questions & Answers

  Receive from his investment cash flows

Chuck Brown will receive from his investment cash flows of $3,145, $3,500, and $3,810 at the end of years 1, 2 and 3 respectively. If he can earn 7.5 percent on any investment that he makes, what is the future value of his investment cash flows at th..

  What is the price of the coupon bond and its YTM

Prices of zero-coupon bonds reveal the following pattern of forward rates: 0f1 = y1 = 5%, 1f1 = 7%, 2f1 = 8%. In addition to the zero coupon bonds, investors also may purchase a 3-year bond making annual coupon payments of $60 with par value of $1,00..

  What is the subscription price

Keira Mfg. is considering a rights offer. The company has determined that the ex-rights price would be $66. The current price is $80 per share, and there are 42 million shares outstanding. The rights offer would raise a total of $70 million. What is ..

  The yield to maturity of the bond

A bond has a coupon of 6%. It has a face value of $100. It pays interest semi-annually. The bond was issued on March 18th, 2013. The settlement date is March 21st, 2013. The maturity date is 3/23/2023. The first interest payment is June 18th, 2013. T..

  What are the floatation costs for issuing preferred share

(Cost of preferred stock) The preferred stock of Gator Industries sells for $35.08 and pays $2.71 per year in dividends. What is the cost of preferred stock financing? If Gator were to issue 525,000 more preferred shares just like the ones it current..

  What is the amount of the firms net working capital

Scare Train, Inc. has the following balance sheet statement items; current liabilities of $875,962; net fixed and other assets of $1,921,620; total assets of $3,463,330; and long-term debt of $602,676. What is the amount of the firm’s net working cap..

  Financing activity on the cash flows

Which of the following would be classified as a financing activity on the statement of cash flows?

  Transfers cash-net taxable income

Adam transfers cash of $300,000 and land worth $200,000 to Camel Corporation for 100% of the stock in Camel. In the first year of operation, Camel has net taxable income of $70,000. If Camel distributes $50,000 to Adam,

  Required investment-considering an expansion

Truman Industries is considering an expansion. The necessary equipment would be purchased for $10 million, and the expansion would require an additional $1 million investment in net operating working capital. The tax rate is 40%.

  What is the companys cost of preferred stock

Hetten house Company’s (HC) perpetual preferred stock sells for $105.50 per share, and it pays a $9.50 annual dividend. If the company were to sell a new preferred issue, it would incur a flotation cost of 5.50% of the price paid by investors.

  What is the current bond price

Ninja Co. issued 10-year bonds a year ago at a coupon rate of 8.8 percent. The bonds make semi-annual payments. If the YTM on these bonds is 7.1 percent, what is the current bond price? Also how would I enter this in a finical?

  Several proposed independent projects

Bell Weather Goods has several proposed independent projects that have positive NPVs. However, the firm cannot initiate any of the projects due to a lack of financing. This situation is referred to as:

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