Business dashboard template: FINANCE

/uploads/galerie/000050/Finance Cockpit W.PNG

Providea workbookcontaining at least12 attributes

Geta ready-to-use,best-in-marketFINANCE dashboard

Finance Home

Get a Home Page for your Finance dashboard

Finance Cockpit

Get instant overview of your Finance KPIs: Revenues, Gross Margin, Gross Margin%, EBIT%, OpEx, EBT%, Total Equity, ROI%...

Finance Top KPIs Overview

Get a transverse view on your top 6 Finance KPIs, split by the dimension of your choice

Finance Top KPIs Evolution

Visualize how your Finance KPIs are evolving (Month-to-Date, Year-to-Date)

12 required attributes

Month
Legal Entity, Company
Cost Center, Department, Division
Total Sales, Revenues
Operating Costs, COGS
Operating Expenses, OpEx
Depreciations & Amortizations
Interests & Taxes
Current Assets
Current Liabilities
Total Assets
Total Liabilities

11 dashboard pages

Detailed presentation of the FINANCE dashboard

Your FINANCE dashboard will contain 23 KPIs

Total RevenuesSum of Revenues
COGSCost 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 labor costs used to produce the good. It excludes indirect expenses such as distribution costs and sales force costs.
Gross MarginAmount left over from Revenues after Costs of Goods Sold are subtracted (also called `Gross Profit`): Revenues - COGS
Gross Margin %Share of Gross Margin on Total Revenues: Gross Margin / Revenues (%)
OpExOperating 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
OpEx to Revenues ratioShare of Operating Expenses on Total Revenues: OpEx / Revenues (%)
EBITEarnings before interest and taxes -> profits before taking away interest charges and tax payments: Gross Margin - (OpEx + Depreciations + Amortizations)
EBIT %Share of EBIT on Total Revenues: EBIT / Revenues (%)
EBTEarnings Before Taxes: EBIT - (Interests + Taxes)
EBT %EBT / Revenues (%)
Deprec. & Amort.Amortizations and depreciations are methods of prorating the cost of business assets over the course of their useful life
Interests & TaxesSum of Interests & Taxes
Current AssetsAssets that are expected to be converted into cash in less than 12 months: Cash, Accounts Receivables, Inventory, Prepaid Expenses
Current LiabilitiesBills that must be paid within one year of the date of the Balance Sheet: Accounts Payable, Accrued Expenses, Current Portion of Debt, Income Taxes Payable
Total AssetsThe final amount of all gross investments, cash and equivalents, receivables, and other assets as they are presented on the balance sheet
Total LiabilitiesSum of Current Liabilities and Long-Term Debt
Working CapitalAmount of money the enterprise has to work with in the short-term: `Current Assets` - `Current Liabilities` (also called `Net Current Assets` or `Funds`)
Working Capital ratioCurrent Assets / Current Liabilities (%)
Liquidity ratioCurrent Liabilities / Current Assets (%)
Total EquityTotal Assets - Total Liabilities
ROI %EBT / Total Equity (%)
Debt to income ratioTotal Liabilities / Revenues (%)
Debt to equity ratioHow much debt the company has relative to its investor equity: Total Liabilities / Total Equity (%)

and 11 dashboard pages

Home

Finance Home

Get a Home Page for your Finance dashboard

Cockpit

Finance Cockpit

Get instant overview of your Finance KPIs: Revenues, Gross Margin, Gross Margin%, EBIT%, OpEx, EBT%, Total Equity, ROI%...

Finance Top KPIs Overview

Get a transverse view on your top 6 Finance KPIs, split by the dimension of your choice

Finance Top KPIs Evolution

Visualize how your Finance KPIs are evolving (Month-to-Date, Year-to-Date)

Financial Analytics

Balance Sheet

Get an instant overview of your main Balance Sheet KPIs

Income Statement

Get an instant overview of your main Profit & Loss KPIs

Income Statement - What-if Analysis

Easily perform simulations and what-if analysis on your Top P&L KPIs

Behavioral Analytics

Finance KPI Performance

Visualize the overall performance of any of your Finance KPIs: what is the performance, how does this performance evolve, who contributes to this performance