FNC 656 - Financial Modeling & Valuation, 3 credit hours

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 portfolio theory; index models, option pricing models; bond analysis (pricing, duration, and immunization); equity valuation; LBOs; accretion, and dilution models; and investment performance analysis. MS Excel is the primary tool to implement these financial models. The purpose of this course is to provide participants with tools to assist them in making and supporting management decisions. Regarding 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 on building models and utilizing Excel, and data from internet resources, and Bloomberg.