Profit and Loss Template

A Profit and Loss Statement is another name for the Income Statement, so if you're looking specifically for a Profit and Loss Statement template, just download our income statement and change the title. The Profit and Loss Template below is for creating a 3-year projection, or an estimate of how you expect your business to perform from year-to-year. It is based on our Business Budget Template, with all the same income and business expense categories.

If you are looking for a 12-month profit and loss template, take a look at the 12-Month Business Budget Template. All you would need to do is change the title to "12-Month Profit and Loss Projection".

Profit and Loss Projection Template

Screenshot (Services) Screenshot (Goods)	The Profit and Loss Projection Template helps you create a 3-year projection of income and expenses for your business. It uses the same list of categories as the business budget, but also includes columns for calculating the Percentage of Total Sales, which helps you to analyze cost of goods sold and operating expenses. This workbook contains two profit and loss templates designed for companies providing services or selling goods. The main difference is that the Goods worksheet includes a Cost of Goods Sold section for recording inventory and purchases and calculating Gross Profit. "No Installation, No Macros - Just a simple spreadsheet"	Download Free Trial Cost: $0.00 License: Company Use (not for resale or distribution) File Type: .xls Size: ~50 KB Version: 1.0 Required: Microsoft Excel® 2002(XP), 2003, or 2007
	Purchase the unlocked version of this Profit and Loss Projection Template so that you can customize, add and remove rows, modify formatting and formulas, etc. 60-Day Money-Back Guarantee Same license agreement and system requirements apply.	BUY Now Cost: $9.95 Immediate Download

Using the Profit and Loss Template

The difference between a business budget and a profit and loss projection is subtle, but important. After creating a profit and loss projection, you could simply change the title of your spreadsheet to "Budget". However, if you are like me, your budget will be much more conservative than your projection. A projection should be as realistic as possible.

The profit and loss template includes the same set of categories as the business budget, and information about income categories and expense categories can be found on the Income Statement and Business Budget pages.