Microsoft Office Tutorials and References
In Depth Information
Using RECEIVED to Calculate Total Cash Generated from a Bond Investment
COUPNUM This returns the number of coupon dates left until ma-
turity.
All the COUP functions require the same four arguments: settlement, matur-
ity, frequency, and basis. For an explanation of these arguments, see the sec-
tions on YIELD and PRICE.
Figure 13.18 shows these coupon functions for a particular security.
COUPNUM
Figure 13.18.
Figure 13.18. You can analyze what portion of a coupon period has gone past
You can analyze what portion of a coupon period has gone past
at the settlement date for the bond.
at the settlement date for the bond.
Using
Using RECEIVED
RECEIVED to Calculate Total Cash Generated from a Bond Investment
to Calculate Total Cash Generated from a Bond Investment
When you buy a bond, your settlement date is probably between two coupon
dates. Unless you are buying the bond on the issue date, you receive less
than the complete number of interest payments. To calculate the total future
cash flows from a bond from the day you buy it until the maturity date, you
use the RECEIVED function.
Syntax
RECEIVED(settlement,maturity,investment,discount,basis)
The RECEIVED function returns the amount received at maturity for a fully
invested security. This function takes the following arguments:
Search JabSto ::




Custom Search