Deborah Thomas
Executive Vice President & Chief Financial Officer at Hasbro
Thanks, Chris, and good morning, everyone. Over the course of 2022, we made meaningful progress to strengthen Hasbro by completing our strategy review, unveiling and beginning to implement Blueprint 2.0 and undertaking a significant transformation project to streamline our organization and priority. While the end of 2022 did not meet our expectations, our focus on controlling what we can and making decisions to strengthen Hasbro for the future improved operating profit margin in a challenging environment.
Let me start with the balance sheet and our focus on disciplined cash management. Lower sales resulted in higher inventories in hand. At year end, we have reduced our on-hand inventory levels by $168 million in third quarter, but they were up $125 million from last year or 23%. This was driven by last year's revenue timing with early retailer purchases and our softer than planned Q4 sales. The timing of MAGIC release is in early 2023 and the increase in paper stock on hand also contributed to the growth.
At retail, inventories were up low-single digits across our top global market and Q4 POS trend indicate churn has slowed and results in increase. As a result, we estimate approximately a $135 million of this is ex of toy and game inventory at retail. Given our higher level of opening retail inventory as well as that from others in the industry, we expect a negative impact on first half retail orders. When we combine this with the fact that 60% of our approximately $300 million in revenue headwinds are in the first half of this year and the early timing of retail orders and shipments last year arising from supply chain challenges, we anticipate our first half revenue to be down approximately 20% compared to the first half of 2022, with Q1 revenue down approximately 25%.
Operating cash flow was $373 million. We are forecasting 2023 operating cash flow in the historical $600 million to $700 million range. We continue to believe we'll will reach $1 billion plus in operating cash flow level, but this is now most likely 2025 and beyond. We have sufficient cash to operate our business, meet our capex needs, including investing for growth and funding our dividend. We continue to target debt-to-EBITDA of 2.0 time to 2.5 time. For 2023, we expect to make progress against this target. Pending the outcome of the sale of non-core film and TV assets, we plan to prioritize the sale proceeds towards paying down debt. We remain committed to maintaining our investment grade rating. At the same time, we're intensely focused on our cost savings goal and improving margins.
Last year, we increased adjusted operating profit margin by 30 basis points, and we believe we have the potential to add an additional 50 basis points to 70 basis points this year. We achieved approximately $50 million in run rate cost savings and actualized $20 million in 2022, but this was partially offset in year end results due to the volume decline in Consumer Products. We remain on track for $150 million in annualized run rate cost savings for year end 2023. This progress keeps us on the path to reach our targeted 20% operating profit margin in 2027, if not sooner, while also growing our existing business earnings and earnings per share over the period.
As Chris mentioned earlier, the process for selling our non-core Entertainment business remains on track, and we plan to update our guidance for our continuing business following the close of the transaction. With a portion of our cost savings, we're continuing to invest in our core initiatives, innovation, digital, direct and insights. We're focusing on higher margin brands, moving out of low return businesses and simplifying our organization. We're in the middle of this transition and as a result, recorded charges last year for transformation activities, including severance and non-cash asset impairment. In the fourth quarter, this included an impairment of POWER RANGERS. The impairment was triggered by our focused strategic approach to prioritize other brands in film development in the near term. Although the impairment charge was incurred, the brand continues to generate value and remains an important part of our brand portfolio.
POWER RANGERS revenue grew last year, celebrating its 30th Anniversary this year with the new scripted special on Netflix, the third season of Dino Fury and continued development on young adult scripted series with writer/showrunner Jenny Klein and Jonathan Entwistle. Looking at our adjusted results for full year 2022, revenue, profit and earnings were impacted by lower than expected fourth quarter sales. Foreign exchange had a negative $166 million impact on full year revenue. Cost of sales was up 240 basis points due to higher product cost, inventory obsolescence, sales analysis and close out of our toy and game products. We benefited from higher product prices early in the year and lower freight expense as we moved through 2022. We anticipate improvement in cost of sales to revenue share driven by our ongoing transformation efforts. Program amortization dollars declined on lower entertainment deliveries in the year, royalty expense declined on lower partner brand and Entertainment revenues.
At year end 2022, we exited several third-party licenses, which will lower partner brand revenue and our royalty obligation this year, while benefiting operating margin. We served loss on advertising last year, aligned with our focus on fewer brands and lower film advertising in our Entertainment segment, as we comp the My Little Pony movie in 2021 and supported through our film releases in 2022. The team plans to increase advertising support of our key brands and categories in 2023, increasing the overall spend, but with a much more targeted approach.
SG&A declined in dollars in line with revenue, primarily due to lower bonus and equity compensation expense, given the outcome of the year, and lower depreciation related to 2021 video game launches. We also saw lower freight distribution expenses plan that have higher warehousing cost associated with increased levels of inventory. In 2023, while we are achieving cost savings in this line item, given the timing to achieve the run rate on those tables, we are planning to forecast the increase with more normalized compensation expenses planned. We expect this to impact 2023 by approximately $80 million, with approximately $65 million impacting SG&A and the remainder in product development.
For the current year, our outlook translates to an adjusted operating profit margin improvement of 50 basis points to 70 basis points. Our adjusted underlying tax rate for 2022 excluding discrete items was 21.8%, in line with our projected rate for the year. In 2023, we expect our underlying adjusted rate to be between 20% to 21%.
Looking at our segments. Wizards of the Coast and Digital Gaming revenues increased 5% in constant currency. Tabletop revenues were up 12% behind strong MAGIC: THE GATHERING releases. Digital declined 23%, which was expected given the comparison with 2021 launches of the premium game, Dark Alliance and MAGIC: THE GATHERING ARENA Mobile. In 2023, digital revenues forecast to increase with the launch of Baldur's Gate 3 from Larian with some revenue expected in the third quarter and increasing in the fourth quarter.
MAGIC, D&D and Digital remain investment priorities for Hasbro. Adjusted operating profit was $538.3 million, down 2%, driven primarily by higher product costs, increased royalties due to MAGIC, Universes Beyond and increased product development, partially offset by decreases in advertising, promotional and depreciation expense versus 2021 gaming launches as well as lower incentive compensation.
As forecasted, adjusted operating profit margin decreased and was 40.6%. For the full year 2023, we expect mid-single digit revenue growth in the segment. Also, as we continue to invest for future growth and expand our Universes Beyond product, we expect adjusted operating profit margin in the high 30% range. Consumer Products segment revenues decreased 7%, excluding a negative $117 million impact of foreign exchange, $92.3 million of which was in Europe. The segment's decline is led by lower revenues in North America and Europe, partially offset by growth in licensing in Latin America. Lower revenue, higher sales allowances, closeouts, and warehousing contributed to a decline in adjusted operating profit margin to 7.6%, which was partially offset by savings realized from our Operational Excellence program within cost of sales and distribution expense, as well as lower air freight, royalties, advertising and incentive compensation.
For the full year 2023, Consumer Products revenue is expected to decline mid-single digits for full year 2022, with adjusted operating profit margin improvement of 150 basis points to 200 basis points from the adjusted op margin in 2022. The team are executing against a robust entertainment slate and strong innovation, but we are facing significant headwinds from exiting certain third-party licenses, transitioning several Hasbro brands from an in-house to license model, reducing recent inventory at retail, rightsizing certain markets and continued FX headwinds. As noted earlier, a significant portion of these headwinds are in the first half.
Entertainment segment revenues decreased 15% in constant currency. When adjusting for music, the segment declined 12%. Revenue was impacted by the timing of deliveries to partners on the TV side of the business and fewer film releases this year versus last. The TV business grew, building on several successful scripted theory, including The Rookie, Yellowjackets and Cruel Summer with several new shows like The Rookie: Feds and The Recruit. Family Brands revenue decreased, given My Little Pony: A New Generation was delivered to Netflix in 2021, without a comparable release in 2022, combined with decreases in digital revenue and delivery. The decrease in music and other, primarily relates to the sale of the music business in the third quarter of 2021.
For 2023, this revenue should be close to zero as we've exited these businesses. Total Entertainment segment adjusted operating profit decreased 19%. Lower revenues impacted profit and were partially offset by lower royalty, advertising, promotion and compensation expense. For the full year 2023, we expect Entertainment revenue to increase low-single digit and adjusted operating profit margin is expected to increase by -- from to 8.6% in 2022.
As Chris mentioned, Dungeons & Dragons: Honor Among Thieves premieres in March. We co-funded this film with Paramount and will participate in the box office and associated Entertainment revenues. Based on our share of box office, we expect Entertainment revenue to begin being recognized in late Q3 or Q4 of this year. We expect the majority of the related cash receipts to occur in 2024. As we look ahead, the sales process for select film and TV entertainment assets is ongoing and the outcome will inform our long term financials.
We continued to anticipate growing revenue at a mid-single digit CAGR and improving operating margin to 20% and potentially greater level in 2027. I couldn't be prouder of the work and dedication our teams have put into the business this past year. In the past several years, it's been dynamic, but they never shy away from the challenge and while the year didn't land as we have planned, the Blueprint 2.0 strategy is in place. Our teams are aligned to train it and we're well along the path in executing that plan.
Before I close, since we last spoke in October, I announced my plans to retire from Hasbro. I remain committed to this company and team and will stay until my successor is in place and is in orderly transition. During my time at Hasbro, we've accomplished more than I could have imagined, and I know this company has even more amazing accomplishments ahead of it. Thank you for your partnership and support of Hasbro all these years. It's a hard decision, but I am confident that Hasbro is in good hands.
We are now happy to take your questions.