Difference between revisions of "Documentation/How Tos/Calc: RECEIVED function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (Robot: Automated text replacement %s)
 
(8 intermediate revisions by 4 users not shown)
Line 23: Line 23:
 
: where days_difference is the number of days between <tt>'''settlementdate'''</tt> and <tt>'''maturitydate'''</tt>, and days_in_year is the number of days in a year, both calculated according to the calendar system <tt>'''basis'''</tt>.
 
: where days_difference is the number of days between <tt>'''settlementdate'''</tt> and <tt>'''maturitydate'''</tt>, and days_in_year is the number of days in a year, both calculated according to the calendar system <tt>'''basis'''</tt>.
  
: As the formula takes no account of compounding, this function is most reliable for periods of less than a year. See * [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]''' for a formula review.
+
: As the formula takes no account of compounding, this function is most reliable for periods of less than a year. See [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]] for a formula review.
  
 
=== Example: ===
 
=== Example: ===
Line 29: Line 29:
 
:  returns approximately <tt>'''10300.5503'''</tt>.  
 
:  returns approximately <tt>'''10300.5503'''</tt>.  
  
{{Documentation/SeeAlso|
+
=== Issues: ===
 +
* Calc and Excel do not agree on the number of days in a year in basis 1. It is not clear which is theoretically correct. Calc uses the number of days in the year containing <tt>'''settlementdate'''</tt>. See [https://issues.apache.org/ooo/show_bug.cgi?id=93527 Issue 93527]! Excel is de facto standard. ODF-Definition: Open Document Format for Office – Applications (OpenDocument) Version 1.2 Part 2: 6.12.43 RECEIVED
 +
 
 +
* Excel appears to have a bug for basis 4.
 +
 
 +
{{SeeAlso|EN|
 
* [[Documentation/How_Tos/Calc: INTRATE function|INTRATE]]
 
* [[Documentation/How_Tos/Calc: INTRATE function|INTRATE]]
  
* [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]'''
+
* [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]
  
 
* [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]]
 
* [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]]
Line 40: Line 45:
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 
+
[[Category: Documentation/Reference/Calc/Financial functions]]
=== Issues: ===
+
* Calc and Excel do not agree on the number of days in a year in basis 1. It is not clear which is theoretically correct. Calc uses the number of days in the year containing <tt>'''settlementdate'''</tt>. See Issue 93527.
+
* Excel appears to have a bug for basis 4.
+

Latest revision as of 09:30, 17 July 2018


RECEIVED

Calculates the amount received at maturity for a zero coupon bond.

Syntax:

RECEIVED(settlementdate; maturitydate; purchasevalue; discountrate; basis)

settlementdate: the settlement (purchase) date of the bond.
maturitydate: the maturity (redemption) date of the bond.
purchasevalue: the value of the bond at purchase.
discountrate: the discount rate of the bond.
basis: is the calendar system to use. Defaults to 0 if omitted.
0 - US method (NASD), 12 months of 30 days each
1 - Actual number of days in months, actual number of days in year
2 - Actual number of days in month, year has 360 days
3 - Actual number of days in month, year has 365 days
4 - European method, 12 months of 30 days each


RECEIVED calculates the amount returned at maturity for a discounted bond which pays no interest. It returns:
purchasevalue / ( 1 - days_difference/days_in_year),
where days_difference is the number of days between settlementdate and maturitydate, and days_in_year is the number of days in a year, both calculated according to the calendar system basis.
As the formula takes no account of compounding, this function is most reliable for periods of less than a year. See Derivation of Financial Formulas for a formula review.

Example:

RECEIVED("2009-06-01"; "2009-12-31"; 10000; 5%; 1)

returns approximately 10300.5503.

Issues:

  • Calc and Excel do not agree on the number of days in a year in basis 1. It is not clear which is theoretically correct. Calc uses the number of days in the year containing settlementdate. See Issue 93527! Excel is de facto standard. ODF-Definition: Open Document Format for Office – Applications (OpenDocument) Version 1.2 Part 2: 6.12.43 RECEIVED
  • Excel appears to have a bug for basis 4.



See Also
Personal tools