Financial Models
(FIN 621)

Ribbon

The Financial Models course focuses on building computerized models to solve a variety of financial problems.  The use of databases (e.g., Microsoft Access) and electronic spreadsheets (Microsoft Excel) are emphasized in the course.  The course differs from the undergraduate version in the depth of coverage and types of assignments.

Ribbon

Syllabus    Syllabus for FIN 621

 

MS Access (Database) Section

Microsoft Access Features (and FAQs)

Database Query Matchups

Sample Databases:

Address Book (option groups)
Webpro Shoes (comprehensive)
Drug Testing Co. (comprehensive)
Investment Counseling Co. (comprehensive)
Galaxy Furniture (comprehensive)

Practice Problems:

A Table with Data
A Basic Illustration
Birthdays (parameter query)
Car Testing Company (relationships)

 

MS Excel (Spreadsheet) Section

Practice Problems:

Amortization Schedule
Bond Valuation
Taxes
Intrinsic Value
Valuation Model (using Value Line data)
Pivot Table
Pivot Table Data for Lease vs. Buy Assignment
 

Home   Return to Larry Guin's Home Page