Department of Finance
Tuesday and Thursday 10:10 – 14:35
Bora Ozkan, Ph.D.
Tuesday, Thursday 15:00 – 16:00, Wednesday 10:00 – 13:00 or by appointment at Alter Hall 401G
Financial modeling is building an abstract representation of the relationships among the variables of financial problems. This course presents the paradigms of finance through the use of state-of-art technology. Emphasis on spreadsheet programming develops an understanding of financial models and the ability to work with those models. This course will tackle common financial problems -ranging from the simple NPV analysis to the relatively more complex portfolio optimization, duration and interest rate risk, options valuation, modern portfolio management, and help the students gain the necessary competencies in building appropriate financial models for each case. The course covers a variety of modeling techniques, such as sensitivity and scenario analysis, optimization methods, and regression analysis. Although, students learn to use alternative financial models to analyze various decision-making opportunities, the aim is to get the students to the skill level where they can model and solve most financial problems they will face in the business world. Learning Objectives:
1. Build competency in using primitive Excel commands
2. Demonstrate competency in use of Excel to build a models for capital budgeting, investment analysis, and option valuation. 3. Display competency in use of advanced Excel functions for sensitivity and what-if analysis 4. Demonstrate competency in the use of Crystal Ball for simulation 5. Develop a financial pro forma model with fully integrated financial statements 6. Design and prepare complex financial models, understand the critical issues/assumptions, prepare sensitivity analysis 7....
Please join StudyMode to read the full document