WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Accounting Tutorials » Income Statement Tutorials » Profit and Loss Statement Template

Profit and Loss Statement Template

Template of Profit and Loss Statement

The profit and loss statement or the income statement is one of the most important financial statements of the Company, which provides the details of the Companies’ revenues and expenses during the particular period the income statement is created. Income statement could be of any period, monthly, quarterly, half-yearly, or annually. The Profit and Loss Statement excel templates provided here discuss the monthly and annual income statement.

The two excel can help businesses to generate their income statement after entering a few financial numbers of their business. Both the templates are look alike in terms of the contents – just the period for which the numbers are put in the template vary.

Profit and Loss Statement Template

Components of Profit and Loss Statement

The major components to be filled by the user in the P&L Template in Excel are as below:

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course
Gross Sales It is the total sales done by the Company during the time period.
Other revenue Any other revenue earned by the Company from various sources like interest income etc.;
Cost of Goods Sold (COGS) This line item includes the Cost of total goods sold by the Company.
Employees’ expense Employees’ expense includes salaries, wages, benefits and other long term benefits provided to the employees which are a direct cost to the Company
Marketing Expenses Marketing expenses done by the Company to improve sales are input in this line item.
Rent This line item includes the rent paid by the Company for their office, factory, manufacturing units or warehouses
Office Supplies and General Expenses This line item includes the expenses done on office supplies, utilities like electricity and other general expenses
Other expenses Any additional expense which is not mentioned in the above expenses is input in this line item
Depreciation and Amortization It includes depreciation and amortization expense on assets acquired or bought by the Company
Interest Expense This line item consists of the interest expense paid by the Company for loans taken by it from banks
Income taxes Income tax is the tax paid on the income earned by the Company. The user can set this to (percentage tax rate* Earning Before Taxes) depending on the tax rate of his Country

All other line items which are bold in the following templates have excel formulas, which will be calculated once the user inputs the financial data for different line items. The snapshots for both the excel templates of Profit Loss Statement are given below:

Monthly Profit and Loss Template in Excel

Monthly P&L Template in Excel will look like the following:

Profit and Loss Statement Template (Monthly PnL Statement (Mn $))

Annual P&L Template in Excel

Annual P&L Template in Excel will look like the following:

Profit and Loss Statement Template (Annual PnL Statement (Mn $))

You can download this Template from here – Profit and Loss Statement Excel Template

Recommended Articles

This article has been a guide to the Profit Loss Statement Template. Here we provide you with the P&L statement excel template for the monthly and annual with examples. You can learn more about financing from the following articles – 

  • Examples of Profit & Loss Statement
  • Basics of Income Statement
  • Multi-Step Income Statement
  • Pro Forma Income Statement
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Free Accounting Course

You will Learn Basics of Accounting in Just 1 Hour, Guaranteed!

* Please provide your correct email id. Login details for this Free course will be emailed to you

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More