Lump Sum Number of Periods Calculator

The lump sum number of periods calculator is used to calculate the number of periods (n), it takes to increase the present value of a lump sum to its future value at a discount rate of i%.

Lump Sum Number of Periods Calculator November 6th, 2016Team
Read more


Lump Sum Discount Rate Calculator

The lump sum discount rate calculator 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 Calculator November 6th, 2016Team
Read more

Continuous Compounding

Normally when computing compound interest the compounding period is a discrete interval, annually, quarterly, monthly, weekly etc. There is nothing however to stop the compounding period getting smaller and smaller until eventually interest is calculated on the balance of the principal amount plus accumulated interest on a continuous basis.

Continuous Compounding November 6th, 2016Team
Read more

NPV and Taxes

The NPV (net present value) of an investment is calculated by adding together the present value of each of the individual cash flows associated with the investment. The purpose of this tutorial is to discuss the effect of taxation and depreciation on each of the investment cash flows and, as a result, on the NPV of the investment itself.

NPV and Taxes November 6th, 2016Team
Read more

Simple Interest Doubling Time Formula

The simple interest doubling time equation calculates the number of periods it takes to double the value of an investment when the investment earns simple interest at a given discount rate (i).

Simple Interest Doubling Time Formula November 6th, 2016Team
Read more

Doubling Time Formula Continuous Compounding

The doubling time equation continuous compounding calculates the number of periods it takes to double the value of an investment when the interest is compounded continuously at a given discount rate (i).

Doubling Time Formula Continuous Compounding 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

You May Also Like


Related pages


define contra accountwiki double entry bookkeepingimpress accountprinciple of double entry accountingjournal entry to write off bad debtcontra account balance sheetfuture value of a lump sum calculatorsalvage value and depreciationcash internal controls checklistcompute cost of goods manufacturedformat of sales ledger control accountreceivables turnover ratio calculationbond pricing calculatorsample excel accounting spreadsheetfinancial accounting trial balanceconsignment agentsuspense payment definitiontemplate for small business bookkeepingcp sp formulasbond amortization accountingvendor statement reconciliationpv tables annuitybalance sheet marketable securitieswhen is the balance in a prepaid expense account reducedtrial balance proformawhat is owner's equitywhat are the efficiency ratiossample balance sheet reconciliation templategeneral ledger vs subsidiary ledgerallowance for bad debt account typenper 3net realisable value of inventoryexcel template accounting small businesstwo column cash bookdepreciation straight line method exampleaccounting equation pdfprepaid insurance journal entry examplegross profit cogsimprest accountdouble declining balance formulasale ledger control accountamortizing bondsclassification of marketable securitiesbills receivable definitionwhat is fob shipping termsdifference between margin and markup calculationpayback period excel formulainternal control for accounts receivablecash flows excelwhat is ledger in accounting with examplesample payroll journal entryaccruals and deferred income definitionzero coupon bond pricejournal entry for contingent liabilityvertical analysis financial statementsissuance of bonds payablecalculating effective annual ratecontra in accounting exampleaccounts ledger booktemporary accounts in accountingpledging receivablesbookkeeping excel templatesbearing notescalculating interest on notes payableaccrued expenses balance sheetgoodwill accounting treatment exampleoperating cycle accounting formulaprepaid expenses in profit and loss accountvariable manufacturing overhead efficiency varianceallowances for doubtful accountsworksheet template excelvariable overhead efficiency variancecash flow calculator excelhow to calculate the markup percentageaccount receivable journal entries adjusting entriesthe accounts receivable turnover is calculated bybasic accounting concepthow to calculate conversion cost per equivalent unit