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

  Compliance with the existing required reserves ratio

What amount ofvault cash would be needed for the bank to be in compliancewith the required reserves ratio and determine therequired reserves ratio that would be needed for the bank toavoid a reserves deficit.

  What will be the loan effective annual interest rate

How much money does Kristi need to have in her retirement saving account today if she wishes to withdraw $25,000 per year for 30 years? She expects to earn an average rate of 8%.

  Suppose you are an analyst asked to prepare a valuation of

suppose you are an analyst asked to prepare a valuation of yeats valves and controls yvc for kate porter. she has asked

  Prepare the entry to record issuance of the bonds

Prepare the entry to record issuance of the bonds at par under U.S. GAAP and repeat the requirement for part (a), assuming application of iGAAP to the bond issuance.

  Find which motorcycle should be produce

Harley Davidson trade motorcycle X and motorcycle Y. Motorcycle X sells for 10,000 dollar, has variable cost including labor and material of 2,000 dollar, and needs ten hours of use of machinery to produce.

  International finance multiple choice questions1nbspnbsp

international finance multiple choice questions1.nbspnbsp companies typically want to participate in foreign direct

  Explain why the present value of a stream of cash flow

Explain why the present value of a stream of cash flow and assets associated therewith, fluctuate in value with the level of interest rates in the bond markets and List and explain the points of financial impact on a company if it increases the re..

  The target capital structure for qm industries is 35 common

the target capital structure for qm industries is 35 common stock 13 preferred stock and 52 debt. if the cost of common

  Calculate the following for general mills

You should look for publicly traded bonds for the firm and the Yield to Maturity (YTM) for the 10 year term bond would be an appropriate rate. You may use www.finra.org or morningstar (bonds tab) to obtain information on publicly traded bonds. If ..

  Selection of optimal source of financemorton industries is

selection of optimal source of finance.morton industries is considering opening a new subsidiary in boston to b

  Possible reasons for inaccurate financial reporting

What are the possible reasons for inaccurate financial reporting? Do you feel this is deliberate and discuss the impact of major accounting scandals on investors' asset preferences.

  Calculate genentechs annual sustainable growth rate

Calculate Genentech's annual sustainable growth rate for the years 2003-2007. Did Genentech face a growth management challenge during this period? Please explain briefly.

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