TEMPLATES > Finance (Bank, Wealth, FO...)

AuM Balance

Template	AuM (NNM)	AuM (Flows)
Description
	Portfolio Management: Get a good better understanding of the volumes you manage (AuM). The pack requires Income, AuM, Market Effect and Net New Money.	Portfolio Management: Get a better understanding of the volumes you manage (AuM). The pack requires AuM, Market Effect, Inflow and Outflow.
Required attributes	7 attributes	9 attributes
	Month Business Line Relationship Manager Client Net New Money Market Effect AuM	Month Business Line Relationship Manager Client Mandate Inflows Outflows Market Effect AuM
KPIs	12 KPIs	14 KPIs
	Total AuM NNM (Net New Money) Total Market Effect Nb of Clients Lost Clients AuM per Client AuM per RM Nb of RMs NNM per Client NNM per RM Accounts per Client New Clients	Total AuM Total Inflows Total Outflows NNM (Net New Money) Total Market Effect Nb of Clients Lost Clients New Clients AuM per Client AuM per RM Nb of RMs NNM per Client NNM per RM Accounts per Client
Dashboard pages	7 pages	8 pages
	AuM (NNM) Home Cockpit - AuM Breakdown: AuM Client Base Client Portfolio: AuM AuM (NNM) Adhoc Analysis AuM (NNM) KPI Performance	AuM (Flows) Home Cockpit - AuM Breakdown: AuM Inflows / Outflows (AuM) Client Base Client Portfolio: AuM AuM (Flows) Adhoc Analysis AuM (Flows) KPI Performance
More information
	More info on AuM (NNM)	More info on AuM (Flows)
Ready to start?
	CreateAuM (NNM)Dashboard	CreateAuM (Flows)Dashboard

AuM Profitability

Template	AuM & Income (NNM)	AuM & Income (Flows)
Description
	Portfolio Management: Get a good better understanding of the volumes you manage (AuM) and their related Profitability (Income & Return on Asset). The pack requires Income, AuM, Market Effect and Net New Money.	Portfolio Management: Get a better understanding of the volumes you manage (AuM) and their related Profitability (Income & Return on Asset). The pack requires Income, AuM, Market Effect, Inflow and Outflow.
Required attributes	8 attributes	10 attributes
	Month Business Line Relationship Manager Client Net New Money Market Effect AuM Income	Month Business Line Relationship Manager Client Mandate Inflows Outflows Market Effect AuM Income
KPIs	16 KPIs	18 KPIs
	Total AuM NNM (Net New Money) Total Market Effect Total Income RoA % Nb of Clients Lost Clients New Clients AuM per Client Income per Account AuM per RM Nb of RMs Income per RM NNM per Client NNM per RM Accounts per Client	Total AuM Total Inflows Total Outflows NNM (Net New Money) Total Market Effect Total Income RoA % Nb of Clients Lost Clients New Clients AuM per Client Income per Account AuM per RM Nb of RMs Income per RM NNM per Client NNM per RM Accounts per Client
Dashboard pages	7 pages	8 pages
	AuM & Income (NNM) Home Cockpit - AuM & Income Breakdown: AuM, Income & RoA Client Base Client Portfolio: AuM & Income AuM & Income (NNM) Adhoc Analysis AuM & Income (NNM) KPI Performance	AuM & Income (Flows) Home Cockpit - AuM & Income Breakdown: AuM, Income & RoA Inflows / Outflows (AuM) Client Base Client Portfolio: AuM & Income AuM & Income (Flows) Adhoc Analysis AuM & Income (Flows) KPI Performance
More information
	More info on AuM & Income (NNM)	More info on AuM & Income (Flows)
Ready to start?
	CreateAuM & Income (NNM)Dashboard	CreateAuM & Income (Flows)Dashboard

CAL Balance

Template	AuM, Lending Stock (NNM, NNL)	AuM, Lending Stock (Flows)
Description
	Portfolio Management: Get a good better understanding of the volumes you manage (AuM & Lending Stock) The pack requires AuM, Market Effect, Net New Money, Lending Stock & Net New Lending.	Portfolio Management: Get a better understanding of the volumes you manage (AuM & Lending Stock). The pack requires AuM, Market Effect, Lending Stock, Inflow, Outflow.
