From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/sbasic/shared/03140012.xhp | 74 ++++++++++++++++++++++ 1 file changed, 74 insertions(+) create mode 100644 helpcontent2/source/text/sbasic/shared/03140012.xhp (limited to 'helpcontent2/source/text/sbasic/shared/03140012.xhp') diff --git a/helpcontent2/source/text/sbasic/shared/03140012.xhp b/helpcontent2/source/text/sbasic/shared/03140012.xhp new file mode 100644 index 000000000..9ad42e26b --- /dev/null +++ b/helpcontent2/source/text/sbasic/shared/03140012.xhp @@ -0,0 +1,74 @@ + + + + + + + SYD Function [VBA] + /text/sbasic/shared/03140012.xhp + + + + + + +
+ + SYD function + + + +SYD Function [VBA] +Returns the arithmetic-declining depreciation rate. +
+ + + +SYD (Cost as Double, Salvage as Double, Life as Double, Period as Double) + + +Double + +Cost is the initial cost of an asset. +Salvage is the value of an asset at the end of the depreciation. +Life is the depreciation period determining the number of periods in the depreciation of the asset. +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 + + +
+SYD function in CALC + +
+ + + \ No newline at end of file -- cgit v1.2.3