Excel Modeling in Investments, Fifth Edition approaches building and estimating models with Microsoft^® Excel^®. Students are shown the steps involved in building models, rather than already-completed spreadsheets.

 

KEY TOPICS: Bond Pricing; The Yield Curve; Affine Yield Curve Models; Portfolio Optimization; Constrained Portfolio Optimization; Portfolio Diversification Lowers Risk; Stock Valuation; DuPont System Of Ratio Analysis; Asset Pricing; Market Microstructure; Life-Cycle Financial Planning; International Parity; Swaps; Option Payoffs and Profits; Option Trading Strategies; Put-Call Parity; Binomial Option Pricing; Black-Scholes Option Pricing; Futures; Pricing By Simulation; Corporate Bonds; Useful Excel Tricks

 

MARKET: Ideal for financial planners and analysts.