How you can calculate Depreciation in STL Method
| Book Name | TEST |
| Fiscal Year | Asset Fiscal Year |
| Depreciation Calendar | Depr. Cal. |
| Depreciation Calendar Periods | 12 |
| Prorate Calendar | Depr. Cal. |
| Number of Prorate Period in Fiscal year | 12 |
| Depreciation Allocation | Evenly |
Suppose Asset:
| Date Placed in Service | 22-OCT-15 | ||||
| Prorate Date | 01-OCT-15 | ||||
| Deprciation Method | STL | ||||
| Depreciable Basis | COST | ||||
| Depreciation Start Date | 22-OCT-15 | ||||
| Cost | 524413.9 | ||||
| Salvage Value | 0 | ||||
| Recoverable Cost (Cost -Salvage Value) | 524413.9 | ||||
Period JUL-18 (1 of 12)
|
Element
|
Fomula
|
Value
|
Life
|
36
|
|
Annual Depreciation Rate
|
12 / Life
12/36 |
0.33
|
Current adjusted Cost
|
524413.9
|
|
Rate Adjustment factor
|
1
|
|
dpr_formula_factor
|
1
|
|
Current Fiscal Year Fraction
|
((Current Fiscal year end date + 1 - Current Fiscal year Starrt
date)) /(Current Fiscal year end date + 1 - Current Fiscal year Starrt
date)))
,(30-JUN-19 + 1 - 01-JUL-18) /(30-JUN-19 + 1 - 01-JUL-18)) |
1
|
Annualized Depreciation Amount For Fiscal Year
|
(Current Adjusted Cost/Rate Adjustment factor)*Annual
Depreciation rate*NVL(formula factor,1)
524413.9/1*.3333333333333333333333333333333333333333*1 |
174804.63
|
Actual Depreciation for current Fiscal year
|
Annualized Depreciation Amount For Fiscal Year * (Current Fiscal
Year Fraction/Adjustment first year fraction);
174804.63 * (1/1); |
174804.63
|
Current Period Fraction
|
1.0 / Number of Depreciation Period in Fiscal year
1.0 /12 |
0.08333333
|
Current Period Depreciation Amount
|
Annualized Depreciation Amount For Fiscal Year*Current Period
Fraction
174804.63*.0833333333333333333333333333333333333333 |
14567.05
|
Year to Date depreciaiton
|
NVL(Previous YTD ,0) + Current Period depreciation
0 + 14567.05 |
14567.05
|
Depreciation Reserve
|
NVL(Depreciation reserve for previous fiscal year,0)+ NVL(Year
to Date depreciation,0)
480712.73+ 14567.05 |
495279.78
|
Period AUG-18 (2 of 12)
| Period day range: | 01-AUG-2018 - 31-AUG-2018 |
| Fiscal Year: | 01-JUL-2018 - 30-JUN-2019 |
Element
|
Fomula
|
Value
|
Life
|
36
|
|
Annual Depreciation Rate
|
12 / Life
12/36 |
0.33
|
Current adjusted Cost
|
524413.9
|
|
Rate Adjustment factor
|
1
|
|
dpr_formula_factor
|
1
|
|
Current Fiscal Year Fraction
|
((Current Fiscal year end
date + 1 - Current Fiscal year Starrt date)) /(Current Fiscal year end date +
1 - Current Fiscal year Starrt date)))
,(30-JUN-19 + 1 - 01-JUL-18) /(30-JUN-19 + 1 - 01-JUL-18)) |
1
|
Annualized Depreciation Amount For Fiscal Year
|
(Current Adjusted Cost/Rate Adjustment factor)*Annual
Depreciation rate*NVL(formula factor,1)
524413.9/1*.3333333333333333333333333333333333333333*1 |
174804.63
|
Actual Depreciation for current Fiscal year
|
Annualized Depreciation Amount For Fiscal Year * (Current Fiscal
Year Fraction/Adjustment first year fraction);
174804.63 * (1/1); |
174804.63
|
Current Period Fraction
|
1.0 / Number of Depreciation Period in Fiscal year
1.0 /12 |
0.08333333
|
Current Period Depreciation Amount
|
Annualized Depreciation Amount For Fiscal Year*Current Period
Fraction
174804.63*.0833333333333333333333333333333333333333 |
14567.05
|
Year to Date depreciaiton
|
NVL(Previous YTD ,0) +
Current Period depreciation
14567.05 + 14567.05 |
29134.1
|
Depreciation Reserve
|
NVL(Depreciation reserve
for previous fiscal year,0)+ NVL(Year to Date depreciation,0)
480712.73+ 29134.1 |
509846.83
|
The given information was very excellent & Great tips, and awesome way to get exert tips from everyone, not only i like that post all peoples like that post, because of all given information was wonderful and it's very helpful for me.
ReplyDeleteAsset Management Software
Asset Tracking Software
IT Asset Management Software
Fixed Asset Management Software
Asset Management Software Dubai