• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Section 179 Deduction Calculator Excel Template

Download Section 179 Deduction Calculator Excel Template

Section 179 Deduction Calculator is an excel template to help you calculate the amount you could save on your tax bill by taking the Section 179 Deduction.

As we all know Section 179 deduction is an immediate expense available to business owners on the purchase of business equipment during the tax year instead of depreciating or capitalizing over multiple years.

This initiative was taken by the government to encourage the small and medium businesses to save money on the tax bill and use it for business enhancement.

Many taxpayers have taken benefit of it and you should also go for it.

To take advantage of these high Section 179 limits for 2017, the equipment must be purchased and put into service by midnight 12/31/2017.

There is a good news for the preceding years, the limits for the year 2018 has been increased to $ 10,00,000 (1 mn).

The limit in the year 2017 is $ 5 00,000 with the threshold limit of total equipment to be $ 2 mn.

Keeping in mind all the above points, we have created Section 179 Deduction Calculator with predefined formulas.

You just need to enter a few amounts and you tentatively know that how much amount you could save on your tax bill. It is a very simple and easy to use this calculator.

Click here to download Section 179 Deduction Calculator.

To download Section 179 deduction calculator in Number for Mac users click on the link below:

Section 179 deduction calculator in Number

We have created some useful templates in excel to help simplify the process of calculating your federal income tax.

Click on the link to download the templates like Simple Tax Estimator, Itemized Deductions Calculator, 401k Calculator and Child Tax Credit Calculator etc.

Let us discuss the contents of the template in detail.

Contents of Section 179 Deduction Calculator

Section 179 Deduction Calculator consists of 2 sections:

  1. Taxpayer’s Details
  2. Section 179 Deductions

1. Tax Payer’s Details

Taxpayer’s section consists of following:

Taxable Income: Enter your taxable income here in this cell. The purpose to provide taxable income here is that according to section 179 (b) (3), the deduction amount shall not exceed the aggregate amount of taxable income of the taxpayer.

Section 179 Deduction Calculator

Thus, if the deduction amount is above the taxable income then section 179 deduction cannot be available.

Tax bracket: You need to enter the tax bracket in the second cell on the left. This will help us calculate the amount you saved on tax.

Tax year: Applicable Tax year. Please keep in mind the calculator is designed according to the limits and threshold of the year 2017 for Section 179 deductions.

Total Cost of Equipment: Enter the total cost of equipment for which you are planning to claim the Section 179 deduction.

Only 4 things need to be provided in Section 179 Deduction Calculator to calculate the amount of available benefit.

2. Section 179 Deductions

When you have entered the above amounts in the taxpayer’s details section, Section 179 Deduction will calculate the total amount of deduction.

Section 179 Deduction Calculator

Total Amount Of Deduction = Section 179 Deduction + Bonus Depreciation + Allowed Depreciation 

Where:

Section 179 Deduction = Cost of Equipment up to $ 5,00,00.

Bonus Deduction = 50% of the Value left after deducting $ 500,000.

If the value of the equipment is less than $500,000 then the bonus depreciation will not be available as the total value of the asset is shown as an expense.

1st year Allowed Depreciation = 10% of the balance amount remaining after deducting $ 500,000. 

Similar to Bonus Depreciation, the first year depreciation is also not available if the amount is below $ 500,000 as the total value of the equipment has been written off as an expense.

Disclaimer: Interpretation of the above topics is for education purpose and cannot be considered as a legal advice. It is highly recommendable to consult a CPA or tax consultant before going for section 179 deductions.

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

« Download 401k Calculator Excel Template
Download Adoption Tax Credit Calculator Excel Template »

Filed Under: Federal Income Tax Templates

You are Here: Home / Excel Templates / Federal Income Tax Templates / Download Section 179 Deduction Calculator Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Federal Income Tax Templates

  • Traditional IRA Calculator Excel Template
  • Roth IRA Calculator Excel Template
  • Adjusted Gross Income Calculator Excel Template
  • Modified Adjusted Gross Income Calculator Excel Template
  • Traditional VS Roth IRA Calculator in Excel
  • Simple Tax Estimator Excel Template
  • Itemized Deductions Calculator Excel Template
  • Schedule B Calculator Excel Template
  • Child Tax Credit Calculator Excel Template
  • 401k Calculator Excel Template
  • Section 179 Deduction Calculator Excel Template
  • Adoption Tax Credit Calculator Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • Calculators
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2025. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT