Excel modeling in investments

Author(s)

    • Holden, Craig W.

Bibliographic Information

Excel modeling in investments

Craig W. Holden

(The Prentice Hall series in finance)

Pearson, c2015

5th ed

Available at  / 2 libraries

Search this Book/Journal

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"

Related Books: 1-1 of 1

Details

Page Top