Excel NOMINAL Function

The Excel NOMINAL function is used to calculate the nominal annual rate (i) required to give an effective annual rate (r), allowing for a given number of compounding periods each year (m). The effective rate allows for compounding, whereas the nominal rate does not allow for compounding.

Excel NOMINAL Function November 6th, 2016Team
Read more

Excel PV Function

The Excel PV function is one of many Excel financial functions, and can be used to calculate the present value in excel of a lump sum, an annuity, or an annuity due. It has the syntax PV (Rate, Nper, Pmt, FV, Type).

Excel PV Function November 6th, 2016Team
Read more

Excel RATE Function

The Excel RATE function is used to calculate the discount rate (i) in time value of money calculations. For example, it can calculate the interest rate on a loan given the value of the loan, the term and the periodic payments, it can be used to calculate the interest rate earned on a savings account, or the interest rate needed to generate annuity payments from a lump sum investment.

Excel RATE Function November 6th, 2016Team
Read more

Excel FV Function

The Excel FV function is one of many Excel financial functions, and can be used to calculate the present value in excel of a lump sum, an annuity, or an annuity due. It has the syntax FV (Rate, Nper, Pmt, PV, Type).

Excel FV Function November 6th, 2016Team
Read more

Excel NPV Function

The Excel NPV function is used to calculate the present value of unequal cash flows in time value of money calculations.

To calculate the net present value of a project, the original investment at the start of the project needs to be deducted from the answer provided by the Excel NPV function.

Excel NPV Function November 6th, 2016Team
Read more

Excel NPER Function

The Excel NPER function is one of many Excel financial functions, and can be used to calculate the number of periods for a lump sum, annuity or annuity due to grow to a future value. In addition the function can also be used to calculate the number of periods it takes for a loan to be repaid.

Excel NPER Function November 6th, 2016Team
Read more

Excel PMT Function

The Excel PMT function is used to calculate the payment (Pmt) in time value of money calculations. For example, it can calculate the payments needed to clear a loan balance, the deposits to a savings account to grow to a future value, or annuity and annuity due payments from a lump sum investment.

Excel PMT Function November 6th, 2016Team
Read more

Excel IRR Function

The Excel IRR function is used to calculate internal rate of return for a range of cash flows in time value of money calculations, and has the syntax IRR (Values, Guess).

Care must be taken when using the Excel IRR function with cash flows that change sign multiple times though out the term of the project, as it can produce meaningless solutions.

Excel IRR Function November 6th, 2016Team
Read more

Excel YIELD Function

The Excel YIELD to maturity function is used to calculate the yield to maturity for a bond, and has the syntax YIELD (Settlement, Maturity, Rate, Pr, Redemption, Frequency, Basis).

Excel YIELD Function November 6th, 2016Team
Read more

Excel EFFECT Function

The Excel EFFECT function is used to calculate the effective annual rate from the nominal annual rate based on the number of compounding periods in a year. The effective annual rate allows for compounding, whereas the nominal annual rate does not allow for compounding.

Excel EFFECT Function November 6th, 2016Team
Read more

You May Also Like


Related pages


aged receivables reportperpetuities calculatorerrors in bank reconciliation statementhow to prepare a schedule of accounts receivablehow to record allowance for doubtful accountsnet relizable valuehow do you calculate ending inventorygearing ratio analysisformula for gearing ratiotrade receivables formulatimesheet sample templatesample of income statement in exceldouble entry for debit notecalculating depreciation straight linescrap value accountingcapitalized lease accountingcalculate simple paybacktimesheet template pdfsubsidiary ledgers and special journalsvariable manufacturing overhead efficiency variancedebtors control accountscalculate depreciation straight line methodbond discount amortization schedulewhat is grn in inventorycredit sales journal entryformula of accounting equationtemplate for receipt of moneydays receivables formulaaccounts flowchartcalculating annuity present valuefv annuity formulasimple payback calculationcompute accounts receivable turnoverselling inventory journal entrywhat is unearned revenue on a balance sheetbad debt expense income statement examplehow to journalize transactions in accountingwhat is amortisation of goodwillcash flow statement calculator excelaccounting intangibleswhat is the meaning of brs in accountinginterest coverage ratio formula examplesalvage value in depreciationoperating lease calculatorformula for unit contribution marginallowance for uncollectible accounts t accountsample of general ledger sheethow to calculate interest rate in excelledger debithow to calculate creditors turnover ratioreorder point calculation examplejournal debit creditchart of accounts template canadaobsolescence stockcalculate the contribution margin per unitaccounting trial balance worksheethow to calculate irr on exceloperative leveragedebits and credits accountingbookkeeping sample testaged accounts payablehorizontal analysis excelmanufacturing variancesaccrual and prepaymentspresent value and future value formulaaccrual accounting entriesleverage ratio formula for bankspetty cash balance sheet examplemoh costbond repayment scheduledays sales in inventory formulasubsidiary ledgerscrap disposal formatamortised definitionmargin vs markup tableunits of production calculatordebtors control account formatexcel payback period