EXCEL MODELING AND ESTIMATION IN THE FUNDAMENTALS OF INVESTMENTS,

THIRD EDITION - Contents   Preface,  Desk Copy,  Purchase on Amazon,  Free US Yield Curve Dynamics.

PART 1  BONDS / FIXED INCOME SECURITIES     1

Chapter 1  Bond Pricing     1 
                             1.1  Annual Payments     1
                             1.2  APR and EAR    2
                             1.3  By Yield To Maturity     3
                             1.4  Dynamic Chart     4
                             1.4  System of Five Bond Variables     5
                             Problems     7
Chapter 2  Bond Duration     8
                             2.1  Basics     8
                             2.2  Price Sensitivity Using Duration     10
                             2.3  Dynamic Chart     12
                             Problems     14
Chapter 3  Bond Convexity     15 
                             3.1  Basics     15
                             3.2  Price Sensitivity Including Convexity     16
                             3.3  Dynamic Chart     19
                             Problems     21
Chapter 4  U.S. Yield Curve Dynamics     22 
                             4.1  Dynamic Chart     22
                             Problems    28
 

PART 2  STOCKS / SECURITY ANALYSIS     30

Chapter 5  Portfolio Optimization     30
                              5.1  Two Risky Assets and a Riskfree Asset     30
                              5.2  Descriptive Statistics     33
                              5.3  Many Risky Assets and a Riskfree Asset     38
                              Problems     49
Chapter 6  Constrained Portfolio Optimization     51
                              6.1  No Short Sales, No Borrowing, and Other Constraints     51
                              Problems     67
Chapter 7  Asset Pricing     68
                              7.1  Static CAPM Using Fama-MacBeth Method     68
                              7.2  APT or Intertemporal CAPM Using Fama-MacBeth Method     73
                              Problems     80
Chapter 8  Trading Simulations using @RISK     82
                              8.1  Trader Simulation     82
                              8.2  Dealer Simulation     98
Chapter 9 Portfolio Diversification Lowers Risk     116  
                              9.1  Basics     116
                              9.2  International     118
                              Problems     120 
Chapter 10 Life-Cycle Financial Planning     121
                              10.1  Basics     121
                              10.2  Full-Scale Estimation   123
                              Problems     131
Chapter 11 Dividend Discount Models     132
                              11.1  Dividend Discount Model     132
                              Problems     133
 

PART 3  OPTIONS / FUTURES / DERIVATIVES     134

Chapter 12 Options Payoffs and Profits     134
                             12.1  Basics     134
                              Problems     136
Chapter 13 Option Trading Strategies     137  
                              13.1  Two Assets     137
                              13.2  Four Assets     142
                              Problems     146
Chapter 14 Put-Call Parity     149
                              14.1  Basics     149 
                              14.2  Payoff Diagram     149  
                              Problems     151
Chapter 15 Binomial Option Pricing     152
                              15.1  Estimating Volatility     152
                              15.2  Single Period     153
                              15.3  Multi-Period     156
                              15.4  Risk Neutral     161
                              15.5  American With Discrete Dividends     164
                              15.6  Full-Scale Real Data     168
                              Problems     176
Chapter 16 Black Scholes Option Pricing     178
                              16.1  Basics     178
                              16.2  Continuous Dividend     179
                              16.3  Greeks     182
                              16.4  Implied Volatility     188
                              16.5  Exotic Options    190
                              Problems     197
Chapter 17 Spot-Futures Parity (Cost of Carry)     199
                              17.1  Basics     199
                              17.2  Index Arbitrage     201
                              Problems     202

PART 4  EXCEL SKILLS     203

Chapter 18 Useful Excel Tricks     203
                              18.1  Quickly Delete The Instruction Boxes and Arrows     203
                              18.2  Freeze Panes     203
                              18.3  Spin Buttons and the Developer Tab     204
                              18.4  Option Buttons and Group Boxes     205
                              18.5  Scroll Bar     207
                              18.6  Install Solver or the Analysis ToolPak     208
                              18.7  Format Painter     208
                              18.8  Conditional Formatting     209
                              18.9  Fill Handle     210
                              18.10  2-D Scatter Chart     210
                              18.11  3-D Scatter Chart     212

CONTENTS ON CD

         Readme.txt
        Excel Mod Est in Fun Inv 3e.pdf
        Ch 01 Bond Pricing.xlsx
        Ch 02 Bond Duration.xlsx
        Ch 03 Bond Convexity.xlsx
        Ch 04 US Yield Curve Dynam.xlsx
        Ch 05-06 Port Optimization.xlsm
        Ch 07 Asset Pricing.xlsm
        Ch 08 Dealer Simulation.xlsm
        Ch 08 Trader Simulation.xlsm
        Ch 09 Portfolio Diversific.xlsx
        Ch 10 Life-Cycle Fin Plan.xlsx
        Ch 11 Div Discount Models.xlsx
        Ch 12 Option Payoff-Profit.xlsx
        Ch 13 Option Trading Strat.xlsx
        Ch 14 Put-Call Parity.xlsx
        Ch 15 Binomial Option Pric.xlsx
        Ch 16 Black Scholes Opt Pr.xlsx
        Ch 17 Spot-Futures Parity.xlsx
        Files in Excel 97-2003 Format