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


future value of growing annuity calculatorbookkeeping journal templateformula for receivable dayscalculate interest expense on bondshorizontal analysis calculatorgeneral ledger accounts exampleswhat are controllable expensescalculating paybackhow to calculate interest rate implicit in the leaseimprest bank accountamortization table makerdso calcunpaid salaries adjusting entrydebiting and crediting accountsbookkeeper dictionaryhorizontal analysis in accountingaccounting ledger entriescalculate markup on costcoupon rate bond calculatorwarranty journal entrydegree of operating leverage equationhow to calculate fixed cost per unitledger balance exampledepreciation with salvage valuegp percentage calculationadvance cash receipt formatexcel cashbook templatedeferred tax accounting journal entriesconstant growth model exceldouble declining method calculatorsublease accounting treatmenthow to calculate retained profitsthe rule of 78 calculatorwhat is common stockholders equitymoney receipt format docobsolete inventory write offwhat is meant by payback periodformula of markupequipment lease calculator excel spreadsheetnet gearing ratio formulapetty cash expense report templateclaim receivable on balance sheetaccounting for unrealized gains and losseseffective interest rate amortization calculatorhow is roce calculatedasset contra accountwhat are special journals in accountingcalculate gp percentagecalculate discount in excelhow to calculate operating leverageadjusting entries affect the cash accountfinancial projections templateaccounting entries for finance leasesimple excel spreadsheet templatewhat is unearned revenue classified asfinance lease journal entries lesseepayroll quizaccrued payrollwrite off accounts receivablemonthly bank reconciliation templatefind the face value of a zero coupon bondstatement of retained earnings examplespaid dividends journal entryhow to calculate unit contribution marginformula for pmtcost of goods sold formulasamortization straight line methodtotal overhead variance formulagp gross profitdiminishing value depreciation formula accountingcontribution margin in dollars formulaamortization expense journal entrymulti step income statement practicesales mix examplecash imprest