Syntax<\/h3>\n
SLN(cost, salvage, life)<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The syntax of this formula is relatively simple when compared to other myriad financial formulas that Google Sheets is packed with. Nevertheless, we will try and practice this on the Google Sheets application to understand it better. Please have a look at the following image.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/SLN-formula-in-Google-Sheets-1.png” alt=”SLN formula in Google Sheets 1″ title_text=”SLN formula in Google Sheets 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As with the other formulas in Google Sheets, we can either use direct numeric values for the input parameters of the SLN formula. We demonstrated this in the first example. Or we could also use the\u00a0cell references as is the case with the second example.<\/p>\n If we try and analyze the working of this formula, it is probably very straightforward as to how the formula works. As indicated in the first paragraph, this formula uses straight-line method to calculate the depreciation amount. For ease of our understanding, if we were to assign a variable letter to each input as below:<\/p>\n The SLN formula should be evaluating\u00a0the output values using the following equation:<\/p>\n D = (C \u2013 S) \/ L<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And there you go! Use the SLN formula in Google Sheets to calculate the depreciation an asset undergoes over a period of time.<\/p>\n If you\u2019d like to learn more about the various formulas of Google Sheets, why not take a look at our blog posts on the DISC formula in Google Sheets <\/span><\/a>and RATE formula in Google Sheets<\/a>.<\/span><\/p>\n Alternatively, check out related blog posts below!<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" There are usually two kinds of assets \u2013 appreciating and depreciating assets. While investments such as stocks, bonds etc. fall into the former category, the purchases like a house and car belong to the latter category. Knowing how an asset depreciates plays a vital role in buying decisions. The\u00a0SLN\u00a0formula in Google Sheets employs a straight […]<\/p>\n","protected":false},"author":40,"featured_media":8423,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"There are usually two kinds of assets - appreciating and depreciating assets. While investments such as stocks, bonds etc. fall into the former category, the purchases like a house and car belong to the latter category. Knowing how an asset depreciates plays a vital role in buying decisions. The SLN<\/a> formula in Google Sheets employs a straight line method of calculating the depreciation an asset undergoes over a period of time. It considers three different input values as explained in below.\n\n
Usage: SLN formula in Google Sheets<\/h3>\n
\n
SLN formula<\/h3>\n
Syntax<\/h3>\nSLN(cost, salvage, life)<\/strong>\n
\n \t
Usage: SLN formula in Google Sheets<\/h3>\nThe syntax of this formula is relatively simple when compared to other myriad financial formulas that Google Sheets is packed with. Nevertheless, we will try and practice this on the Google Sheets application to understand it better. Please have a look at the following image.\n\n
![\"SLN](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/SLN-formula-Illustration-Frame-1.png\")
\n\nAs with the other formulas in Google Sheets, we can either use direct numeric values for the input parameters of the SLN formula. We demonstrated this in the first example. Or we could also use the\u00a0cell references as is the case with the second example.\n\nIf we try and analyze the working of this formula, it is probably very straightforward as to how the formula works. As indicated in the first paragraph, this formula uses straight-line method to calculate the depreciation amount. For ease of our understanding, if we were to assign a variable letter to each input as below:\n\n \t