The Problem and the Future Value Formula

Let's say we have $100 and the interest rate is 5%. What will the value of the investment be at the end of the first year? The formula for the future value of this lump sum investment is as follows:

FV1 = PV + INT or PV(1 + I)ⁿ

The first part of this equation -- FV₁ = PV + INT -- reads, "the future value (FV) at the end of one year -- the subscript ᵢ -- equals the present value plus the added value at the specified interest rate.

The next formula presents this in a form that is easier to calculate the value added by the accrued interest -- PV(1 + I)ⁿ -- which reads, "the present value (PV) times (1 + I)ⁿ, where l represents the interest rate and the superscript ⁿ is the number of compounding periods.

Now let's use the example from above. In one year, your $100 lump sum investment earning 5% interest per year will equal:

FV = $100(1 + 0.05) = $105

In this instance, you do not see a superscript (n) for compounding periods because at this point you're solving for the first year only.

If you wanted to determine the value at the end of two years, your calculation would look like this:

FV = $100(1 + 0.05)² = $110.25

You can solve this, which is a compound interest problem, by calculating the value at the end of the first year, then multiplying the outcome by the same 5 percent rate for the second year:

FV = [$100(1+0.05)] + [$105(1+0.05)] = $110.25

You can continue this process to find the future value of the investment for any number of compounding periods.

Spelling out this process way -- manually performing each year's added value from interest, then using that value to make similar calculations for each following year -- makes it clear how we're arriving at the result, but it's time-consuming. Solving for a future value 20 years in the future means repeating the math 20 times. There are faster and better ways of accomplishing this, one of them being the use of a financial calculator.

Future Value of an Investment Using a Financial Calculator

The formula for finding the future value of an investment on a financial calculator is:

FVN = PV(1 + I)ⁿ

Although it doesn't quite look like it, this is the same formula we used when we did the calculations manually.

Incidentally, you can use this formula with any calculator that has an exponential function key -- most do. However, using a financial calculator is better because it has dedicated keys corresponding to each of the four variables we'll be using, speeding up the process and minimizing the possibility of error. Here are the keys you will punch:

Punch N and 2 (for 2 years)

Punch I/YR and 5 (for the interest rate of 5%)

Punch PV and -105 (for the amount of money we are calculating interest on in year 2)

Punch PMT and PMT (there are no payments beyond the first one)

Punch FV, which returns the answer of $110.25

The advantage of the financial calculator over the manual method is obvious. With the calculator, it's no more difficult or time-consuming to solve for a future value 20 years from now than to solve for a single year. Another time-saving method uses a spreadsheet.

Future Value of a Lump Sum Investment Using a Spreadsheet

Spreadsheets, such as Microsoft Excel, are well-suited for calculating time value of money problems. The function that we use for future value of an investment or a lump sum on an Excel spreadsheet is:

=FV(0.05,1,0,-100,0)

To use the function in the worksheet, click on "Formulas" in the title bar, then click on "Financial." You will then see a list of functions. Click on FV. That will open the Formula Builder box where you'll see five boxes labeled rate, nper, pmt, pv and type. If you want to determine the future value at the end of two years, fill out the boxes as follows:

rate (interest rate) = .05

nper (total number of payment periods = 2

pmt (repeated payments, in this case none) = 0

pv (present value, expressed as a negative number) = -100

type (this refers to the timing of subsequent payments) = Since there are none, enter 0

Earlier versions of Excel require that you click on Calculate to see the result. Later versions present the result automatically.

https://www.thebalance.com/how-to-calculate-the-future-value-of-an-investment-393391

Fri Jul 19, 2024 10:30 am by faithhharris

» CCS.N0000 ( Ceylon Cold Stores)

Wed Mar 20, 2024 11:31 am by Hawk Eye

» Sri Lanka plans to allow tourists from August, no mandatory quarantine

Wed Sep 13, 2023 12:16 pm by lauryfriese

» When Will It Be Safe To Invest In The Stock Market Again?

Wed Apr 19, 2023 6:41 am by කිත්සිරි ද සිල්වා

» Dividend Announcements

Wed Apr 12, 2023 5:41 pm by කිත්සිරි ද සිල්වා

» MAINTENANCE NOTICE / නඩත්තු දැනුම්දීම

Thu Apr 06, 2023 3:18 pm by කිත්සිරි ද සිල්වා

» ඩොලර් මිලියනයක මුදල් සම්මානයක් සහ “ෆීල්ඩ්ස් පදක්කම” පිළිගැනීම ප්රතික්ෂේප කළ ගණිතඥයා

Sun Apr 02, 2023 7:28 am by කිත්සිරි ද සිල්වා

» SEYB.N0000 (Seylan Bank PLC)

Thu Mar 30, 2023 9:25 am by yellow knife

» Here's what blind prophet Baba Vanga predicted for 2016 and beyond: It's not good

Thu Mar 30, 2023 9:25 am by HaeroMaero

» The Korean Way !

Wed Mar 29, 2023 7:09 am by කිත්සිරි ද සිල්වා

» In the Meantime Within Our Shores!

Mon Mar 27, 2023 5:51 pm by කිත්සිරි ද සිල්වා

» What is Known as Dementia?

Fri Mar 24, 2023 10:09 am by කිත්සිරි ද සිල්වා

» SRI LANKA TELECOM PLC (SLTL.N0000)

Mon Mar 20, 2023 5:18 pm by කිත්සිරි ද සිල්වා

» THE LANKA HOSPITALS CORPORATION PLC (LHCL.N0000)

Mon Mar 20, 2023 5:10 pm by කිත්සිරි ද සිල්වා

» Equinox ( වසන්ත විෂුවය ) !

Mon Mar 20, 2023 4:28 pm by කිත්සිරි ද සිල්වා

» COMB.N0000 (Commercial Bank of Ceylon PLC)

Sun Mar 19, 2023 4:11 pm by කිත්සිරි ද සිල්වා

» REXP.N0000 (Richard Pieris Exports PLC)

Sun Mar 19, 2023 4:02 pm by කිත්සිරි ද සිල්වා

» RICH.N0000 (Richard Pieris and Company PLC)

Sun Mar 19, 2023 3:53 pm by කිත්සිරි ද සිල්වා

» Do You Have Computer Vision Syndrome?

Sat Mar 18, 2023 7:36 am by කිත්සිරි ද සිල්වා

» LAXAPANA BATTERIES PLC (LITE.N0000)

Thu Mar 16, 2023 11:23 am by කිත්සිරි ද සිල්වා

» What a Bank Run ?

Wed Mar 15, 2023 5:33 pm by කිත්සිරි ද සිල්වා

» 104 Technical trading experiments by HUNTER

Wed Mar 15, 2023 4:27 pm by katesmith1304

» GLAS.N0000 (Piramal Glass Ceylon PLC)

Wed Mar 15, 2023 7:45 am by කිත්සිරි ද සිල්වා

» Cboe Volatility Index

Tue Mar 14, 2023 5:32 pm by කිත්සිරි ද සිල්වා

» AHPL.N0000

Sun Mar 12, 2023 4:46 pm by කිත්සිරි ද සිල්වා

» TJL.N0000 (Tee Jey Lanka PLC.)

Sun Mar 12, 2023 4:43 pm by කිත්සිරි ද සිල්වා

» CTBL.N0000 ( CEYLON TEA BROKERS PLC)

Sun Mar 12, 2023 4:41 pm by කිත්සිරි ද සිල්වා

» COMMERCIAL DEVELOPMENT COMPANY PLC (COMD. N.0000))

