background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for September 2024 for September 2024
:
Private EquityReal Estate Investing
Hedge Fund InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for September 2024 is Open
Wall Street Prep

Profit and Loss Statement (P&L)

Step-by-Step Guide to Understanding the Profit and Loss Statement (P&L)

Last Updated June 23, 2024

Learn Online Now

Profit and Loss Statement (P&L)

How to Read a Profit and Loss Statement

The profit and loss statement—or “P&L Statement”—is one of the three core financial statements that publicly traded companies are obligated to file with the SEC.

For public companies listed in the U.S., the 10-Q profit and loss statement (P&L), often used interchangeably with the term “Income Statement”, must be filed each quarter, with a 10-K annual filing due for the 4th quarter.

  • Quarterly Filing (10-Q) ➝ 3x Per Year (and 4th is 10-K)
  • Annual Filing (10-K) ➝ 1x Per Year

Together, alongside the cash flow statement (CFS) and balance sheet (B/S), the P&L statement provides a detailed depiction of the financial state of a company.

In particular, the P&L statement shows the operating performance of the company as well as the costs and expenses that impact its profit margins.

Upon assessing a company’s P&L statement, one can gauge the company’s ability to:

  • Generate Revenue ➝ Improve Sales Growth (“Top Line”)
  • Optimize Operating Structure ➝ Reduce Cost of Goods Sold (COGS) and Operating Costs (SG&A, R&D)
  • Increase Profitability → Higher Gross Margin, Contribution Margin (CM), Operating Profit Margin, EBITDA Margin, and Net Profit Margin

How to Prepare Profit and Loss Statement (P&L)

The profit and loss statement (P&L) can be prepared by an accountant under two different methods:

  • Accrual Accounting (U.S. GAAP) ➝ Under the revenue recognition principle (ASC 606), revenue is recognized when “earned” under GAAP standards (i.e. product or service delivered to the customer regardless of whether cash payment was received). Expenses are matched in the same period as the corresponding revenue they helped create, which is called the matching principle. The income statement filed with the SEC must abide by U.S. GAAP reporting standards.
  • Cash Basis Accounting ➝ Under cash basis accounting, revenue is not recognized until the customer pays in cash to the company for the products or services received. Expenses under cash accounting, similar to revenue, are not recognized until the cash outflow occurs – meaning that the company has actually paid the third party in cash. The income statement prepared under cash-basis accounting are more common for private companies.

What is the Format of a P&L Statement?

The standard profit and loss statement (P&L) format will consist of the following line items:

Income Statement Line Items
Net Revenue
  • Net Revenue = Gross Revenue – Returns – Discounts – Sales Allowances
Less: Cost of Goods Sold (COGS)
  • Cost of Goods Sold (COGS) = Beginning Inventory + Purchases in the Current Period – Ending Inventory
Gross Profit
  • Gross Profit = Revenue – COGS
Less: Operating Expenses (Opex)
  • Operating Expenses = Σ SG&A, R&D
Operating Income (EBIT)
  • EBIT = Gross Profit – Operating Expenses
Less: Interest Expense
  • Interest Expense = Interest Rate (%) × Debt
Pre-Tax Income (EBT)
  • EBT = EBIT – Interest Expense
Less: Income Taxes
  • Income Tax = Effective Tax Rate (%) × EBT
Net Income
  • Net Income = EBT – Taxes

Profit and Loss Statement Example: Alphabet (GOOGL)

The profit and loss statement (P&L) of Alphabet (GOOGL)—derived from financial data platform Daloopa—is presented below to illustrate the format of an income statement.

Income Statement Example (P&L)

Alphabet, Inc. Income Statement Example (Source: Daloopa)

Profit and Loss Statement Calculator — Excel Template

We’ll now move on to a modeling exercise, which you can access by filling out the form below.

dl

Excel Template | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Profit and Loss Statement Calculation Example

Suppose we’re tasked with creating a simple profit and loss statement (P&L) for a company with the following financial data.

  • Revenue = $100 million
  • COGS = $40 million
  • SG&A = $20 million
  • Interest Expense = $5 million
  • Tax Rate = 30%

Given those assumptions, we can input each figure into our P&L statement in Excel while ensuring to abide by the industry standard formatting conventions (i.e. the financial modeling “best practices”).

Therefore, the assumptions will be formatted in blue font to denote that the figure is hard-coded input, whereas the calculation metrics are formatted in black font.

Furthermore, each cost and expense is entered as a negative figure to reflect that the line item represents an outflow of cash.

The formula for each profit metric on the profit and loss statement (P&L) is stated in the following list:

  • Gross Profit = $100 million – $40 million = $60 million
  • EBIT = $60 million – $20 million = $40 million
  • Pre-Tax Income (EBT) = $40 million – $5 million = $35 million
  • Net Income = $35 million – ($35 million × 30%) = $25 million

In closing, our hypothetical company’s gross profit, EBIT, and net income are $60 million, $40 million, and $25 million, respectively.

Profit and Loss Statement Template Example ((P&L)

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
Comments
0 Comments
Inline Feedbacks
View all comments
Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.