|
| Course ID: | FINA 4920. 3 hours. | | Course Title: | Computers in Finance | Course
Description: | Applying computers to business applications especially using
Excel in finance related work. | | Oasis Title: | COMPUTERS IN FINA | | Nontraditional Format: | Directed study not involving lecture or laboratory. | | Prerequisite: | FINA 3000 or FINA 3000H | Semester Course
Offered: | Offered every year. | | Grading System: | A-F (Traditional) |
| | Course Objectives: | The goal is for finance majors to apply the concepts of investments, small business
finance, and corporate finance into an Excel framework. The student will also be
able to write documents describing results created in Excel. | | Topical Outline: | Retirement planning; Mortgage Re-financing; Graphing in Excel; Cost of Equity; Beta;
WACC; Cost of Debt; Financial forecasting; Project cash flows; Sales forecasts;
Inventory management; Work scheduling; Portfolio optimization; Financial ratio
analysis; Yield curve dynamics; Real options; Binomial option pricing; Project
selection methods; Repeatable projects; Interest rate parity; and Monte Carlo
simulations | |
Syllabus:
|