SpreadsheetProfit & Loss StatementsFree
Income Statement with Year-on-Year Comparison
Revenue, cost of sales and expenses for two periods with gross, operating and net margins.
Shown with sample data
Colour
Income Statement with Year-on-Year Comparison
Revenue, cost of sales and expenses for two periods with gross, operating and net margins.
- Revenue
- $508,000
- Gross margin
- 54%
- Operating profit
- $58,200
- Net profit
- $43,200
- Revenue$508,000
- Cost of sales$235,000
- Operating expenses$214,800
- Interest and tax$15,000
How to use it
- 1Replace the lines with your own, keeping each in the right section.
- 2Enter both periods as positive numbers.
- 3Read the margins in the key figures.
- 4Investigate cost lines that grew faster than revenue.
In this workbook
About this template
Compare this period with the last on one page. Enter each income and cost line for both; the statement works out gross profit, operating profit and net profit, the margin at each level and the change in every line, so you can see whether growth is reaching the bottom line.
Who it’s for
- Annual and quarterly reviews
- Board packs
- Lender updates
What’s included
- Income statement sheet: Each line for both periods.
- By section sheet: This period and Last period and the number of entries for each section.
How to use it
- 1Replace the lines with your own, keeping each in the right section.
- 2Enter both periods as positive numbers.
- 3Read the margins in the key figures.
- 4Investigate cost lines that grew faster than revenue.
Details
- Format
- Spreadsheet
- Category
- Profit & Loss Statements
- Sheets
- 2
- Setup
- 10 min
- Level
- Beginner
- Price
- Free
Download a copy
Downloads need a free account.