Value Novartis shares using Discounted Cash Flow Valuation Method. Clearly state major assumptions regarding cash flow projections, terminal value calculations and discount rate. Use required return on equity of 8.5%. D

o you think Novartis shares are fairly valued?

Based on your analysis, what assumptions was the market making about Novartis future performance?

Include valuation summary for question as a one-page appendix. Use graphs/charts/tables to emphasize your arguments.

Please find the case below:

Please find the screenshot of the spreadsheet below:

Also, here's a link to it: https://failiem.lv/u/kckmn2kd