Income Statement (+Budget)
299c-表:by Tableau|桜
99e5-表:Description|桜
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)
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
- 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).
- 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 %)
- Depreciation & Amortisation: 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 Profit: Amount left over from Revenues after Costs of Revenues are subtracted (expressed in currency)
- Gross Margin: Share of leftover from Revenues after Cost of Revenues 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 Margin: 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 Margin: Share of income left after expenses and deductions are taken out (expressed in %)
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 (Actual)
- “BUD_REVENUES”**: Revenues (Budget)
- “COST OF REVENUES”**: Cost of Revenues (Actual)
- “BUD_COST OF REVENUES”**: Cost of Revenues (Budget)
- “OPEX”**: Operating Expenses (Actual)
- “BUD_OPEX”**: Operating Expenses (Budget)
- “DEPREC”: Depreciations and Amortisations (Actual)
- “BUD_DEPREC”: Depreciations and Amortisations (Budget)
- “TAXES”: Interests and Taxes (Actual)
- “BUD_TAXES”: Interests and Taxes (Budget)
(**) “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”)
4c7a-表:Features|桜
c0b5-表:Supports data mapping|桜
6d57-表:Resources|桜
646a-表:Developer Website|桜bb6e-表:Privacy Policy|桜b8ff-表:Terms of Service|桜
Download and start your free trial of Tableau today.
Try Tableau Now466b-表:Related Listings|桜
Salesforce Data Cloud - Agent Operational Efficiency
299c-表:by Tableau|桜Financial Performance Dashboard
299c-表:by Mydral|桜Accounts Payable
299c-表:by Tableau|桜Budget Controlling
299c-表:by Tableau|桜Bank Cash Flow
299c-表:by Tableau|桜Income Statement
299c-表:by Tableau|桜Financial Statement
299c-表:by Tableau|桜Balance Sheet (+Budget)
299c-表:by Tableau|桜Hospitality Finance
299c-表:by Tableau|桜Balance Sheet
299c-表:by Tableau|桜Accounts Receivable
299c-表:by Tableau|桜ESG Benchmark
299c-表:by Tableau|桜Bank Income Statement
299c-表:by Tableau|桜CEO Cockpit - Manufacturing
299c-表:by Tableau|桜Income Statement
299c-表:by The Information Lab|桜Executive KPI Scorecard
299c-表:by Biztory|桜Financial and Revenue Intelligence Toolkit
299c-表:by Zuar|桜SuperKPIs Income Statement
299c-表:by Infotopics | Apps for Tableau|桜Budget Allocation
299c-表:by Beinex|桜Climate Change Portfolio Risk
299c-表:by USEReady|桜실적 vs 예산 분석 대시보드 - 한국어
299c-表:by Tableau|桜Return Fraud Monitoring
299c-表:by Cleartelligence|桜Executive KPIs
299c-表:by Cleartelligence|桜