You can use the Performance Returns report to present "after tax" performance results.
You can display country and regional tax rates (for the USA, Federal and state tax rates) in reports and can calculate returns net of country and regional taxes. You can create reports that apply the entity's (country or regional) tax rate at the security level for Performance Returns reports; the report uses the country or region associated with the portfolio entity to determine the appropriate tax rate.
To set up and maintain data needed to present after tax performance results, you:
- Set up and maintain the country and/or region of entities for which you plan to report on tax rates
- Create an Advanced tax field that identifies the type of tax rate you plan to use for after tax calculations and the location of the tax rate data
- Set up and maintain tax rates for countries and regions
- Create an Entity Tax Rate field that determines whether to use the country or region tax rate, and identifies the tax type to use for calculations
Set up the Performance Calculation Report Rule to include fields that calculate and display information related to tax rates
Note:
| Info |
|---|
| Eagle provides a specialized set of guidelines for setting up tax rates and using them in Retail Fund reports. For details, along with a description of the columns in the TAX_RATE table in the PACE_MASTER database, see the Retail Fund Performance User Guide. |
| Anchor | ||||
|---|---|---|---|---|
|
The Performance Calculation report can identify the appropriate tax rate to apply to a portfolio or composite-type entity based on country and/or region information you store at the entity level.
To calculate after tax performance results, set up the following information for your entities:
- In the ENTITY table in the RULES database, ensure that :
...
- you maintain a tax country for each entity
...
- , and maintain a tax region for each entity, if you plan to report on tax rates at a regional level.
- Create an Entity field attribute that identifies the field where you store the tax country for entities.
- Create an Entity field attribute that identifies the field where you store the tax region for entities, if you plan to report on tax rates at a regional level.
...