Technical data

Chapter 11 Using Built-in Functions in Analytic M odels

Parameters

Parameter Description

Cost The cost of th

easset.

Salvage The worth of the asset at the end of its useful life.

Life The number of periods in the asset’s useful life.

Period The period f

or which yo u wish to determine the depreciation.

Example

Suppose that you purchase a machine for 6,000 USD , and you plan to sell it for 500 USD after five years. You

can calculate the depreciation for each year as follows:

• SYD(6000, 500, 5, 1) = 1833

• SYD(6000, 500, 5, 2) = 1467

• SYD(6000, 500, 5, 3) = 1100

• SYD(6000, 500, 5, 4) = 733

• SYD(6000, 500, 5, 5) = 367

TAN

Syntax

TAN(Data)

Description

The TAN fun

ction returns the tangent of Data,whereData represents an angle in radians.

To convert f rom degrees to radians, multiply by PI( ) / 180. (The PI function returns the value of PI.)

Returns

Returns the tangent of Data,whereData represents an angle in radians.

Example

These exam

ples employ the TAN built-in function:

• TAN(PI( )) returns 0 (tangent of p radians).

• TAN(PI()/4)returns 1 (tangent of p / 4 radians).

• TAN(45 * PI( ) / 180) returns 1 (tangent of 45 degrees).