Net Income Template
This net income template shows you the calculation of net income using line items from an income statement.
Below is a screenshot of the net income template:
Download the Free Template
Enter your name and email in the form below and download the free template now!
Net income is the amount of accounting profit a company has left over after paying off all its expenses. Net income is found by taking sales revenueSales RevenueSales revenue is the income received by a company from its sales of goods or the provision of services. In accounting, the terms "sales" and "revenue" can be, and often are, used interchangeably, to mean the same thing. Revenue does not necessarily mean cash received. and subtracting COGS, SG&ASG&ASG&A includes all non-production expenses incurred by a company in any given period. This includes expenses such as rent, advertising, marketing, accounting, litigation, travel, meals, management salaries, bonuses, and more. On occasion, it may also include depreciation expense, depreciation, and amortization, interest expenseInterest ExpenseInterest expense arises out of a company that finances through debt or capital leases. Interest is found in the income statement, but can also be calculated through the debt schedule. The schedule should outline all the major pieces of debt a company has on its balance sheet, and calculate interest by multiplying the, taxes and any other expenses.
Net income is the last line item on the income statementIncome StatementThe Income Statement is one of a company's core financial statements that shows their profit and loss over a period of time. The profit or loss is determined by taking all revenues and subtracting all expenses from both operating and non-operating activities.This statement is one of three statements used in both corporate finance (including financial modeling) and accounting. proper. Some income statements, however, will have a separate section at the bottom reconciling beginning retained earningsRetained EarningsThe Retained Earnings formula represents all accumulated net income netted by all dividends paid to shareholders. Retained Earnings are part of equity on the balance sheet and represent the portion of the business’s profits that are not distributed as dividends to shareholders but instead are reserved for reinvestment with ending retained earnings through net income and dividendsDividend Per Share (DPS)Dividend per share is the total amount of dividend attributed to each share outstanding. The formula is total dividends / shares outstanding or earnings per share x dividend payout ratio. Calculating the DPS allows an investor to determine how much income from the company.
The net income is very important in that it is a central line item to all three financial statementsThree Financial StatementsThe three financial statements are the income statement, the balance sheet, and the statement of cash flows. These three core statements are intricately linked to each other and this guide will explain how they all fit together. By following the steps below you'll be able to connect the three statements on your own.. While it is arrived at through the income statement, the net profit is also used in both the balance sheetBalance SheetThe balance sheet is one of the three fundamental financial statements. These statements are key to both financial modeling and accounting. The balance sheet displays the company’s total assets, and how these assets are financed, through either debt or equity. Assets = Liabilities + Equity and the cash flow statementCash Flow StatementA Cash Flow Statement (officially called the Statement of Cash Flows) contains information on how much cash a company has generated and used during a given period. It contains 3 sections: cash from operations, cash from investing and cash from financing..
Net income flows into the balance sheet through retained earnings, an equity account. This is the formula for finding ending retained earnings:
Ending RE = Beginning RE + Net Income – Dividends
Assuming there is no dividends, the change in retained earnings between periods should equally the net earnings in those periods. If there is no mention of dividends in the financial statements, but the change in retained earnings does not equal net profit, then it’s safe to assume that the difference was paid out in dividends.
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.
- Excel Modeling TemplatesExcel & Financial Model TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
- PowerPoint Presentation Templates
- Transaction Document TemplatesTemplatesFree business templates to use in your personal or professional life. Templates include Excel, Word, and PowerPoint. These can be used for transactions, legal, financial modeling, financial analysis, business planning and business analysis.
