Financial Analysis Functions

Apache OpenOffice 4.1 Calc Guide

Appendix B — Description of Functions

< Previous Section

Next Section >

• Functions Available in Calc
  • Terminology: Numbers and Arguments
• Mathematical Functions
• Financial Analysis Functions
  • A Note About Dates
  • A Note About Interest Rates
• Statistical Analysis Functions
• Date and Time Functions
• Logical Functions
• Informational Functions
• Database Functions
• Array Functions
• Spreadsheet Functions
• Text Functions
• Converting Decimal, Binary, Octal, Hexadecimal
• Complex Number Functions

< Previous Page

Next Page >

Financial Analysis Functions

Accounting systems vary in the number of days in a month or a year used for calculations. The following table lists the integers used for the basis parameter in some financial analysis functions.

Table 37: Basis calculation types

Basis	Calculation
0 or missing	US method (NASD), 12 months of 30 days each, a year has 360 days.
1	Exact number of days in each month and year.
2	Exact number of days in a month, a year has 360 days.
3	Exact number of days in a month, a year has 365 days.
4	European method, 12 months of 30 days each.