# MACRS and Bonus Depreciation Fixed Asset Tax Worksheet

> Source: https://netray.co/tools/macrs-bonus-depreciation-fixed-asset-tax-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List new machines and estimate first year tax deduction from Section 179 expensing, bonus depreciation and the MACRS first year rate.

## Category

cost-finance

## Region

United States

## Audience

- Controller
- Plant manager
- Tax manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Asset

**Key:** asset

**Type:** text

#### MACRS class

**Key:** class

**Type:** select

**Options:**

- 5-year
- 7-year

#### Cost basis

**Key:** cost

**Type:** number

**Format:** currency

#### Section 179 elected

**Key:** s179

**Type:** number

**Format:** currency

#### Bonus percent

**Key:** bonus_pct

**Type:** number

**Unit:** %

**Help:** Enter the bonus percentage allowed for the placed in service date.

#### Year 1 MACRS rate

**Key:** rate1

**Type:** number

**Unit:** %

**Help:** Half-year convention: 20 for 5-year, 14.29 for 7-year.

#### Bonus deduction

**Key:** bonus_amt

**Type:** number

**Expr:** (cost - s179) * bonus_pct / 100

**Format:** currency

#### Year 1 MACRS

**Key:** macrs_amt

**Type:** number

**Expr:** (cost - s179 - (cost - s179) * bonus_pct / 100) * rate1 / 100

**Format:** currency

#### Total year 1 deduction

**Key:** y1

**Type:** number

**Expr:** s179 + (cost - s179) * bonus_pct / 100 + (cost - s179 - (cost - s179) * bonus_pct / 100) * rate1 / 100

**Format:** currency

**Rows:**

**Asset:** 5-axis machining center

**Class:** 7-year

**Cost:** 680000

**S179:** 0

**Bonus pct:** 0

**Rate1:** 14.29

**Asset:** Fiber laser cutter

**Class:** 7-year

**Cost:** 420000

**S179:** 100000

**Bonus pct:** 0

**Rate1:** 14.29

**Asset:** Plant forklift

**Class:** 5-year

**Cost:** 48000

**S179:** 0

**Bonus pct:** 0

**Rate1:** 20

**Asset:** CMM inspection system

**Class:** 7-year

**Cost:** 185000

**S179:** 0

**Bonus pct:** 0

**Rate1:** 14.29

**Totals:**

#### Total cost

**Key:** cost

**Agg:** sum

**Format:** currency

#### Total year 1 deduction

**Key:** y1

**Agg:** sum

**Format:** currency

**Summary:**

#### Year 1 deduction as percent of cost

**Key:** effective

**Expr:** if(gt(sum_cost,0), sum_y1 / sum_cost * 100, 0)

**Format:** percent

**Primary:** true

**Notes:** Illustrative only. Bonus percentages, Section 179 limits, mid-quarter convention and state decoupling change with tax law. Examples use a zero bonus percent so you must enter the rate that applies. Confirm with your tax adviser.

## Content

**Intro:** When a plant buys machines, the tax deduction in year one can differ a lot from book depreciation in the ERP. This worksheet estimates the first year federal deduction using Section 179, bonus depreciation and the half-year MACRS rate so finance and operations can compare purchase options.

**Sections:**

#### How to use it

**Body:** Enter each asset with its cost basis, the amount you plan to elect under Section 179, the bonus percentage that applies to the placed in service date and the year one MACRS rate for the class. The sheet applies the order the tax rules use: Section 179 first, then bonus on the remaining basis, then regular MACRS on what is left. Export to Excel to hand to your tax preparer.

**Bullets:**

- Use tax basis, which can differ from book cost
- Put separate rows for separate placed-in-service dates
- Check the mid-quarter convention if most purchases fall in Q4

#### Formula behind the numbers

**Body:** Year one deduction equals Section 179 plus bonus plus MACRS. Bonus equals bonus percent times basis after Section 179. MACRS equals the year one rate times basis remaining after Section 179 and bonus. In the sample, the 7-year laser cutter with 100,000 dollars elected leaves 320,000 dollars, of which 14.29 percent gives 45,728 dollars of MACRS, for a total near 145,728 dollars. Most CNC and fabrication equipment is generally 7-year property, while many vehicles and some computer equipment fall in 5-year, but confirm classification.

#### ERP and book versus tax notes

**Body:** ERP fixed asset modules such as SAP Asset Accounting depreciation areas, Oracle Fixed Assets books or Business Central fixed asset books can run a separate tax book. Use this worksheet to sanity check the tax book before year end or to model a purchase before it is set up. State rules may decouple from federal bonus depreciation, which creates a state difference you track separately.

#### Common mistakes

**Body:** Applying the half-year rate to assets that fall under mid-quarter convention, forgetting that Section 179 is limited by taxable income, and including land or building structure in equipment basis are frequent errors. Also, entering a bonus percent that no longer applies to the placed in service date overstates the deduction.

**Cta:** If you want asset cost, placed-in-service dates and tax books pulled straight from your ERP into a review report, we can build that read-only view with your finance team.

**Faq:**

#### Does this replace tax software?

**Answer:** No. It is a planning estimate for first year deductions. Final numbers, Form 4562 reporting and limits must come from your tax preparer or tax software.

#### What is the order of Section 179, bonus and MACRS?

**Answer:** Section 179 is taken first and reduces basis. Bonus depreciation applies to the remaining basis. Regular MACRS then applies to what is left after both.

#### Which MACRS class does machinery fall in?

**Answer:** Many manufacturing machines fall in 7-year property, but the class depends on the activity and asset class tables. Confirm in IRS Publication 946 or with your adviser.

#### Why is the bonus percent blank?

**Answer:** The allowed percentage depends on the placed-in-service date and current law, which has changed several times. Enter the value your adviser confirms.

## Search terms

macrs depreciation worksheet excel, bonus depreciation worksheet, first year tax depreciation machinery, section 179 and bonus depreciation template, equipment depreciation schedule tax, manufacturing equipment macrs 7 year

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json