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:
![Net Income Template Screenshot]()
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 and subtracting COGS, SG&ASG&ASG&A includes all non-production expenses incurred by a company in any given period. It includes expenses such as rent, advertising, marketing, 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, 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. 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 with ending retained earnings through net income and dividendsDividend Per Share (DPS)Dividend Per Share (DPS) is the total amount of dividends attributed to each individual share outstanding of a company. Calculating the dividend per share.
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. 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. The financial statements are key to both financial modeling and accounting. and the cash flow statementCash Flow StatementA cash flow Statement contains information on how much cash a company generated and used during a given period..
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 are no dividends, the change in retained earnings between periods should equal 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,
