MIS FINAL REVIEW - In Chapter 5 you should understand the...

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

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

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

View Full DocumentRight Arrow Icon
solves 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)
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.

Page1 / 5

MIS FINAL REVIEW - In Chapter 5 you should understand the...

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