Interest Expense Base Building and Apportionment
Base 511
- On theE&P By Source Code – After LT Interestreport on lineTOTAL GROSS INCOME, sum the amounts in the column for system code61 Passive, FPHCIand the columns for any user-defined source codes withFTC Type:3 – Passive IncomeandSubpart F Type:2 – FPHCIin theSource Code Definition Chartfor the total Passive, FPHCI gross income for the divisional consolidation or subsidiary.
- IfDivisionis selected in the divisional consolidation inBinder PropertiestabInternationalunderDivisional Consolidation Data, calculate the amount in each division.
- On theE&P By Source Code – After LT Interestreport on the line for theIntercompany Interest Expensein column[0] TOTALidentify the amount for the subsidiary or divisional consolidation.
- IfDivisionis selected in the divisional consolidation inBinder PropertiestabInternationalunderDivisional Consolidation Data, calculate the amount in each division.
- For the subsidiary or division or divisional consolidation, allocate the Intercompany Interest Expense to thePassive, FPHCIsource codes to a maximum of the amount ofTOTAL GROSS INCOMEfor each source code of the subsidiary, division, or divisional consolidation.
- If theIntercompany Interest Expenseis less than thePassive, FPHCI TOTAL GROSS INCOMEand more than one source code hasPassive, FPHCI TOTAL GROSS INCOME, for eachPassive, FPHCIsource code, divide thePassive, FPHCI TOTAL GROSS INCOMEby the totalPassive, FPHCI TOTAL GROSS INCOMEin each subsidiary, divisional consolidation, or division to calculate the ratio for each source code.
- Multiply theIntercompany Interest Expenseby the ratio for each source code in each subsidiary, divisional consolidation, or division to calculate the amount ofIntercompany Interest Expenseallocated to eachPassive, FPHCIsource code.
- IfDivisionis selected in the divisional consolidation inBinder PropertiestabInternationalunderDivisional Consolidation Data, and thePassive, FPHCITOTAL GROSS INCOMEof the divisional consolidation includes amounts from divisions and the elimination that don’t have Intercompany Interest Expense, sum thePassive, FPHCITOTAL GROSS INCOMEof the divisions and elimination without Intercompany Interest Expense to calculate the remainingPassive, FPHCITOTAL GROSS INCOMEof the divisional consolidation.
- In the divisional consolidation, subtract theIntercompany Interest Expenseallocated to thePassive, FPHCITOTAL GROSS INCOMEof the divisions withIntercompany Interest Expensefrom theTOTAL Intercompany Interest Expenseof the divisional consolidation to calculate the remainingIntercompany Interest Expense.
- In the divisions with Intercompany Interest Expense, subtract theIntercompany Interest Expenseallocated to thePassive, FPHCITOTAL GROSS INCOMEfrom theTOTAL Intercompany Interest Expenseof the division to calculate the remainingIntercompany Interest Expense.
- Divide the remainingIntercompany Interest Expensein each division by the remainingIntercompany Interest Expensein the divisional consolidation to calculate the ratio for each division.
- Multiply the remainingPassive, FPHCITOTAL GROSS INCOMEof the divisional consolidation by the ratio for each division to calculate the additional amount of Intercompany Interest Expense for each division.
- If the remainingIntercompany Interest Expenseis more than the remainingPassive, FPHCI TOTAL GROSS INCOMEand more than 1Passive, FPHCIsource code has remainingPassive, FPHCITOTAL GROSS INCOMEat the divisional consolidation or subsidiary, for eachPassive, FPHCIsource code, divide the remainingPassive, FPHCI TOTAL GROSS INCOMEby the totalPassive, FPHCI TOTAL GROSS INCOMEin each subsidiary, divisional consolidation, or division to calculate the ratio for each source code.
- Multiply the additional amount ofIntercompany Interest Expenseby the ratio for each source code in each subsidiary, divisional consolidation, or division to calculate the additional amount ofIntercompany Interest Expenseallocated to eachPassive, FPHCIsource code.
- If the remainingIntercompany Interest Expenseis more than the remainingPassive, FPHCI TOTAL GROSS INCOMEin the subsidiary, divisional consolidation, or division, subtract the Total additional amount of Intercompany Interest Expense from the Total remaining amount of Intercompany Interest Expense to calculate theTotal Intercompany Interest Expensefor base512.
- If the remainingPassive, FPHCI TOTAL GROSS INCOMEis more than the remainingIntercompany Interest Expensein the subsidiary, divisional consolidation, or division, subtract the Total additional amount of Intercompany Interest Expense from the Total remaining amount ofPassive, FPHCI TOTAL GROSS INCOMEfor each source code to calculate the remainingPassive, FPHCI TOTAL GROSS INCOMEfor base513.
Base 512
- On theE&P By Source Code – After LT Interestreport on lineTOTAL GROSS INCOME, sum the amounts in the columns for source codes not included in base 511 for the subsidiary or divisional consolidation for the base512 TOTAL GROSS INCOME.
- IfDivisionis selected in the divisional consolidation inBinder PropertiestabInternationalunderDivisional Consolidation Data, on lineTOTAL GROSS INCOME, sum the amounts in the columns for source codes not included in base 511 for the base512 TOTAL GROSS INCOMEin each division with amounts on lineIntercompany Interest ExpenseofTotal Intercompany Interest Expensefor base512or amounts on lineInterest Expense.
- If the subsidiary, divisional consolidation, and division, sum the amount ofTotal Intercompany Interest Expensefor base512and the amount ofInterest Expensein column[0] TOTALto calculate theTotal Interest Expensefor base512.
- If more than one source code is not included in base 511 for the subsidiary, divisional consolidation, or division, on lineTOTAL GROSS INCOME, divide the amount for each source code not included in base 511 by the sum of all source codes not included in base 511 to calculate the base512 TOTAL GROSS INCOMEratio for each source code.
- If the remainingPassive, FPHCI TOTAL GROSS INCOMEfor base513is0, in the subsidiary, divisional consolidation, and each division, multiply the base512 TOTAL GROSS INCOME ratiofor each source code by theTotal Intercompany Interest Expensefor base512to calculate the base 512 Intercompany Interest Expense to allocate to each source code.
- In the subsidiary, divisional consolidation, and each division, multiply the base512 TOTAL GROSS INCOME ratiofor each source code by theInterest Expensein column[0] TOTALto calculate the interest expense to allocate to each source code.
- If the remainingPassive, FPHCI TOTAL GROSS INCOMEfor base513is greater than 0 and theTotal Interest Expensefor base512is less than the base512 TOTAL GROSS INCOME, in the subsidiary, divisional consolidation, and each division, multiply the base512 TOTAL GROSS INCOME ratiofor each source code by theTotal Intercompany Interest Expensefor base512to calculate the base 512 Intercompany Interest Expense to allocate to each source code.
- In the subsidiary, divisional consolidation, and each division, multiply the base512 TOTAL GROSS INCOME ratiofor each source code by theInterest Expensein column[0] TOTALto calculate the interest expense to allocate to each source code.
- If the remainingPassive, FPHCI TOTAL GROSS INCOMEfor base513is greater than 0 and theTotal Interest Expensefor base512is more than the base512 TOTAL GROSS INCOME, in the subsidiary, divisional consolidation, and each division, divide theIntercompany Interest Expensefor base512by theTotal Interest Expensefor base512to calculate the base512 Intercompany Interest Expenseratio.
- In the subsidiary, divisional consolidation, and each division, divide theInterest Expensein column[0] TOTALby theTotal Interest Expensefor base512to calculate the base512 Interest Expenseratio.
- In the subsidiary, divisional consolidation, and each division, multiply the base512 TOTAL GROSS INCOMEratio for each source code by theTotal Interest Expensefor base512and by the base512 Intercompany Interest Expenseratio to calculate the base512 Intercompany Interest Expenseto allocate to each source code.
- In the subsidiary, divisional consolidation, and each division, multiply the base512 TOTAL GROSS INCOMEratio for each source code by theTotal Interest Expensefor base512and by the base512 Intercompany Interest Expenseratio to calculate the base512 Interest Expenseto allocate to each source code.
- If the remainingPassive, FPHCI TOTAL GROSS INCOMEfor base513is greater than 0 and theTotal Interest Expensefor base512is more than the base512 TOTAL GROSS INCOME, in the subsidiary, divisional consolidation, and each division, for each source code, subtract the base512 Intercompany Interest Expensefrom theIntercompany Interest Expensefor base512to calculate theIntercompany Interest Expensefor base513.
- In the subsidiary, divisional consolidation, and each division, for each source code, subtract the base512 Interest Expensefrom theInterest Expensein column[0] TOTALto calculate theInterest Expensefor base513.
Base 513
- For apportionment base code56 – Gross Income – Absolute Value, in the subsidiary, divisional consolidation, and division, sum thePassive, FPHCI TOTAL GROSS INCOMEfor base513and the base512 TOTAL GROSS INCOMEto calculate theTOTAL GROSS INCOMEfor base513.
- In the subsidiary, divisional consolidation, and division, divide thePassive, FPHCI TOTAL GROSS INCOMEfor base513or the base512 TOTAL GROSS INCOMEfor each source code by theTOTAL GROSS INCOMEfor base513to calculate the base513 TOTAL GROSS INCOME – ABSOLUTE VALUEratio for each source code.
- For apportionment base code55 – Gross Income, in the subsidiary, divisional consolidation, and division, sum the positive amounts forPassive, FPHCI TOTAL GROSS INCOMEfor base513and the positive amounts for base512 TOTAL GROSS INCOMEto calculate theTOTAL GROSS INCOMEfor base513.
- In the subsidiary, divisional consolidation, and division, divide thePassive, FPHCI TOTAL GROSS INCOMEfor base513or the base512 TOTAL GROSS INCOMEfor each source code with positive amounts by theTOTAL GROSS INCOMEfor base513to calculate the base513 TOTAL GROSS INCOMEratio for each source code.
- In the subsidiary, divisional consolidation, and divisions with interest expense, for each non-interest expense apportioned by apportionment base code56 – Gross Income – Absolute Value, multiply the amount in column[0] TOTALby the base513 TOTAL GROSS INCOME – ABSOLUTE VALUEratio for each source code to calculate the expense for each source code.
- In the subsidiary, divisional consolidation, and divisions with interest expense, forIntercompany Interest Expenseapportioned by apportionment base code56 – Gross Income – Absolute Value, multiply theIntercompany Interest Expensefor base513by the base513 TOTAL GROSS INCOME – ABSOLUTE VALUEratio for each source code to calculate the expense for each source code.
- In the subsidiary, divisional consolidation, and divisions with interest expense, forInterest Expenseapportioned by apportionment base code56 – Gross Income – Absolute Value, multiply theI Interest Expensefor base513by the base513 TOTAL GROSS INCOME – ABSOLUTE VALUEratio for each source code to calculate the expense for each source code.
- In the subsidiary, divisional consolidation, and divisions with interest expense, for each non-interest expense apportioned by apportionment base code55 – Gross Income, multiply the amount in column[0] TOTALby the base513 TOTAL GROSS INCOMEratio for each source code to calculate the expense for each source code.
- In the subsidiary, divisional consolidation, and divisions with interest expense, forIntercompany Interest Expenseapportioned by apportionment base code55 – Gross Income, multiply theIntercompany Interest Expensefor base513by the base513 TOTAL GROSS INCOMEratio for each source code to calculate the expense for each source code.
- In the subsidiary, divisional consolidation, and divisions with interest expense, forInterest Expenseapportioned by apportionment base code55 – Gross Income, multiply theInterest Expensefor base513by the base513 TOTAL GROSS INCOMEratio for each source code to calculate the expense for each source code.
- In divisions without interest expense, for each non-interest expense apportioned by apportionment base code56 – Gross Income – Absolute Value, multiply the amount in column[0] TOTALby the base513 TOTAL GROSS INCOME – ABSOLUTE VALUEratio for each source code for the divisional consolidation to calculate the expense for each source code.
- In divisions without interest expense, for each non-interest expense apportioned by apportionment base code55 – Gross Income, multiply the amount in column[0] TOTALby the base513 TOTAL GROSS INCOMEratio for each source code for the divisional consolidation to calculate the expense for each source code.