FN 440 Financial Modeling
Students develop financial modeling skills with Microsoft Excel. Students will learn to apply the concepts they have learned in the introductory courses into a spreadsheet model framework. The topics include valuation of cash flows, equity and fixed income securities, retirement planning, graphing in Excel, project cash flows calculation, capital budgeting and NPV analysis, sensitivity analysis, financial ratio analysis, Monte Carlo simulations, cost of equity and beta estimation, and portfolio optimization. The course is application oriented and will be helpful for a variety of jobs in corporate finance and banking.
Prerequisite
FN 215 Financial Management and
FN 315 Investments or
FN 351 Corporate Finance