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

## Continuous to Periodic Interest Rate Formula

The continuous to periodic interest rate formula is used to convert a continuous interest rate (r) to a periodic interest rate (i) with compounding taking place (m) times in a period.

Continuous to Periodic Interest Rate Formula November 6th, 2016

## Flat Interest Rate

The term flat interest rate is sometimes used in relation to loan agreements (particularly car loans) to show the rate of interest based on the original principal loan amount (PV).

Flat Interest Rate November 6th, 2016

## Effective Annual Rate Formula

The effective interest rate formula calculates the rate of interest for a year based on a nominal rate (i) compounded a number of times a year (m). The formula for annual interest rate is sometimes referred to as the annual equivalent rate formula or AER formula.

Effective Annual Rate Formula November 6th, 2016

## IRR Internal Rate of Return

The net present value of a series of cash flows is the sum of the present values of each of the cash flows. The internal rate of return (IRR) is the discount rate which will produce a net present value (NPV) of zero.

IRR Internal Rate of Return November 6th, 2016

## Lump Sum Discount Rate Formula

The lump sum discount rate formula is used to calculate the discount rate (i) needed to compound a lump sum from its present value (PV) to a future value (FV) over a given number of periods (n).

Lump Sum Discount Rate Formula December 7th, 2017

## Related pages

bad debt expense on income statementhow to compute cost of goods manufacturedaccounting ledger entriespredetermined overhead absorption rategross margin templatepoc calculationhow to do fifo methodsunk cost accountingpresent value of a growing annuitypmt excel functionfreight terms fobgrn in accountingaccounts payable checklistunearned revenue examplesaccounts receivable is a debit or creditwhat are subsidiary journalsbank recsformula for calculating debt equity ratioaccrued expense payablegross profit markup calculatordifference between allocation and apportionmentba ii plus growing annuityjob costing spreadsheetallowance for doubtful debts in balance sheetdeferred inventory methodjournal entries quiz200 declining balance depreciationexcel npv function examplejournal entry of loan taken from bankdefine unearned revenuepresent value of a annuitystandard absorption costing systembad and doubtful debts journal entryformula for calculating effective interest rateaccounts recievable turnovernet realisable value of inventorypresent value annuity due formulaeffective monthly interest rate calculatordouble entries accountinggross profit method of estimating inventorypetty cash count sheetpv growing annuityhow to calculate average accounts payableexcel bond calculatorvouchers templatesdouble entry bookkeeping historypv of a growing annuityaccounting outstanding checkssalaries and wages payable on balance sheetcontra income accountblank income statement and balance sheethow to compute debt to equity ratiowhat is a debtors control accountaccrual prepaymentledger book samplecomputation of working capitalconvertible participating preferredaccounting amortization schedulehow to calculate gross margin per unitcarriage inwards and outwardsdays sales outstanding ratioaccounting treatment of intangible assetsconsumables examplesirr function in excelimportance of suspense accountformula for mirroperating leverage calculatordebtor days outstandingcost of goods manufactured formula accountingcalculating mortgage constanthow to calculate the total variable costuses of trial balancevariable overhead variancesnotes payable current liabilityreducing balance method depreciation