Microsoft Office Tutorials and References
In Depth Information
SYD Based on a specified period, SYD returns the sum-of-years’ digits depreciation of an asset.
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
The asset’s initial cost.
The value at the end of the useful life of the asset.
The number of periods over which the asset will be depreciated.
The period for which you’re looking for the sum-of-year’s digits depreciation.
Based on a specified
period, SYD returns
of an asset.
For a treasur y bill, TBILLEQ returns the bond equivalent yield.
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%.