Microsoft Office Tutorials and References
In Depth Information
FVSCHEDULE
FVSCHEDULE
FVSCHEDULE returns the future value of a principal amount after applying several, or a series of
compound interest rates.
=FVSCHEDULE(principal,schedule)
The FVSCHEDULE function returns the future value of a principal amount after applying several, or a
series of compound interest rates. This function is found only if the Analysis Toolpak is installed. It
must be turned on using the Add-Ins command from the Tools menu. Figure 6.18 demonstrates
that the compound interest rates applied to the principal’s present value is 7, 8, and 9%.
The present value or deposited amount.
PRINCIPAL
The array (series) of interest rates to apply.
SCHEDULE
Figure 6.18
FVSCHEDULE returns
the future value of a
principal amount after
applying several, or a
series of compound
interest rates.
A
Cell referencing
generates this
function
INTRATE
INTRATE returns the interest rate of a security that’s fully invested.
=INTRATE(settlement,maturity,investment,redemption,basis)
The INTRATE function is found only if the Analysis Toolpak is installed. It must be turned on
using the Add-Ins command from the Tools menu. In Figure 6.19 the settlement date is
5/15/1999. The maturity date is 9/15/1999. The investment is $500,000, and the redemption
value of the bond is $524,000. With a day count basis of Actual/360, the interest rate for this
fully invested security is 14%.
The security’s settlement date. This is the date after the issue date
when the security is traded to the buyer.
SETTLEMENT
The security’s maturity date. The date when the security expires.
MATURITY
Search JabSto ::




Custom Search