Required attributes	9 attributes	12 attributes
	Month Business Line Relationship Manager Client Net New Money Market Effect AuM Net New Lending Lending Stock	Month Business Line Relationship Manager Client Mandate Inflows Outflows Market Effect AuM Inflows (Lending) Outflows (Lending) Lending Stock
KPIs	15 KPIs	19 KPIs
	Total AuM NNM (Net New Money) Total Market Effect Total Lending Stock NNL (Net New Lending) Total CAL Nb of Clients Lost Clients New Clients AuM per Client AuM per RM Nb of RMs NNM per Client NNM per RM Accounts per Client	Total AuM Total Inflows Total Outflows NNM (Net New Money) Total Market Effect Total Lending Stock Total Inflows (Lending) Total Outflows (Lending) NNL (Net New Lending) Total CAL Nb of Clients Lost Clients New Clients AuM per Client AuM per RM Nb of RMs NNM per Client NNM per RM Accounts per Client
Dashboard pages	7 pages	8 pages
	AuM, Lending Stock (NNM, NNL) Home Cockpit - AuM, Lending Stock Breakdown: AuM, Lending Stock Client Base Client Portfolio: AuM & Lending Stock AuM, Lending Stock (NNM, NNL) Adhoc Analysis AuM, Lending Stock (NNM, NNL) KPI Performance	AuM, Lending Stock (Flows) Home Cockpit - AuM, Lending Stock Breakdown: AuM, Lending Stock Inflows / Outflows (AuM) Client Base Client Portfolio: AuM & Lending Stock AuM, Lending Stock (Flows) Adhoc Analysis AuM, Lending Stock (Flows) KPI Performance
More information
	More info on AuM, Lending Stock (NNM, NNL)	More info on AuM, Lending Stock (Flows)
Ready to start?
	CreateAuM, Lending Stock (NNM, NNL)Dashboard	CreateAuM, Lending Stock (Flows)Dashboard

CAL Profitability

Template	AuM, Lending Stock & Income (NNM, NNL)	AuM, Lending Stock & Income (Flows)
Description
	Portfolio Management: Get a good better understanding of the volumes you manage (AuM & Lending Stock) and their related Profitability (Income & Return on CAL). The pack requires Income, AuM, Market Effect, Net New Money, Lending Stock & Net New Lending.	Portfolio Management: Get a better understanding of the volumes you manage (AuM & Lending Stock) and their related Profitability (Income & Return on CAL). The pack requires Income, AuM, Market Effect, Lending Stock, Inflow, Outflow.
Required attributes	10 attributes	13 attributes
	Month Business Line Relationship Manager Client Net New Money Market Effect AuM Net New Lending Lending Stock Income	Month Business Line Relationship Manager Client Mandate Inflows Outflows Market Effect AuM Inflows (Lending) Outflows (Lending) Lending Stock Income
KPIs	19 KPIs	23 KPIs
	Total AuM NNM (Net New Money) Total Market Effect Total Lending Stock NNL (Net New Lending) Total CAL Total Income Return on CAL % Nb of Clients Lost Clients New Clients AuM per Client Income per Account AuM per RM Nb of RMs Income per RM NNM per Client NNM per RM Accounts per Client	Total AuM Total Inflows Total Outflows NNM (Net New Money) Total Market Effect Total Lending Stock Total Inflows (Lending) Total Outflows (Lending) NNL (Net New Lending) Total CAL Total Income Return on CAL % Nb of Clients Lost Clients New Clients AuM per Client Income per Account AuM per RM Nb of RMs Income per RM NNM per Client NNM per RM Accounts per Client
Dashboard pages	7 pages	8 pages
	AuM, Lending Stock & Income (NNM, NNL) Home Cockpit - AuM, Lending Stock & Income Breakdown: AuM, Lending Stock & Income Client Base Client Portfolio: AuM, Lending Stock & Income AuM, Lending Stock & Income (NNM, NNL) Adhoc Analysis AuM, Lending Stock & Income (NNM, NNL) KPI Performance	AuM, Lending Stock & Income (Flows) Home Cockpit - AuM, Lending Stock & Income Breakdown: AuM, Lending Stock & Income Inflows / Outflows (AuM) Client Base Client Portfolio: AuM, Lending Stock & Income AuM, Lending Stock & Income (Flows) Adhoc Analysis AuM, Lending Stock & Income (Flows) KPI Performance
