Reference no: EM131707923
Question: How to solve this in Excel?
Pick a stock of your choice which you think is likely to be in a high-growth stage and which has publicly-available financial statements for fiscal year 2016. From financial statements, obtain Total Revenue, EBIT, Capital Expenditures, Net Working Capital, Depreciation, and the Debt-to-Equity ratio (use Long-term debt as a measure of total debt) for fiscal year 2016. Make sure the company has positive debt and positive EBIT.
The income statement numbers should be for the entire year, not just for the fourth quarter. (Note: possible sources for financial statements include the company's website, finance.yahoo.com, or the Securities and Exchange Commission (www.sec.gov).)
Assume that the stock will be in a high growth stage over the next 8 years (2017-2024), after which it will reach a stable, lower-growth phase in year 9 (year 2025), which will last into the indefinite future. In addition, assume the following parameters:
The tax rate = 34%.
T-bill rate = 6.5 percent
Market risk premium = 5.5 percent.
High-growth phase: Expected growth rate in EBIT, Capital Expenditures, Revenues, NWC, and Depreciation: 7.5%.
Equity Beta during the high growth period: 1.34.
Cost of debt = 8.75%
Debt-to-equity stays constant over the high-growth phase.
Stable growth phase: Expected growth rate in FCFF = 4.5%
Equity Beta during stable growth phase: 1.12
Cost of debt = 7.5%
Debt-to-equity ratio in the stable growth phase will fall to 60% of what it was in the high-growth phase
Capital expenditures are offset by depreciation.
Use the FCFF approach to calculate the enterprise value of the firm, the equity value of the firm, and the intrinsic share value as of the end of 2016.
|
Reduce the efficacy of port scans
: What steps should the company take to prevent or at least reduce the efficacy of port scans?
|
|
What was the purpose of this study
: Briefly summarize the limitations, suggestions for future research, AND any implications (applications of findings)
|
|
Examine the manner in which your two chosen events
: Examine the manner in which your two chosen events showcase the ability of the U.S. Constitution and Declaration of Independence to live up to their promises.
|
|
Review the shrm case - designing a pay structure
: GB520 - Case analysis on the topic of strategic management and why it is critical to the success of an organization in meeting its goals and mission
|
|
Calculate the capital expenditures and net working capital
: From financial statements, obtain Total Revenue, EBIT, Capital Expenditures, Net Working Capital, Depreciation, and the Debt-to-Equity ratio.
|
|
Write a paper about revolutionary war in american history
: Write a paper about Revolutionary War in American History. See what interests you. If you still are undecided, call, text or email me. We can brainstorm.
|
|
What sequence do you expect the mixture of proteins to elute
: What sequence do you expect the mixture of proteins to elute (first to last) when you run the mixture on a size exclusion column
|
|
How much must the company receive each year in revenue
: Hydroklean ,LLC an environmental soil cleaning company, borrowed $.5 milliontio finance startup costs for a site reclamanation project.
|
|
What was the problem with marx as a youth
: What was the problem with Marx as a youth? What ideas about communism do you think the intended audience was meant to take away from this source?
|