Financial Models
(FIN 421)

Ribbon

The Financial Models course focuses on building computerized models to solve commonly encountered financial problems.  The use of databases (e.g., Microsoft Access) and electronic spreadsheets (Microsoft Excel) are emphasized in the course.  See the items below for more details.

Keyboard

Ribbon

Syllabus    Syllabus for FIN 421

Discussion Forum    Discussion Forum

 

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)

Class Databases

Database from September 15th, 2008 Class

Database from September 22nd, 2008 Class

Database from September 29th, 2008 Class

Videos

Option Groups (17.5 minutes)

Major Graded Database Assignment:

MSU Bookstore assignment

 

MS Excel (Spreadsheet) Section

Practice Problems:

Amortization Schedule
Bond Valuation
Taxes
Pivot Table Example
 

Major Graded Spreadsheet Assignment:

To be announced

 

Home   Return to Larry Guin's Home Page