Sum multiple tables
This formula uses structured references to refer to the "Amount" column in each table. The structured references in this formula resolve to normal references like this:
=SUM(Table1[Amount],Table2[Amount])
=SUM(C7...Read moreDave Bruns
PRICE Function
The Excel PRICE function returns the price per $100 face value of a security that pays periodic interest. For example, the PRICE function can be used to determine the "clean price" of a bond (also known as the quoted price), which is the price of the bond excluding accrued interest.
In...Read more
Bond valuation example
In the example shown, we have a 3-year bond with a face value of $1,000. The coupon rate is 7% so the bond will pay 7% of the $1,000 face value in interest every year, or $70. However, because interest is paid semiannually in two equal payments, there will be 6 coupon payments of $35 each. The...Read more
COUPDAYBS Function
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments. The Excel COUPDAYBS function returns the number of days from the start of the coupon period to the settlement date.
...Read more
COUPDAYSNC Function
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments. The Excel COUPDAYSNC function returns the number of days from the settlement date to the next coupon date.
The...Read more
COUPNCD Function
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments. The Excel COUPNCD function returns the next coupon date after the settlement date.
The settlement date is the date...Read more
COUPNUM Function
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments. The Excel COUPNUM function returns the number of coupons (interest payments) payable between the settlement date and maturity...Read more
COUPPCD Function
Historically, bonds were printed with an elaborate design on paper that included detachable coupons. The coupons were presented to the bond issuer by the bondholder to collect periodic interest payments.
The Excel COUPPCD function returns the previous coupon date before the settlement...Read more
COUPDAYS Function
Historically, bonds were printed on paper with detachable coupons. The coupons were presented to the bond issuer in order to collect periodic interest payments. The COUPDAYS function returns the number of days in a coupon period that includes the settlement date.
The settlement date is...Read more
RANDARRAY Function
The RANDARRAY function generates an array of random numbers between two values. The size or the array is determined by rows and columns arguments. By default, RANDARRAY returns an array of random numbers between 0 and 1. However, RANDARRAY will generate whole numbers when the...Read more