<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CALC new formulas: Written down value & written down depreciation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134367#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CALC new formulas: Written down value & written down depreciation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134367">bug 134367</a>
from <span class="vcard"><a class="email" href="mailto:testing1237a-c@yahoo.com" title="johnks <testing1237a-c@yahoo.com>"> <span class="fn">johnks</span></a>
</span></b>
<pre>(In reply to Eike Rathke from <a href="show_bug.cgi?id=134367#c2">comment #2</a>)
<span class="quote">> 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.</span >
hey. this functionality is already built into excel and calc both. check
<a href="https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060103.html?DbPAR=CALC">https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060103.html?DbPAR=CALC</a>
and for excel
<a href="https://www.excel-easy.com/examples/depreciation.html">https://www.excel-easy.com/examples/depreciation.html</a>
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.
<a href="https://ifrscommunity.com/knowledge-base/depreciation-and-amortisation/#link-diminishing-balance-method">https://ifrscommunity.com/knowledge-base/depreciation-and-amortisation/#link-diminishing-balance-method</a>
this link for ifrs diminishing balance method
<a href="https://www.sapling.com/5109836/calculate-accumulated-depreciation">https://www.sapling.com/5109836/calculate-accumulated-depreciation</a>
for calculating depreciation as per indian laws.
this really isnt something new, just an improvement</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>