LibreOffice 25.2 Help
Returns the arithmetic-declining depreciation rate.
SYD (Cost as Double, Salvage as Double, Life as Double, Period as Double)
Double
비용은 자산의 초기 비용입니다.
잔존 가치는 감가상각 이후에 남은 자산의 가치입니다.
내구년한은 자산의 감가상각에서 감가상각할 수 있는 기간의 총 횟수를 의미합니다.
Period is the period number for which you want to calculate the depreciation.
REM ***** BASIC *****
Option VBASupport 1
Sub ExampleSYD
REM Calculate the yearly depreciation of an asset that cost $10,000 at
REM the start of year 1, and has a salvage value of $1,000 after 5 years.
Dim syd_yr1 As Double
REM Calculate the depreciation during year 1.
syd_yr1 = SYD( 10000, 1000, 5, 1 )
print syd_yr1 ' syd_yr1 is now equal to 3000.
End Sub