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


multi step income statementsdebtor collection period ratiodefinition of accounting and bookkeepingaccounts payable skills testallowance for doubtful accounts journal entryexcel bookkeeping templatesservices rendered accounting entrycommon size income statement and balance sheetmarkup percentage equationoverhead allocation and apportionmentfinancial gearing definitionhow to calculate discount percentage in excelperpetual periodic inventoryprepaid insurance premiumsdepreciation schedule straight line methodformula fixed costinventory shrinkagestandard cost variance definitionhow to calculate profit mark updepreciation adjusting entryadvance expenses journal entryhow to calculate pv ratiopayment voucher sample docallocating overheadformat bank reconciliation statementwhat is vertical analysis in accountingtemplate for requisition formfixed asset register template downloadrule of 78s calculatorbook value formula depreciationaccounts recivable turnoverchart of accounts pakistanjob sheet templateswhat are sundries in accountingcorrecting trial balance errorsgross profit method of inventoryadjusting entry for depreciationdebt ratios formulawhat is reducing balance methodaccounting double entry cheat sheetoverhead journal entryinvestor ratios definitioneom in accountingpmt formula explainedbank reconciliation exercise and answerscash register balance sheet templatedupont analysis templatebank overdraft liabilitiesnet salvage value formulastockholders equity equationjournal entry for credit salesformula for stockholders equitybookkeeping to trial balanceexamples of ledgersinvoice ledgercalculating depreciation straight linebank reconciliation interview questionsin a perpetual inventory systemretained earnings examplesmandatory redeemable preferred sharesannuity formula proofaccounting npvcalculate future value formulaunits of production method of depreciationvertical analysis of balance sheetperpetual inventory income statementpetty cash slip templatefuture value of growing annuitybeginning stockholders equity formulaformula for overhead costwhat is the normal balance for accounts payableaccount payable turnover days formulawhat are debits and credits accountingapportionment accountingbookkeeping journal templatelease journal entrieswhat does fob shipping point meaneffective annual rate formulasimple interest calculation formula in excel