Excel applications for investment

Instructions on how to build a financial model in Excel. Shows how to use these models to solve common investment problems. Instructions for using spreadsheets, putting data into Excel. Assess risk and return. Assess the safety of equities and fixed incomes. Calculating, analyzing equity capital, contracts...

Excel applications for investment

Troy A. Adain, Jr

Mc Graw Hill

2006

Abstract

Instructions on how to build a financial model in Excel. Shows how to use these models to solve common investment problems. Instructions for using spreadsheets, putting data into Excel. Assess risk and return. Assess the safety of equities and fixed incomes. Calculating, analyzing equity capital, contracts...

The main content of the book is presented in the following 5 parts:

+ Part 1: Excel setting the stage: Making and using spreadsheets, bringing data in to excel.

+ Part 2: Risk and return: measuring risk and return, compounding and interest rate conversion, portfolio selection with a risk free asset.

+ Part 3: Bonds and other fixed income securities: valuing fixed income securities, duration and convexity, analyzing th term structure and implicit forward rates.

+ Part 4: Stocks: Calculating beta, the capital asset pricing model, arbitrage pricing theory, the dividend discount model, ratio analysis and comparables.

+ Part 5: Options, futures and other derivative securities.

Citation

Troy A. Adain, Jr. Excel applications for investment. Mc Graw Hill, 2006.

Collection

Bộ sưu tập Công nghệ Thông tin

Related document

Excel applications for investment	Operating System Concepts, 10th Edition	Database Fundamentals

QR code

Content