John Terrones Email & Phone Number

Manhattan Beach, California, United States

• Worked with CFO and VP of FP&A to lead the organization-wide budget and reforecast process and rolling monthly flash.
• Key member in developing a strike model during the SAG/writer strike to accurately forecast potential downfalls for entire U.S equipment rental services with a total full year loss of $202M EBITDA vs. budget with a.
• Established workflows for tracking revenue trends and capital expenditure, as well as cash flow projection.
• Supported Hackman Capital Partner’s real estate M&A team in market due-diligence and underwriting potential studio acquisitions with integration strategies, both domestically and internationally.
• Provided leadership with ad-hoc scenario planning analysis for strategic initiatives, at both the studio operation and equipment rental levels.
• Created Powerpoint presentations for board of directors and other executive meetings.

Manhattan Beach, California, United States

• Became the go-to Excel professional for building platform wide financial models and automating through easy to interface dashboards. Became key member in using expertise to assist other departments including.
• Created and presented a 10-year plan for Television City Studios to Hackman Capital Partners that included trends, KPIs and recommendations for growth.
• Directed bi-weekly rolling short-term EBITDA forecasts to ensure operational excellence.
• Proactively identified and communicated forecast discrepancies from budget before month-end close to resolve issues.
• Managed straight-line schedules for shows and prepared monthly accrual backup for accounting.
• Created acquisition proformas for potential new studios using a combination of historical studio data and metrics.

Manhattan Beach, California, United States

• Assisted manager in building the FP&A department with main responsibility to create workflows for financial reporting.
• Created, automated and managed an Excel-based monthly consolidated financial package with variance commentary for MBS executives.
• Developed and built budget and reforecast templates for individual departments and respective consolidation packages with dashboards for input and output.
• Owned multiple financial models including P&L consolidations, TTM, MTD/YTD variances against budgets/reforecast, KPIs, capital expenditures, and rent rolls.
• Traveled to the U.K. to develop and improve processes at the MBS equipment rental joint-venture at Pinewood Studios.

Beverly Hills, California

• Provide executives with monthly consolidated financial reports of the entire Larry Flynt Corporation (brand HUSTLER), including L.F.P., Inc. and all its subsidiaries, both international and domestic.
• Presented consolidated variance analysis and commentary of actual against forecast/budget changes to executives.
• Experience with diverse profit & loss variance analysis including international and domestic broadcasting, retail, gaming (casino), publishing, video, real-estate, E-commerce, internet, and clubs.

Westlake Village, CA

• Responsible for developing, quantifying, and evaluating the transformation of internal and external information into business intelligence to support the strategic objectives of the organization and drive operational.
• Includes data and technology management (data acquisition, mining, analysis, data integrity management, metrics management and reporting).
• Possesses strong analytical, organizational, facilitation and communication skills and demonstrate the ability to collaborate within a group or team environment.
• Experience with SQL, macros, ad-hoc analysis, V-Lookups, pivot tables, formulas (i.e. IF, AND, OR, COUNTIF, SUMIF), filters, sorts and a variety of Excel calculations are used on a daily basis.

Bachelor’S Degree, Finance, General

Business Administration / Finance

General Studies