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


retained earninghow to solve bank reconciliation statementaverage inventory turnover formulameaning of unpresented chequeaccounts receivable aging templateaccounting objectivity principlepurchasing price variancedividend paid journal entrycalculating the effective annual rateexcel pmt function formulagearing ratio calculationadvantages and disadvantages of pay back periodppe disposalaccounts receivable turnover ratio measuressales ledger control account formatbalance sheet excel formulasjournal entry for invoicereducing balance loan calculator excel downloadhow to calculate percentage of completion in excelincome tax provision journal entryis unearned revenue a liabilitycash flow balance sheet templatewhat does sales ledger meanreceivables turnover ratio industry averagemark up calculatorroyalty revenue accountingexamples of accrued expensesnotes receivable definitioncost volume profit formulaamortization accounting treatmentpv of annuity tableinventory shrinkage rateaccounts receivable sampleaccrual accounting explainedbookkeeping spreadsheet template excelreimbursement of petty cashaccrued expense journal entrysum of the years digits depreciation formulatally journal entrycalculate double declining balance depreciationmarkup formulaannual equivalent rate calculatorbasic bookkeeping exampleslifo reserve formulaaccounts payable quizthe calculation of depreciation using the declining balance methodleased assets on balance sheetbank reconciliations examplespresent value annuity factor formuladefine imprest accountbookkeeping journal entrieswhy accumulated depreciation is creditaccounting for doubtful debtsfv excel formulabank reconciliation fraudasset turnover ratio formuladupont equation analysisextended dupont equationselling price calculator with markupcapitalized lease accountingeffective interest rate calculation in excelwhat is the formula for fixed costoverhead absorption ratesdefine accrued incomeformula for calculating liquidity ratiofreight prepaid and freight collectcost of goods sold formula manufacturingwhy is a trial balance preparedhow to compute manufacturing overhead ratenpv perpetuitygross margin calchow to calculate stock split 2 for 1patent intangible assetdays sales in receivables ratio formulainterest bearing loan definitionstraight line depreciation schedulebalance sheet prepaid expensesfixed cost formula accounting