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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
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

This note was uploaded on 04/22/2011 for the course BBA FIN 423 taught by Professor Mahmudulhaque during the Spring '11 term at BRAC University.

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 Right Arrow Icon
Ask a homework question - tutors are online