Ledger Based NAV Expense Rule Calculation Example
You can use an adjusted NAV expense rule to set up a Ledger based expense rule.Â
In this example, you set up an Adjusted NAV Expense Rule to include ledger account balances from all ledger accounts in the capital and income ledger accounts. (Ledger account range 3001000000 – 4999999999). The ledger account amount displayed by the query is 23,516,010.00.
The variable expense uses a tier rule shown in the following table.
Tier ID | Lower Bound | Upper Bound | Fee Tier Percent Rate |
---|---|---|---|
TIERRULE10 | 0.00000000 | 5,000,000.00000000 | 0.03000000 |
TIERRULE10 | 5,000,000.01000000 | 10,000,000.00000000 | 0.02500000 |
TIERRULE10 | 10,000,000.01000000 | 0.00000000 | 0.02250000 |
Using the previous tier rule and the ledger based NAV component amount of 23,516,010.00, the system calculates the variable expense as shown in the following table.
Tier ID | Lower Bound | Upper Bound | Fee Tier Percent Rate | NAV Tier Amounts | Expense |
---|---|---|---|---|---|
TIERRULE10 | 0.00000000 | 5,000,000.00000000 | 0.03000000 | 5,000,000.00000000 | 410.96 |
TIERRULE10 | 5,000,000.01000000 | 10,000,000.00000000 | 0.02500000 | 4,999,999.99000000 | 342.47 |
TIERRULE10 | 10,000,000.01000000 | 0.00000000 | 0.02250000 | 13,516,009.99000000 | 833.18 |
 |  |  |  | 23,516,009.98000000 | 1,586.60 |