FNC 488 - Financial Modeling Capstone, 3 credit hours

Prerequisite(s): FNC 445 and FNC 446
The course applies economic theories to solve various problems in financial management and investments. Using a hands-on approach to building financial spreadsheet models, the student will gain knowledge of numerical and graphical practices. These include but are not limited to asset return calculations, portfolio theory, index models, and the capital asset pricing model, option pricing models, bond pricing, equity valuation, LBOs and investment performance analysis. MS Excel is the primary tool to implement these financial models, however, the course will also make use of statistics and probability. In a nutshell, this course focuses on the practical application of financial modeling using Excel. The purpose of this course is to provide participants with tools to assist them in making and supporting management decisions. In terms of subject matter, students should be comfortable with equity and fixed-income derivatives, portfolio math, reading financial statements, free cash flow projections, and cost of capital calculations such as WACC. The bulk of our time will be spent building models and utilizing Excel, and data from internet resources, and Bloomberg.