Difference between revisions of "Manuals/calci/FV"
Jump to navigation
Jump to search
| Line 7: | Line 7: | ||
*<math>PresentValue</math> is the present value, and | *<math>PresentValue</math> is the present value, and | ||
*<math>Type</math> is value 0 or 1 indicating when the payments are due. | *<math>Type</math> is value 0 or 1 indicating when the payments are due. | ||
| − | + | **FV() calculates the future value of an investment depending on payment periods, payment value and interest rate. | |
| − | FV() calculates the future value of an investment depending on payment periods, payment value and interest rate. | ||
== Description == | == Description == | ||
Revision as of 16:15, 22 August 2018
FV (Rate,NoPaymentPeriods,Payment,PresentValue,Type)
Where
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate} is the rate of interest per period,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NoPaymentPeriods} is the total number of payment periods in an annuity,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Payment} is the payment value for each period,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PresentValue} is the present value, and
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Type}
is value 0 or 1 indicating when the payments are due.
- FV() calculates the future value of an investment depending on payment periods, payment value and interest rate.
Description
FV(Rate, NoPaymentPeriods, Payments, PresentValue, Type)
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Payment} is optional. If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Payment} is omitted, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PresentValue} should be included.
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PresentValue} is optional. If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PresentValue} is omitted, it is assumed to be zero(0) and argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Payments} should be included.
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Type} can be 0 or 1. Below table indicates the selection of type value -
| Type value | Description |
|---|---|
| 0 | Payments due at the end of the period |
| 1 | Payments due at the beginning of the period |
- If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Type} is other than 0 or 1, Calci displays #N/A error message.
- For monthly payment, Rate should be divided by 12 (e.g. 10%/12) and PaymentPeroid should be multiplied by 12 (e.g. 4*12).
Examples
Consider the following example that shows the use of FV function:
| 2% | 4.5% | |
| 11 | 5 | |
| -50 | -45 | |
| -800 | -1000 | |
| 1 | 0 |
=FV(A1/12,A2,A3,A4,A5) : Calculates the future value for the values in the range A1 to A5.
Annual interest rate is compounded monthly. Displays 1370.3201724868504 as a result. =FV(B1/12,B2,B3,B4,B5) : Calculates the future value for the values in the range B1 to B5.
Annual interest rate is compounded monthly. Displays 1245.5849933323898 as a result. =FV(0.04/12,10,-1000,,1) : Annual interest rate is compounded monthly and PresentValue is omitted.
Displays 10185.178946116719 as a result.
Related Videos
See Also
References