SYD Function [VBA]
Returns the arithmetic-declining depreciation rate.
यस k, कार्य वा वस्तुले प्रयोगयोग्य कार्यक्रम कोडमा एक मोड्युलमा प्रयोग गरिएको Option VBASupport 1 विधानसहितका अगाडि सक्षम गरिएको छ।
SYD (Cost as Double, Salvage as Double, Life as Double, Period as Double)
Double
लागत एउटा सम्पत्तिको सुरुआत लागत हो ।
बचेको ह्रास कट्टीको अन्त्यको बचेको मूल्य हो ।
Life मूल्यह्रास अवधि हो जसले सम्पत्ति को मूल्यह्रास हुने अवधि को संख्या निर्धारण गर्छ।
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