FINAN 5380 - Advanced Financial Modeling for Investments

The course will apply economic theories learned from other courses to solve various problems in financial management and investments. It will take a hands-on approach in building financial spreadsheet models. Microsoft Excel is a primary tool to implement the financial models. The students will have ample examples of numerical and graphical practices on problems that arise in various areas of financial analyses. These include but are not limited to asset return calculations, portfolio theory, index models, the capital asset pricing model and investment performance analysis. The course will also make use of statistics and probability.