Income Statement Template - Free Download

You know you can prepare your income statement in just a click. In ADโ€™s income statement template, you just have to put your figures and you will get your income statement in a minute. Income statement is also known as profit and loss statement. It depicts companyโ€™s true financial performance over a specific period of time. Moreover, it is one of the most important financial statement out of other statements such as balance sheet and cash flow statement.

DOWNLOAD THE INCOME STATEMENT TEMPLATE

Download your free income statement template now.

Income Statement Excel Template

Get Free Access to AD’s easy to useย  Statement Templateย 

IF IT INTEREST YOU, DO SHARE IT WITH YOUR FELLOWS.

How To Use The Template

How to prepare your own income statement using ADโ€™s template, in this section I will let you know.

INCOME STATEMENT EXCEL TEMPLATE

Here, you can get a quick snippet of your revenues, gross profit, and net income in the first rows of the template. But first you have to insert your own numbers in the blocks to get the desired results. The template contains three sheet, the first one is the introduction sheet, the second one is presenting a demo data (you can edit it too), and last one is totally blank where you can put your own numbers.

Itโ€™s very easy to use ADโ€™s excel template. Here are some useful tips on how to edit the template.

  • Fist download your free template.
  • Then make excel editable by clicking editable option pointing at the front top.
  • Enter you own numbers in cells
  • If you need to add more expenses or revenues, you have to add rows. You can add it by right clicking the cursor and click insert or simply use a short key (Ctrl + Shift + plus sign).
  • Such that you may need to remove some expenses or other rows. To do that simply point your cursor on that row and press delete button.

Income Statement Format

Income Statement Format

Steps of Preparing an Income Statement

Itโ€™s very easy to prepare an income statement because it requires only 8 steps to follow.

  • 1st Step:ย Calculate Net Sales
  • 2nd step:ย Calculate Cost of Goods Sold
  • 3rd Step:ย Calculate Gross Profit
  • 4th Step:ย Calculate Operating Expenses
  • 5th Step:ย Calculate Operating Income
  • 6th Step:ย Calculate the Net Income before Interest & Taxes (EBIT)
  • 7th Step:ย Calculate EBT
  • 8th Step:ย Calculate Net Income

Learn complete guide on how to prepare income statement here:

How to Prepare an Income Statement?

Solved Example

For your understanding, here is a dummy data and with the help of this data, you will learn how to prepare it.

The following data are related to Mr. Junaid after adjustment at Dec 31, XXXX:

  • Salesย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย $250,000
  • Merchandise inventory (opening) 10,000
  • Purchases 53,000
  • Commission incomeย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย 1,000
  • Sales discountย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  5,000
  • Junaid Drawingย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย 19,000
  • Utility expenseย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย 4,000
  • Depreciation expenseย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย 5,000
  • Bad debt expense ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย 3,000
  • Salaries expense ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย ย 10,000
  • Rent expense payableย  ย  ย  ย  ย  ย  ย  ย  ย  ย  ย  11,000
  • Allowance for bad debtsย  ย  ย  ย  ย  ย  ย  ย  ย  11,000
  • Merchandise inventory (ending)ย  ย  ย 15,000

Prepare an income statement with the help of above data.

Mr. Junaid

Income statement

For the period ended Dec 31, XXX

ย ย ย ย ย ย ย ย ย  Sales

ย 

$250,000

Less: Sales discount

ย 

ย ย ย ย ย ย  ย ย ย ย ย ย ย ย (5,000)

ย ย ย ย ย ย ย ย ย  Net Sales

ย 

245,000

Less: Cost of Goods Sold

ย ย 

ย ย ย ย ย ย ย ย ย  Opening Inventory

$10,000

ย 

Add:ย  Purchases

ย ย ย  53,000

ย 

ย ย ย ย ย ย ย ย ย  Goods available for sale

63,000

ย 

Less: Ending inventory

ย ย ย  (15,000)

ย 

ย ย ย ย ย ย ย ย ย  Cost of Goods Sold (COGS)

ย 

ย  (48,000)

ย ย ย ย ย ย ย ย ย  Gross Profit

ย 

197,000

Less: Operating expenses

ย 

ย 

ย ย ย ย ย ย ย ย ย  Utility expenseย 

4,000

ย 

ย ย ย ย ย ย ย ย ย  Depreciation expenseย ย 

5,000

ย 

ย ย ย ย ย ย ย ย ย  Bad debt expense

3,000

ย 

ย ย ย ย ย ย ย ย ย  Salaries expense

10,000

ย 

ย ย ย ย ย ย ย ย ย  Total operating expenses

ย 

ย  (22,000)

ย ย ย ย ย ย ย ย ย  Operating income

ย 

175,000

Add: Commission income

ย 

ย ย ย ย ย ย  1,000

ย ย ย ย ย ย ย ย ย  Net Income

ย 

ย  176,000

So, the net income for the period is $176,000.

Thanks for downloading ADโ€™s income statement template. Share this template with your friends.

Recommended Articles

Hira Aziz

Hira Aziz - Author

She is a Business Content writer and Management contributor at 12Manage.com, where she contributes a business article weekly. She has over 2 years of experience in writing about accounting, finance, and business.

Cash Flow Statement Template

Get Free Access to AD’s easy to use Cash Flow Statement Templateย 

Cash Flow Statement Template by Accounting Drive
Scroll to Top