Excel modeling in investments
Author(s)
Bibliographic Information
Excel modeling in investments
(The Prentice Hall series in finance)
Pearson, c2015
5th 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
For courses in corporate finance or financial management at the undergraduate and graduate level.
Excel Modeling in Investments, Fifth Edition approaches building and estimating models with Microsoft (R) Excel (R). Students are shown the steps involved in building models, rather than already-completed spreadsheets.
Table of Contents
Preface vii Fifth Edition Changes vii
Ready-To-Build Spreadsheets vii
What Is Unique About This Book xi
Conventions Used In This Book xii
Craig's Challenge xiv
Excel (R) Modeling Books xiv
Suggestions for Faculty Members xiv
Acknowledgements xv
About The Author xvi
PART 1 BONDS / FIXED INCOME SECURITIES 1
Chapter 1 Bond Pricing 1
1.1 Annual Payments 1
1.2 EAR, APR, and Foreign Currencies 2
1.3 Duration and Convexity 7
1.4 Price Sensitivity 9
1.5 Immunization 11
1.6 System of Five Bond Variables 17
Problems 18
Chapter 2 The Yield Curve 21
2.1 Obtaining It From Treasury Bills and Strips 21
2.2 Using It To Price A Coupon Bond 22
2.3 Using It To Determine Forward Rates 23
Problems 24
Chapter 3 Affine Yield Curve Models 25
3.1 US Yield Curve Dynamics 25
3.2 The Vasicek Model 30
3.3 The Cox-Ingersoll-Ross Model 32
Problems 34
PART 2 PORTFOLIO MANAGEMENT 35
Chapter 4 Portfolio Optimization 35
4.1 Two Risky Assets and a Riskfree Asset 35
4.2 Descriptive Statistics 38
4.3 Many Risky Assets and a Riskfree Asset 42
4.4 Any Number of Risky Assets 52
Problems 57
Chapter 5 Constrained Portfolio Optimization 58
5.1 No Short Sales, No Borrowing, and Other Constraints 58
5.2 Any Number of Risky Assets 68
Problems 77
Chapter 6 Portfolio Performance 78
6.1 Evaluation Measures 78
Problems 80
Chapter 7 Portfolio Diversification Lowers Risk 81
7.1 Basics 81
7.2 International 82
Problems 84
PART 3 SECURITY ANALYSIS 85
Chapter 8 Stock Valuation 85
8.1 Dividend Discount Mode
by "Nielsen BookData"