Tutor for students and financial professionals
If you have a bank account on sum $10,000 and bank pay 20% a year, you will earn $6,000 after 3 years.
FV (Future Value) = PV(Present Value) * (1 + n (number of periods) * R (interest rate per period)).
Excel has the function 'FV' which make this calculation. Our FinStat Excel templates contains the spreadsheet 'FV'. You simply enter PV, R, and n values, and the result is done.
If you have the same bank account on sum $10,000 and bank pay 20% a year, you will earn $7,280 after 3 years.
FV = PV * (1 + R) ** n
Excel has the function 'FVSCHEDULE'' which make this calculation. Our FinStat Excel templates contains the spreadsheet 'SCHEDULE'. You enter PV and a serie of R values for several periods. Then simply click a button 'Calculate'. A result is done. Please note that our product FinStat Excel templates allows to calculate FV value if even you have different interest rates in your periods. If your interest rate is the same in all periods, you can copy it. Example:
|PV||Rate||Future value of an investment|
In this example the FV value is calculated for 3 periods. If you have more than 3 periods, you can simply add interest rates in the column "Rate". Then click a "Calculate" button.
Our FinStat Excel templates contains also the spreadsheet 'PV'. It allows to calculate PV value using FV, n, and R. Example:
If you have $10,000 and the interest rates for years are: 1 - 20%, 2- 25%, 3- 30%.
|Year||Income per year||Base||Rest|
FV = PV * (1 + n1 * r1 + n2 * r2 + ... + ni * ri)
FV - Future Value
PV - Present Value
ni - duration of i peroid
ri - interest rate of i period
FV = PV * ( 1 + r1) ** n1 * ( 1 + r2) ** n2 ...* ( 1 + ri) ** ni
|Year||Income per year||Base||Rest|
We have special Excel template for this purpose. Its screenshot is shown below. Alternatively, you can review our full collection of statistical and financial Excel templates.
To calculate a future investment value, you enter your current sum in the cell B3, values in the columns 'Number of Periods' and 'Interest Rate'. Then choose a simple or compound interest rate and click the button 'Calculate'. Now you can see the result in the cell D3.
Our collection of Excel templates contains the following spreadsheet.
It allows to calculate compound interest sum when interest rates are different in periods. The principal in this case is current value. Both Excel templates are developed with VBA programming use.
To be continued
You also may want to review our following Excel add-ins: Excel add-ins Part 1, Excel add-ins Part 2, Excel add-ins Part 3, Excel add-ins Part 4, Excel add-ins Part 5, Excel add-ins Part 6
We have also Accounting Excel Templates: Accounting Excel Templates Part 1, Accounting Excel Templates Part 2
We have Budgeting Excel templates: Budgeting Excel Templates Part 1
We have the calendars for Excel: Calendars for Excel Part 1, Calendars for Excel Part 2, Calendars for Excel Part 2
We have financial Excel templates: Financial Excel Templates Part 1
We have inventory management Excel templates: Inventory Management Excel Templates Part 1
We have planning Excel templates: Planning Excel Templates Part 1, Planning Excel Templates Part 2
We have scheduling Excel templates: Scheduling Excel Templates Part 1
We have financial Analysus Excel templates: Financial Analysis Excel Templates Part 1
|Amortization||Add Power to Excel|
|Archotecture & Construction||Amortization|
|Banking||Architeckture & Construction|
|Banking with Excel||Asset Register|
|Business Databases||Car Accounting|
|Business Resource Management||Checks|
|Business Software with Source Code||Conversion|
|Business Systems||Download Managers|