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

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, 2016Team
Read more

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, 2016Team
Read more

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, 2016Team
Read more

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, 2017Team
Read more

You May Also Like

Related pages

depreciation of fixed assets definitionsub ledgersstock valuation calculator excelcash receiptingwhat is the future value of an annuityunearned revenue meaningroyalty revenue accountingshipping method fobhow to compute contribution margin per unitwhat is debits and creditshow to calculate the quick ratiogross markup formulajournal entry of accrued interestaccounts payable spreadsheet templateexcel accounting tutorial pdfcapital stock journal entryfob destination freight prepaid and allowedworking capital turnover ratio formulaballoon payment calculator excelfifo method examplemeaning of narration in accountinghow to calculate inventory holding periodexamples of capital employeddividends normal balanceinventory turnover ratio calculation examplepredetermined factory overhead rateaccounts payable report sampleaccounting for factory overheadjournal entry of depreciationperpetual inventory recordssimple bookkeeping with excelperpetual system accountingaccounting for insurance recoveriesdefine sundry creditorsbad debt allowance methodfob cost definitioncontinous compounding formuladishonored billlifo cogsbookkeeping and accounting notesjournal entries for accounts payablean nsf check is azero coupon bond calculationunearned revenue liabilityprintable general ledgervalue of a perpetuity formulaturnover ratio formulaefficiency ratio receivables turnoverassets turnover ratio formulahow to calculate pv ratiowhen is the balance in a prepaid expense account reducedaccounting prepaid rentimprest account exampledeferred tax singaporedaily time sheet templateaccounts recievable turnover ratiodiminishing balance method depreciationconsignment sales accounting entriesbond sinking fund journal entryhow do you calculate retained earningspresent value annuity calculationhow to find manufacturing overheadprepaid insurance premiumsprofit margin formulasaccrual double entryamortisation of intangible assetsaccounting aptitude test questions and answersproduct costing formulabank reconciliation statement excel formatmileage claim templatebank reconciliation statements examplesoverhead budget variancesimple interest and compound interest formulasdefine sundry debtorscalculate unit variable costannuity examplespayback analysis exampleloan write off accounting treatmentdividend ratio formulaexcel formula pmt