Question34-PhucDang
.docx
keyboard_arrow_up
School
Seattle University *
*We aren’t endorsed by this school
Course
MISC
Subject
Finance
Date
May 29, 2024
Type
docx
Pages
3
Uploaded by GeneralScorpionPerson1978
Question 3:
By the end of 2017, the predicted final worth of ORN is around $15,586.66. Included in this is a revenue growth rate that starts at 117% in 2012 and averages 45% from 2012 to 2017. The attached "projections" Excel file shows the projected financial statements and the growth rates applied. The presented financial statements are supplemented by these notes. We are making predictions based only on ORN's historical performance when we use this method rather than the relative value. In contrast to the constant growth model, which takes stock market volatility into account when calculating a company's worth, the relative value approach looks at how similar organizations are doing in terms of share price and earnings. Because it relies on comparisons, relative value analysis might produce misleading results if the compared companies' market strategies and goods are significantly different.
Also included in the attached Excel file under the "relative value" column are forecast details for the price-to-earnings ratio. This forecast for the price-to-earnings ratio of ORN is derived from the relative values of comparable companies; after applying weights to the p/e ratios of previous competitors, ORN is assigned a p/e ratio of 24.82. As a result of a greater weighting for firms that are 100 percent equity, OutReach Networks should have a marginally higher Forward P/E ratio than the average Forward P/E ratio of comparable firms when the relative value method is applied. Additionally, ORN continues to intend to reinvest the majority of retained earnings in future expansion because of its anticipated growth potential. Due to these two factors, its p/e ratio is quite high.
For a more applicable valuation, by using a risk-adjusted discount rate model (RADR), the present value of ORN is $ 178.93 million. To determine the beta used in the model, the given betas for all four relative firms were used and altered based on their relationship between equity and value. Once the new betas for these firms were determined (as shown in the attached Excel under tab “Ex. 2-comparables”), they were then averaged to give a relative beta to be used for ORN which is 1.4. This was then used to calculate the RADR which is shown in the attached Excel on the tab “Discount CF PV & 50% Cut.” The new RADR is 13.27%. This RADR is then used to estimate the present value of the cash flows through 2017 and these cash flows are all added together to give us the projected present value of the firm.
This same Excel tab also shows what would happen if we only got half of the financial flows we expected. A predicted present value of $89.46 million for the firm is generated using the same methodology as before but with half the cash flows. It would be excellent to accept Everest Partner's offer if anticipated cash flows are half of what they were originally predicted since $30 million invested would be worth around 34% ownership of the company in this scenario.
Question 4:
However, when assessing the firm's potential through the venture capital method, it would be prudent to determine that its value is $83.21 million. A large discount rate, ranging from 40 to 60%, is typically applied when computing the horizon or terminal value of a company
via the venture capital method. The utilization of the 50% discount rate was employed in the "Venture Capital Method" tab to calculate the estimated value of OutReach Networks in 2017 at its constant growth terminal value of $948 million. A 50% discount rate was calculated using the
means of 40% and 60%. Everest Partners determined their perceived value of the business using 50% of expected cash flows; therefore, the 50% discount rate is also applicable when compared to the discounted cash flow method.
Following an assessment of OutReach Networks utilizing the discounted cash flow method and the venture capital method about Everest Partner's offer, the present value of the organization is projected to be $89.46 million and $83.21 million, correspondingly. Everest Partners' stance on the suitability of a 50% discount rate supports the company's demand for a 30% equity stake. In the Excel pane labeled "Justified for 30% Equity Stake," the equity ownership that Everest Partners can anticipate using the discounted cash flow method and the venture capital method for a $30 million investment is 33.53% and 36.05%, respectively. Even though a 30% equity stake is rational in light of these two valuation techniques and a 50% discount rate, the question of whether a 50% discount rate is excessively high must be resolved.
In other terms, Perez should negotiate for a higher valuation on Monday at 8:00 a.m. The typical range for growth rate is 3–5%. When a growth rate of 4% is applied, the discount rate calculated using the Capital Asset Pricing Model is 13.3%. By applying this discount rate to the anticipated cash flows (as opposed to applying a 50% discount or reducing the expected cash flows by 50%), the Risk-Adjusted Discount Rate (RADR) Present Value for OutReach Networks
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
hello, I need help please
arrow_forward
hello, I need help please
arrow_forward
Here are alphas and betas for Company X and Company Y for the 60 months ending April 2019.
Alpha is expressed as a percent per month. A month later, the market is up by 5%, X is up by 6% and
Y is up by 3%.
(3a) What is the abnormal rate of return for X and Y?
]
Alpha Beta
X 0.57 1.08
Y 0.46 0.65
The table below shows a condensed income statement and balance sheet for a plant.
Income Statement
Assets at 31 December 2018
Revenue
56.66 Net working capital
7.08
Raw materials cost 18.72
Operating cost 21.09
Depreciation
Investment plant & equipment 69.33
4.50 Less accumulated depreciation
Net plant & equipment
21.01
Pretax income
12.35
48.32
Tax at 35%
4.32
Net income
8.03 Total assets
55.40
(3b) Calculate the plant's EVA. Assume the cost of capital is 9%.
(3c) Assume now that the plant could be sold to another company for $95 million. How should this
fact change your calculation of EVA? Explain your answer
arrow_forward
If Night Owl Inc. calculated the following for their debt-to-equity ratio over two years, did the ratio
improve or worsen?
2021 = 1.4
2020 = 0.9
O A Improve
O B. Worsen
O C. Same
OD, Unknown
arrow_forward
Bartman Industries' and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015-2020. The Winslow 5000 data are adjusted to include dividends.
1.) Use the data to calculate annual rates of return for Bartman, Reynolds, and the Winslow 5000 Index. Then calculate each entity's average return over the 5-year period. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the index. Also, the rates of return for 2015 are not avaiable because 2014 data are not given).
Bartman Industries
Reynolds Inc.
Winslow 5000
Year
Stock Price
Dividend
Holding period return
Stock Price
Dividend
Holding period return
Includes Divs.
Holding period return
2020
$17.25
$1.15
$48.75
$3.00
11,663.98
2019
14.75…
arrow_forward
The Dow Jones Industrial Average had the following annual returns:
Year
Return
2019 22.3%
2020
7.3%
2021
19%
2022
-8.7%
Using just these last 4 years of data, what is the expected return for the Dow Jones?
What is the standard deviation of the returns? Please show and explain your work.
arrow_forward
Returns for the Cabell's Company over the last 3 years are shown below. What's the standard deviation of
Cabell's returns? (Hint: this is a historical data problem, not a probability distribution.)
Return
25%
Year
2019
2018
-10
2017
30
23.87%
22.97%
21.79%
25.18%
arrow_forward
Suppose a firm has had the following historic sales figures.
Year:
2016
2017
2018
2019
Sales $1,480,000 $1,680,000 $1,580,000 $2,070,000
2020
$1,900,000
What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend?
Note: Round your answer to the nearest whole dollar.
Next year's sales
arrow_forward
Manshukh
arrow_forward
Given the information below for Seger Corporation, compute the expected share price at the end of 2022 using price ratio analysis.
Assume that the historical (arithmetic) average growth rates will remain the same for 2022.
Note: Do not round intermediate calculations. Round your answers to 2 decimal places.
Year
Price
EPS
CFPS
SPS
2016
$97.50
3.15
7.52
55.10
Using PE ratio
Using P/CF ratio
Using P/S ratio
2018
2017
$103.40 $ 102.10
3.86
4.66
8.44
8.86
60.10)
59.50
Share Price:
2020
2019
$99.60 $ 121.10
5.36
10.37
63.00
7.25
11.95
74.20
2021
$136.50
8.25
13.20
82.20
arrow_forward
Given the information below for Seger Corporation, compute the expected share price at the end of 2022 using price ratio analysis.
Assume that the historical (arithmetic) average growth rates will remain the same for 2022.
Note: Do not round intermediate calculations. Round your answers to 2 decimal places.
Year
Price
EPS
CFPS
SPS
2016
2017
$ 103.50 $ 109.40
5.30
4.59
8.02
8.84
60.10
65.10
Using PE ratio
Using P/CF ratio
Using P/S ratio
2018
$ 108.10
6.10
9.16
64.50
X Answer is complete but not entirely correct.
$
$
$
Share Price
2019
$ 105.60
6.80
10.87
68.00
167.36 X
272.56 X
155.05
2020
$ 127.10
7.75
12.25
79.20
2021
$ 142.50
8.75
13.40
87.20
arrow_forward
Nikul
arrow_forward
Returns earned over a given time period are called realized returns. Historical data on realized returns is often used to estimate future results. Analysts across companies use realized stock returns to estimate the risk of a stock.
Five years of realized returns for Falcon Freight Inc. (Falcon) are given in the following table:
2016
2017
2018
2019
2020
Stock return
25.00%
17.00%
30.00%
42.00%
13.00%
Also note that:
1.
While Falcon was started 40 years ago, its common stock has been publicly traded for the past 25 years.
2.
The returns on Falcon's equity are calculated as arithmetic returns.
Given this return data, the average realized return on Falcon Freight Inc.’s stock is .
The preceding data series represents a sample of Falcon’s historical returns. Based on this conclusion, the standard deviation of Falcon’s historical returns is .
If investors expect the average realized return on Falcon Freight Inc.’s stock from…
arrow_forward
Given the information below for Seger Corporation, compute the expected share price at the end of 2020 using price ratio analysis. Assume that the historical (arithmetic) average growth rates will remain the same for 2020. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
Year
2014
2015
2016
2017
2018
2019
Price
$
52.10
$
58.00
$
56.70
$
54.20
$
75.70
$
91.10
EPS
3.10
3.81
4.61
5.31
7.10
8.10
CFPS
7.37
8.32
8.77
10.22
11.86
13.14
SPS
23.70
28.70
28.10
31.60
42.80
50.80
arrow_forward
4)Johnson and Johnson had a return on equity in 2020 of 31.4%and
paid out 36% of it earning as depends it earned a net income of
$1.625million on a book value of equity of $5,171million .as
consequence of the covid pandemic .the return on equity is
expected to drop 25%in 2021land that the dividend pay out ratio will
remain unchanged
A) Estimate the growth rate in earnings based upon 2020 numbers
B)Estimate the growth rate in 2020when the ROE drops from 31.4%
to 25%
arrow_forward
Given the information below for Seger Corporation, compute the expected share price at the end of 2022 using price ratio analysis.
Assume that the historical (arithmetic) average growth rates will remain the same for 2022.
Note: Do not round intermediate calculations. Round your answers to 2 decimal places.
Year
Price
EPS
CFPS
SPS
2016
$94.50
4.34
7.27
52.60
Using PE ratio
Using P/CF ratio
Using P/S ratio
2017
$ 100.40
5.05
8.24
58.52
X Answer is not complete.
Share Price
2018
$99.10
5.22
8.71
57.90
$
148.40 x
2019
$97.90
6.06
10.12
60.69
2020
$ 121.50
7.00
11.80
71.60
2021
$ 136.80
8.00
13.10
78.70
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- hello, I need help pleasearrow_forwardhello, I need help pleasearrow_forwardHere are alphas and betas for Company X and Company Y for the 60 months ending April 2019. Alpha is expressed as a percent per month. A month later, the market is up by 5%, X is up by 6% and Y is up by 3%. (3a) What is the abnormal rate of return for X and Y? ] Alpha Beta X 0.57 1.08 Y 0.46 0.65 The table below shows a condensed income statement and balance sheet for a plant. Income Statement Assets at 31 December 2018 Revenue 56.66 Net working capital 7.08 Raw materials cost 18.72 Operating cost 21.09 Depreciation Investment plant & equipment 69.33 4.50 Less accumulated depreciation Net plant & equipment 21.01 Pretax income 12.35 48.32 Tax at 35% 4.32 Net income 8.03 Total assets 55.40 (3b) Calculate the plant's EVA. Assume the cost of capital is 9%. (3c) Assume now that the plant could be sold to another company for $95 million. How should this fact change your calculation of EVA? Explain your answerarrow_forward
- If Night Owl Inc. calculated the following for their debt-to-equity ratio over two years, did the ratio improve or worsen? 2021 = 1.4 2020 = 0.9 O A Improve O B. Worsen O C. Same OD, Unknownarrow_forwardBartman Industries' and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015-2020. The Winslow 5000 data are adjusted to include dividends. 1.) Use the data to calculate annual rates of return for Bartman, Reynolds, and the Winslow 5000 Index. Then calculate each entity's average return over the 5-year period. (Hint: Remember, returns are calculated by subtracting the beginning price from the ending price to get the capital gain or loss, adding the dividend to the capital gain or loss, and dividing the result by the beginning price. Assume that dividends are already included in the index. Also, the rates of return for 2015 are not avaiable because 2014 data are not given). Bartman Industries Reynolds Inc. Winslow 5000 Year Stock Price Dividend Holding period return Stock Price Dividend Holding period return Includes Divs. Holding period return 2020 $17.25 $1.15 $48.75 $3.00 11,663.98 2019 14.75…arrow_forwardThe Dow Jones Industrial Average had the following annual returns: Year Return 2019 22.3% 2020 7.3% 2021 19% 2022 -8.7% Using just these last 4 years of data, what is the expected return for the Dow Jones? What is the standard deviation of the returns? Please show and explain your work.arrow_forward
- Returns for the Cabell's Company over the last 3 years are shown below. What's the standard deviation of Cabell's returns? (Hint: this is a historical data problem, not a probability distribution.) Return 25% Year 2019 2018 -10 2017 30 23.87% 22.97% 21.79% 25.18%arrow_forwardSuppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 Sales $1,480,000 $1,680,000 $1,580,000 $2,070,000 2020 $1,900,000 What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar. Next year's salesarrow_forwardManshukharrow_forward
- Given the information below for Seger Corporation, compute the expected share price at the end of 2022 using price ratio analysis. Assume that the historical (arithmetic) average growth rates will remain the same for 2022. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Year Price EPS CFPS SPS 2016 $97.50 3.15 7.52 55.10 Using PE ratio Using P/CF ratio Using P/S ratio 2018 2017 $103.40 $ 102.10 3.86 4.66 8.44 8.86 60.10) 59.50 Share Price: 2020 2019 $99.60 $ 121.10 5.36 10.37 63.00 7.25 11.95 74.20 2021 $136.50 8.25 13.20 82.20arrow_forwardGiven the information below for Seger Corporation, compute the expected share price at the end of 2022 using price ratio analysis. Assume that the historical (arithmetic) average growth rates will remain the same for 2022. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Year Price EPS CFPS SPS 2016 2017 $ 103.50 $ 109.40 5.30 4.59 8.02 8.84 60.10 65.10 Using PE ratio Using P/CF ratio Using P/S ratio 2018 $ 108.10 6.10 9.16 64.50 X Answer is complete but not entirely correct. $ $ $ Share Price 2019 $ 105.60 6.80 10.87 68.00 167.36 X 272.56 X 155.05 2020 $ 127.10 7.75 12.25 79.20 2021 $ 142.50 8.75 13.40 87.20arrow_forwardNikularrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals Of Financial Management, Concise Edi...FinanceISBN:9781337902571Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning