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
|
