|

Addison-Wesley / Prentice Hall

Business

My Instructor Resource Center :  Log in or request access

Excel Modeling in the Fundamentals of Investments Book and CD-ROM, 2/E
Craig W. HoldenIndiana University

ISBN-10: 0131611380
ISBN-13:  9780131611382

Publisher:  Prentice Hall
Copyright:  2005
Format:  Kit/Package/ShrinkWrap
Published:  01/23/2004
New edition available
  This item has been replaced by Excel Modeling and Estimation in the Fundamentals of Investments, 3/E.



For undergraduate courses in investments.

Excel Modeling in the Fundamentals of Investments is a supplemental book and CD. It teaches students how to build financial models with step-by-step instructions in Excel. It can accompany any undergraduate investments textbook, including textbooks by Alexander, Bodie, Corrando, and Reilly.

  • NEW - Updated coverage—Adds Annual Payments model to the Bond Pricing chapter, adds saving as a percentage of wealth to the Lifetime Financial Planning chapter, updates the yield curve database, updates the tax rates, and updates the dates in all examples.
    • Keeps text up-to-date.

  • Instructions for building financial models, not templates.
    • Students really learn finance by building financial models themselves (active learning), rather than using canned templates which are “black boxes” (passive learning).

  • Every chapter has end-of-chapter problems.
    • Provides students with the opportunity to practice what they have learned.

  • Progression from simple examples to practical, real-world applications—Including Portfolio Optimization that uses real data on 20 stocks to calculate the efficient frontier, the tangent line, the weights of the tangent portfolio, and then graph everything; US Yield Curve Dynamics shows you a "movie" of 30 years of monthly zero-coupon, yield curves highlighting the dynamics of the US yield curve history; Implied Volatilities are calculated from real call and put prices using the Black Scholes Option Pricing model and Excel's Solver. Then the “smile” (or “scowl”) pattern of implied volatilities is graphed.
    • Provides real-world applications that students will be excited about.

  • Can accompany any popular undergraduate investments textbook because the CD provides alternative notation versions—The printed book matches the notation of the Bodie book (Essentials of Investments by Bodie, Kane, and Marcus). The CD contains PDF files with alternative chapters that match the notation of other popular undergraduate investments books, including:
    • Fundamentals of Investments by Alexander, Sharpe, and Bailey

    • Fundamentals of Investments by Corrado and Jordan

    • Investments by Reilly and Norton.

  • Updated coverage—Adds Annual Payments model to the Bond Pricing chapter, adds saving as a percentage of wealth to the Lifetime Financial Planning chapter, updates the yield curve database, updates the tax rates, and updates the dates in all examples.
    • Keeps text up-to-date.

I. BONDS/FIXED INCOME SECURITIES.

1. Reading Bond Listings.

Basics.

2. Bond Pricing.

Annual Payments. APR vs. EAR. By Yield to Maturity. System of Five Bond Variables. Dynamic Chart. Problems.

3. Bond Duration.

Basics. Price Sensitivity Using Duration. Dynamic Chart. Problems.

4. Bond Convexity.

Basics. Price Sensitivity Including Convexity. Dynamic Chart. Problems.

5. Using the Yield Curve.

Dynamic Chart.

II. STOCKS/SECURITY ANALYSIS.

6. Portfolio Optimization.

Two Assets. Many Assets. Dynamic Chart. Full-Scale Real Data. Problems.

7. Portfolio Diversification Lowers Risk.

Basics. International.

8. Life-Cycle Financial Planning.

Basics. Problems.

9. Dividend Discount Models.

Two Stage. Dynamic Chart. Problems.

III. OPTIONS/FUTURES/DERIVATIVES.

10. Options Payoffs and Profits.

Basics. Problems.

11. Option Trading Strategies.

Two Assets. Four Assets. Problems.

12. Put-Call Parity.

Basics. Payoff Diagram. Problems.

13. Binomial Option Pricing.

Single Period. Multi-Period. Risk Neutral. Full-Scale Real Data. Problems.

14. Black Scholes Option Pricing.

Basics. Dynamic Chart. Continuous Dividend. Implied Volatility. Problems.

15. Spot-Futures Parity (Cost of Carry).

Basics. Index Arbitrage. Problems.

Faculty Excel Files, 2/E
Holden
©2005 | Prentice Hall | On-line Supplement | Instock
ISBN-10: 0131424149 | ISBN-13: 9780131424142
URLhttp://www.prenhall.com/holden
  View Downloadable Files



FinCoach 2.0: CD-ROM Edition
Handa
©2002 | Prentice Hall | CD-ROM Only | Instock
ISBN-10: 0130606189 | ISBN-13: 9780130606181
Buy from myPearsonStore


Interwrite Personal Response System
EduCue, Addison-Wesley & Benjamin Cummings
©2004 | Prentice Hall | Electronic Supplement | Instock
ISBN-10: 0321267354 | ISBN-13: 9780321267351


Wall Street Journal User's Guide, The
Addison-Wesley
©2004 | Prentice Hall | Paper | Instock
ISBN-10: 0321267001 | ISBN-13: 9780321267009


This package contains:
•   Holden, Excel Modeling in the Fundamentals of Investments, 2/E (2005)
•   Holden, UG Investments Software CD, 2/E (2005)

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.