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)
PseudoRandom 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)
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentText 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
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '09
 BRADCUPP
 Depreciation, Internal Rate Of Return (IRR), Andrew K. Ex, view CTRL

Click to edit the document details