Microsoft Office Tutorials and References

In Depth Information

**SYD**

SYD
Based on a specified period,
SYD
returns the sum-of-years’ digits depreciation of an asset.

=SYD(cost,salvage,life,per)

The
SYD
function returns the sum-of-years’ digits depreciation of an asset. In the example in

Figure 6.36, if you bought an asset for $700,000 and the salvage value is $350,000, the useful

life of the asset is 8 years. The sum-of-years’ digits depreciation is for the fifth period, resulting

in $38,889.

The asset’s initial cost.

COST

The value at the end of the useful life of the asset.

SALVAGE

The number of periods over which the asset will be depreciated.

LIFE

The period for which you’re looking for the sum-of-year’s digits depreciation.

PER

Figure 6.36

Based on a specified

period,
SYD
returns

the sum-of-years’

digits depreciation

of an asset.

TBILLEQ

For a treasur y bill,
TBILLEQ
returns the bond equivalent yield.

=TBILLEQ(settlement,maturity,discount)

The
TBILLEQ
function returns the bonds equivalent yield for a treasur y bill. The
TBILLEQ

function is found only if the Analysis Toolpak is installed. It must be turned on using the Add-Ins

command from the Tools menu. As you see in Figure 6.37, the treasur y bill’s settlement date

is 11/15/1999 and the maturity date is 2/25/2000. The treasur y bill’s discount rate is 8.9% and

the result is 9.26%.