Skip to main content

PRICEMAT

Calculates the price of a security paying interest at maturity, based on expected yield.

Sample Usage

PRICEMAT(DATE(2010,01,02),DATE(2039,12,31),DATE(2010,01,01),3,1.2)

PRICEMAT(A2,B2,C2,D2,E2,1)

Syntax

PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])

  • settlement - The settlement date of the security, the date after issuance when the security is delivered to the buyer.

  • maturity - The maturity or end date of the security, when it can be redeemed at face or par value.

  • issue - The date the security was initially issued.

  • rate - The annualized rate of interest.

  • yield - The expected annual yield of the security.

  • day_count_convention - [ OPTIONAL - 0 by default ] - An indicator of what day count method to use.

    • 0 indicates US (NASD) 30/360 - This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard, and performs specific adjustments to entered dates which fall at the end of months.

    • 1 indicates Actual/Actual - This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years. Used for US Treasury Bonds and Bills, but also the most relevant for non-financial use.

    • 2 indicates Actual/360 - This calculates based on the actual number of days between the speficied dates, but assumes a 360 day year.

    • 3 indicates Actual/365 - This calculates based on the actual number of days between the specified dates, but assumes a 365 day year.

    • 4 indicates European 30/360 - Similar to 0, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.

Notes

  • settlementmaturity, and issue should be entered using DATETO_DATE or other date parsing functions rather than by entering text.

See Also

YIELDDISC: Calculates the annual yield of a discount (non-interest-bearing) security, based on price.

YIELD: Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.

PRICEDISC: Calculates the price of a discount (non-interest-bearing) security, based on expected yield.

PRICE: Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

DISC: Calculates the discount rate of a security based on price.

 

In order to use the PRICEMAT formula, start with your edited Excellentable:

Then type in the PRICEMAT Formula in the area you would like to display the outcome:

 


By adding the values you would like to calculate the PRICEMAT formula for, Excellentable will generate the outcome:


 

Step 4. Once saved, your completed formula will display in a confluence page like this. 

A
B
C
D
1
Population
Total area in mi2
Land area in mi2
2
Alabama
4833722
52,420 (135,767)
50,645 (131,170)
3
Alaska
735132
665,384 (1,723,337)
570,641 (1,477,950)
4
Arizona
6626624
113,990 (295,233)
113,594 (294,207)
5
Arkansas
2959373
53,179 (137,733)
52,035 (134,770)
6
California
38332521
163,695 (423,968)
155,779 (403,466)
7
Colorado
5268367
104,094 (269,602)
103,642 (268,432)
8
Connecticut
3596080
5,543 (14,356)
4,842 (12,541)
9
Delaware
925749
2,489 (6,446)
1,949 (5,048)
10
Florida
19552860
65,758 (170,312)
53,625 (138,888)
11
Georgia
9992167
59,425 (153,910)
57,513 (148,958)
12
Hawaii
1404054
10,932 (28,314)
6,423 (16,635)
13
Idaho
1612136
83,569 (216,443)
82,643 (214,044)
14
15
TOTAL: 
95838785
16
E
F
1
Water area in mi2
House seat(s)
2
1,775 (4,597)
7
3
94,743 (245,383)
1
4
396 (1,026)
9
5
1,143 (2,960)
4
6
7,916 (20,502)
53
7
452 (1,171)
7
8
701 (1,816)
5
9
540 (1,399)
1
10
12,133 (31,424)
27
11
1,912 (4,950)
14
12
4,509 (11,678)
2
13
926 (2,398)
2
14
15
16
100.0


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.