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

Income Statement Template

Download the Excel templates below

Download CFI’s income statement template

Please download CFI’s free income statement template to develop your own profit and loss statement for a business or to analyze another company.  After you have downloaded the Excel file you can enter your own numbers in cells with blue font color which will auto-populate an annual or monthly statement as the result.  The Excel file contained below has four templates included.

 

Download the free template

Enter your name and email in the form below and download the free template now!

Income Statement Template

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

 

The income statement (also called a profit and loss statement) summarizes a business’ revenues and operating expenses over a time period to calculate the net income for the period.

 

download income statement templates

 

Below are two types of income statement templates.

 

#1 Annual income statement template

If you are analyzing the financial information for a company that spans several years, you may wish to use an annual income statement.  The annual income statement template shown below takes five years of historical (or forecast) data and displays them consecutively.  This provided for easy year-over-year (YOY) analysis.

This free template is can be used for large or small businesses and can be easily edited by removing or inserting rows (for new line items) as required.

Please fill out the form above (name and email address) for the annual income statement template and download a free copy of the Excel file.

 

Annual Income Statement Template screenshot

 

#2 Monthly income statement template

The monthly income statement template is designed for a business that requires more detailed reporting time period or requires a roll-up of monthly data into each annual period.  Since this template shows the data on monthly basis, seasonality and month-over-month trends can be easily analyzed.

The monthly income statement template can be sued for any size company and allows for easy adjustment by adding and deleting line items.

By filling out the form at the top of this page you can download the Excel file with monthly templates.

 

monthly income stateemnt template sreenshot

 

Items listed on an income statement

Just as every business is unique, so is every income statement.  The templates included in the download are designed to be as industry-neutral as possible, however, it was not practical to include line items for all types of businesses.

Common examples of items on an income statement are:

  • Revenue lines
  • Cost of Goods Manufactured
  • Gross Margin
  • Amortization
  • Depreciation
  • Rent expense
  • Salaries and Wages
  • Phone and internet
  • SG&A
  • Operating Income (EBIT)
  • Interest Expense
  • Earnings Before Tax (EBT)
  • Income Tax
  • Net Income

 

Steps to use the income statement templates

Follow these easy steps to download, update, and use the templates:

  1. Download the template file
  2. Use the annual or monthly sheet, according to the time period you want for the statement
  3. Type over each blue font color cells with hardcoded numbers and replace with your own numbers
  4. Add or remove line items as necessary
  5. Confirm that all formulas in black font color cells are working as intended
  6. Save a copy of the file as both a PDF and as an XLS

There are two types of templates to download (annual and monthly) which are illustrated above.

 

Changing and editing the income statement template

The templates included in the Excel file were designed to be easily adapted to any business.  With that in mind, the instructions below will help you update the templates.

Since your company is unlikely to have the same number of expenses as the Excel file, you will need to add or remove line items.

To add more expenses or line items, simply insert a new row and check that all black formulas still work properly.

To remove/delete expenses, right click on a row and select the delete option with your mouse (or press Alt + E + D on your keyboard)

For more information about income statement line items, see Deloitte’s free guides here https://www.iasplus.com/en/standards/ias/ias1

 

Additional resources

Thanks for downloading CFI’s free templates which help you create your own income statement in Excel. CFI is the official global provider of the Financial Modeling and Valuation Analyst (FMVA)™ certification, designed to transform anyone into a world-class financial analyst.

CFI’s mission is to help you advance your career as a financial analyst, so please check out these additional resources:

  • Profit and Loss (P&L) Template
  • Valuation methods
  • What is financial modeling?
  • DCF financial modeling guide

Financial Analyst Certification

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