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
For the companies Lockheed-Martin (LMT) & Northrop-Grumman (NOC)
Use Macrotrends data to calculate Return on Sales, Return on Assets, Debt
Ratio, Inventory Turnover, Lead Time for each company
Use Fintel to determine EPS forecasts for 2024-2027 for each company, and use
those to calculate an average earnings growth rate for each
-
https://fintel.io/sfo/us/Imt
https://fintel.io/sfo/us/noc
Assuming MARR = WACC + 3%, calculate a fair market price for the stock of
each company, assuming that earnings grow at the calculated rate for the next 50
years, with the following WACC
LMT:
NOC:
8.00%
8.25%
Find the current stock price for each company
Based on the above calculations, which company's stock would you buy, and
provide your reasoning (If neither or both, explain reasoning)
arrow_forward
Does the information indicate whether the current ratio will be useful in predicting financial failure in terms of the trends shown? Discuss.
Current Ratio
2016
2017
2018
2019
2020
BHP
1.44
1.85
2.51
1.89
1.45
RIO
1.61
1.71
1.98
1.56
1.80
FMG
1.48
1.18
1.33
1.37
2.25
arrow_forward
Given the data in the following table, the Net Profit Margin in 2023 was… % (table is attached)
1) 12.74 2 ) 16.73 3) 15.49 4) 11.69 5) 10.62
arrow_forward
Can you please see attached and help me solve for part one and part two using the income statements and balance sheets. Looking to calculate the following risk ratios for 2024 and 2025 (assuming all sales were on accounr) as well as calcuate the following profitibility ratios for 2024 and 2025
arrow_forward
Using data available in the case, calculate the annual growth rate from 2020 to 2021 (in percentages). All calculations should be
rounded to two decimals (e.g., 12.77%).
> Answer is complete but not entirely correct.
2021
2020
2020-2021
Revenue
2,057,622
1,736,432
18.50
%
Cost of Goods Sold
1,259,830
921,980
36.64
%
Gross Profit
797,792
814,452
(1.02) %
Operating Expenses
789,795
570,245
38.50 %
Operating Income
7,997
244,207
2,953.73%
Net Income
14,553
191,960
(92.42) %
arrow_forward
Please use the attached images as well...
Compute the following:
4. For fiscal 2020: Free Cash Flow to Equity
5. Market Capitalization, Market to Book Value and the Price-Earnings Ratio as of year-end 2020
Stock Prices in 2018 = $68.98
2019 = $84.15
2020 = $107.82
arrow_forward
DAS Co. is preparing its financial forecast for next year and its AFN is negative. This means that
Select one:
O a. the predicted change in total assets must be negative.
O b. sales growth must be negative.
O c. the dividend payout ratio must be greater than the predicted growth rate in sales.
O d. the predicted change in spontaneous liabilities must be greater than the predicted change in
total assets.
arrow_forward
Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales
using the average approach?
You must use the built-in Excel function to answer this question.
Input area:
Year
Sales
2016
2017
2018
es es e
$
1,500,000
$
1,750,000
$
1,400,000
2019
$
2,000,000
2020
$
1,600,000
Output area:
Next year's sales
arrow_forward
Calculate the projected price/earnings ratio and market/book ratio. Explain whether these ratios indicate that investors will be expected to have a high or low opinion of the company.
Computron's Balance Sheets (Millions of Dollars)
2019
2020
Assets
Cash and equivalents
$ 60
$ 50
Short-term investments
100
10
Accounts receivable
400
520
Inventories
620
820
Total current assets
$ 1,180
$ 1,400
Gross fixed assets
$ 3,900
$ 4,820
Less: Accumulated depreciation
1,000
1,320
Net fixed assets
$ 2,900
$ 3,500
Total assets
$ 4,080
$ 4,900
Liabilities and equity
Accounts payable
$ 300
$ 400
Notes payable
50
250
Accruals
200
240
Total current liabilities
$ 550
$ 890
Long-term bonds
800
1,100
Total liabilities
$ 1,350
$ 1,990
Common stock
1,000
1,000
Retained earnings
1,730
1,910
Total equity
$ 2,730
$ 2,910
Total liabilities and equity
$ 4,080
$ 4,900…
arrow_forward
Perform the common sizing analysis for 2019 and 2018. Comment on your observations on the changes in the percentages.
Focus on
a) the change in the amount of total assets --- does this mean the firm is doing better? Why or why not?
b) the changes in current assets, current liabilities and what this could mean for the firm.
c) the changes in debt: what has increased more, total current liabilities or long-term debt?
d) the change in total common equity. What has driven the change?
e) the conundrum that although sales have nearly doubled, the firm makes a loss in 2019. What has caused this situation?
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
Chapter 12, Question 6. Attached is a similar question with correct answers. Please aswer what is the projected sales forecast for 2013 and 2014. Along with income statements. Thank you! :)
arrow_forward
Suppose a firm has had the following historic sales figures.
Year:
2016
2017
2018
2019
2020
Sales
$3,100,000
$3,350,000
$3,000,000
$3,600,000
$3,200,000
What would be the forecast for next year’s sales using the naïve approach?
arrow_forward
The analysis of Returned on Invested Capital is as follows:
2015: 3.77%
2016: 1.46%
2017: 2.90%
2018: 2.94%
2019: 2.24%
a. What is the trend analysis for that Returned on Invested Capital and why it is increasing and decreasing?
arrow_forward
2.
1.
1. Given the most recent financial statements for FY2023. Sales for FY2024 are expected to grow by 10 percent. The following assumption must be held in the pro forma financial statements. The tax rate (percentage), the interest expense ($ amount), and the dividend payout ratio (percentage) will remain constant. COGS, SGA, Depreciation, all current asset accounts, Net PPE, intangibles, other assets, and accounts payable increase spontaneously with sales. Calculate the pro forma value for total assets for FY24 if the firm operates at full capacity and no new debt or equity is issued. (Enter percentages as decimals and round to 4 decimals)
2. Given the most recent financial statements for FY2023. Sales for FY2024 are expected to grow by 10 percent. The following assumption must be held in the pro forma financial statements. The tax rate (percentage), the interest expense ($ amount), and the dividend payout ratio…
arrow_forward
Suppose a firm has had the following historic sales figures.
Year:
2016
Sales $1,420,000
2017
$1,720,000
Next year's sales
2018
2019
2020
$1,600,000 $2,010,000 $1,770,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.
27
arrow_forward
Suppose a firm has had the following historic sales figures.
Year:
Sales
2016
$1,900,000
2017
$2,150,000
2018
$1,800,000
2019
$2,400,000
2020
$2,000,000
What would be the forecast for next year's sales using the average approach?
Next year's sales
arrow_forward
Perform the common sizing analysis for 2019 and 2018. Comment on your observations on the changes in the percentages.
e) the conundrum that although sales have nearly doubled, the firm makes a loss in 2019. What has caused this situation?
arrow_forward
The image uploaded is the calculation of Cal Bank's Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.
arrow_forward
Suppose a firm has had the following historic sales figures.
Year:
2016
2017
2018
2019
2020
Sales
$1,530,000
$1,720,000
$1,560,000
$2,100,000
$1,850,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.
arrow_forward
Projecting NOPAT and NOA Using Parsimonious Forecasting Method
Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands).
Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places.
Financial information
Net sales
Net operating profit after tax (NOPAT)
Net operating assets (NOA)
$2,788,322
211,362
571,823
Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions.
Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to
adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with two decimal places_.
Note: When completing the question…
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
i. Use the following simplified 2019 balance sheet to show, in general terms, how an improvement in one of the ratios—say, the DSO—would affect the stock price. For example, if the company could improve its collection procedures and thereby lower the DSO from 38.1 days to 27.8 days, how would that change “ripple through” the financial statements (shown in thousands below) and influence the stock price?
Accounts receivable $ 402 Debt $ 965 Other current assets 888
Net fixed assets 361 Equity 686. Total assets $1,651 Total liabilities and equity $1,651
j. Although financial statement analysis can provide useful information about a company’s operations and its financial condition, this type of analysis does have some potential problems and limitations, and it must be used with care and judgment. What are some problems and limitations?
arrow_forward
Projecting NOPAT and NOA Using Parsimonious Forecasting Method
Following are Logitech's sales, net operating profit after tax (NOPAT), and net operating assets (NOA) for its fiscal year ended March 31, 2019 ($ thousands).
Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places.
Financial information
Net sales
Net operating profit after tax (NOPAT)
Net operating assets (NOA)
$2,091,242
158,522
428,867
Use the parsimonious method to forecast Logitech's sales, NOPAT, and NOA for fiscal years ended March 31, 2020 through 2023 using the following assumptions.
Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into
the provided spaces below with two decimal places_.
Note: When completing the question…
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
A.Perform horizontal analysisand vertical analysis (for 2020only)on the income statement. In your answer please remember to indicate if it is an INCREASE or (DECREASE) and round your findings to ONE decimal place [e.g. -32.996% is - 33.0% or minus 33.0% or (33.0%).
B. Comment on the significant changes disclosed by the comparative statement of comprehensive income. What has caused the changes to occur?
C. Prepare a statement of retained earnings for the year ended June 30, 2020. (Retained earnings at July 1, 2019 were $58,000, dividends declared and paid during the financial year were $37,000.
D. Explain how profits for the year ended June 30, 2019 were $126,700 yet Retained Earnings at July 1, 2019 were only $58,000.
arrow_forward
The image uploaded is the calculation of Societe Generale Profitability ratios, shorter liquidity ratios, long-term liquidity ratios, and investment ratios for 2020, 2021, 2022. A base year of 2019 was also added. Evaluate the financial performance by comparing the three (3) years' financial performance that is 2020, 2021, and 2022 I have provided in the table with the base year.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337902571/9781337902571_smallCoverImage.jpg)
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285190907/9781285190907_smallCoverImage.gif)
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
Related Questions
- For the companies Lockheed-Martin (LMT) & Northrop-Grumman (NOC) Use Macrotrends data to calculate Return on Sales, Return on Assets, Debt Ratio, Inventory Turnover, Lead Time for each company Use Fintel to determine EPS forecasts for 2024-2027 for each company, and use those to calculate an average earnings growth rate for each - https://fintel.io/sfo/us/Imt https://fintel.io/sfo/us/noc Assuming MARR = WACC + 3%, calculate a fair market price for the stock of each company, assuming that earnings grow at the calculated rate for the next 50 years, with the following WACC LMT: NOC: 8.00% 8.25% Find the current stock price for each company Based on the above calculations, which company's stock would you buy, and provide your reasoning (If neither or both, explain reasoning)arrow_forwardDoes the information indicate whether the current ratio will be useful in predicting financial failure in terms of the trends shown? Discuss. Current Ratio 2016 2017 2018 2019 2020 BHP 1.44 1.85 2.51 1.89 1.45 RIO 1.61 1.71 1.98 1.56 1.80 FMG 1.48 1.18 1.33 1.37 2.25arrow_forwardGiven the data in the following table, the Net Profit Margin in 2023 was… % (table is attached) 1) 12.74 2 ) 16.73 3) 15.49 4) 11.69 5) 10.62arrow_forward
- Can you please see attached and help me solve for part one and part two using the income statements and balance sheets. Looking to calculate the following risk ratios for 2024 and 2025 (assuming all sales were on accounr) as well as calcuate the following profitibility ratios for 2024 and 2025arrow_forwardUsing data available in the case, calculate the annual growth rate from 2020 to 2021 (in percentages). All calculations should be rounded to two decimals (e.g., 12.77%). > Answer is complete but not entirely correct. 2021 2020 2020-2021 Revenue 2,057,622 1,736,432 18.50 % Cost of Goods Sold 1,259,830 921,980 36.64 % Gross Profit 797,792 814,452 (1.02) % Operating Expenses 789,795 570,245 38.50 % Operating Income 7,997 244,207 2,953.73% Net Income 14,553 191,960 (92.42) %arrow_forwardPlease use the attached images as well... Compute the following: 4. For fiscal 2020: Free Cash Flow to Equity 5. Market Capitalization, Market to Book Value and the Price-Earnings Ratio as of year-end 2020 Stock Prices in 2018 = $68.98 2019 = $84.15 2020 = $107.82arrow_forward
- DAS Co. is preparing its financial forecast for next year and its AFN is negative. This means that Select one: O a. the predicted change in total assets must be negative. O b. sales growth must be negative. O c. the dividend payout ratio must be greater than the predicted growth rate in sales. O d. the predicted change in spontaneous liabilities must be greater than the predicted change in total assets.arrow_forwardSuppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? You must use the built-in Excel function to answer this question. Input area: Year Sales 2016 2017 2018 es es e $ 1,500,000 $ 1,750,000 $ 1,400,000 2019 $ 2,000,000 2020 $ 1,600,000 Output area: Next year's salesarrow_forwardCalculate the projected price/earnings ratio and market/book ratio. Explain whether these ratios indicate that investors will be expected to have a high or low opinion of the company. Computron's Balance Sheets (Millions of Dollars) 2019 2020 Assets Cash and equivalents $ 60 $ 50 Short-term investments 100 10 Accounts receivable 400 520 Inventories 620 820 Total current assets $ 1,180 $ 1,400 Gross fixed assets $ 3,900 $ 4,820 Less: Accumulated depreciation 1,000 1,320 Net fixed assets $ 2,900 $ 3,500 Total assets $ 4,080 $ 4,900 Liabilities and equity Accounts payable $ 300 $ 400 Notes payable 50 250 Accruals 200 240 Total current liabilities $ 550 $ 890 Long-term bonds 800 1,100 Total liabilities $ 1,350 $ 1,990 Common stock 1,000 1,000 Retained earnings 1,730 1,910 Total equity $ 2,730 $ 2,910 Total liabilities and equity $ 4,080 $ 4,900…arrow_forward
- Perform the common sizing analysis for 2019 and 2018. Comment on your observations on the changes in the percentages. Focus on a) the change in the amount of total assets --- does this mean the firm is doing better? Why or why not? b) the changes in current assets, current liabilities and what this could mean for the firm. c) the changes in debt: what has increased more, total current liabilities or long-term debt? d) the change in total common equity. What has driven the change? e) the conundrum that although sales have nearly doubled, the firm makes a loss in 2019. What has caused this situation?arrow_forwardIf 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_forwardChapter 12, Question 6. Attached is a similar question with correct answers. Please aswer what is the projected sales forecast for 2013 and 2014. Along with income statements. Thank you! :)arrow_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 LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337902571/9781337902571_smallCoverImage.jpg)
Fundamentals Of Financial Management, Concise Edi...
Finance
ISBN:9781337902571
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285190907/9781285190907_smallCoverImage.gif)
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)