The course is split into two parts:

* Part I (Financial Modeling): How to implement a financial model to make informed
      decisions through financial forecasting and scenario analysis;
* Part II (Portfolio Management): How to build and manage an efficient portfolio that is
      capable of maximizing the risk-returns profile.

The course also includes Excel applications for each of the topics covered. 


PART 1: Overview and Goals

Making educated decisions today by forecasting operating and financial performance is a critical exercise for owners, managers, consultants, investment bankers, creditors, equity and credit analysts, and investors such as private equity groups, hedge funds, institutional investors and individuals.  As we are ineluctably constrained by our inability to predict the future, financial projections are rarely perfect.  Nonetheless, we endeavor to model several scenarios predicated on historical and anticipated results to derive various conclusions.  There are countless variables, which can certainly be incorporated into projections.  However, the best financial model is always the one that is stable and robust, yet simple and easy to build, navigate and audit.

1) To understand step-by-step how to build a comprehensive, multi-purpose projection model in Excel;
2) To interpret selective operating, credit and equity valuation data.  Based on this information, you will learn how to:
        a) Evaluate a company’s operating and financial performance;
        b) Develop an appropriate capital structure by structuring debt and equity transactions which create an appropriate risk
              and reward equilibrium, and
        c) Formulate an educated investment opinion and propitiously timed entry and exit trading points. 


PART 2: Overview and goals

This part of the course will give students an introductory overview of the current theories of portfolio management and provide a conceptual framework for the evaluation of investment strategies. It aims to provide students with exposure to the process of investment management including identification of investment objectives and constraints, determining asset allocations, and measuring portfolio performance. It will also cover the fundamental concepts of investments, including risk and return, market efficiency, portfolio diversification, and CAPM. The coverage will include applications and implementation, with a focus on performance evaluation.



The final grade for the course will be calculated according to the following percentages:

Class attendance: 10%  (Includes both in-class presence and participation);
Take-home assignments: 30%
Final presentation: 30%
Final exam: 30%