Earn your certification as a Financial Modeling & Valuation Analyst (FMVA)®. Register today!

Net Income Template

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 Template

Download the free Excel template now to advance your finance knowledge!

 

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 revenue and subtracting COGS, SG&A, depreciation, and amortization, interest expense, taxes and any other expenses.

Net income is the last line item on the income statement proper. Some income statements, however, will have a separate section at the bottom reconciling beginning retained earnings with ending retained earnings through net income and dividends.

The net income is very important in that it is a central line item to all three financial statements. While it is arrived at through the income statement, the net profit is also used in both the balance sheet and the cash flow statement.

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 Templates
  • PowerPoint Presentation Templates
  • Transaction Document Templates

Financial Analyst Certification

Become a certified Financial Modeling and Valuation Analyst (FMVA)® by completing CFI’s online financial modeling classes and training program!