Excel modeling in investments
Author(s)
Bibliographic Information
Excel modeling in investments
(The Prentice Hall series in finance)
Pearson, c2012
4th ed
Available at 2 libraries
  Aomori
  Iwate
  Miyagi
  Akita
  Yamagata
  Fukushima
  Ibaraki
  Tochigi
  Gunma
  Saitama
  Chiba
  Tokyo
  Kanagawa
  Niigata
  Toyama
  Ishikawa
  Fukui
  Yamanashi
  Nagano
  Gifu
  Shizuoka
  Aichi
  Mie
  Shiga
  Kyoto
  Osaka
  Hyogo
  Nara
  Wakayama
  Tottori
  Shimane
  Okayama
  Hiroshima
  Yamaguchi
  Tokushima
  Kagawa
  Ehime
  Kochi
  Fukuoka
  Saga
  Nagasaki
  Kumamoto
  Oita
  Miyazaki
  Kagoshima
  Okinawa
  Korea
  China
  Thailand
  United Kingdom
  Germany
  Switzerland
  France
  Belgium
  Netherlands
  Sweden
  Norway
  United States of America
Description and Table of Contents
Description
An approach to building and estimating models through the use of Excel.
Excel Modeling in Investments focuses on active learning by showing readers how to build and estimate financial models using Excel. This approach shows the steps involved in building models, rather than solely providing readers with completed spreadsheets.
This edition contains new content on investments.
Table of Contents
PART 1: BONDS/FIXED INCOME SECURITIES
Chapter 1: Bond Pricing
Chapter 2: The Yield Curve
Chapter 3: Affine Yield Curve Models
PART 2: PORTFOLIO MANAGEMENT
Chapter 4: Portfolio Optimization
Chapter 5: Constrained Portfolio Optimization
Chapter 6: Portfolio Diversification Lowers Risk
PART 3: SECURITY ANALYSIS
Chapter 7: Stock Valuation
Chapter 8: DuPont System Of Ratio Analysis
PART 4: STOCKS
Chapter 9: Asset Pricing
Chapter 10: Market Microstructure
Chapter 11: Life-Cycle Financial Planning
PART 5: INTERNATIONAL INVESTMENTS
Chapter 12: International Parity
Chapter 13: Swaps
PART 6: OPTIONS, FUTURES, AND OTHER DERIVATIVES
Chapter 14: Option Payoffs and Profits
Chapter 15: Option Trading Strategies
Chapter 16: Put-Call Parity
Chapter 17: Binomial Option Pricing
Chapter 18: Black-Scholes Option Pricing
Chapter 19: Futures
Chapter 20: Pricing By Simulation
CONTENTS ON CD
Chapter 21: Corporate Bonds
PART 7: EXCEL SKILLS
Chapter 22: Useful Excel Tricks
by "Nielsen BookData"