What is FVSCHEDULE Function?
FVSCHEDULE Function returns the future value of the principal amount after applying a series of compound interest rates.
You can use FVSCHEDULE to calculate the future value of an investment with a variable or adjustable rate.
This function includes all the variable interest rates for investment and determines the future value of an investment by compounding them.
Syntax for FVSCHEDULE Function
=FVSCHEDULE(principal, schedule)
Arguments
Principal: Invested amount/Present Value/Lump sum amount invested/Principal value of an investment.
Schedule: Schedule of interest rates which apply each period.
The values in schedule can be numbers or blank cells. Blank cells are taken as 0 or no interest.
We have created the infographics for the FVSCHEDULE Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.
Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.
Simply follow the instructions in the infographics below:
Note: The values specified for the Principal and Schedule arguments must be numeric or an error is returned.
For example, if the interest rate is 10% you need to indicate that rate as a decimal value of 0.1.
Errors
“#VALUE!” error occurs when any of the supplied arguments are non-numeric.
“#NAME?” error occurs when Analysis ToolPak add-in is not enabled.
Applicability of FVSCHEDULE Function
FVSCHEDULE is a financial function. It is used many ways in the finance industry. Some of them are as follow:
- Calculate Future Business Worth based on the expected growth rate.
- Calculate Compound interest for investment for variable rates.
- Helps much calculation in the banking industry where interest rates differ according to tenure.
Example
We invest $ 25,000 into a fund that gives a return of 2% for the first year, 4% for the second year, and 5% for the third year.
Let us use FVSCHEDULE function to determine the future value of your investment.
Insert $ 25,000 in cell A1. 0.02, 0.04 and 0.05 in A2, A3, and A4 respectively.
Apply the formula =FVSchedule (A1, A2: A4).
It will give you the future value of $ 27,846.
Download the sample file from the link below:
FVSCHEDULE Function sample File
Difference between FV Function and FVSCHEDULE Function in Excel
FV calculates the future value on constant payments with non-variable/constant interest rates. Whereas FVSCHEDULE calculates the future value on variable or adjustable interest rates.
To learn helpful financial function other function like CUMPRINC, ACCRINTM and PRODUCT Functions, please click on the name of the function.
Additionally, you can download other accounting templates like Break Even Analysis Template, Salary Sheet Template and Invoice with GST Template from here.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.
Leave a Reply