Why depreciation rate resulted by test formula not same with rate in Depreciation Calculation Diagno
Hi,
I have an asset:
Asset ID = 90149
Method = DD-FISCAL-03 --base on formula
Method Formula = DECODE ( FLOOR ( <Remaining Life 1> ) , 0 , 0.5 , 1 , 0.5 , GREATEST ( 2 / <Life> , 1 / <Remaining Life 1> ) )
Life = 4 years
Cost = 200000000
Date Place In Service = 13Sep2018
Start Depreciation = NOV-18.
Why depreciation for period APR-22 get value = 3541667, why rate depreciation get 2.4 for that last years ?,
because in test formula should be 0.5
Here below What-If-Report base on Depreciation Calculator:
Asset | Period | Fiscal | Expense | Prorate | Life | Salvage | Basic | Adjust | New | |||
Number | Desc | Name | Year | Account | Cost | Convention | (Mos) | value | Rate | Rate | Depreciation | Depreciation |
90149 | CAP DASH | Nov-18 | 2019 | 10.756600.203 | 200,000,000 | ACTUAL MTH | 48 | 0 | 8,333,333 | 8,333,333 | ||
Dec-18 | 2019 | 10.756600.203 | 200,000,000 | ACTUAL MTH | 48 | 0 | 8,333,333 | 8,333,333 | ||||
Jan-19 | 2019 | 10.756600.203 | 200,000,000 | ACTUAL MTH | 48 | 0 | 8,333,333 | 8,333,333 | ||||
Feb-19 | 2019 | 10.756600.203 | 200,000,000 | ACTUAL MTH | 48 | 0 | 8,333,333 | 8,333,333 | ||||
Mar-19 | 2019 | 10.756600.203 | 200,000,000 | ACTUAL MTH |