Skip to main content

AFF 714

Financial Modeling II

This course will provide students with an introduction to effectively using Excel to solve many common problems that arise in finance and investments. The course will provide students with an overview of what is involved in creating an effective financial model. Students will then apply these financial modeling guidelines to a variety of investment problems. The student will also be given an introduction to Visual Basic and how it can add to the effectives of financial modeling with Excel. The student will gain an insight into how to more effectively use Excel to analyze some common investment problems. In addition the student will learn how through effective financial modeling solutions to financial problems, can be tested to see how sensitive the solution is to the assumptions made in the model. As well, the student will learn how to present clearly and effectively the results of their financial modeling analysis. The course will build upon what the student has learned in AFF 514.
Weekly Contact: Lab:3 hrs.
GPA Weight: 1.00
Course Count: 1.00
Billing Units: 1

Prerequisites

AFF 501 and AFF 514

Antirequisites

FIN 731

Co-Requisites

None

Custom Requisites

None

Mentioned in the Following Calendar Pages

*List may not include courses that are on a common table shared between programs.

Finance