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%.
Search JabSto ::

Custom Search