Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Executive Summary of Rosetta Stone

Discuss about the Rosetta Stone for analysis of suitable tools .

Executive Summary of Rosetta Stone

The main purpose is to show the advantages and disadvantages of showing the IPO. The project shows the identification of the present problems of Rosetta Stone. The methods used shows the analysis of suitable tools solve the relevant issues to address the problems

Background of the company

Rosetta Stone, is a learning software company. The history of the company originates from the year 1980 by an economics professor Allen Stoltzfus. The seed of initiation of the company was due to the slow progress of the professor to learn the Russian language. It was found that the conventional classroom teaching of the Russian Language was becoming ineffective and the Mr. Allen Stoltzfus was looking for more natural way to learning language. Later on, the implementation of computer technology was implemented with pictures and sound. The company started the distribution of the software services was done with the CD ROM technology in the year 1990.  This provided the users with an opportunity to learn the new languages effectively. The software used the combination of images, text to teach the children to make the children to make them learn their first language, the company named this method as Dynamic immersion method. “Dynamic”, because of the use of digital technology and immersion due to the convenience of the learning from anywhere.

Despite of the global economic crisis the company was keen on going public. This fourth quarter of the company showed an expansion of 53% despite of the degrading economic conditions and the company was able to expand 53% of its revenues. Tom Adams considered IPO as a crucial opportunity to establish business credibility.

Identification of issues

  • Key considerations to be made in going public
  • Prohibition of the public to invest in the shares was prohibited for a private company
  • Problem in financing of credit
  • Dependence of the company on negotiations between other parties (Massari Gianfrate & Zanetti 2016)

Speaker Note

The problem was related to the decision making of the company going public. The company had to decide between the advantages and the disadvantages of going public and the various other alternatives to the IPO. Moreover since Rosetta Stone was privately owned, then offer to the public to buy the shares was prohibited. It was facing several issues in obtaining loan, this shows the dependence of the company on negotiations between other parties.

Analysis of the problems/issues

  • Multiple Market Approach
  • Discounted rate of the cash flow values

Slide 6 Analysis of the problems/issues

Exhibit 7

ROSETTA STONE, INC.: PRICING THE 2009 IPO

Financial Forecast for Rosetta Stone (in millions of dollars except percentages)

 

2008A

2009E

2010E

2011E

2012E

2013E

2014E

2015E

2016E

2017E

2018E

Revenue growth

52.5%

35.0%

35.0%

30.0%

25.0%

23.0%

21.0%

18.0%

13.0%

10.0%

5.0%

Gross margin

86.3%

86.0%

86.0%

85.0%

84.0%

83.0%

82.0%

81.0%

80.0%

79.0%

78.0%

SGA exp / Revenue

63.5%

63.5%

63.5%

63.0%

63.0%

62.5%

62.5%

62.5%

62.5%

62.5%

62.5%

R&D exp / Revenue

8.8%

9.0%

9.0%

8.5%

8.5%

8.5%

8.5%

8.0%

8.0%

8.0%

8.0%

Capital expenditures

7.0

5.0

8.0

9.0

9.5

10.0

11.0

11.0

9.0

8.0

5.0

NPPE turnover

13.5

15.0

15.2

15.4

15.6

15.8

16.0

16.2

16.4

16.8

17.3

NWC turnover

8.9

9.0

9.0

9.0

8.5

8.5

8.0

8.0

8.0

8.0

8.0

Revenue

209.4

282.7

381.6

496.1

620.1

762.7

922.9

1,089.0

1,230.6

1,353.6

1,421.3

Gross profit

180.7

243.1

328.2

421.7

520.9

633.1

756.8

882.1

984.5

1,069.4

1,108.6

SGA expense

133.0

179.5

242.3

312.5

390.7

476.7

576.8

680.6

769.1

846.0

888.3

R&D expense

18.4

25.4

34.3

42.2

52.7

64.8

78.4

87.1

98.4

108.3

113.7

  EBIT

29.4

38.2

51.5

67.0

77.5

91.5

101.5

114.3

116.9

115.1

106.6

Net working capital

23.4

31.4

42.4

55.1

73.0

89.7

115.4

136.1

153.8

169.2

177.7

Net PPE

15.7

18.8

25.1

32.2

39.7

48.3

57.7

67.2

75.0

80.6

82.2

Speaker note for Slide 6

The forecasted revenue growth of is mainly declining from 2008 to 2018 indicating a slow growth prospects of the company. Although the net working capital, is expected to increase on a yearly basis the revenue growth is decreasing due to similar markets giving competition to Rosetta Stone.

