how to calculate percentage in openoffice calc

Basis is chosen from a list of options and indicates how the year is to be calculated. Period is the settlement period to be considered. Salvage is the salvage value of the capital asset at the end of the depreciable life. First_period is the end date of the first settlement period. Date_purchased is the date of acquisition. Unlike AMORLINC, a depreciation coefficient that is independent of the depreciable life is used here. * AMORDEGRC(cost date _purchased first_period salvage period rate basis)Ĭalculates the amount of depreciation for a settlement period as degressive amortization. Rate is the annual nominal rate of interest (coupon interest rate). * ACCRINTM(issue settlement rate par basis)Ĭalculates the accrued interest of a security in the case of one-off payment at the settlement date. Frequency is the number of interest payments per year (1, 2 or 4). First_interest is the first interest date of the security. * ACCRINT(issue first_interest settlement rate par frequency basis)Ĭalculates the accrued interest of a security in the case of periodic payments. US method ( NASD), 12 months of 30 days each.Įxact number of days in months, exact number of days in year.Įxact number of days in month, year has 360 days.Įxact number of days in month, year has 365 days.Įuropean method, 12 months of 30 days each. The following table gives the integers used for the basis parameter used in some of the financial analysis functions. However, if you enter it as 3.25, the function will treat it as a 325% interest rate.Īccounting systems vary in the number of days in a month or a year used in calculations. For example, to compute a loan with a 3.25% interest rate, enters 3.25% into the function.Įither way will work. To enter an interest rate as a percentage, type in the interest rate followed by the % key. For example, to compute a loan with a 3.25% interest rate, enter. To enter an interest rate as a decimal, divide it by 100 before entering it into a function. You can enter interest rates one of two ways.Īs a decimal.

How to calculate percentage in openoffice calc