Tax Rates

Oracle Hyperion Tax Provision requires input of the appropriate national income tax rates and regional income tax and apportionment rates at the legal entity level.

The Tax Rates form contains the national and regional tax and apportionment rates needed by the system to compute the national and regional provision for a specific entity. These tax rates are listed below:

  • Prior Year Tax Rate—The national statutory tax rate for the prior year; used for informational purposes.

  • Current Year Tax Rate—The national statutory tax rate for the current period; used in the calculation of the current provision, current year activity in the deferred tax rollforward, foreign rate differential in the consolidated effective tax rate report, and the current year tax rate change component in the deferred tax rollforward.

  • Current Temp Opening Rate—The beginning-of-year deferred tax rate to be used for temporary differences classified as current; used in the calculation of the beginning of year deferred tax asset/liability and the beginning of year rate change component in the deferred tax rollforward.

  • Current Temp Closing Rate—The end-of-year deferred tax rate to be used for temporary differences classified as current; used in the calculation of ending deferred tax asset/liability and the beginning-of-year and current-year rate change components in the deferred tax rollforward.

  • Non-Current Temp Opening Rate—The beginning-of-year deferred tax rate to be used for temporary differences classified as noncurrent; used in the calculation of the beginning-of-year deferred tax asset/liability and the beginning-of-year rate change component in the deferred tax rollforward.

  • Non-Current Temp Closing Rate—The end-of-year deferred tax rate to be used for temporary differences classified as noncurrent; used in the calculation of the ending deferred tax asset/liability and the beginning-of-year and current-year rate change components in the deferred tax rollforward.

Additionally, the system requires the apportionment rate for regional calculations on a jurisdiction-by-jurisdiction basis. The apportionment rate is listed below:

  • Apportionment Percentages, Opening—The prior-year apportionment percentage to be used by the system in the calculation of the opening tax balances in the deferred provision.

  • Apportionment Percentages, CY—The current-year apportionment percentage to be used by the system in the calculation of apportioned income in the current provision and tax based on current-year activity in the deferred provision.

  • Apportionment Percentages, Closing—The end-of-year apportionment percentage to be used by the system in the calculation of closing tax balances in the deferred provision.

To enter tax rates:

  1. Open the Tax Rates form.
  2. Set the Point of View by selecting members for the Scenario, Year, Period, and Entity dimensions.
  3. Enter the rate for each type.
  4. Click Submit Data.