When teaching depreciation in Introduction to Accounting, faculty always cover a variety of different depreciation methods, including straight-line depreciation. Next time you teach this topic, build ...

Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function to calculate the straight line -- a standard ...

You will notice that the results will give you a numeric array with an equal number of rows and columns. There are two other methods to use the MINVERSE function. Method one is to click the fx button ...

Hear more on calculation of depreciation in Excel from a Technology Q&A author, and hear from a risk management expert on what organizations have learned in the past year. The first section explains ...

SUMIF, SUMIFS, AVERAGEIFS, and COUNTIFS are commonly used accounting functions in Microsoft Excel. These formulas are used to calculate cell values based on the criteria you have described or ...

Depreciation expense can be a big portion of a company’s total expense. And since expenses decrease income, it affects the overall value of a company. Understanding what it is and the methods can help ...

Jim Mueller, CFA, began his career as a scientist. He has five years of experience as a senior analyst and another four years as a research analyst. David Kindness is a Certified Public Accountant ...