AMORLINC

AMORLINC - This function calculates the amount of depreciation for a settlement period as linear amortization. If the capital asset is purchased during the settlement period, the proportional amount of depreciation is considered.

Syntax:

AMORLINC(Cost;Date purchased;First period;Salvage;Period;Rate;Basis)

Cost: the acquisition costs.

Date purchased: the date of acquisition.

First period: the end date of the first settlement period.

Salvage: The salvage value of the capital asset at the end of the depreciable life.

Period: the settlement period to be considered.

Rate: the rate of depreciation.

Basis: is chosen from a list of options and indicates how the year is to be calculated.

• 0 or missing - US Method (NASD), 12 months of 30 days each
• 1 - exact number of days in month, exact number of days in year
• 2 - exact number of days in month, year has 360 days
• 3 - exact number of days in month, year has 365 days
• 4 - European Method, 12 months of 30 days each

Example:

The cost is 2000. What is the depreciation on the first period for an asset that was acquired on September 22, 2007, where the end of the first period is December 26, 2007. The salvage value is 300, the depreciation rate is 12 percent and the actual number of days in the months and years are used.

=AMORLINC(2000;"9.22.2007";"12.26.2007";300;1;0.12;1) will return 553


Screen Shot:

AMORDEGRC

AMORDEGRC - this function calculates the amount of depreciation for a settlement period as degressive amortization.

Syntax:

AMORDEGRC(Cost;Date purchased;First period;Salvage;Period;Rate;Basis)

Cost: the acquisition costs.

Date purchased: the date of acquisition.

First period: the end date of the first settlement period.

Salvage: The salvage value of the capital asset at the end of the depreciable life.

Period: the settlement period to be considered.

Rate: the rate of depreciation.

Basis: is chosen from a list of options and indicates how the year is to be calculated.

• 0 or missing - US Method (NASD), 12 months of 30 days each
• 1 - exact number of days in month, exact number of days in year
• 2 - exact number of days in month, year has 360 days
• 3 - exact number of days in month, year has 365 days
• 4 - European Method, 12 months of 30 days each

Example:

The cost is 2000. What is the depreciation on the first period for an asset that was acquired on September 22, 2007, where the end of the first period is December 26, 2007. The salvage value is 300, the depreciation rate is 12 percent and the actual number of days in the months and years are used.

=AMORDEGRC(2000;"9.22.2007";"12.26.2007";300;1;0.12;1) will return 553


Screen Shot:

ACCRINTM (Calculates the accrued interest of a security in the case of one-off payment at the settlement date)

ACCRINTM - Calculates the accrued interest of a security in the case of one=off payment at the settlement date.


Syntax:

ACCRINTM(Issue;Settlement;Rate;Par;Basis)

Issue: issue date of the security.

Settlement: date at which the interest accrued up until then is to be calculated.

Rate: annual nominal rate of interest (coupon interest rate)

Par: par value of the security.

Basis: is chosen from a list of options and indicates how the year is to be calculated.

• 0 or missing - US Method (NASD), 12 months of 30 days each
• 1 - exact number of days in month, exact number of days in year
• 2 - exact number of days in month, year has 360 days
• 3 - exact number of days in month, year has 365 days
• 4 - European Method, 12 months of 30 days each

Example:

A security is issued on February 4, 2007. The maturity date is set for September 22, 2007. The Rate is 9% and Par is 1000 currency units. The basis of the daily/annual calculation is the daily balance (3). How much interest has accrued?

=ACCRINTM("2.4.2007"; "9.22.2007"; .09; 1000; 3) returns 56.71232877.

Note: The month, day, and year are separated by a period. Also the entire date must be in "".


Screen Shot:

ACCRINT (Accrued interest)

ACCRINT - Returns the accrued interest for a security that pays periodic interest.

Syntax:

ACCRINT(Issue;First Interest;Settlement;Rate;Par;Frequency;Basis)

Issue: issue date of the security.

First interest: first interest date of the security.

Settlement: date at which the interest accrued up until then is to be calculated.

Rate: annual nominal rate of interest (coupon interest rate)

Par: par value of the security.

Frequency: number of interest payments per year (1, 2 or 4).

• Yearly = 1
• Semiannually = 2
• Quarterly = 4

Basis: is chosen from a list of options and indicates how the year is to be calculated.

• 0 or missing - US Method (NASD), 12 months of 30 days each
• 1 - exact number of days in month, exact number of days in year
• 2 - exact number of days in month, year has 360 days
• 3 - exact number of days in month, year has 365 days
• 4 - European Method, 12 months of 30 days each

Example:

A security is issued on January 3, 2007. First interest is set for November 12, 2007. The settlement date is May 16, 2007. The Rate is 11% and Par is 1000 currency units. Interest is paid quarterly. The basis is the US method (0). How much interest has accrued?

=ACCRINT("1.3.2007"; "11.12.2007"; "5.16.2007"; 0.11; 1000; 4; 0) returns 40.63888889

Note: The month, day, and year are separated by a period. Also the entire date must be in "".


Screen Shot: