Calculate the internal rate of return

Assignment Help Corporate Finance
Reference no: EM13922784

Stay Young, plc is a cosmetics manufacturer, despite being relatively new, has enjoyed significant success and achieved sales growth rates of over 20% in the last five years.

It has now identified another growth opportunity which involves exporting its products to Asia and South America and this opportunity would double the size of the company both in terms of long term financing raised and in terms of sales.

In order to pursue this opportunity, the company will have to build a new factory for which they have identified a site, and they believe the factory could be up and running in 2 years.

Currently, Stay Young, plc believes the level of risk of its activity is the same as the average level of risk for its industrial sector, resulting in a discount rate of 12.64% but there are currently differing views on the board of Stay Young, plc on how this investment would affect that level of risk.

Financial Information

Stay Young, plc has made the following assessment of the financials associated with this investment opportunity:

• Feasibility study on the site of the new factory has been conducted for £1million, of which half has been paid and the other half will be paid in six months' time;

• Required investment in acquiring the land and building the factory is £4million, which will be spent 75% now and 25% at the end of this year

• Sales are expected to be 750,000units in year one at an average price of £2.5 per unitsplit evenly between the two geographical areas

• Unitsales are expected to grow at 25% per year in Asia and 10% per yearin South America for the first4 years, after which they will stabilise, while prices are expected to remain unchanged in real terms for the whole period of the analysis;

• Variable production costs will follow the following patterns:

o Materials -30% of price in year one, decreasing by five percentage points in each of the following3 years, after which is stabilises;

o Labour

-20% of price in year one, decreasing by 25% in each of the following2 years, after which is stabilises;

o Other costs

-5% of price throughout the planning period

• Administration costs are expected to be 15% of salesin year one. They will remain at the same absolute value until year four,at which time they will increase by 10%, and then will remain unchanged until the end of the planning period

• Increase in working capitalwill bein line with increase in sales for the first three years and no change afterwards.

Initial working capital is £0.5million;

• The factory is expected to last for 20 years, and will be depreciated over that period of time.

It is not the company's intention to make any significant changes to its existing business and it normally uses a 7
-year planning period.

Inflation rate is expected to be 3.5% per year and the company pays Corporate Tax at a rate of 30%.

Required

1. to fill the following tables

Profitability

Year

 

x

x

x

x

x

x

x

Sales

 

 

 

 

 

 

 

 

 

Volume Asia

x

x

x

x

x

x

x

 

Volume Ammerica

x

x

x

x

x

x

x

 

Total Sales

x

x

x

x

x

x

x

Production Costs

 

 

 

 

 

 

 

 

 

Materials

x

x

x

x

x

x

x

 

Labour

x

x

x

x

x

x

x

 

Other

x

x

x

x

x

x

x

 

Admin

x

x

x

x

x

x

x

 

Capital Allowances

x

x

x

x

x

x

x

Pre-Tax Profit (operating profit)

 

x

x

x

x

x

x

x

 

Taxation

x

x

x

x

x

x

x

Net profit

 

x

x

x

x

x

x

x

Cash flow

Year

x

x

x

x

x

x

x

Initial Investment

X

X

X

X

X

X

X

Operating profit

X

X

X

X

X

X

X

Capital allowances

X

X

X

X

X

X

X

Less tax liability from previous year

X

X

X

X

X

X

X

Working Capital

X

X

X

X

X

X

X

Net Cash flow

X

X

X

X

X

X

X

Discount rate

X

X

X

X

X

X

X

Present value

X

X

X

X

X

X

X

 

 

 

 

 

 

 

 

Cumulative cash flow

X

X

X

X

X

X

X

2. Calculate

1. Net Present Value (NPV)
2. Internal Rate of Return (IRR)
3. Payback Period (PbP)
4. Average Rate of Return (ARR)

3. Calculate the Weighted Average Cost of Capital (WACC) for Stay Young.

4. Identify what you believe are the two key factors for the success of this project and prepare two sensitivity analysis assuming a 20% deterioration in each of those factors.

Reference no: EM13922784

Questions Cloud

Identify the pressure point for influencing strategic change : Identify the pressure points for influencing strategic change in an organisation with which you are familiar. How would you describe their strategic management process as prescriptive or emergent?
Does society influence what is presented in films : Choose one film from the list below and read the provided reviews. Compare and contrast the approach each review adopts. To what degree do the reviews agree with one another (if at all) regarding the overall worth of the film?
Bonds pay annual interest january : Lock Corporation issued $1,800,000 face value, 5%, 10- year bonds at $1,667,518. This price resulted in an effective-interest rate of 6% on the bonds. Lock uses the effective-interest method to amortize bond premium or discount. The bonds pay annual ..
Determine total stockholders'' equity : Assuming the shares are held in the treasury, what effect does this transaction have on net income,
Calculate the internal rate of return : Calculate the Weighted Average Cost of Capital (WACC) for Stay Young - Identify what you believe are the two key factors for the success of this project and prepare two sensitivity analysis assuming a 20% deterioration in each of those factors.
Social influences on behavior : We live within a social world; it is not surprising that many theorists and researchers have studied what effects the social environment has on the thoughts, emotions, and behavior of the individual.
Advantages and disadvantages of standard costs : What are some of the advantages and disadvantages of standard costs? How do managers determine what the standard cost should be? Describe the effect of inaccurate standard costs on financial reporting.
Compare and contrast the approach each review adopts : Choose one film from the list below and read the provided reviews. Compare and contrast the approach each review adopts. To what degree do the reviews agree with one another (if at all) regarding the overall worth of the film?
Kennedy manufacturing company : Kennedy Manufacturing Company reported the following year-end information: beginning work in process inventory, $270,000; cost of goods manufactured, $1,074,000; beginning finished goods inventory, $380,000; ending work in process inventory, $330,000..

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

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