Financial Statement | 5e8b-表:Tableau Exchange|桜

Financial Statement

299c-表:by Tableau|桜

99e5-表:Description|桜

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
  • Improve your Cash Conversion Cycle

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)
  • Cost of Revenues: Total cost incurred to produce and sell a product or service. It includes all the costs associated with the production process, such as raw materials, labour and overhead expenses. It also includes any other direct costs related to the production and delivery of the product or service (expressed in currency).
  • Gross Profit: Amount left over from Revenues after Costs of Revenues are subtracted (expressed in currency)
  • 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)
  • Operating Expenses %: 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)
  • Net Income: Total amount of income left after expenses and deductions are taken out (expressed in currency)

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)
  • 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)
  • 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)
  • Total Equity: Determines how much a company would have left over in assets if the company went out of business immediately (expressed in currency)

Liquidity Ratios

  • Current ratio: Business’s ability to meet its payment obligations as they fall due
  • Quick ratio: Determine a debtor’s ability to pay off current debt obligations with its most liquid assets (i.e.: “Cash” and “Accounts Receivable”)

Asset Ratios

  • Inventory Turn: Determines how many times a company turns over its inventory in relation to its cost of goods sold (COGS) in a year (expressed in number of turns)
  • Asset Turn ratio: Measures the value of a company’s revenues relative to the value of its assets. It measures the efficiency with which a company uses its assets to generate revenue (expressed in number of turns)

Profitability Ratios

  • Gross Margin: Share of leftover from Revenues after Cost of Revenues are subtracted (also called “Gross Profit %”) (expressed in %)
  • Operating Margin: Share of earnings before interest and taxes → share of profits before taking away interest charges and tax payments (expressed in %)
  • Net Margin: Share of income left after expenses and deductions are taken out (expressed in %)
  • Return on Assets: Indicates how profitable a company is in relation to its total assets. It measures the efficiency with which a company uses its assets to generate profit (expressed in %)
  • Return on Equity: Determines a company’s profitability and how efficient it is in generating profits. ROE is considered to be the return on net assets (expressed in %)

Leverage Ratios

  • Debt-to-Equity Ratio: Measures the degree to which a company is financing its operations with debt rather than its own resources
  • Debt Ratio: Measures the extent of a company’s leverage. It can be interpreted as the proportion of a company’s assets that are financed by debt
  • Debt-to-Asset Ratio: Defines how much debt a company owns compared to its assets. This information reflects how financially stable a company is (expressed in %)

Cash Conversion Cycle

  • Days Inventory Outstanding (DIO): Average time, in days, that a company takes to turn its inventory. It is used to determine the efficiency of sales (expressed in days)
  • Days Sales Outstanding (DSO): Average number of days that it takes a company to collect payment for a sale (expressed in days)
  • Days Payable Outstanding (DPO): Average time, in days, that a company takes to pay its bills and invoices to its creditors (expressed in days)
  • Cash Conversion Cycle (CCC): Average time, in days, that it takes for a company to convert its investments in inventory and other resources into cash flows from sales (expressed in days)

Required attributes

  • Month (date): Month
  • KPI Code (string): KPI Code according to defined rules (*)
  • KPI Breakdown (string): Level of detail that identifies the nature of the revenue, expense, asset or liability (**)
  • KPI Value (numeric): Value of the corresponding KPI

(*) “KPI Code” is an attribute where specific values are expected:

  • “REVENUES”**: Revenues
  • “COST OF REVENUES”**: Cost of Revenues
  • “OPEX”**: Operating Expenses
  • “DEPREC”: Depreciations and Amortisations
  • “TAXES”: Interests and Taxes
  • “CASSETS”**: Current Assets
  • “CLIABILITIES”**: Current Liabilities
  • “NASSETS”**: Non-Current Assets
  • “NLIABILITIES”**: Non-Current Liabilities

(**) “KPI Breakdown” is an attribute for which specific values are expected in certain special cases:

KPI Code = “REVENUES” (Revenues)

  • KPI Breakdown=“xxx” → Any type of Revenue (replace “xxx” with your breakdown of “Revenues”)

KPI Code = “COST OF REVENUES” (Cost of Revenues)

  • KPI Breakdown=“xxx” → Any type of Cost of Revenues (replace “xxx” with your breakdown of “Cost of Revenues”)

KPI Code = “OPEX” (Operating Expenses)

  • KPI Breakdown=“xxx” → Any type of Operating Expense (replace “xxx” with your breakdown of “Operating Expenses”)

KPI Code = “CASSETS” (Current Assets)

  • KPI Breakdown=“Cash” → Refers to the amount of readily available cash held
  • KPI Breakdown=“Accounts Receivable” → Refers to the amount of money owed by customers for goods or services provided on credit
  • KPI Breakdown=“Inventory” → Refers to the value of goods, products or materials held in inventory Current Liabilities
  • KPI Breakdown=“xxx” → Any other type of Current Asset (replace “xxx” with your breakdown of “Current Assets”)

KPI Code = “CLIABILITIES” (Current Liabilities)

  • KPI Breakdown=“Accounts Payable” → Refers to the amount of money owed to suppliers
  • KPI Breakdown=“xxx” → Any other type of Current Liability (replace “xxx” with your breakdown of “Current Liabilities”)

KPI Code = “NASSETS” (Non-Current Assets)

  • KPI Breakdown=“xxx” → Any type of Non-Current Asset (replace “xxx” with your breakdown of “Non-Current Assets”)

KPI Code = “NLIABILITIES” (Non-Current Liabilities)

  • KPI Breakdown=“xxx” → Any type of Non-Current Liability (replace “xxx” with your breakdown of “Non-Current Liabilities”)

4c7a-表:Features|桜

c0b5-表:Supports data mapping|桜

6d57-表:Resources|桜