Financial due diligence and EBITDA forecasting for a healthcare sector client with 14 affiliate entities.
Our client is in the healthcare sector, it provides healthcare-related management services through its affiliates. Being a representative of the client's transaction advisory team, we performed financial due diligence on historical data while also evaluating and forecasting the expected EBITDA.
The challenge was to forecast the earnings for all the affiliate (14) entities including the entities that were newly acquired. With the limited information available we had to devise a systematic approach to set parameters to forecast the expected values, the critical activity was to stay consistent while also taking into consideration individual adjustments for each entity to ensure the reliability of due diligence adjustments.
We created entity-level FS by leveraging the audited financials of the past two periods as the basis to forecast and calculate the day's sales outstanding (DSO) for each entity. The individual entity values were then carefully consolidated at the holding entity level for further analysis.
As per the discussions with the management, we leveraged the patient encounter information to calculate the forecasted adjustments for each entity. "Revenue Projections," and "Outpatient/ inpatient days/beds" were considered as the base to calculate the change in the revenue and operating expenses.
To understand the potential income to be generated in the future period, we have eliminated the revenue portion from entities that were discontinued in calculating the EBITDA. It was ensured that the NI of newly acquired entities was pro-rated based on the acquisition period. Further, we considered a 2.5% increase each year to account for inflation to reflect the future run-rate of costs and income.
We forecasted accounts receivable (AR), and accounts payable (AP) schedules, along with the list of top five vendors for each period. The reconciliation of the cost of goods sold, operating expenses, and NI was subsequently performed.
Throughout the transition process, we maintained daily communication with the client, providing regular updates on progress, addressing concerns promptly, and soliciting feedback to ensure alignment with their objectives of the transaction.
Ready for stress-free bookkeeping and smarter financial decisions? Connect with your Finkeepers pod now.
Ready for stress-free bookkeeping and
smarter financial
decisions? Connect with
your Finkeepers pod now.
Your form has been successfully submitted.
Our team will get back to you shortly.