More information
	More info on AuM, Lending Stock & Income (NNM, NNL)	More info on AuM, Lending Stock & Income (Flows)
Ready to start?
	CreateAuM, Lending Stock & Income (NNM, NNL)Dashboard	CreateAuM, Lending Stock & Income (Flows)Dashboard

Wealth

Template	Wealth Management
Description
	Get a detailed understanding of your Wealth services: Asset Under Management (investment model, managers...), Clients (Flows, Avg AuM...), Profitability (Revenues, Expenses, Commissions...) and Clients P&L (Gains, TWR - Performance %...)
Required attributes	17 attributes
	Date Manager Client Country Of Residence Investment Model Market Value Accrued Interest Management Fees Flows FX Gain Price Gain LoanFeesMonth Fixed Fees Variable Fees Introducer Commissions Manager Commissions TWR
KPIs	28 KPIs
	Total AuM Total Gains Total Management Fees Total Operating Expenses Total Gross Revenue Total Net Revenue Introducer Commissions % on Gross Revenue Introducer Commissions % on Net Revenue Total Introducer Commissions Period Performance % (TWR) Total Manager Commissions Clients Net Revenue % Avg AuM per Client Total Fixed Expenses Fixed Expenses % Total Variable Expenses Variable Expenses % Total Flows Total Fees Total Investment Gains FX Gains % Total FX Gains Total Price Gains Price Gains % Weighted Avg Management Fees % Total Accrued Interests Clients (over period)
Dashboard pages	8 pages
	Wealth Management Home Wealth Management Cockpit Breakdown: AuM Client Base Client Portfolio: AuM Wealth Management Adhoc Analysis Wealth Management KPI Performance Wealth Management Country Analysis
More information
	More info on Wealth Management
Ready to start?
	CreateWealth ManagementDashboard

Trading

Template	Trading
Description
	Get a better understanding of the volumes of trading and Clients that you manage (Trade Volume) and their Revenue (Revenue and Commission Rate).
Required attributes	9 attributes
	Date Trader Client Sector Trade Type Nb of Transactions Trade Amount Commission Rate Trade Revenue
KPIs	8 KPIs
	Trade Volume Total Revenue Number of Trades Number of Clients Nb of New Clients Avg Commission Rate Trade Volume per client Revenue per client
Dashboard pages	9 pages
	Trading Home Cockpit Trading Trading Breakdown Trading Adhoc Analysis Trading KPI Performance Trading - Potential New Revenue Trading - Trade Volume by Sector Trading - Trade Volume by Trade Type Trading - Trader Activity
More information
	More info on Trading
Ready to start?
	CreateTradingDashboard

Loans

Template	Loans
Description
	This Accelerator provides complete and insightful information on your loans, the revenue they have generated, and any Delinquent or Default loans.
Required attributes	16 attributes
	Month Snapshot Loan Start Date Loan End Date Borrower Branch Loan # Loan Type Is Delinquent Loan Is Default Loan Loan Amount (total) Loan Interests (total) Loan Fees (total) Client Liabilities (end of month) Loan Interests (for the month) Loan Fees (for the month) Loan Amortization (for the month)
KPIs	18 KPIs
	Total Liabilities Nb Loans Total New Loans Nb New Loans Full Loan Amount Full Loan Interests Full Loan Fees Total Amortization Total Interests Total Fees Total Revenue Revenue Rate Nb Delinquent Loans Loan Delinquency Rate Total Delinquent Loans Nb Loan Defaults Loan Default Rate Total Loan Defaults
Dashboard pages	7 pages
	Cockpit Loans Loans Revenue Loans Maturity Delinquent and Default Loans Borrower Detail Loans Adhoc Analysis Loans KPI Performance
More information
	More info on Loans
Ready to start?
	CreateLoansDashboard