# Oracle EBS Fixed Asset Straight-Line Depreciation Calculator > Source: https://netray.co/tools/oracle-ebs-fixed-asset-straight-line-depreciation-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Straight-line depreciation by life in months with salvage value, plus a net book value curve over the asset's life. ## Category oracle ## Erp Oracle E-Business Suite ## Audience - Fixed asset accountant - Controller - EBS finance user ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Asset cost **Key:** cost **Type:** number **Default:** 250000 **Min:** 0 **Step:** 1000 **Unit:** $ #### Salvage value **Key:** salvage_pct **Type:** number **Default:** 10 **Min:** 0 **Max:** 100 **Step:** 1 **Unit:** % of cost #### Life **Key:** life_months **Type:** number **Default:** 84 **Min:** 1 **Step:** 12 **Unit:** months **Help:** Oracle Assets stores asset life in months, for example 84 for 7 years. #### Months in service **Key:** months_elapsed **Type:** slider **Default:** 30 **Min:** 0 **Max:** 120 **Step:** 1 **Unit:** months **Outputs:** #### Salvage value **Key:** salvage **Expr:** cost * salvage_pct / 100 **Format:** currency #### Depreciable basis **Key:** base **Expr:** cost - salvage **Format:** currency #### Monthly depreciation **Key:** monthly **Expr:** base / life_months **Format:** currency **Primary:** true #### Accumulated depreciation **Key:** accumulated **Expr:** min(base, monthly * months_elapsed) **Format:** currency #### Net book value **Key:** nbv **Expr:** cost - accumulated **Format:** currency **Primary:** true #### Remaining life **Key:** remaining **Expr:** max(0, life_months - months_elapsed) **Format:** months **Chart:** #### Net book value and accumulated depreciation by month in service **Type:** line **X:** months_elapsed **From:** 0 **To:** 120 **Steps:** 41 **Series:** - nbv - accumulated **Disclaimer:** Does not model prorate conventions, mid-month rules, ceiling limits, bonus or tax methods. Oracle Assets applies the prorate convention and calendar in the first period, so compare with the Asset Details page. ## Content **Intro:** Fixed asset reconciliations often start with a simple question: what should this asset's accumulated depreciation be after this many months? This calculator answers it for straight-line depreciation using life in months, as stored in Oracle Assets. **Sections:** #### How to use it **Body:** Enter cost, salvage as a percent of cost, and the life in months from the asset's book assignment. Set months in service to the number of full depreciation periods already run. The result gives monthly depreciation, accumulated depreciation and net book value, and the chart shows both lines across ten years. Use it to sanity check a sample of assets against the Asset Details page or the Asset Reserve Detail report before a close. **Bullets:** - Use the depreciation periods run, not calendar months, if you have gaps. - Check for assets with zero life or expired lives with remaining NBV. - Confirm the salvage setting separately from the percentage convention. #### The formula **Body:** Straight-line depreciation is (cost - salvage) divided by life in months for each month. Accumulated depreciation after n months is the smaller of the depreciable basis and the monthly amount times n. Net book value is cost minus accumulated depreciation, and it flattens at salvage once the life is exhausted. If the first period uses a prorate convention such as half-month, the first and last periods differ slightly, which explains small differences against the system. #### Common mistakes and ERP notes **Body:** Differences between hand calculation and Oracle Assets are nearly always the prorate convention, a retirement or adjustment mid-life, a cost change that triggers a catch-up or prospective recalculation, or a different method on the tax book. Review the book control for the depreciation calendar and the deprn_basis_rule if the numbers disagree. Remember that corporate and tax books can differ, so check you are comparing the same book. **Bullets:** - Check the prorate calendar and convention for the date placed in service. - Review amortization adjustments after cost changes. - Reconcile to the general ledger accumulated depreciation account by category. **Cta:** If you want asset and depreciation exceptions flagged automatically across books, we can build a read-only reconciliation helper over your EBS data. **Faq:** #### Does Oracle Assets use life in months? **Answer:** Yes, the life of an asset is stored in months on its book assignment. For example a 7 year life is 84 months. Depreciation methods then apply rates or flat amounts based on that life. #### Why does my system amount differ by a small amount? **Answer:** The most likely cause is the prorate convention in the first period, such as half-month or mid-quarter, which changes the first and last periods. Rounding settings and prior adjustments are the next suspects. #### How does salvage value work? **Answer:** Salvage reduces the depreciable basis, so the asset depreciates from cost down to salvage and never below it under straight-line. You can use a percentage of cost or a fixed amount in the book assignment. #### Can I use this for tax books? **Answer:** Only if the tax book uses straight-line over a fixed life. Many tax methods, such as declining balance or table-based rates, are different, and you should use the method defined in the tax book. ## Search terms oracle assets straight line depreciation, straight line depreciation calculator, net book value calculator, oracle fixed assets depreciation method, monthly depreciation calculator, asset life in months calculator, ebs fixed assets reconciliation --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json