Preview

Fin361 Week 5 Regression Analysis Case

Powerful Essays
Open Document
Open Document
3153 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Fin361 Week 5 Regression Analysis Case
FINS3625 APPLIED CORPORATE FINANCE

Case Study Written Report

Week 8 Valuation: Laura Martin

Name

Student Number

% Contributio n 20 20 20 20 20

Signature

Karen Chan Yifeng Chen (Nino) Tony Richardson Weitao Wu (Tony) Wendy (Wenyu) Yan

z3242429 z3283995 z3253113 z3284666 z3241580

1

Multiples versus DCF analysis Multiples analysis is simple to understand and apply. The inputs for the multiple are publicly available, though are vulnerable to accounting manipulation. Also, it is difficult to obtain a truly comparable large sample of firms. Multiples analysis is backward-looking, reliant on historical/current data to obtain multiples. It reflects relative value rather than the intrinsic value which DCF valuation produces.
…show more content…
The “stealth tier” could also be valued using decision-tree analysis (see A9). An investment timing option could also be incorporated, which would allow Cox Communication to determine whether it would be profitable to “light up” and utilize the empty channels today or at a later date. Including the stealth tier option would impact the multiple analyses based on invested capital (see A10) and also EBITDA. For an effective valuation however, Cox Communications would have to be compared to companies that have a similar stealth tier, which is unrealistic. How is the stealth tier like a call option? Applicability of Martin’s option analysis The stealth tier is similar to a call option as the company has the right but not the obligation to use the unused capacity to implement further operating capacity. Therefore the decision of whether to use this capacity is a real option as the stealth tier has a value and a cost (see A11), and it is up to management as to it being exercised or not. Martin used the Black-Scholes model to value this stealth tier. Inputs from the real option illustration can be obtained as required by the Black-Scholes model (see A12). Thus it appears that the B-S model can value the stealth tier due to it resemblance to a call option, and that the 14% premium on …show more content…
Considering that the current price (or value of the option) is calculated as $23.15 per channel/per home, and the exercise price is $1.22 (opportunity cost of profit passed) the option is valuable (the current price is significantly larger than the exercise price). In addition, the option has an estimated 10 year life, which adds value as the holder of the option has a longer time to decide action. Finally for this scenario, the riskier the underlying, the more valuable the option. Volatility of 50% is high, adding value to the option. A9. Cash flows for the next 10 years generated under the stealth tier can be projected under different market condition scenarios. The cash flows under each scenario can then be discounted back to the current time, and the weighted average calculated to arrive at expected NPV of the tier” the

You May Also Find These Documents Helpful

  • Good Essays

    As stated in our text, the most popular used firm valuations in healthcare is the DCF (Discounted Cash Flow) method. When using this approach there are three methods used and they are: for the next five years cash flows are estimated, after the cash flows are estimated they are then discounted to show the current value of the firm and, at the end of the fifth year, the value of the acquired firm will be estimated, or annual cash flows will no longer be estimated. (Cleverley, Song, Cleverley,…

    • 688 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Your division is inconsideration for two investments, each of which requires an upfront expenditure of $25 million. You estimate that the cost of capital is 10% and that the investments will produce the following after tax cash flows (in millions of dollars):…

    • 465 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Fin 200 Week 1 Assignment

    • 276 Words
    • 2 Pages

    28.) The relationship between net income and net cash flows from operating activities for the company is that, the net income is the basic in which the company can use is a direct method. The items on the income statement are adjusted to cash accounting. The net income shows where it starts and the adjustments are made to change net income to cash flow from operations.…

    • 276 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    A1 Study Pack

    • 540 Words
    • 2 Pages

    5. What is the idea of valuation about? What are the differences between a DCF and a comps approach to valuation?…

    • 540 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The equation of the ‘best fit’ line or the regression equation is SALES(Y) = 9.638 + 0.2018 CALLS(X1)…

    • 1056 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    Regression Analysis Quiz

    • 682 Words
    • 3 Pages

    You are about to test the hypothesis that sales of your product will increase at a very similar rate at either a $5 drop in unit price or a $7 drop in unit price. You are involved in what type of research?…

    • 682 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    fin week 5 assignment

    • 563 Words
    • 4 Pages

    Your finance text book sold 53,250 copies in its first year. The publishing company expects the sales to grow at a rate of 20 percent for the next three years, and by 10 percent in the fourth year. Calculate the total number of copies that the publisher expects to sell in year 3 and 4. (If you solve this problem with algebra round intermediate calculations to 6 decimal places, in all cases round your final answers to the nearest whole number.)…

    • 563 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The following analysis charts will help determine the overall satisfaction or dissatisfaction that employees feel about the company they work for and the management team of that company. The final analysis will let management know if anything needs to be corrected.…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    1. Calculate real GDP for 2004 and 2005 using 2004 prices. To calculate the real GDP we use the constant price for 2004 which was $20.…

    • 650 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    At times we can generate a regression equation to explain outcomes. For example, an employee’s salary can often be explained by their pay grade, appraisal rating, education level, etc. What variables might explain or predict an outcome in your department or life? If you generated a regression equation, how would you interpret it and the residuals from it?…

    • 377 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Fi515 Final Exam

    • 1601 Words
    • 7 Pages

    The corporate valuation model can be used both for companies that pay dividends and those that do not pay dividends.…

    • 1601 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    was based on a Net Present Value (NPV) analysis on six different scenarios. Each scenario and…

    • 2248 Words
    • 58 Pages
    Powerful Essays
  • Satisfactory Essays

    To analyze the profit and loss possibilities inherent in the option investment strategies, please perform the following analyses for call and put options on Lotus’s common stock that mature in February 1994 and that have an exercise price of $55 per share.…

    • 524 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    I declare that this assessment is my own work, based on my own personal research/study . I also declare that this assessment, nor parts of it, has not been previously submitted for any other unit/module or course, and that I have not copied in part or whole or otherwise plagiarised the work of another student and/or persons. I have read the ACAP…

    • 1102 Words
    • 5 Pages
    Powerful Essays
  • Better Essays

    Regression Analysis

    • 1285 Words
    • 6 Pages

    This presentation on Regression Analysis will relate to a simple regression model. Initially, the regression model and the regression equation will be explored. As well, there will be a brief look into estimated regression equation. This case study that will be used involves a large Chinese Food restaurant chain.…

    • 1285 Words
    • 6 Pages
    Better Essays