| 
Welcome to the web site for the Financial Models class.
Here you will
find the Syllabus, Lecture Notes, and other class material. Enjoy your
visit.
If you do not have Adobe Acrobat Reader, you can get it from
here:
If you want to get the lecture notes in Microsoft Word format,
go here:
 .
Syllabus for FIN 4453 Section
01
Quick Overview and
Chapter 1 (Aug 24)
Excel Files:
Excel Basics
Solutions to
Homework Assignment
Chapter 2 (Aug 31) Excel Files: Building
the IS
Building the BS
Building the SCF
All Financial Statements
Solutions to
Homework Assignment
Chapter 3 (Sep 14) Excel Files:
Building
the Cash Budget
Cash Budget (complex)
Complete Dataset for
Chapter 3
Solutions to
Homework Assignment
Chapter 4 (Sep 21) Excel Files:
Example
Current Ratio for Healthcare
Firms Delta's Z-Score
Z-Scores for Apparel Industry
How accurate is the Z-score?
Solutions to
Homework Assignment
Project
Part I Outline (this part due October 26, 2009)
Case Study for Chapter 4 (Sep 28) Excel Files:
Data for Case Study
Chapter 5 (Sep 28 and October
12)
Excel Files:
Financial Statement
Forecasting
Solutions to
Homework Assignment
Exam 1 (Oct 5)
Review for Exam 1
Sample
Questions for Exam 1 (with answers)
Chapter 6 (Oct 12 and 19) Excel Files:
Examples
Solutions to
Homework Assignment
Chapter 7 (Oct 19) Excel Files:
Examples
Solutions to
Homework Assignment
Chapter 8 (Oct 26)
Excel Files:
Examples
Excel Macro (from textbook, needed
to open other files)
Solutions to
Homework Assignment (you will need to save and open the Excel Macro from
above for some of the answers here)
Chapter 9 (Oct 26 and Nov 2) Excel
Files:
Bond Examples
Textbook Examples
Solutions to
Homework Assignment
Treasuries Links: (1)
(2)
You can also find more detailed quotes on treasuries in the Wall
Street Journal web site http://online.wsj.com. Go to Markets -> Market Data -> Bonds, Rates, &
Credit Markets. Click on "See Full Daily Closing Prices" for quotes on
individual treasuries.
Inflation
Forecast Link
Exam 2 (Nov 9)
Review for Exam
2
Sample
Questions for Exam 2 (with answers)
Project
Part II Outline (this part due November 30, 2009)
Chapter 10 (Nov 16) Excel Files:
Examples
Solutions to
Homework Assignment
Case Study for Valuation Chapters (Nov
16) Excel Files:
Data for Case Study
Chapter 11
(Nov 23) Excel Files:
Examples
MIRR Examples
Solutions to
Homework Assignment
Chapter 12 (Nov 30) Excel Files:
Examples
More Examples
Excel Macro
Solutions to
Homework Assignment
Chapter 13 (Nov 30) Excel Files:
Examples
Solutions to
Homework Assignment
Case Study for Portfolio Models
(Dec 7) Excel Files:
Data for Case Study
How to create macro and
button
Links of Interest:
http://finance.yahoo.com/ -
Yahoo! provides links to the SEC filings of firms where you can find all
necessary financial statements.
http://www.netadvantage.standardandpoors.com/ - Standard & Poor's
provides good analysis for individual stocks as well as whole industries.
Templates for Excel: Here you can find useful templates for many business
applications.
Grading Spreadsheet
|
