Question
Questions: 1) Please bridge ADSs 12/31/2019 Cash EBITDA before Q of E adjustments (reported cash EBITDA) to 12/31/2109 Cash EBITDA after Q of E adjustments
Questions:
1) Please bridge ADSs 12/31/2019 Cash EBITDA before Q of E adjustments (reported cash EBITDA) to 12/31/2109 Cash EBITDA after Q of E adjustments (adjusted cash EBITDA). List every adjustment in this bridge.
2) Please bridge Maebes original calculation of net debt in 12/31/2019 to her post KMPG due diligence calculation of 12/31/2019 net debt, assuming, among other things, that she had originally treated deferred revenue as a DLI, but will now treat it as a working capital item.
3)Calculate the pre and post money equity valuation and the enterprise value for ADS before and after the adjustments, assuming that DCP still intends to invest $65 million at a TEV of 10x FYE 12/31/2019 adjusted cash EBITDA. What % of ADSs fully diluted shares outstanding would DCPs preferred stock be convertible into before and after the adjustments?
Please show the calculations you do on the excel file with commentary.
Maebe Funke, partner at the VC \& Growth PE firm of Divaaliya Capital Partners (DCP), looked out her office window at 3000 Sand Hill Road, wondering why so many business school cases started by having the protagonist looking out her office window. After pondering this subject, she turned her attention to her firm's potential investment in AD Systems ("ADS"), a successful yet relatively small provider of hosted HR management software services using the SaaS model. The company had been founded by George and Lucille Bluth in 2012. The two had divorced after George was convicted of fifty-seven counts of fraud, and Lucille had since been the CEO of the business. A month ago, DCP had been granted a 30-day exclusivity period to perform financial due diligence on AD Systems and had hired KPMG to perform the analysis. The exclusivity period had been granted based on the term sheet provided by DCP which stipulated that DCP would make a $65 million investment in ADS in exchange for newly issued convertible preferred shares. The parties had agreed on an enterprise value for ADS of 10x FYE 12/31/2019 expected cash EBITDA (a common non-GAAP metric in SaaS businesses). When calculating ADS's equity value and therefore the \% ownership in ADS to be acquired for the $6 million, DCP had stipulated that the deferred revenue liability would be treated as a debt-like item and that the FYE 12/31/2019 expected cash EBITDA would be adjusted pursuant to a quality of earnings analysis. Among other items, Divaaliya had been provided with historical financial statements for FYE 12/31/2017 and 2018 as well as expected FYE 12/31/2019 financial statements. Since then, Lucille Bluth had hired Joffrey's, a leading tech investment banking firm, to advise her. Joffrey's had insisted that it was market practice to treat deferred revenue as working capital rather than a debt-like item. Lucille now refused to move forward with the deal unless DCP made the corresponding adjustment to equity value. Additionally, KPMG had completed its work and surfaced several relevant issues: - The company had briefly entered the frozen banana business after taking over a bankrupt frozen banana stand in 2013. It sold this business on March 31, 2019, booking a profit of $7 million on the sale, which it reported as revenue in 2019. Frozen Banana had been generating $0.5 million of monthly cash EBITDA since ADS acquired it in 2016. - ADS was on the verge of acquiring a software consulting business, Software Consulting Business. It expected closing to take place on September 30, 2019 and had included this business in the FYE 12/31/2019 expected financial statements for the period of ownership. Software Consulting Business had generated $0.45 million of monthly cash EBITDA throughout FY 2019 and was expected to continue doing so for the foreseeable future. - In relation to the above acquisition, ADS expected to incur a restructuring expense of $2 million at closing, which the company and KPMG consider non-recurring. ADS had included this item as an operating expense in its Expected FY 2019 income statement and provided for it as a liability on its expected 12/31/2019 balance sheet. However, Maebe had neglected to identify this as a debt-like item in her pre Q of E valuation. The restructuring payments were expected to be made in 2020. - ADS had performed a consulting assignment regarding the implementation of certain software services on behalf of the Venezuelan government. This assignment was a one-time project which contributed $3.3 million to ADS's cash EBITDA in 2019. Related to this contract, ADS now had $3.5 million in cash in a Venezuelan bank account, which it was unable to repatriate and should therefore be considered trapped or restricted. - Lucille's four adult children had been drawing an aggregate of $4 million annually from the business, which the company had reported as an operating expense. Fortunately, these four were no longer involved in the business. DCP's term sheet had stipulated that any payments to family members not involved in the business would be discontinued at closing. However, under their employment contracts, Lucille's children were entitled to an aggregate $2 million severance payment in the event of a sale of the company. In addition, DCP's law firm, Over \& Billings, believe that an ongoing patent dispute relating to ADS's use of a competitor's technology was likely to be adjudicated against ADS. Their expected value for the settlement was $2.5 million which, in their view, would be paid sometime in 2021. No provision had been made for this in the ADS's financial statements. Finally, DCP's environmental consultant had found buried frozen banana waste on the company's owned headquarters which was threatening to leak into the water table. It estimated that the cost of cleaning the site would be $1 million. There was no provision for this in the company's financial statements. Funke needed to re-calculate the valuation based on the above and decide whether to move forward despite Bluth's demand that deferred revenue not be treated as debt. Exhibit 1: AD Systems Reported Financial Statements (non-GAAP) Cash EBITDA Cash Flow Statement (In millions unless stated) Net Income Depreciation Amortization Changes in Working Capital Restructuring Expense Addback of PIK Interest Cash Flow from Operations Changes in Long-Term Assets Capital Expenditures \begin{tabular}{l|l|l|} \hline2017 & 2018 & E2019 \\ \hline 52.2 & 57.3 & 73.6 \\ \hline \end{tabular} Acquisitions Dividends Cash Flow Available For Debt Repayment New Debt/(Debt Repayment) Net Free Cash Flow \begin{tabular}{|r|r|r|} \hline2017 & 2018 & E2019 \\ \hline 11.6 & 21.9 & 34.8 \\ \hline 15.7 & 15.5 & 15.0 \\ \hline 19.3 & 20.3 & 22.7 \\ \hline 22.5 & 10.5 & 11.2 \\ \hline & & 2.0 \\ \hline & & \\ \hline 69.0 & 68.2 & 85.8 \\ \hline \end{tabular} Balance Sheet (In millions unless stated) \begin{tabular}{|c|c|r|} \hline(19.7) & (21.1) & (25.1) \\ \hline(9.8) & (12.0) & (13.6) \\ \hline & & (4.2) \\ \hline 14.1) & (17.7) & (12.2) \\ \hline 35.4 & 27.4 & 30.7 \\ \hline \end{tabular} Assets Cash Accounts Receivable Current Assets Gross PP\&E Accumulated Depreciation PP\&E, Net \begin{tabular}{l|l|l} \hline111.0) & (12.0) & 115.3) \\ \hline24.4 & 15.4 & 15.3 \\ \hline \end{tabular} Deferred Commissions Accumulated Amortization Deferred Commissions, Net 20172018 Goodwill Total Assets \begin{tabular}{rrr} & = & 3.4 \\ 142.9 & 158.9 & 183.3 \\ \hline \end{tabular} Liabilities \& Shareholder's Equity Accounts Payable Accured Expenses Taxes Payable Deferred Revenue Current Liabilities Other Liabilities Long-Term Debt Total Liabilities Shareholder's Equity Paid-In-Capital Retained Earnings Total Shareholder's Equity Total Shareholder's Equity \& Liabilities \begin{tabular}{|r|r|r|} \hline 15.7 & 15.7 & 15.7 \\ \hline7.8 & 22.1 & 44.7 \\ \hline23.6 & 37.8 & 60.5 \\ \hline 142.9 & 158.9 & 183.3 \\ \hline \end{tabular} Maebe Funke, partner at the VC \& Growth PE firm of Divaaliya Capital Partners (DCP), looked out her office window at 3000 Sand Hill Road, wondering why so many business school cases started by having the protagonist looking out her office window. After pondering this subject, she turned her attention to her firm's potential investment in AD Systems ("ADS"), a successful yet relatively small provider of hosted HR management software services using the SaaS model. The company had been founded by George and Lucille Bluth in 2012. The two had divorced after George was convicted of fifty-seven counts of fraud, and Lucille had since been the CEO of the business. A month ago, DCP had been granted a 30-day exclusivity period to perform financial due diligence on AD Systems and had hired KPMG to perform the analysis. The exclusivity period had been granted based on the term sheet provided by DCP which stipulated that DCP would make a $65 million investment in ADS in exchange for newly issued convertible preferred shares. The parties had agreed on an enterprise value for ADS of 10x FYE 12/31/2019 expected cash EBITDA (a common non-GAAP metric in SaaS businesses). When calculating ADS's equity value and therefore the \% ownership in ADS to be acquired for the $6 million, DCP had stipulated that the deferred revenue liability would be treated as a debt-like item and that the FYE 12/31/2019 expected cash EBITDA would be adjusted pursuant to a quality of earnings analysis. Among other items, Divaaliya had been provided with historical financial statements for FYE 12/31/2017 and 2018 as well as expected FYE 12/31/2019 financial statements. Since then, Lucille Bluth had hired Joffrey's, a leading tech investment banking firm, to advise her. Joffrey's had insisted that it was market practice to treat deferred revenue as working capital rather than a debt-like item. Lucille now refused to move forward with the deal unless DCP made the corresponding adjustment to equity value. Additionally, KPMG had completed its work and surfaced several relevant issues: - The company had briefly entered the frozen banana business after taking over a bankrupt frozen banana stand in 2013. It sold this business on March 31, 2019, booking a profit of $7 million on the sale, which it reported as revenue in 2019. Frozen Banana had been generating $0.5 million of monthly cash EBITDA since ADS acquired it in 2016. - ADS was on the verge of acquiring a software consulting business, Software Consulting Business. It expected closing to take place on September 30, 2019 and had included this business in the FYE 12/31/2019 expected financial statements for the period of ownership. Software Consulting Business had generated $0.45 million of monthly cash EBITDA throughout FY 2019 and was expected to continue doing so for the foreseeable future. - In relation to the above acquisition, ADS expected to incur a restructuring expense of $2 million at closing, which the company and KPMG consider non-recurring. ADS had included this item as an operating expense in its Expected FY 2019 income statement and provided for it as a liability on its expected 12/31/2019 balance sheet. However, Maebe had neglected to identify this as a debt-like item in her pre Q of E valuation. The restructuring payments were expected to be made in 2020. - ADS had performed a consulting assignment regarding the implementation of certain software services on behalf of the Venezuelan government. This assignment was a one-time project which contributed $3.3 million to ADS's cash EBITDA in 2019. Related to this contract, ADS now had $3.5 million in cash in a Venezuelan bank account, which it was unable to repatriate and should therefore be considered trapped or restricted. - Lucille's four adult children had been drawing an aggregate of $4 million annually from the business, which the company had reported as an operating expense. Fortunately, these four were no longer involved in the business. DCP's term sheet had stipulated that any payments to family members not involved in the business would be discontinued at closing. However, under their employment contracts, Lucille's children were entitled to an aggregate $2 million severance payment in the event of a sale of the company. In addition, DCP's law firm, Over \& Billings, believe that an ongoing patent dispute relating to ADS's use of a competitor's technology was likely to be adjudicated against ADS. Their expected value for the settlement was $2.5 million which, in their view, would be paid sometime in 2021. No provision had been made for this in the ADS's financial statements. Finally, DCP's environmental consultant had found buried frozen banana waste on the company's owned headquarters which was threatening to leak into the water table. It estimated that the cost of cleaning the site would be $1 million. There was no provision for this in the company's financial statements. Funke needed to re-calculate the valuation based on the above and decide whether to move forward despite Bluth's demand that deferred revenue not be treated as debt. Exhibit 1: AD Systems Reported Financial Statements (non-GAAP) Cash EBITDA Cash Flow Statement (In millions unless stated) Net Income Depreciation Amortization Changes in Working Capital Restructuring Expense Addback of PIK Interest Cash Flow from Operations Changes in Long-Term Assets Capital Expenditures \begin{tabular}{l|l|l|} \hline2017 & 2018 & E2019 \\ \hline 52.2 & 57.3 & 73.6 \\ \hline \end{tabular} Acquisitions Dividends Cash Flow Available For Debt Repayment New Debt/(Debt Repayment) Net Free Cash Flow \begin{tabular}{|r|r|r|} \hline2017 & 2018 & E2019 \\ \hline 11.6 & 21.9 & 34.8 \\ \hline 15.7 & 15.5 & 15.0 \\ \hline 19.3 & 20.3 & 22.7 \\ \hline 22.5 & 10.5 & 11.2 \\ \hline & & 2.0 \\ \hline & & \\ \hline 69.0 & 68.2 & 85.8 \\ \hline \end{tabular} Balance Sheet (In millions unless stated) \begin{tabular}{|c|c|r|} \hline(19.7) & (21.1) & (25.1) \\ \hline(9.8) & (12.0) & (13.6) \\ \hline & & (4.2) \\ \hline 14.1) & (17.7) & (12.2) \\ \hline 35.4 & 27.4 & 30.7 \\ \hline \end{tabular} Assets Cash Accounts Receivable Current Assets Gross PP\&E Accumulated Depreciation PP\&E, Net \begin{tabular}{l|l|l} \hline111.0) & (12.0) & 115.3) \\ \hline24.4 & 15.4 & 15.3 \\ \hline \end{tabular} Deferred Commissions Accumulated Amortization Deferred Commissions, Net 20172018 Goodwill Total Assets \begin{tabular}{rrr} & = & 3.4 \\ 142.9 & 158.9 & 183.3 \\ \hline \end{tabular} Liabilities \& Shareholder's Equity Accounts Payable Accured Expenses Taxes Payable Deferred Revenue Current Liabilities Other Liabilities Long-Term Debt Total Liabilities Shareholder's Equity Paid-In-Capital Retained Earnings Total Shareholder's Equity Total Shareholder's Equity \& Liabilities \begin{tabular}{|r|r|r|} \hline 15.7 & 15.7 & 15.7 \\ \hline7.8 & 22.1 & 44.7 \\ \hline23.6 & 37.8 & 60.5 \\ \hline 142.9 & 158.9 & 183.3 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started