Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
4 Cards in this Set
- Front
- Back
Finance Functions
(For annuities) interest rate? # of periods? payment? Present Value? Future Value? |
=RATE(nper,pmt,pv,fv,type)
=NPER(rate,pmt,pv,fv,type) =PMT(rate,nper,pv,fv,type) =PV(rate,nper,pmt,fv,type) =FV(rate,nper,pmt,pv,type) *type means either 0 or 1. 0, the default, indicates payments made at the end of period. 1 means payments made at the beginning (annuity due) |
|
Calculating interest for a specified period?
Calculating principal payments for a specified period? Calculating cumulative interest / principal paid on a loan? Calculating SL Depreciation? DDB Depreciation? True/False: Creating named ranges from selection is in the Data tab. You can name a range locally or globally throughout the worksheet. They are not case sensitive. They must begin with a _____, _____ or _____. _, _, or any cell references may not be used. |
=PPMT(rate,period,nper,pv,fv,type)
=IPMT(rate,period,nper,pv,fv,type) =CUMIPMT/CUMPRINC(rate, nper, pv, start period, end period, type) =SLN(cost,salvage,life) =DDB(cost, salvage, life, period, factor) False (Formula) letter, underscore, backslash; C, R, |
|
Calculating Net Present Value?
Calculating IRR? |
=NPV(hurdle rate,value1,value2...)
*to avoid trouble take the initial cash outflow and subtract it from this equation (starts at end of first year) =IRR(values, guess) *values must include 1 pos. and 1 neg. #. guess is optional. |
|
A _____ is additional money required from the borrower at the end of a loan.
_____ is the sum of the cash flows, excluding the initial investment, divided by the investment value True / False: You can define a range name for a value not listed in a worksheet. he _____ is the time it will take to earn sufficient profits so that the loan can be repaid. Print Titles under the ___________ tab allows you to repeat columns / rows across all data |
balloon payment
ROI True payback period Page Layout |