Background of the Company

Slide 7 Analysis of the revenue forecast

  • Declining trend of the revenue of the company
  • Revenue growth percentage is expected to grow by only 5% in the year 2018 (Larson & Yozzo, 2014).

Speaker note for Slide 7

Analysis of the revenue forecast

The revenue forecast analysis clearly shows the declining trend of the revenue of the company. This is evident because in the year 2008 the forecasted revenue growth was 52%, while in the year 2018 the revenue growth percentage was expected to grow by 5%. Although the net working capital, is expected to increase on a yearly basis the revenue growth is decreasing due to similar markets giving competition to Rosetta Stone.

Slide 8 Advantages of going public

  • The advantage of the company was seen in the form of issuing of 6.25 million shares to the public this represents 30% of the company’s total stake
  • Based on the financial figures from the last five years it can be further stated that the company will be able to increase the revenue by 725% and 625% increase in the net income.

Speaker note for Slide 8

Advantages

The advantage of the company was seen in the form of issuing of 6.25 million shares to the public this represents 30% of the company’s total stake. This shows that the company already issued half of the share process and the next half of the share price issue was due. Based on the financial figures from the last five years it can be further stated that the company will be able to increase the revenue by 725% and 625% increase in the net income.

Slide 9 Disadvantages of going public

  • There are several issues related to the transfer of owner of the company
  • The public company may become fully owned by the Government and company rights may be completely lost in an IPO offering.
  • The credit limit of an IPO company will further increase and the company will be entitled to more debt.
  • . In case, the company is not able to project the required amount of revenue, the Government may decide to dissolve shares to private companies (Laje et al. 2013). .

Speaker note for Slide 9

There are several issues related to the transfer of owner of the company. The public company may become fully owned by the Government and company rights may be completely lost in an IPO offering. The credit limit of an IPO company will further increase and the company will be entitled to more debt. In case, the company is not able to project the required amount of revenue, the Government may decide to dissolve shares to private companies.

Slide 10 Discount rate appropriate for the cash flow forecast

  • Weighted average of the beta is 0.92
  • The percentage of the discount rate appropriate for the cash flow forecast is 9.03% (Mousavi et al. 2013)
 

Beta

9.03%

0.69

0.79

0.89

0.99

1.09

5.5%

7.1%

7.6%

8.2%

8.7%

9.3%

6.0%

7.4%

8.0%

8.6%

9.2%

9.8%

6.5%

7.7%

8.4%

9.0%

9.7%

10.3%

7.0%

8.1%

8.8%

9.5%

10.2%

10.9%

7.5%

8.4%

9.2%

9.9%

10.7%

11.4%

Speaker note

The weighted average beta is mainly calculated from beta of the competitors companies. In addition, after the effective valuation, 9.03% is assumed a the overall discount rate, which could be used in cash flow forecast to determine the Present value of the forecasted cash flow.

Advantages of multiple market approach

  • Useful for the valuation of the similar assets having similar prices
  • Helps in determining the future growth of the company and assists the investors
  • Useful in evaluating the free cash flow after a particular financial period (Matthews, 2014).

Speaker note for Slide 11

The market multiples approach is useful for the valuation of the similar assets having similar prices. It is useful to determine the present position of Rosetta stone in terms of similar other companies. It also helps in determining the future growth of the company and assists the investors in making an adequate decision for investing in the company. It is also useful in evaluating the free cash flow after a particular financial period.

Identification of Issues

The net results clearly shows that the forecasted share value of the IPO is higher than the outstanding amount of the premoney shares.

 Disadvantages of multiple market approach

  • Non- consideration of economic crisis
  • Non-inclusion of the corporate tax rate
  • Mainly signifies high or low values of the company (Roosenboom 2012)

Speaker note for Slide 12

The primary drawback of this model is non- consideration of economic crisis in which the liquidity of the position of a cannot be assessed by using this model. It also deals with projecting either the high or the low values of an organization which may incorrectly depict the performance of a company. 

The disadvantage is seen in the non-inclusion of the corporate tax rate, which may directly affect then earning g of then revenue of the company.

Advantages of Discounted Cash flow method

  • Consideration of intrinsic value of the stock
  • Relies on availability of the free cash flow
  • The rates are estimated in such a basis that the share prices won’t be affected from the inflationary pressure in the economy (Willenbor, Wu & Yang 2015)

Speaker note

It takes into consideration the intrinsic value of the stock. Unlike the price earning technique, the DCF is reliant on the availability of the free cash flow.  This will help the investors to identify the source of cash flow. The rates are estimated in such a basis that the share prices won’t be affected from the inflationary pressure in the economy.

