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

Download Section 179 Deduction Calculator Apple Numbers Template

Download Section 179 Deduction Calculator Apple Numbers Template

50% of our readers demanded the Section 179 Deduction Calculator in Numbers as most of them are Mac user. Thus, we decided to make our first-ever template in Numbers. It was really enjoyable to work with Numbers.

Section 179 Deduction Calculator in Numbers is a template which calculates the money amount saved by you while opting for Section 179 Deduction Calculator.

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

The limits for the year 2018 has been increased to $ 10,00,000 (1 mn) from $ 500,000.

Note: To claim the Section 179 Deduction, the equipment should be purchased and put into service by midnight 12/31/2017.

Section 179 Deduction is an immediate expense deduction allowed to small businesses to claim the purchase price of their business equipment up to $ 500,000 under certain conditions to be met.

Conditions:

  1. The property should be in taxpayer’s name or must have the legal rights over it.
  2. It should be tangible, depreciable and personal property.
  3. Purchased and put to use in the same year.
  4. Acquired from a non-related party.

Different type of property has a different ruling like a motor vehicle, manufacturing equipment etc.  Publication 946 for more about depreciation and Section 179 deduction.

Section 179 Deduction Calculator in Numbers

We have created a simple and ready to use Numbers Template for Section 179 Deduction Calculator with predefined formulas. You just need to insert your basic details and it will automatically calculate the amount for you.

Click here to download Section 179 Deduction Calculator In Numbers.

To download the same in Microsoft Excel click on the link below:

Section 179 Deduction Calculator Excel Template

This template can be helpful for individuals to calculate the amount Section 179 Deductions

Let us discuss the contents of the template in detail.

Contents of Section 179 Deduction Calculator in Numbers

Section 179 Deduction Calculator in Numbers consists of 2 sections:

  1. Taxpayer’s Details
  2. Deductions

1. Taxpayer’s Details

Taxpayer’s detail consists of detail the following:

Taxable Income: It is mandatory to enter the taxable income in the template because if your taxable income is less than the claimed amount of Section 179 deduction you don’t qualify for the deduction.

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 in Numbers

Tax Bracket: Enter your tax bracket in which you fall for the tax year.

Tax Year: Year for which the Section 179 deduction is claimed.

Cost of Equipment: Total cost of equipment purchased and put to use in the tax year.

2. Deductions

Deduction section consists of the calculations. Here the user doesn’t need to enter anything. All the cells in this section contain predefined formulas. The deductions section consist of the following:

Section 179 Deduction: Section 179 Deduction for any equipment up to $ 500,000 is permitted by law.

If your equipment is above $ 500,000 you get only $ 500,000. If below you can write off the complete equipment in the first year itself.

50% Bonus Depreciation: In case the equipment is above the $ 500,000 threshold, then you are entitled to a 50% bonus depreciation.

For example, the cost of your equipment is $ 650,000. You are entitled to write off the $ 500,000 as section 179 deduction and also be able to claim the 50% bonus depreciation on the balance amount; that is $ 75000 (150,000 x 50%).

Section 179 Deduction Calculator in Numbers

1st Year Depreciation: First-year depreciation is taken as 10% of the balance amount. Similar to bonus depreciation, this depreciation is claimable on if the value of the deduction is above $ 500,000.

Total First Year Deduction: This cell will give you the total amount of deduction you will get in the first year of the purchase of the equipment.

Total Deductions = Section 179 + Bonus Depreciation + Regular Depreciation

In addition to the above, the cost you will save will also consist of the amount of tax you will save along with the deductions.

Cash Saving on Purchase = Total Deductions X Tax Brackets

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 Simple Tax Estimator Apple Numbers Template »

Filed Under: Federal Income Tax Apple Numbers Templates

You are Here: Home / Excel Templates / Federal Income Tax Templates / Download Section 179 Deduction Calculator Apple Numbers 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 Numbers Templates

  • Section 179 Deduction Calculator Apple Numbers Template
  • Simple Tax Estimator Apple Numbers Template
  • Itemized Deduction Calculator Apple Numbers Template
  • AGI Calculator Apple Numbers Template
  • Schedule B Calculator Apple Numbers 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