Financial Statement

Financial statements are formal records of the financial activities and position of an organisation.

This Tableau Accelerator allows you to:

• Assess the financial health of your organisation
• Appraise your financial results (profits & losses): Income Statement, Waterfall, Annual Report
• Realise some simulations on your Income Statement (What-If Analysis)
• Appraise your financial positions: Balance Sheet

Demo video

Answer key business questions

• What is our organisation’s financial situation?
• How much profit did our organisation generate?
• What is our working capital?
• Are we in too much debt?
• What are the drivers of change in our net income over time?

Monitor and improve KPIs

Income Statement

• Total Revenues: Total amount of income generated by the sale of goods or services related to the company's primary operations (expressed in currency)
• 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)
• 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 %)
• 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)
• 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 %)

Balance Sheet

• Current Assets: Assets that are expected to be converted into cash in less than 12 months: Cash, Accounts Receivables, Inventory, Prepaid Expenses (expressed in currency)
• Current Liabilities: Bills that must be paid within 12 months of the date of the Balance Sheet: Accounts Payable, Accrued Expenses, Current Portion of Debt, Income Taxes Payable (expressed in currency)
• Total Assets: The final amount of all gross investments, cash and equivalents, receivables and other assets as they are presented on the balance sheet (expressed in currency)
• Total Liabilities: Current Liabilities and Long-Term Debt (expressed in currency)
• Working Capital: Amount of money the enterprise has to work with in the short-term (also called 'Net Current Assets' or 'Funds') (expressed in currency)
• Working Capital ratio: Business's ability to meet its payment obligations as they fall due (also called "Current Ratio") (expressed in %)
• Liquidity ratio: Determine a debtor's ability to pay off current debt obligations without raising external capital (also known as 'Quick Ratio') (expressed in %)
• Total Equity: Determines how much a company would have left over in assets if the company went out of business immediately (expressed in currency)
• Debt to equity ratio: How much debt the company has relative to its investor equity (expressed in %)

Performance Ratios

• Debt to income ratio: Percentage of your current liabilities compared to your revenues. It determines your borrowing risk (expressed in %)
• ROI %: Return on Investment: determines the monetary value of an investment versus its cost (expressed in %)

Required attributes

• Month (date): Month
• Company (string): Legal Entity, Company, Cost Centre
• Revenues (numeric): Sales, Revenues
• Operating Costs, COGS (numeric): : Operating Costs, COGS (Cost of Goods Sold)
• 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]
• Current Assets (numeric): Current Assets
• Current Liabilities (numeric): Current Liabilities [positive value expected]
• Total Assets (numeric): Total Assets
• Total Liabilities (numeric): Total Liabilities [positive value expected]