Disadvantages of Discounted Cash flow method

  • Difficult to predict the sales and the cost trends
  • Uncertainty of the cash flows
  • Changing discount rates

Speaker note for Slide 14

It is difficult to predict the sales and the cost trends with the certainty of the cash flows. The values are further sensitive to the assumptions of the perpetuity growth rates and the discount growth rates. The discount rate approach to the cash flow forecast is based on the approximations of the discount rates appropriate for the cash flow forecast

Evaluating the current price of Rosetta Stone

  • With the help of Multiple market approach and Discounted cash flow Method the overall price valuation of Rosetta Stone is assumed at $15.5
  • However, as mentioned in the case study the share value of the company is at $17.49 as of 2008.

Multiple Market Approach

Particulars

Amount

EBITDA

$ 34.6m

EBITDA Ratio

13.4 times

Enterprise Value

$ 463.6m

Debt

$9.9m

Equity Value

$ 453.7m

Outstanding value of shares (Pre-money)

17.2m

Implied share price

$ 26.4

Speaker note for Slide 16

The company is facing issues to decide for the use of market- multiple approaches in the valuation method. It is important to understand the appropriate discount rate of the cash flow forecast and proper approach to calculate the terminal value to estimate the share price of the company. The multiple market approach mainly helps in depicting the highest and the lowest values of any company's shares. Investors to evaluate the future growth of share price mainly use this valuation. Thus, $ 26.4 is evaluated as the highest figure, which could be used by Rosetta stone in depicting their share price during the IPO process.

Discounted Cash flow method

Terminal value calculation using discounted rate of the cash flow values

Valuation

Terminal Growth rate

3.00%

Discount rate

9.03%

Shares Outstanding

17.2

Debt value

9.9

2008A

2009E

2010E

2011E

2012E

2013E

2014E

2015E

2016E

2017E

2018E

CAGR 08/18

NOPAT

29.4

38.2

51.5

67.0

77.5

91.5

101.5

114.3

116.9

115.1

106.6

13.76%

Depreciation

1.9

1.7

1.9

1.9

2

1.5

1.6

1.5

1.2

2.5

3.4

5.99%

Capex

5

8

9

9.5

10

11

11

9

8

5

3.3

-4.07%

Change in NWC

8

11

12.7

17.8

16.8

25.6

20.8

17.7

15.4

8.5

7.1

-1.19%

Free cash flow

18.3

20.9

31.7

41.6

52.7

56.4

71.3

89.1

94.7

104.1

99.6

18.49%

Terminal Value

1701.26

Implied EV /EBIT

15.5

Speaker note

The discount cash flow method helps in evaluating the overall accurate share price of the company. In addition, $15.5 is estimated as the appropriate share value, which could be used as the base during the IPO process. 

Price recommend to offer shares

  • In order to promote then shares in the economic crisis of the shares the company needs to keep a price range of $15.5 to $ 18.5.

Speaker note

The valuation of the current share price is with the help of the discounted cash flow and the market multiples has depicted with the discounted cash flow and with then multiple market models. In order to promote then shares in the economic crisis of the shares the company needs to keep a price range of $15.5 to $ 18.5.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2017). Rosetta Stone: Analysis Of Suitable Tools. Retrieved from https://myassignmenthelp.com/free-samples/rosetta-stone-analysis-of-suitable-tools.

"Rosetta Stone: Analysis Of Suitable Tools." My Assignment Help, 2017, https://myassignmenthelp.com/free-samples/rosetta-stone-analysis-of-suitable-tools.

My Assignment Help (2017) Rosetta Stone: Analysis Of Suitable Tools [Online]. Available from: https://myassignmenthelp.com/free-samples/rosetta-stone-analysis-of-suitable-tools
[Accessed 23 February 2024].

My Assignment Help. 'Rosetta Stone: Analysis Of Suitable Tools' (My Assignment Help, 2017) <https://myassignmenthelp.com/free-samples/rosetta-stone-analysis-of-suitable-tools> accessed 23 February 2024.

My Assignment Help. Rosetta Stone: Analysis Of Suitable Tools [Internet]. My Assignment Help. 2017 [cited 23 February 2024]. Available from: https://myassignmenthelp.com/free-samples/rosetta-stone-analysis-of-suitable-tools.

Get instant help from 5000+ experts for
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Other Similar Samples

support
Whatsapp
callback
sales
sales chat
Whatsapp
callback
sales chat
close