Income Statement

An income statement or profit and loss account is one of the financial statements of a company and shows the company's revenues and expenses during a particular period. It indicates how the revenues are transformed into net income (or net profit).

This Tableau Accelerator allows you to:

• Appraise your financial results (profits & losses): Income Statement, Waterfall, Annual Report
• Realise some simulations on your Income Statement (What-If Analysis)

Demo video

Answer key business questions

• What is the financial status of the organisation?
• What is the performance of the organisation?
• What is the expected future growth of the organisation?
• How much profit has the organisation generated?

Monitor and improve KPIs

Revenues

• Total Revenues: Total amount of income generated by the sale of goods or services related to the company's primary operations (expressed in currency)

Expenses

• COGS: Cost of goods sold (COGS, also known as 'Cost of Sales') refers to the direct costs attributable to the production of the goods sold in a company. This amount includes the cost of the materials used in creating the good along with the direct labour costs used to produce the good. It excludes indirect expenses such as distribution costs and sales force costs. (expressed in currency)
• OpEx: Operating Expenses: Expenditures (that is, cash out) that a company makes to generate income (also called 'SG&A Expenses'): S&M Expenses, R&D Expenses, G&A Expenses (expressed in currency)
• OpEx to Revenues ratio: Determines how much it actually costs to run your business against how much you bring in from revenues (expressed in %)
• Deprec. & Amort.: Amortisations and depreciations are methods of prorating the cost of business assets over the course of their useful life (expressed in currency)
• Interests & Taxes: All taxes the company is subject to, plus all the interests it has to pay to creditors (expressed in currency)

Profitability

• Gross Margin: Amount left over from Revenues after Costs of Goods Sold are subtracted (also called 'Gross Profit') (expressed in currency)
• Gross Margin %: Share of left over from Revenues after Costs of Goods Sold are subtracted (also called 'Gross Profit %') (expressed in %)
• Operating Income: Earnings before interest and taxes → profits before taking away interest charges and tax payments (expressed in currency)
• Operating Income %: Share of earnings before interest and taxes → share of profits before taking away interest charges and tax payments (expressed in %)
• Net Income: Total amount of income left after expenses and deductions are taken out (expressed in currency)
• Net Income %: Share of income left after expenses and deductions are taken out (expressed in %)

Required attributes

• Month (date): Month
• Company (string): Legal Entity, Company, Cost Centre...(or any level of detail of your choice)
• Revenues (numeric): Sales, Revenues
• Operating Costs, COGS (numeric): Operating Costs, COGS (Cost of Goods Sold) [positive value expected]
• Operating Expenses; OpEx (numeric): Operating Expenses, OpEx [positive value expected]
• Depreciations & Amortisations (numeric): Depreciations + Amortisations [positive value expected]
• Interests & Taxes (numeric): Interests + Taxes [positive value expected]