## 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, 2016

## 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, 2016

## 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, 2016

## 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, 2016

## 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, 2016

## 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, 2016

## 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, 2016

## 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, 2016

## 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, 2016

## 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, 2016

## Related pages

bank reconciliation statement is prepared byannuity due definitionseries discount calculatorfreight collect shipping termexplanation of accounting cycleexamples of double entry bookkeepingdeclining balance depreciation calculatorcompute inventory turnoverbad debt write offspv growing annuitycommon size analysis of income statementnotes receivable meaningamortisation schedulethe accounting equation explainedinventory held on consignmentissuance of preferred stockvertical analysis income statement calculatordiscount on bonds payable on balance sheetfree payment voucher templatebasic bookkeeping examplesaccumulated depreciation normal balancechart of accounts for non profit organizationbank reconciliation adjusting entriesbasic bookkeeping testwhat is lifo methoddebits and creditsreducing balance loan calculator excel downloadperiodic vs perpetual inventory systemretaining earnings formulastatement of retained earnings equationincome statement spreadsheethow to record accrued expensejournal entry for interest expensescrap value in accountingweighted average formulasdefinition of sundry expensesindirect material in manufacturing processhow to figure straight line depreciationdays sales outstanding ratiocogs percentagecontribution margin statement exampledebt asset ratio calculatorexcel formula irrwhat is a accrued expenselifo reserve exampleaccounting journalizing examplesselling and administrative expenses formulacredit debit chartadjusting journal entries practicewhat is prepaid insurancepv calculator annuitypetty cash in balance sheetfactoring of accounts receivable definitionunearned service revenue journal entryperpetuity present value formuladays sales in receivablescalculate the payback period for each projectbank reconciliation tutorialdouble column cash book formatdividend payout formulajurnal account payableincome statement projection templateadvantages of subsidiary bookspmt examplepv in excelnet realizable value formulacalculate net realizable valueprice volume varianceexpenses template small businessformula roceformula for total fixed costdebits credits accountinghow to calculate pv of annuityamortization for intangible assetsno coupon bondformula of arrstock turnover period formulasample of a petty cash voucherwhat is controllable margin