BUS 447 - Financial Modeling Capstone, 3 credit hours

Prerequisite(s): BUS 365 and BUS 446
This course is a hands-on, application-oriented tour of financial models used in corporate finance, investment analysis, and portfolio management. The course is designed to acquaint students the building of financial spreadsheet models and analyze financial decisions quantitative and graphically. The topics covered include but are not limited to asset return calculations, portfolio theory, 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. The purpose of this course is to provide participants with tools to assist them in making and supporting financial 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.