Using Microsoft Excel's Straight-line and Sum-of-the-years Digits Depreciation Functions Business Articles | September 28 Cheap Asics Womens Shoes , 2012 Analyzing real estate investments? Making book depreciation calculations? Microsoft Excel can help. Excel's SLN, or straight-line depreciation, function lets you easily calculate standard straight-line depreciation amounts. And Excel's SYD, or sum-of-the-years-digits, function lets you easily calculate standard sum of the year's digits depreciation.
Excel provides handy depreciation functions for making straight-line depreciation calculations (which are typically used for real estate depreciation) and for making sum-of-the-years-digits depreciation calculations (which may be used for book depreciation.). As you might expect, both are straight-forward to use and easy to understand.
Straight-line Depreciation calculations with the SLN function
The SLN function calculates straight-line balance depreciation for an asset given the cost Cheap Asics Shoes , its salvage value, and its estimated economic life. The DDB function uses the following syntax:
SLN (cost, salvage, life)
Suppose, for example, that you must calculate the straight-line depreciation for equipment that costs $50 Cheap Asics Running Shoes Online ,000, lasts five years, will have a salvage value of $10,000 at the end of the fifth year. To calculate the depreciation for the first year, you use the following formula:
The function returns the value 8000.00. To calculate the depreciation for the second year, you use the same formula because straight-line depreciation is the same for each year period.
Sum-of-the-Years-Digits Depreciation calculations with the SYD function
The SYD function calculates sum-of-the-years-digits depreciation for an asset given the cost, its salvage value, estimated economic life, and the accounting period for which depreciation is being calculated. The SYD function uses the following syntax:
Suppose, for example, that you must calculate the sum-of-the-years-digits depreciation for equipment that costs $50,000, lasts five years Cheap Asics Gel Kayano Shoes Online , and will have a salvage value of $10,000 at the end of the fifth year. To calculate the depreciation for the first year, use the following formula:
=SYD (50000,10000,5,1)
The function returns the value 13333.33. To calculate the depreciation for the second year Cheap Asics Womens Shoes Online , you use the formula
Organic Chemistry is the most interesting and easy to learn subject of all the sciences. However a lot of students find it daunting. The fear of Organic chemistry pervades from a lack of understanding of the subject which itself stems from a incorrect approach to learning the subject.
There are two basic steps in learning organic chemistry - Reasoning and Practice. In my experience of twenty years teaching chemistry, I have come across a lot of students and they have done very well for themselves by just following the above steps. Some of the basic considerations that go into learning chemistry are as follows:
1. Organic chemistry is not tough. Organic chemistry is not tough at all. It is one of the most systematic sciences. This subject needs more practice and if you are comfortable in writing and identification of compounds from different structural notations, I am sure that it will provide you with a good start. Remember that 40 percent of organic chemistry is done if you are good at identification of structural formulae or writing the structures.
2. Don't just read it - practice it. - You can clear your concepts only by doing questions. You need to do minimum 10-20 different questions from every concept in order to master it. For example, Carbocations concept governs the preferred product formation in many a reactions. Every book has a detailed explanation of the meaning and stability of the carbocations. Understanding the concept of order of stability is very simple and straightforward, However the problem occurs when you start to apply the concepts to the problem. Identification of different types of carbocations becomes easy only after you have practiced different questions based on it
3. Breakup Your Chapter Into Small Topics. For example Cheap Asics Running Shoes , Writing Lewis Structures, Resonance, Tautomerism etc. You need not cram the language given in the book, Read the topics thoroughly to understand them. For example in the resonance topics, there are many do:s and don't:s. Do not cram them because you will not achieve anything by doing so. What is important is to practice the rules by doing questions based on the notes. You can rest assured that no professor would ask you to list out the rules during the exam - but applications of the rules forms the favorite questions of many a professors. They may also appear in the True False statements but they can be attempted very well if the topic has been understood well by you.
4. Understanding The Organic Reactions To Master Them. Organic reactions can only be mastered by understanding them. Every atom behaves in a reaction with