Income Statement Template in Excel
July 10th, 2013
TagsIncome statementIncome Statement in ExcelIncome Statement TemplateIncome Statement TemplatesTemplate for Income StatementTemplates for Income StatementTemplates for Income Statements
Join our Exclusive FREE Webinars on Financial Modeling: CLICK HERE
An income statement is a financial statement that reports the financial performance of a company over a span of time. It is also referred as â€œStatement of operationsâ€ or â€œStatement of earningsâ€ or more commonly "Profit and Loss Statement (P&L)â€. The major components of an income statement template are:
Component 1: Revenues â€“ Inflows from producing/delivering goods or services. This section includes:
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
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:
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 (http://www.sec.gov/) are required to supply their documents to a service called EDGAR.
EDGAR has free access to more than 20 million filings.
Go to http://www.sec.gov/edgar/searchedgar/webusers.htm and get a tutorial on how to use EDGAR.
Creating an Income Statement Template
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: CLICK HERE )
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 join 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???
- Put your comments below
- Email us @ firstname.lastname@example.org
- Register for our FREE Webinars on Financial Modeling
- Take a look at our Financial Modeling Program
About the Author
EduPristine is trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe. One of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, Operational Risk Modeling etc. It was founded by industry professionals who have worked in the area of investment banking and private equity in organizations such as Goldman Sachs, Crisil - A Standard & Poors Company, Standard Chartered and Accenture. EduPristine has conducted corporate training for various leading corporations and colleges like JP Morgan, Bank of America, Ernst & Young, Accenture, HSBC, IIM C, NUS Singapore etc. EduPristine has conducted more than 500,000 man-hours of quality training in finance.
FREE 10 days
- about edupristine
- about pristine
- Business Analytics
- career guidance
- Career in Finance
- CFA Concept Checkers
- CFA exam prep
- CFA exam updates
- CFA high scoring tips
- CFA level 1 and 2
- CFA practice test
- Chartered Financial Analyst (CFA)
- classes updates
- current affairs learning
- Detailed CFA blogs
- Diagnose FRM
- edupristine new updates
- exam tips
- Excel FRM
- Fin mod templates
- Financial Modeling
- Financial modeling concept checkers
- Financial Modeling Templates
- Financial Risk Manager (FRM)
- Free Quizzes
- FRM concept checkers
- FRM exam analysis
- FRM exam prep
- FRM exam updates
- FRM expert interviews
- FRM Interviews
- FRM Questions and Answers
- GARP and FRM news
- General updates
- job openings
- job profiles
- jobs in finance
- Learning systems updates
- News and Discussion
- open source financial models
- other courses
- other job openings
- pristine new updates
- Professional Risk Manager (PRM)
- Project Management
- Questions of the day
- Tips and Material
- Value at Risk (VAR)
- webinar blogs
- webinar updates
- webinar updates