Over 2 million + professionals use CFI to learn accounting, financial analysis, modeling and more. Unlock the essentials of corporate finance with our free resources and get an exclusive sneak peek at the first chapter of each course. Start Free
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 downloadable Excel file contained below includes two types of templates (annual and monthly).
Download the free Excel template now to advance your knowledge of financial modeling and accounting.
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.
Below are two types of income statement templates.
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 provides for an easy year-over-year (YOY) analysis.
This free template 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.
The monthly income statement template is designed for a business that requires a more detailed reporting time period or requires a roll-up of monthly data into each annual period. Since this template shows the data on a monthly basis, seasonality and month-over-month trends can be easily analyzed.
The monthly income statement template can be used 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.
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, and therefore contain more commonly used line item names.
Common examples of items on an income statement are:
Follow these easy steps to download, update, and use the templates:
There are two types of templates to download (annual and monthly), which are illustrated above.
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).
Thank you for downloading CFI’s Income Statement Template which helps you create your own income statement in Excel. CFI’s mission is to help you advance your career as a financial analyst, so please check out these additional resources:
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.
A well rounded financial analyst possesses all of the above skills!
CFI is the global institution behind the financial modeling and valuation analyst FMVA® Designation. CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.
In order to become a great financial analyst, here are some more questions and answers for you to discover:
CFI is a global provider of financial modeling courses and of the FMVA Certification. CFI’s mission is to help all professionals improve their technical skills. If you are a student or looking for a career change, the CFI website has many free resources to help you jumpstart your Career in Finance. If you are seeking to improve your technical skills, check out some of our most popular courses. Below are some additional resources for you to further explore:
to take your career to the next level and move up the ladder!
Get Certified for Financial Modeling (FMVA)®Gain in-demand industry knowledge and hands-on practice that will help you stand out from the competition and become a world-class financial analyst.
