In Chapter 5 you should understand the functions:
n
VLOOKUP
(LOOKUP_VALUE, TABLE_ARRAY, COL_INDEX_NUM, RANGE_LOOKUP)
Search specified part of worksheet vertically
(
HLOOKUP
(LOOKUP_VALUE, TABLE_ARRAY, ROW_INDEX_NUM, RANGE_LOOKUP)
Similar to vlookup except it searches a horizontal lookup table in which data is stored
in rows instead of columns
(
LOOKUP
(LOOKUP_VALUE, LOOKUP_VECTOR, RESULT_VECTOR)
Looks up the greatest value that doesn’t exceed a specified value anywhere in a table/
range
(
INDEX
(REFERENCE, ROW_NUM, COLUMN_NUM, AREA_NUM)
Returns the value in a table based on the row and column numbers that you specify (allows to
retrieve data from multidimensional tables)
(
CHOOSE
(INDEX_NUM, VALUE1, VALUE2, …)
Reference/Lookup function that can return a value or range for up to 29 different values
(
ISBLANK
(VALUE)
To check if a specified range exists
(
In Chapter 6 you should be familiar with financial concepts of interest (simple or
compound), principal, amortization schedules, cash flows
Simple Interest=
interest that is paid soley on the amount of the original principal value
principal * Interest rate per time period * # of periods
Compound Interest=
adding interest earned each period to the principal
Annual Percentage Yield
Yearly simple interest rate taking into account compounding
Annual Percentage Rate
reflects interest being paid on the actual amount borrowed
(
RATE (NPER, PMT, PV, FV, TYPE
Solvers for the interest rate per period
(
NPER (RATE, PMT, PV, FV, TYPE)
solves for the number of periods
(
PMT (RATE, NPER, PV, FV, TYPE)
solves for the value of the payment per period
(
PV (RATE, NPER, PMT, FV, TYPE)
solves for the initial value, the amount in or out at the beginning of the financial
transaction
(
FV (RATE, NPER, PMT, PV, TYPE)
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Documentsolves for the final value, the amount in or out at the end of the financial transaction
(
PPMT (RATE, PER, NPER, PV, FV, TYPE)
principal payment for a specific period
(
IPMT (RATE, PER, NPER, PV, FV, TYPE)
interest payment for a specific period
(
CUMIPMT (RATE, NPER, PV, START_PERIOD, END_PERIOD, TYPE)
cumulative interest paid between start_period and end_period
(
CUMPRINC (RATE, NPER, PV, START_PERIOD, END_PERIOD, TYPE)
cumulative principal paid between start_period and end_period
(
SLN (COST, SALVAGE, LIFE)
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '08
 PRIEST
 Net Present Value, Variable Data Tables, original principal value

Click to edit the document details