Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Does this company have a good capex? and why? Gamestop DCF Revenues Revenue Growth 2018 3,333 2019 3.543 6% 2020 3,239 -9% 2021 4,300 33%

image text in transcribed

Does this company have a good capex? and why?

Gamestop DCF Revenues Revenue Growth 2018 3,333 2019 3.543 6% 2020 3,239 -9% 2021 4,300 33% 2022 5,200 21% 2023 5.900 13% 2024 6,700 14% 2025 7,500 12% 2026 Terminal Yr 8,000 7% Weighted Average Cost of Capital risk free rate 3.0% Beta 1.00 Equity Risk Premium 6.0% Cost of Equity 9.0% Cost of Debt 4.0% DeblEquity 2% EBIT Operating Margin Tax Expense Net Operating Profit After Tax (NOPAT) 883 26.5% 112 985 27.8% 128 580 17.9% 200 1,100 25.6% (275) 1,500 28.8% (375) 1,750 29.7% (438) 2.000 29.9% (500) 2250 30.0% (563) 2,800 35.0% (700) 995 1,113 780 825 1.125 1,313 1,500 1,688 2,100 Calculated discount rate (WACC) 8.9% 220 234 227 230 250 300 325 350 375 Discount Rate: 8.9% D&A Expense Capex (Capital Expenditures) (296) (209) (189) (200) (300) 350 400 450 500 Terminal Growth Rate: Tax Rate: 5.0% 25% 919 1,138 818 855 1,075 1,963 2.225 2.488 3,124 2,975 80,759 987 1.656 1.724 1,771 Free Cash Flow To Enterprise Terminal Value (2027 free cash flow /(kg) PV of Future Free Cash Flows PV of Terminal Value Year in future discounting back to your Sum of 2022-2026 PV's Value of years beyond 2026 (terminal year) less Net Debt Total Equity Value 1,945 52,807 5 1 2 3 4 8,084 52,807 Plug in the most recent net debt = Short term debt + long term debt-cash (on balance sheet) 60,890 # of Shares Outstanding Equity Value Per Share Stock Price Stock Pricelintrinsic Value 148 #of shares outstanding in most recent balance sheet or from bloomberg 411 This is your DCF Value, also called your intrinsic value 370 Plugin current stock price 90% Gamestop DCF Revenues Revenue Growth 2018 3,333 2019 3.543 6% 2020 3,239 -9% 2021 4,300 33% 2022 5,200 21% 2023 5.900 13% 2024 6,700 14% 2025 7,500 12% 2026 Terminal Yr 8,000 7% Weighted Average Cost of Capital risk free rate 3.0% Beta 1.00 Equity Risk Premium 6.0% Cost of Equity 9.0% Cost of Debt 4.0% DeblEquity 2% EBIT Operating Margin Tax Expense Net Operating Profit After Tax (NOPAT) 883 26.5% 112 985 27.8% 128 580 17.9% 200 1,100 25.6% (275) 1,500 28.8% (375) 1,750 29.7% (438) 2.000 29.9% (500) 2250 30.0% (563) 2,800 35.0% (700) 995 1,113 780 825 1.125 1,313 1,500 1,688 2,100 Calculated discount rate (WACC) 8.9% 220 234 227 230 250 300 325 350 375 Discount Rate: 8.9% D&A Expense Capex (Capital Expenditures) (296) (209) (189) (200) (300) 350 400 450 500 Terminal Growth Rate: Tax Rate: 5.0% 25% 919 1,138 818 855 1,075 1,963 2.225 2.488 3,124 2,975 80,759 987 1.656 1.724 1,771 Free Cash Flow To Enterprise Terminal Value (2027 free cash flow /(kg) PV of Future Free Cash Flows PV of Terminal Value Year in future discounting back to your Sum of 2022-2026 PV's Value of years beyond 2026 (terminal year) less Net Debt Total Equity Value 1,945 52,807 5 1 2 3 4 8,084 52,807 Plug in the most recent net debt = Short term debt + long term debt-cash (on balance sheet) 60,890 # of Shares Outstanding Equity Value Per Share Stock Price Stock Pricelintrinsic Value 148 #of shares outstanding in most recent balance sheet or from bloomberg 411 This is your DCF Value, also called your intrinsic value 370 Plugin current stock price 90%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Market Regulations And Finance

Authors: Ratan Khasnabis, Indrani Chakraborty

2014th Edition

8132217942, 978-8132217947

More Books

Students also viewed these Finance questions

Question

How would we like to see ourselves?

Answered: 1 week ago