2023-2024 Undergraduate Catalog

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.

Credits

3

Prerequisite

FN 215 Financial Management and FN 315 Investments or FN 351 Corporate Finance