Quantifacts - Wealth Management Software & Services
 
Profitability

Home | Software Products & Services | Quantifacts Q4 | Profit Manager | Outsourced Services | Case Studies

 
 
 
Profit Manager: Profit/Loss by Account, Officer, Department, etc.
This cost accounting system imports data from the Q4 Wealth Management System and sends back valuable P&L results
Expanding Profitability Reporting
Cost Modeling
Profit/Loss By Officer
Profit/Loss by Account
Analyze Where You Make and Lose Money
Benefits of Using Profit Manager
Use Profit Manager, Add Cost, P/L to All Your Business Reports
 

Expanding Profitability Reporting

In most wealth management firms, one person is responsible for profitability – you! There is one hot seat. There is one report detailing revenues, expenses, and hopefully a profit.

Some firms have created several hot seats, for example one for personal accounts, one for employee benefit accounts, and, say, one for estates. Now it is necessary to prepare a profit/loss report for each of these. These businesses have their own staffs, but they also share in use of certain service units such as operations, data processing, personnel, and senior management. It is necessary to apply/allocate these costs to each business.

Drawbacks are the following:

  • Revenues not properly allocated to accounts in each business
  • Costs not allocated to accounts
  • Allocations not based on real service usage
  • Officer cost not allocated to his/her accounts
  • Cost methods are fixed and may not be challenged

Cost Modeling

Today, modern managers want to establish many hot seats, essentially making every account manager profit responsible for his/her accounts.

To support this reporting, you must use cost accounting to calculate profit/loss for each account.

Most general ledger systems provide a rudimentary tool to perform profit/loss calculations for departments. Most managers are unhappy with the results because the costing methods are oversimplified. Few systems have the ability to prepare profit/loss by account and officer.

With Profit Manager, you can model cost methods and make changes until you achieve “buy in” from the management team. We can help in this process. Because the process is online and interactive, you can quickly reapply costs, run p/l’s, and examine profit margins using different methods. This helps you complete the negotiation with managers and establish methods which are agreed to as fair.

Profit/Loss By Officer

In the following example, the bank has decided to prepare profit/loss by officer using only direct costs and a gross margin.

  Personal Trust 9 Months YTD
Amy Wilson
100
James Pearson
124
Dorothy Williams
133
Mary Smith
139
Marsha Young
142
John Sampson
155
Number of Accounts 143 94 77 21 218 186
Value For Fees $56,960 $29,016 $19,496 $14,668 $6,006 $340,356
Full Value $62,279 $30,980 $22,534 $15,340 $6,006 $344,104
Revenues
Trust Account Fees $290,239 $137,463 $88,370 $45,427 $90,173 $508,426
Advisory Fees $57,662 $54,421 $25,291 $8,247 $7,920 $54,890
Sweep Fees $7,889 $4,721 $13,274 $1,053 $3,775 $8,939
Third Party Fees $12,382 $10,422 $4,314 $2,194 $1,973 $20,145
Fund Custody Fees $5,436 $5,044 $3,283 $944 $1,075 $5,445
Total Revenue $373,609 $212,071 $134,533 $57,864 $104,915 $597,846
Basis Points
Per Admin Officer 60.0 68.5 59.7 37.7 174.7 17.4
Annualized 80.0 91.3 79.6 50.3 232.9 23.2
Direct Costs
Adminstrator Cost $40,604 $41,938 $37,945 $23,084 $26,852 $102,169
Investment Officer Cost $39,296 $23,491 $20,256 $1,569 $2,236 $66,895
Operations Direct Cost $106,922 $55,968 $36,595 $14,305 $21,773 $145,299
Non-Direct Officer Salary & Benefits $21,431 $14,319 $11,840 $3,192 $26,981 $26,862
Other Direct Cost $66,248 $44,480 $36,573 $8,892 $83,377 $82,872
Total Direct Cost $274,501 $180,195 $143,209 $51,041 $161,218 $424,096
Margins
Gross Margin $99,108 $31,876 $(8,676) $6,823 $(56,303) $173,750
% Gross Margin 26.5% 15.0% -6.4% 11.8% -53.7% 29.1%

 

Profit/Loss by Account

Here is a profit/loss by account. Note that we show the p/l on actual fees and on would be standard fees:

 

Analyze Where You Make and Lose Money

Use Profit Manager to conduct special studies. Here we show, for small accounts, the range of profit loss. Our worst accounts are on the left, our best are on the right. The red bar represents the variance from standard fees. Even if we collected this variance (a full, standard fee in each account), we still could not make money on the first 70% of these accounts!

Here is a segment of profitable accounts, with values from $.5-2 million. But we lose money in lowest 30%, and much of this appears to be due to the variance from standard fees.

Benefits of Using Profit Manager:

  • Establish profit consciousness among your people.
    • Measure the profitability at any level in the organization and zero in on areas that need attention.
    • You separate profitable accounts from unprofitable accounts
    • You rank officers by profitability
    • You measure the profitability of lines of business
  • Tailor fee and commission increases that ensure each account’s costs are covered.
  • Identify accounts that are costly to serve and focus on ways to either reduce their costs, or increase fees.
  • Array accounts by profitability levels and find out why you have big losers and big winners.
  • Optimize revenue increase and cost reduction programs. No longer will all customers be painted with the same broad brush. You can see the account-level, -income impact of your decisions.
  • Confidently and aggressively compete on pricing being able to determine account level break-even points.

Use Profit Manager, Add Cost, P/L to All Your Business Reports

A number of clients are including cost and profit/loss results in all their business reporting. This is an exciting prospect. Are your people increasing fees in unprofitable accounts? Are substandard fee accounts unprofitable? Make every account manager a Profit Manager.

 

  Home | Top
 
Wealth Management Reporting