WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Future Value Formula

Future Value Formula

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Formula to Calculate FV

Future Value (FV) Formula is a financial terminology used to calculate the value of cash flow at a futuristic date as compared to the original receipt. The objective of this FV equation is to determine the future value of a prospective investment and whether the returns yield sufficient returns to factor in the time value of money.

The formula for Future Value (FV) is:

FV=C0 * (1+r)n

Whereby,

  • C0 = Cash flow at the initial point (Present value)
  • r = Rate of return
  • n = number of periods

Future Value Formula

Example

You can download this Future Value (FV) Excel Template here – Future Value (FV) Excel Template

If Mrs. Smith has $9,000 in her bank account and she earns an annual interest of 4.5%. With the help of the future formula, her account after 15 years will be:

  • FV = 9,000 * (1 + 0.045) ^ 15
  • FV = 9,000 * (1.045) ^ 15
  • FV = 9,000 * 1.935
  • FV = $17,417.54

We can consider another example for better understanding:

Mrs. Smith has another account that has $20,000 paying an annual rate of 11% compounded on a quarterly basis. Since January 1, 2017, the terms of the agreement have been renewed, and the compounded interest is attributed twice a month. Does Mrs. Smith want to calculate the total value of the account on December 31, 2017?

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

We firstly need to arrive at the opening balance as on January 1, 2017:

  • PV (Jan’16 – Dec’16) = $20,000
  • Compounding period (n) = 4
  • Annual interest rate (r) = 11% which converts to quarterly interest of 2.75 % [11% / 4]
  • FV = 20,000 * (1 + 0.0275) ^ 4
  • FV = 20,000 * (1.0275) ^ 4
  • FV = $22,292.43 (This is the opening balance as of January 1, 2017)

Thus, now for calculating Future value as of 31st December, 2017, the Present value if $22,292.43.

Compounding period (n) now is 2*12 = 24 since the compound interest is now twice a month.

Annual interest (r) = 11% which converts monthly interest rate = 11%/12 = 0.0092 [this will further be split twice a month thus, 0.92/2 = 0.0046%]

  • Thus, FV = PV (1 + r) ^ n
  • FV = 22,292.43 * (1 + 0.0046) ^ 24
  • FV = 22,292.43 * (1.00046) ^ 24
  • FV = 22,292.43 * 1.116
  • FV = $24,888 [Value of the account as on December 31, 2017]

Use and Relevance

  1. The primary benefit of FV is to determine whether an investment opportunity will garner sufficient yield in the future.
  2. The concept is applicable to Personal and Corporate decisions.
  3. The objective is to have an understanding of how economic factors can have an impact on the earnings such as Inflation, Standard of living, operating expenses/recurring expenses (separate analysis is required to be done).
  4. It shows the stream of payments that are expected to receive over a period of time, e.g., a 10-year investment can show how much returns can be earned every year.
  5. In certain circumstances, the formula is also used as an input to other formulas. For e.g., annuity in the form of recurring deposits in an interesting account will be the FV of every deposit.

Future Value Calculator

You can use the following Future Value Calculator

C0
r
n
Future Value Formula =
 

Future Value Formula =
C0 X (1 + r)n =
0 * (1 + 0)0 = 0

Future Value Formula Video

Recommended Articles

This has been a guide to Future Value Formula. Here we learn how to calculate future value (FV) using its formula along with practical examples, a calculator, and a downloadable excel template. You may also have a look at these articles below to learn more about Corporate Finance

  • Calculate PV
  • Value Formula in Excel
  • NPV vs XNPV
4 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Future Value (FV) Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More