FREE SPREADSHEET
MODELS (EXCEL
FILES) To save these files to your
hard disk, click on the link and then click on Save in the File
Download dialog box.
1.
Dynamic Chart of US Yield Curve Dynamics* Monthly US
Yield Curves from Jan 1970 to Dec 2004. Dynamic Chart lets you see a "movie"
of how they have changed over 35 years.
2.
Dynamic
Chart of Portfolio Optimization
An
"animated" chart illustrates the Mean-Variance comparative statics. That is,
how changes in the inputs (means, standard deviations, and correlations)
effect the efficient frontier and the weights of the tangent portfolio.
3. Dynamic
Chart of Black Scholes Option Pricing An "animated" chart
illustrates the Black Sholes comparative statics. That is, how changes in
the inputs (standard deviations, riskfree rate, exercise price, and time to
maturity) effect the value of a call or put option.
Learn about Craig Holden's Invention
of Dynamic Charts
* Copyright © 2005 Craig W. Holden. -- updated through the
end of Dec 2004.
FREE SAMPLES OF MY BOOKS
|
EXCEL MODELING IN CORPORATE FINANCE,
SECOND
EDITION
-
Contents,
Preface,
Desk Copy,
Testimonials,
Purchase
on Amazon. Chapter
9 U.S.
Yield Curve Dynamics Chapter 10 Project
NPV |
EXCEL MODELING IN INVESTMENTS,
SECOND
EDITION
-
Contents,
Preface,
Free Samples, Desk Copy,
Testimonials,
Purchase on Amazon. Chapter 9 Portfolio
Optimization |