## How to Calculate an Outstanding Loan Balance

As regular payments will clear a loan balance over the term, the present value (PV) of the payments must be equal to the value of the loan. It follows that the remaining balance on an loan can be calculated by calculating the present value (PV) of the outstanding loan repayments.

How to Calculate an Outstanding Loan Balance November 6th, 2016

## Present Value of a Growing Annuity Formula

The present value of a growing annuity formula is used to calculate the present value of a series of periodic payments which increase at a constant rate each period. The payments made at the end of each period, and a discount rate i% is applied.

Present Value of a Growing Annuity Formula November 6th, 2016

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

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

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

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

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

## Present Value of a Growing Annuity Calculator

The present value of a growing annuity calculator is used to calculate what a cash sum growing at a rate g received at the end of each period, for n periods is worth today, taking into account a discount rate i.

Present Value of a Growing Annuity Calculator November 6th, 2016

## Annuity Payment Formula FV

This annuity payment formula FV calculates the annuity payment required to provide a given future value FV. The annuity formula assumes payments are made at the end of each period for n periods, and a discount rate i is applied.

Annuity Payment Formula FV November 6th, 2016

## Future Value of a Growing Annuity Calculator

The future value of a growing annuity calculator is used to calculate what a cash sum growing at a constant rate g, received at the end of each period for n periods is worth at the end of period n, allowing for a discount rate i.

Future Value of a Growing Annuity Calculator November 6th, 2016

## Annuity Payment Formula PV

This annuity payment formula PV calculates the annuity payment required to provide a given value today PV (present value). The annuity formula assumes payments are made at the end of each period for n periods, and a discount rate i is applied.

Annuity Payment Formula PV November 6th, 2016

## Future Value Annuity Formula

The future value of an annuity formula is used to calculate the future value of a series of periodic payments. The payments are for the same amount, made at the end of each period, and a discount rate i% is applied.

Future Value Annuity Formula November 6th, 2016

## Related pages

disbursement voucher templatecontra liability account examplesexplain the accounting cyclejob order costing accountingformula of annuitydeclining balance method of depreciation formulaprofitability ratios accountingan adjusting entry affectsapportionment calculatorexamples of long term liabilities on balance sheetdiscount rate formula excelbills receivable and bills payable meaningdaybook in excelbills receivable and bills payable meaningcompute straight line depreciationcalculate total asset turnoverthe amortization of bond discountconverting preference sharescompound interest and simple interest formulaspayroll tax accountant salaryvariable cost per unit formulastandard absorption costing systemsimple payback period calculatorcash voucher templateperpetual vs periodicmeaning deferred revenue expenditure give examplescalculating margin vs markupgross profit markupcapital lease and finance leaseannuity future value formulaaccrued income asset or liabilityprofitability index calculator financialexcel gross profit formulainvestment doubling time calculatorpresent value annuity due formulais notes payable a debit or creditcash payback formulainventory turnover calculation examplesample of requisition formexample of cash discountpledging accounts receivablefinancial forecast template excelformat of sales ledger control accountwhat are adjusting journal entriesdouble declining balance calculatorhow do you calculate contribution marginfuture value interest factor annuitystraight line depreciation method calculatorfv tablesdeferred tax accounting journal entrieslabor rate variance exampleoverhead cost variancestatement of stockholders equity examplereorder point and safety stockprofitabilty indexbookkeeping and accounting pdfrop formulaaccrued expenses meaningwhat is the dupont formulaaccounting equation templateaccounts aptitude testwhat is inventory shrinkageoverstatement examplescash disbursementscommon size balance sheet and income statementyear end closing entriesexample of sundry expensesexcel job costing templatepv of an annuity tableaccount payable journal entrysimple bookkeeping with exceldouble entry accounting templatedefinition bookkeepingconsignment accounting treatmentperpetual inventory vs periodic inventoryjob timesheetunpresentedstable monetary unit conceptdebt to equity equationdeferred tax liability in cash flow statementoutstanding rent journal entry