By downloading this free Profit and Loss template, you will be able to easily create your own income statement. Once you have downloaded this tool, simply enter your own information in all of the blue font color cells. This will automatically produce a monthly or annual statement as the output. The Excel file contains four tabs which each include a different template.

A profit and loss statement (P&L), also known as an income statement, summarizes the income and expenses of a company over a specific period of time to arrive at its net earnings for the period.

Steps to Effectively Use Your Profit and Loss Template

  • Download the Excel file.
  • Use the monthly or annual worksheet, depending on what type of statement you want to produce.
  • Replace all blue cells that contain hardcoded numbers with your company’s information.
  • Double check to ensure all the formulas in black cells working properly.
  • Save as a new file and save a version as PDF as well as XLS.
There are two types of template included in the Excel file:
  1. Monthly P&L template - perfect for businesses which require regular reporting and detail. All information is shown in a series of monthly columns which makes the details clearer than it would annually. Perfect for small, medium and large businesses as it can be adjusted.
  2. Annual P&L template - ideal for businesses who have been operating for several years. Follows the same format and structure and the monthly P&L but does not include a total column at the end that sums up each of the periods. Can be used by any size business and can be easily altered.

Components of the P&L Template

  • Revenue streams (also called sales streams)
  • Returns, Refunds, Discounts
  • Total Net Revenue
  • Cost of Goods Sold
  • Gross Profit
  • Advertising & Promotion
  • Depreciation & Amortization
  • Rent and Office
  • Salaries, Benefits & Wages
  • Telecommunication
  • Travel
  • Utilities
  • Selling, General & Administrative (SG&A)
  • Earnings Before Interest & Taxes (EBIT)
  • Interest Expense
  • Earnings Before Taxes (EBT)
  • Income Taxes
  • Net Earnings
All worksheets in this profit and loss template can be altered to suit your business' needs. If you need to add any more line items, simply insert a new row - just make sure the formulas adding up the totals capture those new rows.

This business tool includes 1 Profit and Loss Excel Template

Reviews Add a review

More From Corporate Finance Institute®

Browse our top rated business templates. See All
REIT Financial Model Template
This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will…
Energy Industry Comps Template Energy Industry Comps Template
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
See All