Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Rosetta stone ipo 2009

19/03/2021 Client: saad24vbs Deadline: 2 Day

1. Prepare a common size income statement for the years prior to the IPO (Excel). Discuss your findings. Do you see any evidence of scale economies or other factors that could affect your assumptions of future profitability or cash flow? (Maximum of 1/2 page of text, plus supporting Excel tab 1).

2. Construct the 2008 cash flow statement (Excel). What accounts for the increase in the company’s cash balance from 2007 to 2008? Note: For the operating cash flows portion of this, include all deferred taxes and all deferred revenue in your determination of operating cash flows and include the current portion of long-term debt in financing cash flows. Be careful not to double-count profit by also including it in the change in accumulated income. And be careful not to double count depreciation and amortization by not adjusting property and equipment and/or intangibles for changes due to depreciation and amortization. (Maximum 1 page explaining your analysis, plus supporting Excel Tab 2).

3. Using the data in the case, including comparables data, estimate the WACC of Rosetta Stone and explain the assumptions you made for the risk-free rate, the market risk premium, the equity beta, and the marginal corporate tax rate. How did you use the comparable firm data in this analysis? (Maximum 1 page of text, plus Excel Tab 3).

4. Using your estimate of WACC and the unlevered free cash flow projections in Exhibit 7A from the Course Materials tab on iLearn, prepare a discounted cash flow valuation for Rosetta Stone. Based on a discounted cash flow valuation, what do you expect to be the aftermarket value of the equity and the aftermarket price of the Rosetta Stone shares? What continuing value did you use in the DCF valuation and how did you determine it? (Maximum 1 page, plus Excel Tab 4).

5. As an alternative to discounted cash flow, use the comparable firm data for EBITDA multiples to estimate aftermarket value and aftermarket price per share. Explain your work. (Maximum 1 page, plus Excel Tab 5).

6. Based on the EBITDA multiples of the comparable firms, use @Risk to assess the sensitivity of aftermarket value per share to uncertainty. Explain your work (Maximum 1 page, plus Excel Tab 6).

7. Based on your analysis in parts 4, 5, and 6, at what price would you recommend that the Rosetta Stone shares be sold? Explain your reasoning. (Maximum 1 page, plus Excel Tab 7).

8. Considering any planned underpricing of the offering, and adjusting for an underwriter discount (fee) of 7 percent of gross proceeds, what do you expect will be the Postmoney (aftermarket) value per share? How did you deal with the fact that about half of the shares are being sold by selling shareholders and will not increase shares outstanding or provide proceeds to Rosetta Stone? (Maximum 1 page, plus Excel Tab 8). (Note: Since selling at a discount to aftermarket value will dilute value per share, this price will probably be somewhat lower than the aftermarket value you estimated before the offering.)

9. Relative to your estimate of aftermarket value per share in part 8, what is the full cost of the IPO as a percent of aftermarket value per share? What is the full cost as a percentage of the aftermarket value you estimated in part 4, 5, or 6, whichever you finally used in your IPO pricing? Explain. (1 page of text, plus Excel Tab 9).

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Assignments
Top Quality Assignments
Finance Master
Math Specialist
Homework Master
Quick N Quality
Writer Writer Name Offer Chat
Instant Assignments

ONLINE

Instant Assignments

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$36 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

I will cover all the points which you have mentioned in your project details.

$64 Chat With Writer
Finance Master

ONLINE

Finance Master

I will cover all the points which you have mentioned in your project details.

$64 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I have read and understood all your initial requirements, and I am very professional in this task.

$42 Chat With Writer
Homework Master

ONLINE

Homework Master

Give me a chance, i will do this with my best efforts

$20 Chat With Writer
Quick N Quality

ONLINE

Quick N Quality

I have read your project details. I can do this within your deadline.

$48 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Naplan year 7 persuasive writing topics - Which one of the following metals has the highest density - Nur512-Reply to this discussion kevin - Hawthorns country club arbor grill menu - Art appreciation essay topics - Harvey norman market capitilisation - 7-eleven franchise application form - 2350 doulton drive mississauga - Discharge of mortgage cba - Https acrobat adobe com us en sign html - Reply 1 and 2 ,150 words each one add references and citations by 08/14/2020 - Caedmon primary school website - How to write a guest speaker speech - Health and welfare organization - What memories do bo kaap and its significant spaces hold - Calculating margin activity capsim - C++ - What are reserved words with a programming language - 3 Page Essay - Marriott corporation the cost of capital solution xls - Why the pledge of allegiance should be revised - James hardie weather barrier - High altitude balloon experiments - Pink floyd brick in the wall - Walden university georgia - Ethical decision making quiz - Horizontal stabilizer trim actuator - 345 repeater station road springbrook - Capsim presentation powerpoints - Question paper wikipedia - Self care eating healthy and maintaining a healthy weight ati - Case study - The processes of photosynthesis and cellular respiration are complementary - Introduction to political theory john hoffman paul graham pdf - Unit I Essay (Study Guide attached) - How to write a soap note for nurse practitioners - Economics - Short Story by Joyce Carol Oates - Racv membership card replacement - Faith Essay - Introduction to Data Communication and Networking - ERD Diagram - Essay on do androids dream of electric sheep - Change the chart style to style 42 - Sypol health and safety - SCI 207 - Homework Question - Computer Related Crime - Exam 70 768 practice test - Monthly retirement planning worksheet answers - What are behavioral observation scales in counseling - Round to 1 sf - Sand falling on a conveyor belt - ESSAY... Human Development: Development Though the Lifespan 7th edition - Royal dutch shell plc wiki - Hw 5 pt1 - Royal caribbean jewelry guarantee - Curving grades using a normal distribution - Data Analytics vs Data Mining - The nine jeffrey toobin pdf - Toolkit for finance unsw - The polytechnic institute of new york university - Proc freq sas output - Difference between west egg and east egg - SADC - I am hiring writing team for the subjects of business, management , marketing, finance, HR - CPT Final Narrative paper - Are instant cold packs endothermic or exothermic - Nola pender theory to practice application - 8-2 Final Project II Submission: Professional Relevance Essay - Profit Maximization - Flag note bank solidworks - To build a fire discussion questions - Sam's big land flea market - What is the purpose of dhs and dhs programs - Kenya gatsby trust jobs - Aquinas diocesan grammar school - Annotated Bibliography - Project lessons learned template - Super glue warning label - Manchester united case study analysis - Commscope snap in hangers - Reflections - Brooke building salford royal - They say i say answers to exercises - Plant utilization formula capsim - Where is love black eyed peas lyrics - What did marie tharp do - Sea duck 5 letters - Four basic metaparadigm concepts in nursing - Developing a pool of leadership successors combines evaluating - Qut student job board - Experiment 2 measurement instruments mass volume density answers - Even parity generator truth table - The beginning of the song that diverts the heart poem - Give me liberty eric foner pdf - 509 week 2summary - Https www youtube com watch v askaqwobvhc - Life ming yuan pore strips directions - How are informative reports different from analytical reports