{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

excel_locations

# excel_locations - Ch 4 Details on Data Tables Discusses...

This preview shows pages 1–2. Sign up to view the full content.

Excel Locations 3/17/03 We explain and illustrate various Excel functions and operations in different BOC models, as the need fo arise. We provide here a listing of the various operations and indicate where they are found. Some opera in many of our models. In those cases, we list the first model in which the operation is explained, along w models where it may be explained in greater detail or with different twists. Topic: Comments Rate function Ch 1 Very basic PV function Ch 1 Very basic NPV function Ch 1 Very basic IRR function Ch 1 Very basic LINEST function Ch 2 Used to get beta; In general, used to find slope of line. LOGEST function Ch 8 Used to find growth rate. Chart; Scatter Ch 2 Used to plot beta graphs; minimal explanations Data tables Ch 3 Show returns and risk for different portfolio weights. Bond Yield function Ch 4 Details on how to calculate YTM and YTC Bond price function Ch 4 Details on how to calculate a bond's price Date function Ch 4 Discusses DATEVALUE to get exact periods to maturity. Data tables

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Ch 4 Details on Data Tables. Discusses 1-variable and 2-variable tables. Gr Duration function Ch 4 Discusses use of the Excel bond duration function. Goal Seek Ch 5 Explains use of Goal Seek to find the input value that forces the outpu Scenario Analysis Ch 8, 10 Explains how to use Excel's Scenario Manager tool to do a scenario an IF and AND functions Ch 11,13 Explains and illustrates how to use Excel's IF and AND functions. Growth rates Ch 8 Uses LOGEST to find a growth rate. Ln function Ch 13 Uses the Math function for the natural log. Shows other math function NORMDIST Ch 13 Uses the Statistical normal distribution function for option valuation. STDEVP Ch 14 Uses the standard deviation function with probability data. VLOOKUP Ch 14 Explains VLOOKUP and uses it to find the interest rate at a specified Where covered or the functions ations are used ith other raphs results. ut to given level. nalysis. ons. debt ratio....
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

excel_locations - Ch 4 Details on Data Tables Discusses...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online