Financial Planning & Analysis

A Case Study: Joint Venture Finance

In a prior client engagement, I served as the founding Finance Partner for a large entertainment studio launching an app as a joint venture with other major entertainment companies. I came on board to no finance infrastructure, and the client was operating against a fixed development timeline and investment commitment. Nonetheless, I developed all of their forecasting, reporting, and scenario planning models to manage their operational strategy. Let’s go over best practices in joint venture finance that I gleaned from that experience.

Tip #1: Understand all salient deal points.

When I first came to the client’s office, I quickly discovered they were operating without any financial planning and reporting infrastructure. They had already hired an executive team, droves of software engineers and data engineers, as well as marketing folks. They had leased office space and started to pay third-party vendors. 

In other words, they were burning through cash without a plan for how to manage it responsibly within a development budget.

To immediately tackle this problem, my first step was to sit down with the General Counsel and discuss the key deal points. Namely:

  • How frequently was the client obligated to report to its investment partners, and at what level of detail? 
  • On what basis was the required reporting (e.g., cash, accrual, etc.)? 
  • What was the current investment commitment and timeline, as well as the required product deliverables within that timeline?

I discovered that the joint venture partners had agreed to a monthly reporting structure on a cash basis. There was an established development budget cap, as well as an annual approved budget for its first year of post-launch operations.

Tip #2: Design a Chart of Accounts and necessary reporting attributes in the company’s Enterprise Resource Planning (ERP) system.

Once I had a clear understanding of the deal requirements, the next step was to discern expectations from key team members. I conferred with all executive team leads to understand their respective internal needs for reporting and research. For example, the Head of Product may want to know forecasted data usage from Amazon Web Services, while the VP of Marketing may want to categorize spend by type of campaign (e.g., email/push vs. print). 

Taking these perspectives into consideration, I constructed a bottoms-up Chart of Accounts to meet the flexibility in reporting to the organization. The client used SAP for its ERP system, and I leveraged SAP’s “WBS Elements” feature to create additional data attributes within a specific account. This allowed for even more granular reporting where needed.

Tip #3: Establish a comprehensive vendor management process.

As mentioned, the client was burning cash without a plan. They had already contracted with a few essential third-party vendors in order to operate. However, there was no clear-cut process on how to pay these vendors. 

I established a central email account for vendors to digitally submit invoices, and I spoke with the legal team to have invoice instructions changed within future vendor agreements. Leveraging the new Chart of Accounts, I created a guide on how to “code” invoices to the proper accounts. Then, I trained the office administrators on invoice coding, and I gave them shared access to the invoice mailbox.

Vendors were finally being paid on time, and invoices were coded to the correct accounts. (What a concept!) But how would future payments be forecasted and managed? A monthly meeting was established with the team leads to stay afloat of the current and future vendor pipeline. I built an Excel tracking tool to monitor by-vendor SLA terms, timelines, and anticipated rate increases.

Tip #4: Build a bottoms-up operational forecast model.

Now that the urgent building blocks were in place, I could finally tackle building a robust financial model. I started by working from a download of monthly actuals from the new Chart of Accounts. I leveraged trends from historical monthly spending and created SG&A account forecasts. Then, I layered on:

  1. commitment schedule from the third-party vendor tracking,
  2. by-employee labor tracking, and 
  3. a by-account topside worksheet to enable flexibility in forecasting special circumstances. 

Whenever any product is being developed, labor is usually the largest expense line item. Due to this, I ensured the forecast model allowed for any possible changes in headcount and their associated costs. I set up a weekly meeting with Human Resources to stay in close touch with any anticipated staff updates. I also informed HR about the cash available to spend on labor, which influenced some hiring and role re-leveling decisions.

In order to both inform guidance internally and report to investment partners, I amalgamated the granular detail into a high-level reporting summary based on categorized cost drivers. I wanted to clearly speak to the “punch lines” of the forecast model, particularly when the audience included some executives who lacked a Finance background.

Tip #5: Construct a robust reporting suite.

To complete the client’s finance infrastructure, I constructed a monthly reporting template that seamlessly integrated with the forecast model. I additionally ensured the monthly reporting template suite satisfied all of the requisite deal points contemplated in the master agreement. A cadence was established to review the monthly reporting package with the respective investment partners and answer any of their questions.

By thoughtfully approaching how to establish the client’s finance and operations infrastructure, I was able to deliver both the initial development and first year post-launch operating costs within budget. I also had the intel to construct a detailed, bottoms-up budget for their second year of operations, which was approved by all investment partners on the Board of Directors. The client is still operating today and continues to leverage the models and accounts I constructed to help manage their business.

Learn More About Joint Venture Finance or Other FP&A Disciplines

Along with joint venture finance expertise, we offer a wide range of services to help drive your finance and accounting functions forward. If you found this post valuable and are looking for similar support within your company, we invite you to explore our entertainment finance consulting services. You can also learn more about building longer-term financial planning strategies by downloading our insightful timeline:

5-year strategic financial planning timeline download button

About the Author

Jaime has 12 years of diverse finance and project management experience in the real estate, entertainment, video games, and technology industries. Prior to joining 8020, Jaime was the Director of Studio Finance and Operations at Activision Publishing and had previously worked for WB Games, Warner Bros. Entertainment, Mesa West Capital, and SL Green Realty Corp. Her expertise centers around financial planning & analysis, operational strategy, budgeting and forecasting, cause of change analysis, reporting, cash flow forecasting, asset valuation, process design, and financial systems implementations. Jaime holds a Bachelor of Science degree in Economics from the Wharton School of Business at the University of Pennsylvania.

Categorized in: ,

similar articles

Learn to think and approach problems like our financial consultants.

Careers

On Process Improvement & Communication

My most recent role involved cost recovery from external partners that received invoices from my client for services on a quarterly basis. These services were related to providing various things from business support to access to certain business applications and third-party licenses. There were lots of changes to the scope of these different services in… View Article

April 16, 2021Seena Mostafavipour

Resources

ASC 842 Review Template

Our detailed checklist offers a clear process for reviewing new and existing leases to meet the ASC 842 Lease Accounting standard.

April 12, 2021Tennille Wilkinson

Careers

Michael LaBorde: 6 Questions for 6 Years

We’re celebrating team member Michael LaBorde’s six-year work anniversary at 8020 Consulting! To get his perspective on his experience over the last six years, we asked him six questions: 1. What do you enjoy most about your work these days? How do you think that’s changed over time? I like the variety of industries I’m… View Article

April 9, 2021George Jacob

See All