Projected pl statement template

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.

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.

Screenshot Goods. Disclaimer : This spreadsheet and the information on this page is for illustrative and educational purposes only.

We do not guarantee the results or the applicability to your unique financial situation. You should seek the advice of qualified professionals regarding financial decisions.

Calculating net profit is simple math. Keep your assumptions simple. Remember our principle about planning and accounting. While a Profit and Loss Statement or Projected Profit and Loss affects the Balance Sheet because earnings are part of capital, it includes only sales, costs, expenses, and profit. Then operating expenses. I explained that choice and depreciation and amortization as well in Financial Projection Tips and Traps , in the previous section. Leave a Comment Cancel reply.

Go to mobile version. Loading Comments Email Required Name Required Website.