Fri Mar 10, 2023 4:43 pm by yellow knife

» Bitcoin and Cryptocurrency

Fri Mar 10, 2023 1:47 pm by කිත්සිරි ද සිල්වා

» CSD.N0000 (Seylan Developments PLC)

Fri Mar 10, 2023 10:38 am by yellow knife

» PLC.N0000 (People's Leasing and Finance PLC)

Thu Mar 09, 2023 8:02 am by කිත්සිරි ද සිල්වා

» Bakery Products ?

Wed Mar 08, 2023 5:30 pm by කිත්සිරි ද සිල්වා

» NTB.N0000 (Nations Trust Bank PLC)

Sun Mar 05, 2023 7:24 am by කිත්සිරි ද සිල්වා

» Going South

Sat Mar 04, 2023 10:47 am by කිත්සිරි ද සිල්වා

» When Seagulls Follow the Trawler

Thu Mar 02, 2023 10:22 am by කිත්සිරි ද සිල්වා

» Re-activating

Sat Feb 25, 2023 5:12 pm by කිත්සිරි ද සිල්වා

» අපි තමයි හොඳටම කරේ !

Tue Feb 14, 2023 3:54 pm by ruwan326

» මේ අර් බුධය කිසිසේත්ම මා විසින් නිර්මාණය කල එකක් නොවේ

Tue Jan 03, 2023 6:43 pm by ruwan326

» SAMP.N0000 (Sampath Bank PLC)

Wed Nov 30, 2022 8:24 am by කිත්සිරි ද සිල්වා

» APLA.N0000 (ACL Plastics PLC)

Fri Nov 18, 2022 7:49 am by කිත්සිරි ද සිල්වා

» AVOID FALLING INTO ALLURING WEEKEND FAMILY PACKAGES.

Wed Nov 16, 2022 9:28 pm by කිත්සිරි ද සිල්වා

» Banks, Finance & Insurance Sector Chart

Tue Nov 15, 2022 5:26 pm by කිත්සිරි ද සිල්වා

» VPEL.N0000 (Vallibel Power Erathna PLC)

Sun Nov 13, 2022 12:15 pm by කිත්සිරි ද සිල්වා

» DEADLY COCKTAIL OF ISLAND MENTALITY AND PARANOID PERSONALITY DISORDER MIX.

Mon Nov 07, 2022 6:36 pm by කිත්සිරි ද සිල්වා

» WATA - Watawala

Sat Nov 05, 2022 8:44 am by කිත්සිරි ද සිල්වා

» KFP.N0000(Keels Food Products PLC)

Sat Nov 05, 2022 8:42 am by කිත්සිරි ද සිල්වා

» Capital Trust Broker in difficulty?

Fri Oct 21, 2022 5:25 pm by කිත්සිරි ද සිල්වා

» IS PIRATING INTELLECTUAL PROPERTY A BOON OR BANE?

Thu Oct 20, 2022 10:13 am by කිත්සිරි ද සිල්වා

» What Industry Would You Choose to Focus?

Tue Oct 11, 2022 6:39 pm by කිත්සිරි ද සිල්වා

» Should I Stick Around, or Should I Follow Others' Lead?

Tue Oct 11, 2022 9:07 am by කිත්සිරි ද සිල්වා