FIN 313 Financial Modeling in Excel

Spreadsheet Financial modeling has become an important and prevalent element in financial industry. The ability to design simple to advanced financial models in excel has become an essential tool to the finance profession. As such, this course provides students with a hands-on tool to design and implement financial models in excel based on essential topics in finance. These topics include: financial statements and analysis; cash budgeting; financial forecasting; time vale of money; stock valuation; bond valuation; cost of capital; capital budgeting; risk analysis; capital budgeting; portfolio diversification; and many more excel functions useful in carrying out financial analysis in practice. This course requires the basic knowledge of excel and finance.

Credits

3

Prerequisite

FIN 332 & FIN 334