# PRICEDISC

Name of Formula:

PRICEDISC

Definition/Description of Formula:

This function returns the price per \$100 face value of a discounted security.

Syntax:

PRICEDISC(settlementmaturity,discountredemption, basis)

• `settlement` - Enter the date after issuance when the security is delivered to the buyer.
• `maturity` - The end date of the security, when it could be redeemed.
• discount- The discount rate of the security at time of purchase.
• `redemption` - The redemption value of the security.
• basis[ OPTIONAL - `0` by default ] - An indicator of what day count method to use.
• 0- This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard
• 1- This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years.
• 2- This calculates based on the actual number of days between the speficied dates, but assumes a 360 day year.
• 3- This calculates based on the actual number of days between the specified dates, but assumes a 365 day year.
• 4- 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:

Step 1.  To begin to use PRICEDISC formula, start with the Excellentable you would like to edit..

Step 2. Then type the PRICEDISC formula into the cell you have chosen to display the outcome:

Step 3. Enter in the values needed to achieve your final 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
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
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
10

JavaScript errors detected