Income Statement Template in Excel

June 18, 2013
, , , , , , , , , , , , , , ,

This session will talk about:

  • Learn to create a layout for Income Statement

  • Create an Income Statement Template for LinkedIn

  • Learn the Best Practices for Creation of a "Financial Model Template".

What is an Income Statement?

An income statement is one of the financial statements of a company that shows the company’s revenues and expenses during a particular period. It indicates how the revenues (money received from the sale of products and services before expenses are taken out, also known as the “top line”) are transformed into the net income (the result after all revenues and expenses have been accounted for, also known as “net profit” or the “bottom line”). It displays the revenues recognized for a specific period, and the cost and expenses charged against these revenues, including write-offs (e.g., depreciation and amortization of various assets) and taxes. The purpose of the income statement is to show managers and investors whether the company made or lost money during the period being reported.

One important thing to remember about an income statement is that it represents a period of time like the cash flow statement. This contrasts with the balance sheet, which represents a single moment in time.

Income-Statement framework

The major components of an income statement template are:

Component 1: Revenues - Inflows from producing/delivering goods or services.

  • Sales - revenue from day to day activities

  • Investment Income - interest and dividend income

  • Gains - Increase in assets from transactions.

Component 2: Expenses - Outflows, ie., costs involved in from producing/delivering goods or services

  • Cost of Goods Sold (COGS)

  • Selling, general, and administrative expense (SG&A) - rent, salaries, advertising expenses etc.

  • Depreciation and amortization - decrease in value of assets over time

  • Tax expenses

  • Interest expenses

  • Losses - Decreases in assets from transactions.

Component 3: The equation used in making an Income Statement Template is: Revenues - Expenses = Net Income (gains/loss)

Example: An income statement template of Google, Inc. is shown below:

Income Statement Template of google

Getting access to Income Statement Template of a Real Life Company

  • With the advent of internet and IT, financial statements like income statements are getting more and more accessible to common man with every passing day. Most companies make available their quarterly and annual reports on their corporate website

  • In the US, all companies filing with the SEC (U.S. Securities and Exchange Commission) are required to supply their documents to a service called EDGAR

  • EDGAR has free access to more than 20 million filings

  • Go to SEC EDGAR search tools and get a tutorial on how to use EDGAR.

Income Statement

Creating an Income Statement Template

How to Create your own Income Statement?

To create your own Income statement for a company you can download the Annual Report filings for the company from the SEC website and copy the Income statement numbers from there into your own Income Statement Template.

Key Things to Note in an Income Statement Template:

  • Highlighting (using bold) major components like revenue, expenses etc.

  • Color coding - always differentiate values which are assumed and which are derived using different colors (For further details read our blog on color coding in Excel)

  • Enclose negative values within a bracket.

Taking a Step Forward

In case you wish to learn in depth about creating an Income Statement Template and complex financial models for companies, you can join our Financial Modeling course or watch our Free Webinars on Financial Modeling.

Download Templates for Income Statement

  • Unfilled Income Statement Template: I have created an Income statement template for you, where the subheadings are given. You can download the same from here. You can go through the case and fill in the yellow boxes. I also recommend that you try to create this structure on your own

  • Filled Income Statement Template: Download this filled template and check, if the information you recorded, matches mine or not!

Got Queries regarding the Cash impact or Financial Modeling???

You can also read our blog on Balance Sheet Template


About the Author

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Popular Courses

Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA® Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA® Institute, CFA® Program, CFA® Institute Investment Foundations and Chartered Financial Analyst® are trademarks owned by CFA® Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.

Post ID = 29460