Syntax
=FVSCHEDULE(principal, schedule)Arguments
| Argument | Required | Description |
|---|---|---|
principal | Required | The starting amount |
schedule | Required | The interest rates to apply, in order |
How to use FVSCHEDULE
FVSCHEDULE takes 2 required arguments. Type =FVSCHEDULE( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=FVSCHEDULE(1, {0.09, 0.11, 0.1})Result Related financial functions
- DOLLARFRConverts a decimal price to a whole number and a fraction written after the decimal point.
- DURATIONReturns the Macaulay duration in years of a security that pays periodic interest, for 100 face value.
- EFFECTReturns the effective annual interest rate from a nominal rate and the compounding periods per year.
- FVReturns the future value of an investment with constant payments and a constant rate.
- INTRATEReturns the interest rate of a fully invested security.
- IPMTReturns the interest part of one payment of a loan or investment.
- IRRReturns the internal rate of return of cash flows at regular periods.
- ISPMTReturns the interest paid in one period of a loan with equal principal repayments.
- MDURATIONReturns the modified duration in years of a security that pays periodic interest, for 100 face value.