Download Adjusted Gross Income Calculator Free Excel Template

Filter by Categories
Select all
Business Statements
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Invoice/ Bill
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
Filter by File Types

Download Adjusted Gross Income Calculator in Microsoft Excel and Spreadsheet for Federal Income Tax computation. This AGI or Adjusted Gross Income Calculator helps you calculate your tax bracket as well as tax liability.

What is Adjusted Gross Income?

Adjusted Gross Income (AGI) is the basis of various tax thresholds. It eventually helps to determine eligibility for certain tax credits.

Adjusted Gross income (AGI) is your total income less allowable deductions.

About Adjusted Gross Income Calculator Excel Template

Once you download this Federal Income tax – AGI Calculator template, You will see four different sections, namely,

  1. Firstly The Header Section
  2.  Secondly The Gross Income Section.
  3. Thirdly Allowable Deductions Section.
  4. Subsequently Calculation of AGI

1. Header Section

However, The header section contains the basic information around AGI Calculator. Also, If you are an advisory or consulting company you can add company name or logo in the template.

2. Gross Income Section

This section consists of income from different sources. These sources include:

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

Enter amounts of all applicable incomes in all respective cell. At the end, this will evaluate your Total Gross Income.

3. Allowable Deductions

These claimable deductions allowed by IRS are:

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

Therefore, Enter amounts of all applicable incomes in their respective cell. So, it will evaluate your Total Gross Income.

 4. Calculation of AGI

So, Now it is time to compute the adjusted gross income (AGI). The Calculation of AGI is 3 step process.

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

Therefore the Formula is:

So, AGI = Gross Income – Allowable Deductions

Where to find Adjusted Gross Income in tax return ?

Subsequently, Gross Income is the total of your income from all different sources. However, Gross Income doesn’t include gifts, inheritances, tax-free Social Security benefits or tax-free interest from state or local bonds. Moreover, Allowable deductions are the one claimable expenses allowed by IRS. Furthermore, The allowable deductions use to derive AGI deduction prior to tax exemptions for military service, dependent status, etc.

Download and use Adjusted Gross Income Calculator excel template

Now, let us look into how to use this Adjusted Gross Income calculator excel template. You should have Microsoft Office/ Microsoft Excel installed in your system.

Post installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip decompressing software. Once extracted, you can open the file using Excel and start entering data or customizing the template. You can change currency and fields but with caution.

Click the button below to Download Adjusted Gross Income Calculator Excel Template

By Downloading this Free Excel Template, it is implied that you comply with Download Instructions

Download Instructions

If the excel templates can not be downloaded, Leave us a message in the Comment Section. We will solve the related problems for you as soon as possible. All Excel templates and dashboards and tools are sole property of As a User, you can download and use the excel templates, dashboards and calculators for personal and business use with no payment i.e. for free, but without permission, you can not distribute it on the Internet website or CD/DVD channels !

Without permission granted from us/ management team of, use of these excel templates and dashboards is not allowed. However, if you want to share this templates and dashboards with your friends and peers, we have provided sharing option in various social media and platform via which you can share our content.

We hope that you can get our help in making your personal and business activities easier with the use of free excel templates and dashboards, and at the same time, support the construction of our website by considering our efforts and aforesaid instructions.