Excel Modeling in the Fundamentals of Investments Book and CD-ROM
2nd Edition
Published on 5. July 2005
Book
Mixed media product
978-0-13-161138-2 (ISBN)
Description
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.
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.
More details
Edition
2nd edition
Language
English
Place of publication
Upper Saddle River
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
Weight
388 gr
ISBN-13
978-0-13-161138-2 (9780131611382)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Craig W. Holden
Excel Modeling and Estimation in the Fundamentals of Investments
Book
05/2008
3rd Edition
Pearson
€48.10
Article is exhausted; no reprint
Previous edition
Book
04/2001
Pearson
€25.53
Article exhausted; check for reprint
Content
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.
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.