[Libreoffice-bugs] [Bug 134367] CALC new formulas: Written down value & written down depreciation

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134367

--- Comment #3 from johnks <testing1237a-c at yahoo.com> ---
(In reply to Eike Rathke from comment #2)
> If this isn't core functionality of one of the major spreadsheet
> implementations I'd rather say this is something for an Add-In extension
> that someone with a financial background could implement.

hey. this functionality is already built into excel and calc both. check 
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060103.html?DbPAR=CALC

and for excel 
https://www.excel-easy.com/examples/depreciation.html

these formula exist but the issue i have is they dont use the "%" method of
calculating depreciation while in taxes and usually even, we are supposed to
calculate depreciation based on opening values and the useful life is ignored.

https://ifrscommunity.com/knowledge-base/depreciation-and-amortisation/#link-diminishing-balance-method

this link for ifrs diminishing balance method 

https://www.sapling.com/5109836/calculate-accumulated-depreciation

for calculating depreciation as per indian laws.

this really isnt something new, just an improvement

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200714/5cfe494f/attachment.htm>