This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Spring '11
- Normal Distribution, Probability theory, function Ch