![]() Try Microsoft Edge A fast and. Balance sheet. Balance sheet that allows year over year comparison including accumulated depreciation. This is an accessible template. Professional Microsoft Access Template Databases with full source code built in all Microsoft Access Form, Tables, Report and VBA. Good morning all. This is my first post to the site, and what a wonderful site this is. I wish I had come across it years ago. I am working on a database that is going to track the assets for a non-profit organization. One of the aspects which they wish to have happen is to have the database auto-calculate the depreciation value of any given asset (straight-line). I have done several searches on this topic and in a previous post in the archives here it seemed to imply that there was a built-in straight-line depreciation calculation in access? I have not been able to find it. If anyone can tell me what it is or how to get it that would be great. I appreciate it! (I'm sure this is probably one of the easier posts to respond to. ![]() I will see what I can do to give some of you guru's a good challenge;-) Many thanks in advance! I do have that open, but I have not seen any specific calculation within that database. Perhaps I am not looking in the right spot, but while the tables have 'sample data' in them, there is nothing specific as to the way it was calculated. The only thing that I have found to be true to form is the way they calculate the total depreciation, which is (presumably) a summation of posted depreciation amounts. Thoughts or other ideas are welcome. See this link for the DDB method. The only difference between StraightLine and DDB is that SL does not have the 'factor'. Thus the annual SL depreciation would be computed as follows. (Cost - Salvage)/Life.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |