Job Description
As a key member of the COE FP&A team, this position manages the Residuals ultimates reporting process for Television, Theatrical and Home Entertainment Products produced or acquired by Warner Bros. Discovery and HBO/Max according to Film Accounting Standards ASC 926 for the planning cycles (Budget, Forecast). This includes management of contractual guild obligations and the setup and review of residual ultimate calculations to ensure the accuracy of reporting obligations.
Residuals Ultimates Reporting:
• Manages monthly by-title residuals ultimates calculations and analysis for Television, Theatrical, and Home Entertainment products managed by FP&A
• • Builds and maintains residuals models used to compute ultimate residuals liability, including validation of episodic guild rates for reasonableness, and maintaining manual override calculations, by market and by title, as needed to ensure timely and accurate ultimate calculations for all products.
• Prepares and updates ultimate residuals calculations by title utilizing detailed excel models, SAP and TM1.
• Collaborates with departmental personnel and provides participations ultimates for inclusion in weekly, monthly, quarterly, and annual reporting requirements.
• Ensures appropriate analytical analysis is completed and communicated to Senior Management and responds to queries of Senior Management related to issued participations reporting.
• Manages and updates residuals control log monthly and validates rates from AIRS and Oracle (corporate residuals systems) to ensure that the most recent information provided by the Corporate Residuals Group is used for the calculation of residuals ultimates for all products.
• Reviews residual ultimate calculation with the Corporate Residuals and HBO/Max Business Affairs groups to ensure accuracy and completeness based on mutual understanding of guild rules.
• Provide commentary to senior management on variances vs. prior forecasts, prior year and budget for all planning cycles.
• Communicate risks and opportunities to senior management.
• Ensures nesessary system adjustments are reviewed and maintained to produce accurate costing (expense) results, including rates table maintenance, costing class and MPM attribute (PRI, NEW, DRS) maintenance, and system overrides (stat items).
• Manages monthly Rollforward of residuals rates.
• Works closely with Studios Corporate Residuals Group, HBO/Max Business Affairs and various Business Unit personnel, as required.
• Determines and communicates procedures to be followed by departments that provide data for Residuals ultimates.
• Ensures appropriate analytical analysis is completed and communicated to Senior Management and responds to queries of Senior Management related to issued residuals ultimates.
MUST HAVE:
• Advanced proficiency in Excel required (creating spreadsheets, pivot tables, v-lookups, macros)
• SAP BW/BPS experience preferred
• Strong analytical and logic skills including ability to grasp the ''big picture'' while also maintaining strong detail orientations
• Must have effective writing and verbal communication skills
• Thorough knowledge of accounting principles and practices (GAAP) and financial statements
• Advanced proficiency in Excel required
NICE TO HAVE:
• Minimum of 5-7 years' experience in an accounting/forecasting or related environment required
• Previous experience in public accounting and/or the entertainment industry preferred
• BA/BS degree in Accounting/Finance/Business or related field required
Championing Inclusion at WBD
Warner Bros. Discovery embraces the opportunity to build a workforce that reflects the diversity of our society and the world around us. Being an equal opportunity employer means that we take seriously our responsibility to consider qualified candidates on the basis of merit, regardless of sex, gender identity, ethnicity, union status, age, sexual orientation, religion or belief, marital status, pregnancy, parenthood, disability or any other category protected by law.
Jobcode: Reference SBJ-r040x8-98-80-143-34-42 in your application.