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

Download Adjusted Gross Income Calculator Excel Template

Download Adjusted Gross Income Calculator Excel Template

AGI or Adjusted Gross Income Calculator helps you calculate define your tax bracket as well as your tax liability.

AGI is is the basis of several tax thresholds. It also helps to determine the eligibility for certain tax credits. AGI is your total income less of allowable deductions.

We have created an easy and ready to use Adjusted Gross Income Calculator in excel. You can use this excel template to calculate your AGI.

Adjusted Gross Income Calculator

You just need to enter your figures and it will automatically calculate your AGI.

Click here to download the Adjusted Gross Income Calculator Excel Template.

To download the same calculator in Numbers click the link below:

AGI Calculator Apple Numbers Template

You can download excel templates like Traditional IRA Calculator, Roth IRA Calculator and Income Statement Projection in Excel for easy calculations.

Let us discuss the contents of the template in detail.

Contents of Adjusted Gross Income Calculator Excel Template

The Adjusted Gross Income Calculator consists 4 sections.

  1. Header Section
  2. Gross Income Section.
  3. Allowable Deductions Section.
  4. Calculation of AGI

1. Header Section

The header section contains the heading ” AGI Calculator. If you are an advisory company you can add your company name or logo in the template.

Adjusted Gross Income Calculator

2. Gross Income Section

This section consists of income from different sources.

These sources include:

  • Wages / Salary.
  • Income from Dividends.
  • Income from Business/Business Partnerships.
  • Taxable Pension.
  • Alimony Received.
  • Rental Income.
  • Capital Gains on Investment.
  • Royalty Income.
  • Income from Farming activities.
  • Unemployed Compensations.

Adjusted Gross Income Calculator

Enter amounts of all applicable incomes in the respective cell.

At the end, it will evaluate your Total Gross Income.

3. Allowable Deductions

These claimable deductions allowed by IRS include:

  • Expenses made for Business Purposes.
  • Expenses related to rent or royalties.
  • Losses made during sale or exchange of properties.
  • Student Loan Interests.
  • Alimony paid.
  • Contributions to IRAs.
  • Contributions to Medical Saving Accounts.
  • 50% of Self employment tax.
  • Self-employed Health Insurance Expenses.

Adjusted Gross Income Calculator

Enter amounts of all applicable incomes in the respective cell.

At the end, it will evaluate your Total Gross Income.

 4. Calculation of AGI

The Calculation of AGI is a 3 step process.

  1. Adding income from all sources.
  2. Adding all applicable allowable expenses.
  3. The difference of Gross Incomes less of Allowable Deductions.

Adjusted Gross Income Calculator

Formula:

AGI = Gross Income – Allowable Deductions

Gross Income is the total of your income from all sources.

Gross Income doesn’t consist of gifts, inheritances, tax-free Social Security benefits or tax-free interest from state or local bonds.

Allowable deductions are those claimable expenses allowed by IRS.

The allowable deductions used to derive AGI deducted prior to tax exemptions for military service, dependent status, etc.

Example of Calculating Adjusted Gross Income

Mr. X has a salary of 5200 per month. Thus, his annual salary is 5200 x 12 = 62400

Income of Mr. X

Annual Salary – $ 62,400

Interests – $ 15,000

Rental Income – $ 7,500

Capital Gains – $ 1,000

Thus, adding the above figures the Total Gross Income of Mr. X is $ 85,900.

Deductions for Mr. X

Rent and Royalty expenses – $ 2,000

Losses from Sale or Exchange of Property – $ 14,500

Education expenses and Student Loan Interests – $ 5,000

IRA Contributions – $ 5,000

When you add all the above deductions, Mr. X’s allowable deduction is $ 26,500.

Adjusted Gross Income of Mr. X

Gross Income – Allowable Deductions

= $ 85,900 – $ 26,500

= $ 59, 400

= Adjusted Gross Income of Mr. X

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 Roth IRA Calculator Excel Template
Download Modified Adjusted Gross Income Calculator Excel Template »

Filed Under: Federal Income Tax Templates

You are Here: Home / Excel Templates / Federal Income Tax Templates / Download Adjusted Gross Income 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