Computing apps Final

Computing apps Final - Computing apps Final Internal Rate...

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

View Full Document Right Arrow Icon
Computing apps Final Internal Rate of Return (IRR) Q: You buy a tattoo ink gun for $4000. You plan to make $1000 in year 1,$2000 in year 2, $3000 in both year 3 and 4. What is your internal rate of return? Year 0 ($4,000) Year 1 $1,000.00 Year 2 $2,000.00 Year 3 $3,000.00 Year 4 $3,000.00 A: IRR(A1:A5) INT chops off the decimal portion of a real number (rounds down). Ex. 5.612226 INT(A1) = 5 MOD returns the remainder of a long division problem. Ex. MOD(26,5) = 1 (remainder) Pseudo-Random Number Generation MOD(A*Z,M) Where A and M are constants. Z is the previous generated random number. Ex. Let a=5 and m=17 4 MOD(5*4,17) = 3 Rand Generates a real number between 0 and 1. RAND() = 0.342402 *NEVER USE RANDBETWEEN WITH REAL VALUES! (real=decimals)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Text Functions Ex. aNDrEw K. UPPER (A1) =ANDREW K. LOWER (A1) = andrew k. PROPER (A1) = Andrew K. Ex. Stephanie C. Frahme LOWER(LEFT(A15,1) & LEFT(B15,1) & LEFT(C15,6)) = scfrahme Materials from Test 1 Model for a cell is the manner in which the cell’s data is stored on the computer’s hard disk. A
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/27/2009 for the course BA 212 taught by Professor Bradcupp during the Spring '09 term at Pepperdine.

Page1 / 7

Computing apps Final - Computing apps Final Internal Rate...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online