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.
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
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 (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.
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.
Got Queries regarding the Cash impact or Financial Modeling???
Put your comments below
Take a look at ourÂ Financial Modeling Program.
You can also read our blog on Balance Sheet Template
Related links you will like:
Using Colour Codes in Financial Modeling
Classification of items in Cash Flow Statement