| 
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
04
Quick Overview (Aug 24)
Chapter 1 (Aug 26) Excel
Files:
Excel Basics
Solutions to
Homework Assignment
Chapter 2 (Aug 31 and Sep 2) Excel Files: Building
the IS
Building the BS
Building the SCF
All Financial Statements
Solutions to
Homework Assignment
Chapter 3 (Sep 9 and 14) Excel Files:
Building
the Cash Budget
Cash Budget (complex)
Complete Dataset for
Chapter 3
Solutions to
Homework Assignment
Chapter 4 (Sep 16 and 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 23) Excel Files:
Data for Case Study
Exam 1 (Sep 28)
Review for Exam 1
Sample
Questions for Exam 1 (with answers)
Chapter 5 (Sep 30 and Oct 5)
Excel Files:
Financial Statement
Forecasting
Solutions to
Homework Assignment
Chapter 6 (Oct 7 and 12) Excel Files:
Examples
Solutions to
Homework Assignment
Chapter 7 (Oct 12 and 14) Excel Files:
Examples
Solutions to
Homework Assignment
Chapter 8 (Oct 19 and 21)
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 21, 26, and
28) 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 2)
Review for Exam
2
Sample
Questions for Exam 2 (with answers)
Chapter 10 (Nov 4) Excel Files:
Examples
Solutions to
Homework Assignment
Project
Part II Outline (this part due November 30, 2009)
Case Study for Valuation Chapters (Nov
9) Excel Files:
Data for Case Study
Chapter 11
(Nov 16 and 18) Excel Files:
Examples
MIRR Examples
Solutions to
Homework Assignment
Chapter 12 (Nov 23 and 25) 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
|
