HelpFeedback
Excel Applications in Invsmnts
Information Center
Table of Contents


Excel Applications for Investments

Troy A. Adair, Jr., University of Michigan

ISBN: 0073530573
Copyright year: 2006

Table of Contents



PART I -- EXCEL: SETTING THE STAGE

Chapter 1 -- Making and Using Spreadsheets
Chapter 2 -- Bringing Data into Excel

PART II -- RISK AND RETURN

Chapter 3 -- Measuring Risk and Return
Chapter 4 -- Compounding and Interest Rate Conversion
Chapter 5 -- Portfolio Selection with Only Risky Portfolios
Chapter 6 -- Portfolio Selection with a Risk-Free Asset

PART III -- BONDS AND OTHER FIXED-INCOME SECURITIES

Chapter 7 -- Valuing Fixed-Income Securities
Chapter 8 -- Duration and Convexity
Chapter 9 -- Analyzing the Term Structure and Implicit Forward Rates

PART IV -- STOCKS

Chapter 10 -- Calculating Beta
Chapter 11 -- The Capital Asset Pricing Model
Chapter 12 -- Arbitrage Pricing Theory
Chapter 13 -- The Dividend Discount Model
Chapter 14 -- Ratio Analysis and Comparables

PART V -- OPTIONS POSITION PAYOFFS and PROFITS

Chapter 15 -- Option Position Payoffs and Profits
Chapter 16 -- Binomial Option Pricing
Chapter 17 -- Black-Scholes Option Pricing
Chapter 18 -- Futures and Forward Contracts
Chapter 19 -- Analyzing Swap Contracts


To obtain an instructor login for this Online Learning Center, ask your local sales representative. If you're an instructor thinking about adopting this textbook, request a free copy for review.