Financial Analysis/ Stock Valuation Using Excel
Budget: $30 – $250 USD
-Using financial data and information from Yahoo Finance (YF) ONLY, calculate the
Intrinsic Value (calculated price) for Intel Corporation (INTC) using the FREE CASH FLOW (FCF) VALUATION METHOD
-Use the company’s sales figure on December 31, 2019 as your “Initial Sale” (sales at
the beginning of year 1) and project your data sets 10 years into future.
-List all the key assumptions – like Sales Growth Rate, Profit Margin, Cost of Capital,
etc. – that you used in arriving at the company’s intrinsic value
*Compare the price that you calculated with the closing Market Price for the
company on Friday, April 29 and tell me if the company is Overvalued, Undervalued, or
priced correctly. Explain reason and make a good case for response,
one way or another.
Intrinsic Value (calculated price) for Intel Corporation (INTC) using the FREE CASH FLOW (FCF) VALUATION METHOD
-Use the company’s sales figure on December 31, 2019 as your “Initial Sale” (sales at
the beginning of year 1) and project your data sets 10 years into future.
-List all the key assumptions – like Sales Growth Rate, Profit Margin, Cost of Capital,
etc. – that you used in arriving at the company’s intrinsic value
*Compare the price that you calculated with the closing Market Price for the
company on Friday, April 29 and tell me if the company is Overvalued, Undervalued, or
priced correctly. Explain reason and make a good case for response,
one way or another.