Spreadsheets for Finance: How to Calculate Depreciation скачать в хорошем качестве

Spreadsheets for Finance: How to Calculate Depreciation

When you buy a capital asset for your business, like a machine, a vehicle, or property, you'll probably want to depreciate it over time. This will make your financial statements reflect that the asset is being used up gradually, rather than all at once. Here's how to calculate depreciation using the Straight-line, Declining balance, Double-declining Balance, and Sum of year's digits (SOYD) methods in a spreadsheet, in Microsoft Excel 2013. The same methods also work in the Google Sheets app in Google Drive, and in most other spreadsheet applications. View the companion tutorial and download an example spreadsheet at Tuts+: http://computers.tutsplus.com/tutoria.... By Bob Flisser.