# Business Central Fixed Asset Depreciation Calculator > Source: https://netray.co/tools/business-central-fixed-asset-depreciation-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Preview straight-line and declining-balance book value and depreciation for a fixed asset before setting up its depreciation book. ## Category cost-finance ## Erp Dynamics 365 Business Central ## Audience - Accountant - Controller - BC consultant ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Acquisition cost **Key:** cost **Type:** number **Default:** 50000 **Min:** 0 **Step:** 500 **Unit:** $ #### Salvage value **Key:** salvage **Type:** number **Default:** 5000 **Min:** 0 **Step:** 500 **Unit:** $ **Help:** Residual value at the end of useful life. #### Useful life **Key:** life **Type:** slider **Default:** 5 **Min:** 1 **Max:** 20 **Step:** 1 **Unit:** years #### Declining balance rate **Key:** db_rate **Type:** number **Default:** 30 **Min:** 1 **Max:** 100 **Step:** 1 **Unit:** % per year **Help:** Fixed percentage applied to the opening book value each year. #### Year to analyse **Key:** year **Type:** slider **Default:** 3 **Min:** 1 **Max:** 10 **Step:** 1 **Unit:** year **Outputs:** #### Straight-line depreciation per year **Key:** sl_annual **Expr:** (cost - salvage) / life **Format:** currency #### Straight-line book value at year end **Key:** sl_book **Expr:** cost - min(year, life) * sl_annual **Format:** currency **Primary:** true #### Straight-line accumulated depreciation **Key:** sl_accum **Expr:** cost - sl_book **Format:** currency #### Declining balance book value at year end **Key:** db_book **Expr:** cost * pow(1 - db_rate / 100, year) **Format:** currency **Primary:** true #### Declining balance charge in that year **Key:** db_year **Expr:** cost * pow(1 - db_rate / 100, year - 1) * db_rate / 100 **Format:** currency #### Declining balance accumulated depreciation **Key:** db_accum **Expr:** cost - db_book **Format:** currency **Chart:** #### Book value by year **Type:** line **X:** year **From:** 1 **To:** 10 **Steps:** 10 **Series:** - sl_book - db_book **Disclaimer:** Year-based simplification. Business Central calculates depreciation by period and day count using the depreciation book's method, starting and ending dates and the Depreciation Table or No. of Years setting. Tax depreciation rules differ by country. ## Content **Intro:** Before you create a depreciation book or run Calculate Depreciation in Business Central, it helps to know what number to expect. This calculator shows straight-line and declining-balance results side by side for any year of an asset's life. **Sections:** #### How to use it **Body:** Enter the acquisition cost, expected salvage value and useful life, then choose the year you want to inspect. For declining balance, enter the percentage rate you plan to use on the depreciation book. The outputs show the year-end book value and accumulated depreciation under each method, and the chart plots both across ten years. #### The formulas **Body:** Straight-line depreciation is cost minus salvage, divided by life, charged equally each year until the asset reaches salvage. Declining balance multiplies the opening book value by the rate, so charges are largest early and shrink every year. Book value at year n equals cost times one minus rate, to the power n. Declining balance in this model does not stop at salvage; in BC you control the end through the book's ending date. **Bullets:** - Straight-line: BC method Straight-Line - Declining balance: Declining-Balance 1 and 2 methods, with a percentage you define - User-defined and Table methods exist for custom curves - Book value = acquisition cost + depreciation (posted as negative) #### Reading the result **Body:** Declining balance front-loads the expense, which suits assets that lose value quickly or tax regimes that allow accelerated write-offs. Straight-line is simpler and predictable. If the two lines cross, that is where straight-line depreciation would start to exceed declining balance, and where many policies switch methods. BC does not switch automatically. #### Common mistakes **Body:** Setting the depreciation starting date after the posting date of the acquisition, mixing book and tax depreciation in one book instead of using separate depreciation books, and forgetting that a mid-year start produces a partial first year. Check the Fixed Asset G/L Journal preview before you post the first run. **Cta:** If you are migrating fixed assets from NAV, AX or another ERP and need the register to tie out, we can help validate opening book values and depreciation start dates. **Faq:** #### Does this match what BC will post? **Answer:** It matches the annual shape, not the exact daily figures. BC uses a 360 or 365 day basis depending on settings, and partial first years change the first charge. Use this to plan, then confirm in a journal preview. #### Can I use it for tax depreciation? **Answer:** Only as a rough check. Tax methods vary by country, with prescribed rates and conventions. In BC, keep tax depreciation in a separate depreciation book so it does not affect the financial books. #### What if salvage value is zero? **Answer:** Set it to zero. Straight-line then writes the asset down to nothing over its life, and declining balance never reaches zero, so many policies set an ending date or a switch. #### Why does declining balance never reach salvage? **Answer:** Because each year takes a percentage of a shrinking balance. Choose an ending date on the depreciation book, or use another method for the final years. ## Search terms business central fixed asset depreciation, business central straight line depreciation, business central declining balance, depreciation book business central, calculate depreciation dynamics 365, fixed asset depreciation calculator --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json