Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11FVSCHEDULE function - Returns the future value of an investment that has variable or adjustable interest in period in Excel
The following article details the meaning and usage of the FVSCHEDULE function - Returns the future value of an investment that has an interest rate that changes or can be adjusted periodically in excel.
Description: The function that calculates the future value of an investment with interest.
Syntax : = FVSCHEDULE (principal, schedule) .
Inside:
- principal : The initial value of the investment.
- schedule : an array containing the interest rates to apply.
Attention:
- The values in the array can be either numbers or blank cells, in which case the blank cell is counted as zero (interest = 0).
For example:
Calculate the amount of investment received after 3 years with an initial value of 200,000,000, knowing the interest rates for years, respectively, 0.12, 0.15, and 0.08.
In the cell to calculate the investment value after 3 years enter the formula: = FVSCHEDULE (B6, C6: E6) .
Press Enter and the result of the investment after 3 years is:
In case the interest rate value is left blank, the function of self-understanding interest rate is 0:
The above is a detailed guide on how to use the FVSCHEDULE function in Excel hoping to help you.
Good luck!
Samuel DanielYou should read it
- DURATION function - The function returns the periodic periodic interest payments in Excel
- GEOMEAN function - The function returns the average of a positive array or range of data in Excel
- AMORDEGRC function - The function returns the depreciation for each accounting period in Excel
- INTERCEPT function - The function returns the point at which the line will intersect the y-axis by using the existing x and y values in Excel
- Use the cumulative interest calculation function in Excel
- FORECAST function - The function returns a value along a linear trend in Excel
- MIRR function - The function returns the adjusted internal rate of return in Excel
- COUPNCD - The function returns the next coupon date in Excel
May be interested
- How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing. - ISPMT function - The function that calculates interest for a specified period in Excelispmt function - the function that calculates interest for a specified period in excel
- CHISQ.TEST function - The function returns the independence test in Excelchisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
- How to use the IF function in Excelthe if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- CUMIPMT function - The function of calculating accrued interest in Excelthe following article is to use cumipmt function to calculate accrued interest. it helps you plan the lowest interest rate payment plan.
- SLN function - Returns the depreciation value of an asset using the straight-line method in Excelthe following article details the syntax and usage of sln in excel. description: returns the depreciation of assets according to the straight-line method over a given period.
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
Office information
- Compare ODDFPRICE and ODDLPRICE functions in Excel
- OR function in Excel, how to use the OR function, and examples
- How to get the current date in Excel
- Group in Word, group of image blocks in Word
- BETADIST function - Cumulative distribution function Beta in Excel
- TTEST - Returns the probability associated with a Student's t-Test in Excel
Compare ODDFPRICE and ODDLPRICE functions in Excel
OR function in Excel, how to use the OR function, and examples
How to get the current date in Excel
Group in Word, group of image blocks in Word
BETADIST function - Cumulative distribution function Beta in Excel
TTEST - Returns the probability associated with a Student's t-Test in Excel