# Companion Files: The Consolidated Tax Return Handbook

Author: Julian R. Sterling
Companion page: https://julianrsterling.com/consolidated-tax-return/

## Files Included

1. **Consolidated_Tax_Return_Workbook.xlsx**
   The complete 10-tab working model behind every schedule and scenario in *The Consolidated Tax Return Handbook* (Alderbrook Industrial Holdings, Inc., tax years 2026 to 2028):
   - `1_Inputs`: Group ownership, starting stock bases, P&L operating assumptions, intercompany transfers, S3 SRLY NOL, and scenario parameters.
   - `2_CTI_2026_2028`: Annual separate taxable income, consolidated taxable income (CTI), P.L. 119-21 1% charitable floor and 10% ceiling, consolidated Section 163(j), and standalone vs. consolidated tax savings ($1,231,986 over 3 years).
   - `3_Intercompany_1502_13`: CNC equipment matching schedule (Section 168(i)(7)), outside-sale acceleration proof ($700,000 single-entity gain), inventory resale matching, and intercompany loan netting.
   - `4_Basis_ELA_1502_32`: Annual outside stock basis rollforwards for S1, S2, and S3 under Treas. Reg. 1.1502-32 and S2's Excess Loss Account ($4,482,200 end 2027; $4,089,800 end 2028).
   - `5_SRLY_CNOL_1502_21`: Post-2017 S3 SRLY cumulative register (TD 9927 80% cap and 1.25x drawdown), Section 382 overlap comparison, and departing-member CNOL apportionment.
   - `6_ULR_1502_36`: Unified Loss Rule Tier 1 (two-block basis redetermination), Tier 2 (basis reduction), Tier 3 (attribute reduction), and Section 1.1502-36(d)(6) election comparison.
   - `7_ShortYear_1502_76`: Mid-year closing allocation comparing Closing of the Books vs. Ratable Allocation with extraordinary capital gain and Next-Day Rule bonus.
   - `8_TaxAlloc_1552`: Side-by-side 2026 tax allocation across Section 1552(a)(1), Section 1552(a)(2), and Section 1552(a)(1) paired with Treas. Reg. 1.1502-33(d) 100% percentage method.
   - `9_Scenarios_163j_Exit`: Binding consolidated Section 163(j) carryforward allocation ($2,104,000) and S2 stock exit with ELA recapture and intercompany gain acceleration.
   - `10_Controls`: 12 automated reconciliation checks whose total failure count must equal 0.

2. **Consolidated_Tax_Return_Calculator.xlsx**
   A clean 4-tab standalone practitioner calculator (`Start_Here`, `1_Group_Inputs`, `2_Consolidated_Calc`, `3_Checks`) pre-loaded with an independent worked example so you can enter your own group's figures immediately.

## Conventions

- Blue text marks editable input cells.
- Black text marks live Excel formulas (zero macros, zero circular references).
- Check the `10_Controls` (or `3_Checks`) tab after any edit and confirm total failures equal 0 before relying on any output.
