FIN 455 - Financial Modelling

3 units (fi 6)(EITHER, 3-0-0)

Financial models are important in financial statement preparation, cash flow analysis, capital budgeting, business valuation, risk management, performance analysis, and many other management decision processes. In this course you will learn to construct financial spreadsheet models using current best practices with the functionality available in Excel. Topics include modelling basics, spreadsheet operations, financial statement models, valuation models, cost of capital, corporate transactions, sensitivity and scenario analyses, aesthetics and visualization, time series models, and an introduction to advanced Excel features. The emphasis is on building good models that help in decision making, with examples and exercises from the breadth of corporate finance. Prerequisite: FIN 201.