90.2K

Verified Solution

Link Copied!

Calculate the Intrinsic Value of 2 stocks from FINA 3107 stock list. Make sure one stock is a "growth" stock and the other is a "value" stock. Individual steps are below: 1. Use the attached spreadsheet. 2. Eligible FINA stocks are listed in the first tab. Select any stock you want, so long as one is growth and one is value (in your opinion). 3. A tab is set up for each type of stock (Growth and Value). 4. A color code is provided so you know what type of entry is required (fact, opinion, calculation, etc.) 5. The calculation entries mean you must create a calculation or review the formula that is already there. 6. A description of what the entry requirement is is provided for each line item. 7. Enter "facts" (generally color coded in green). Search online for current price, trailing twelve month (TTM) earnings and expected earnings growth data for each stock and input it into the stock's tab (one tab is for the growth stock and another for the value stock). 8. The date of your facts should be noted in the Analysis/Price Date row. I suggest you take a screen shot of your sources and include them in a separate tab. 9. Enter Judgments (generally color coded in blue). These are your opinions but should be reasonable and based information relevant to each stock. 10. The "Terminal" P/E ratio is what you would expect at the end of the cash flow horizon, 11. The growth stages are based on how you think the stocks income may grow. You don't have multiple states - and may not need Portfolio view | edit | delete | create new | alerts | open in screener view | edit | delete | create new | alerts | open in screener Calculate the Intrinsic Value of 2 stocks from FINA 3107 stock list. Make sure one stock is a "growth" stock and the other is a "value" stock. Individual steps are below: 1. Use the attached spreadsheet. 2. Eligible FINA stocks are listed in the first tab. Select any stock you want, so long as one is growth and one is value (in your opinion). 3. A tab is set up for each type of stock (Growth and Value). 4. A color code is provided so you know what type of entry is required (fact, opinion, calculation, etc.) 5. The calculation entries mean you must create a calculation or review the formula that is already there. 6. A description of what the entry requirement is is provided for each line item. 7. Enter "facts" (generally color coded in green). Search online for current price, trailing twelve month (TTM) earnings and expected earnings growth data for each stock and input it into the stock's tab (one tab is for the growth stock and another for the value stock). 8. The date of your facts should be noted in the Analysis/Price Date row. I suggest you take a screen shot of your sources and include them in a separate tab. 9. Enter Judgments (generally color coded in blue). These are your opinions but should be reasonable and based information relevant to each stock. 10. The "Terminal" P/E ratio is what you would expect at the end of the cash flow horizon, 11. The growth stages are based on how you think the stocks income may grow. You don't have multiple states - and may not need Portfolio view | edit | delete | create new | alerts | open in screener view | edit | delete | create new | alerts | open in screener

Answer & Explanation Solved by verified expert

See Answer