Financial Analysis for Company Evaluation

All of these Excel sheets must be completed using reasonable assumptions and a transparent, traceable rationale explaining how and why each figure was chosen, including the data sources used. Each calculation should be supported by clear explanations and justification for the inputs applied. Once the model is fully filled out, a 2–3 page written report must be prepared, as outlined below. The worksheets are interconnected—simply follow them and the instructions in them in sequence and enter the appropriate data with explanations. Most of the required information can be obtained directly from the Novo Nordisk A/S ADR 10-K filings. The company which is being focused on is of course Novo Nordisk A/S ADR.

The Tasks in detail:
1. Template model with additional sheets
2. Optimal capital model with a synthetic rating of your company
3. Research note 2-4 pages plus appendix with charts and