soham430299/testing-finmethod

1[
2    {
3      "role": "system",
4      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
5    {
6      "role": "user",
7      "content": "LTM EBITDA Before Adjustments"
8    },
9    {
10      "role": "assistant",
11      "content": "{\"Data needed\": [\"Net Income (or Net Profit / Profit After Tax / Earnings After Tax)\", \"Interest Expense (or Finance Costs)\", \"Income Tax Expense (or Provision for Income Taxes / Tax Expense)\", \"Depreciation & Amortization Expense (may be listed separately as Depreciation Expense and Amortization Expense, or as a combined line)\", \"Operating Profit or Operating Income (if provided separately)\"],\n\"How to solve\": [\"Start with Net Income from the Income Statement.\", \"Add back Interest Expense from the Income Statement (sometimes split across segments).\", \"Add back Income Tax Expense from the Income Statement.\", \"Add back Depreciation & Amortization Expense from the Income Statement (or Cash Flow Statement if listed in cash flows from operating activities).\", \"Sum these to calculate the EBITDA for each period in the last twelve months.\", \"If the company reports quarterly, sum the last four quarters to get LTM EBITDA Before Adjustments.\", \"If the company reports year-to-date (YTD) figures, ensure the YTD covers twelve months. If not, adjust by adding the missing quarter(s) from the prior fiscal year.\"]}"
12      
13    },
14    {
15      "role": "system",
16      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
17    {
18      "role": "user",
19      "content": "Comp EBITDA Adjustments_Transaction Expenses"
20    },
21    {
22      "role": "assistant",
23      "content": "Data needed:\n\n- To calculate NORMAL EBITDA (starting point):\n  - Net income from the Income Statement\n  - Interest expense and interest income from the Income Statement or Notes\n  - Income tax expense from the Income Statement\n  - Depreciation and amortization expense from the Income Statement or Cash Flow Statement\n\n- For Transaction Expenses adjustment:\n  - Detailed expenses related to transactions such as mergers, acquisitions, divestitures, or other corporate deals\n  - These transaction-related expenses may be found in:\n    - Income Statement (often under “Professional fees,” “Advisory fees,” “Legal fees,” or “Transaction expenses” line items)\n    - Notes to financial statements detailing transaction costs\n    - Management discussion & analysis (MD&A) or supplementary schedules\n  - Certificate of Compliance (if applicable) specifying which transaction expenses qualify for EBITDA adjustments\n\nHow to solve:\n\n1. Extract net income, interest, tax, depreciation, and amortization to calculate normal EBITDA:\n   EBITDA = Net Income + Interest Expense + Income Tax Expense + Depreciation + Amortization\n\n2. Identify transaction-related expenses from Income Statement line items and notes.\n3. Verify with Certificate of Compliance which transaction expenses should be added back (adjusted).\n4. Add back qualifying transaction expenses to EBITDA to calculate Compliance Adjusted EBITDA with transaction expense adjustments:\n   Comp EBITDA with Transaction Adjustments = EBITDA + Transaction Expenses"
24  
25    },
26    {
27      "role": "system",
28      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
29    {
30      "role": "user",
31      "content": "Comp EBITDA Adjustments_Cash Expenses"
32    },
33    {
34      "role": "assistant",
35      "content": "Data needed:\n\n- To calculate NORMAL EBITDA (starting point):\n  - Net income from the Income Statement\n  - Interest expense and interest income from the Income Statement or Notes\n  - Income tax expense from the Income Statement\n  - Depreciation and amortization expense from the Income Statement or Cash Flow Statement\n\n- For Cash Expenses adjustment:\n  - Specific cash expenses that are non-recurring or extraordinary and thus adjusted out of EBITDA\n  - These may include items such as restructuring costs, legal settlements paid in cash, one-time cash bonuses, or other unusual cash outflows\n  - Sources for these expenses include:\n    - Income Statement (often under special or non-recurring expenses)\n    - Notes to financial statements with details on cash expenses\n    - Management discussion & analysis (MD&A) or separate adjustment schedules\n  - Certificate of Compliance (if applicable) detailing which cash expenses qualify for adjustment\n\nHow to solve:\n\n1. Extract net income, interest, tax, depreciation, and amortization to calculate normal EBITDA:\n   EBITDA = Net Income + Interest Expense + Income Tax Expense + Depreciation + Amortization\n\n2. Identify qualifying cash expenses from Income Statement line items, notes, or MD&A.\n3. Confirm eligibility of cash expenses for adjustment with Certificate of Compliance.\n4. Add back qualifying cash expenses to EBITDA for compliance adjusted EBITDA:\n   Comp EBITDA with Cash Expense Adjustments = EBITDA + Cash Expenses"
36  
37    },
38    {
39      "role": "system",
40      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
41    {
42      "role": "user",
43      "content": "Comp EBITDA Adjustments_Non-Cash Expenses"
44    },
45    {
46      "role": "assistant",
47      "content": "Data needed:\n\n- To calculate NORMAL EBITDA (starting point):\n  - Net income from the Income Statement\n  - Interest expense and interest income from the Income Statement or Notes\n  - Income tax expense from the Income Statement\n  - Depreciation and amortization expense from the Income Statement or Cash Flow Statement\n\n- For Non-Cash Expenses adjustment:\n  - Non-cash expenses such as stock-based compensation, impairment charges, asset write-downs, or other non-cash items\n  - These items may appear in:\n    - Income Statement (separate line items or included in operating expenses)\n    - Notes to financial statements with details on non-cash charges\n    - Management discussion & analysis (MD&A) or schedules explaining adjustments\n  - Certificate of Compliance (if applicable) specifying which non-cash expenses qualify for EBITDA adjustments\n\nHow to solve:\n\n1. Extract net income, interest, tax, depreciation, and amortization to calculate normal EBITDA:\n   EBITDA = Net Income + Interest Expense + Income Tax Expense + Depreciation + Amortization\n\n2. Identify qualifying non-cash expenses from Income Statement and notes.\n3. Confirm with Certificate of Compliance which non-cash expenses should be added back.\n4. Add back qualifying non-cash expenses to EBITDA for compliance adjusted EBITDA:\n   Comp EBITDA with Non-Cash Expense Adjustments = EBITDA + Non-Cash Expenses"
48  
49    },
50    {
51      "role": "system",
52      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
53    {
54      "role": "user",
55      "content": "Comp EBITDA Adjustments_Proforma Non-Cash"
56    },
57    {
58      "role": "assistant",
59      "content": "Data needed:\n\n- To calculate NORMAL EBITDA (starting point):\n  - Net income from the Income Statement\n  - Interest expense and interest income from the Income Statement or Notes\n  - Income tax expense from the Income Statement\n  - Depreciation and amortization expense from the Income Statement or Cash Flow Statement\n\n- For Proforma Non-Cash adjustment:\n  - Non-cash expenses expected or projected post-transaction, often related to proforma adjustments for acquisitions or restructurings\n  - These may include:\n    - Stock-based compensation related to new equity grants in proforma entities\n    - Amortization of acquired intangible assets (proforma adjustment)\n    - Estimated impairments or write-downs anticipated after the transaction\n  - Sources include:\n    - Proforma financial statements (if available)\n    - Notes and disclosures on proforma adjustments\n    - Management forecasts or MD&A discussion\n  - Certificate of Compliance (if applicable) detailing which proforma non-cash expenses qualify for adjustment\n\nHow to solve:\n\n1. Extract net income, interest, tax, depreciation, and amortization to calculate normal EBITDA:\n   EBITDA = Net Income + Interest Expense + Income Tax Expense + Depreciation + Amortization\n\n2. Identify proforma non-cash expenses from proforma statements, notes, and management forecasts.\n3. Verify with Certificate of Compliance which proforma non-cash expenses should be added back.\n4. Add back qualifying proforma non-cash expenses to EBITDA to calculate compliance adjusted EBITDA:\n   Comp EBITDA with Proforma Non-Cash Adjustments = EBITDA + Proforma Non-Cash Expenses"
60  
61    },
62    {
63      "role": "system",
64      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
65    {
66      "role": "user",
67      "content": "Comp EBITDA Adjustments_Others"
68    },
69    {
70      "role": "assistant",
71      "content": "Data needed:\n- Net income (Income Statement)\n- Interest expense and interest income (Income Statement or Notes)\n- Income tax expense (Income Statement)\n- Depreciation and amortization (Income Statement or Cash Flow Statement)\n- Details and amounts of other adjustments such as restructuring costs, litigation settlements, fines, or any non-recurring expenses (Notes to Financial Statements, MD&A, or Certificate of Compliance)\n- Period markers like LTM, YTD, Prior Year to select correct timeframe (Income Statement headers or notes)\n\nHow to solve:\n1. Calculate normal EBITDA as: Net Income + Interest Expense - Interest Income + Income Tax Expense + Depreciation + Amortization\n2. Identify all other qualifying adjustments from notes or compliance certificates\n3. Add or subtract these “Other” adjustments to/from EBITDA based on their nature to arrive at adjusted EBITDA"
72  
73    },
74    {
75      "role": "system",
76      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
77    {
78      "role": "user",
79      "content": "Comp EBITDA Equity Infusion"
80    },
81    {
82      "role": "assistant",
83      "content": "Data needed:\n- Net income (Income Statement)\n- Interest expense and interest income (Income Statement or Notes)\n- Income tax expense (Income Statement)\n- Depreciation and amortization (Income Statement or Cash Flow Statement)\n- Amount of equity infusion (Balance Sheet - Shareholders' Equity section or Statement of Changes in Equity)\n- Related transaction costs or fees (Income Statement or Notes)\n- Certificate of Compliance confirming qualifying equity infusion adjustments (if applicable)\n- Period indicators like LTM, YTD, Prior Year for timing consistency\n\nHow to solve:\n1. Calculate normal EBITDA as: Net Income + Interest Expense - Interest Income + Income Tax Expense + Depreciation + Amortization\n2. Extract equity infusion amounts and related costs from Balance Sheet and notes\n3. Adjust EBITDA by adding back qualifying transaction costs or fees as per compliance documentation\n4. Ensure all adjustments correspond to the correct period (LTM, YTD, etc.) as indicated    "
84    },
85    {
86      "role": "system",
87      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
88    {
89      "role": "user",
90      "content": "Comp Excess EBITDA Addbacks"
91    },
92    {
93      "role": "assistant",
94      "content": "Data needed:\n- Details of all excess EBITDA addbacks or adjustments disclosed in:\n  - Certificate of Compliance (if applicable)\n  - Notes to Financial Statements\n  - Management Discussion & Analysis (MD&A)\n- LTM or YTD net income or operating income (whichever is available), if addbacks are adjustments to these figures\n- Any supporting schedules detailing the composition of these addbacks (e.g., pro forma adjustments, non-recurring items, transaction expenses)\n- Date range or period of the addbacks (e.g., LTM, YTD, or prior year)\n- Any offsetting adjustments or reversals related to these addbacks\n- Descriptions and amounts of each individual excess addback item (e.g., “one-time legal fees,” “non-operating income adjustments”)\n- Sign-off or attestation in the Certificate of Compliance confirming the addback amounts (if provided)\n\nHow to solve:\n1. Identify the period (LTM, YTD, or prior year) for which excess EBITDA addbacks are calculated.\n2. Extract each addback amount from:\n   - Certificate of Compliance (if provided)\n   - Notes to Financial Statements\n   - MD&A (Management Discussion & Analysis)\n3. Ensure supporting documentation exists for each addback (schedules, footnotes).\n4. Aggregate the individual addbacks to determine the total excess EBITDA addback amount.\n5. Confirm that addbacks align with the definition of “excess” (e.g., above standard EBITDA adjustments) based on the company’s policy or loan agreement.\n6. Reconcile the final addback total to the EBITDA figure reported or disclosed elsewhere, ensuring consistency."
95    },
96    {
97      "role": "system",
98      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
99    {
100      "role": "user",
101      "content": "Comp EBITDA Total Adjustments"
102    },
103    {
104      "role": "assistant",
105      "content": "Data needed:\n- All individual adjustment line items included in the Comp EBITDA total adjustments, such as:\n  - Transaction expenses\n  - Cash expenses\n  - Non-cash expenses\n  - Pro forma non-cash adjustments\n  - Other adjustments\n  - Excess EBITDA addbacks\n- Detailed amounts for each of these adjustments, pulled from:\n  - Certificate of Compliance (if applicable)\n  - Notes to Financial Statements\n  - Management Discussion & Analysis (MD&A)\n- The period covered for these adjustments (e.g., LTM, YTD, or prior year)\n- Supporting schedules or disclosures that provide the composition or breakdown of these adjustments (e.g., schedules in financial statements, footnotes, or explanatory text in MD&A)\n- Any reversals or offsets to adjustments that may reduce the total (e.g., reversals of previously recognized adjustments or credits applied to certain expenses)\n- Confirmation of total adjustments in the Certificate of Compliance, if available\n- Cross-reference to see if these adjustments tie back to other reported figures (e.g., bridging schedules for adjusted EBITDA)\n\nHow to solve:\n1. Identify the reporting period (LTM, YTD, or prior year) that the Comp EBITDA Total Adjustments apply to.\n2. Extract individual adjustment line items from the following sources:\n   - Certificate of Compliance (if applicable)\n   - Notes to Financial Statements\n   - MD&A\n3. Confirm the classification of each adjustment (e.g., transaction expense, non-cash adjustment, pro forma adjustment).\n4. Obtain supporting schedules for each adjustment, ensuring clarity on how the amount was calculated and its nature (e.g., one-time, recurring).\n5. Verify if any adjustments have offsetting reversals that should be accounted for in the final total.\n6. Aggregate the individual adjustments to arrive at the total Comp EBITDA Adjustments figure.\n7. Cross-check and reconcile the final total adjustments figure with reported EBITDA metrics in the same reporting period, ensuring consistency and alignment.\n8. Document the reconciliation and sources for audit and review purposes."
106    },
107    {
108      "role": "system",
109      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
110    {
111      "role": "user",
112      "content": "Compliance Adj EBITDA"
113    },
114    {
115      "role": "assistant",
116      "content": "Data needed:\n- Adjusted EBITDA figure as calculated for compliance purposes, which may be presented in:\n  - Certificate of Compliance (if applicable)\n  - Notes to Financial Statements\n  - MD&A (Management Discussion & Analysis)\n- All individual adjustment line items used to calculate the Compliance Adj EBITDA, such as:\n  - Transaction expenses\n  - Cash expenses\n  - Non-cash expenses\n  - Pro forma adjustments\n  - Other adjustments (including excess EBITDA addbacks)\n- The period to which these adjustments apply (e.g., LTM, YTD, or prior year)\n- Any footnotes or supporting schedules that show how the Compliance Adj EBITDA figure was derived\n- Any offsetting reversals or deductions that reduce the adjustments\n- Evidence of final Compliance Adj EBITDA amount signed off in the Certificate of Compliance (if available)\n- Reconciliation of Compliance Adj EBITDA to reported EBITDA or other profitability measures (if provided)\n\nHow to solve:\n1. Determine the applicable reporting period (LTM, YTD, or prior year) for the Compliance Adj EBITDA.\n2. Extract the individual adjustment line items from:\n   - Certificate of Compliance (if available)\n   - Notes to Financial Statements\n   - MD&A\n3. Gather supporting documentation for each adjustment (e.g., footnotes, schedules, or explanatory text) to confirm their basis and amounts.\n4. Verify any reversals or deductions that may affect the final total of adjustments.\n5. Calculate the Compliance Adj EBITDA by adding/subtracting all these individual adjustments to/from the base EBITDA figure.\n6. Cross-check the final Compliance Adj EBITDA figure against reported metrics to ensure it aligns with the definition used for compliance (e.g., loan agreement covenants).\n7. Document the full calculation path and sources for audit and verification purposes.    "
117    },
118    {
119      "role": "system",
120      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
121    {
122      "role": "user",
123      "content": "YTD Net Revenues"
124    },
125    {
126      "role": "assistant",
127      "content": "Data needed:\n- Net revenues (or net sales) reported for the year-to-date (YTD) period, pulled directly from:\n  - Income Statement\n  - Notes to Financial Statements (if any breakdown or clarification provided)\n- The exact period covered by the YTD net revenues figure (e.g., January 1 to March 31, 2025)\n- Any adjustments or reclassifications made to revenue amounts during the YTD period (e.g., due to accounting policy changes, restatements)\n- If revenue is shown as gross (before returns, discounts, allowances), details of these deductions to arrive at net revenues\n- Supporting schedules or reconciliations (if revenue is reported in segments, ensure that segment revenues tie to the total YTD net revenues)\n\nHow to solve:\n1. Identify the period covered by the YTD net revenues (e.g., from start of fiscal year to end of reporting date).\n2. Locate the YTD net revenues amount on the Income Statement for the relevant period.\n3. If adjustments exist (e.g., returns, discounts, allowances), ensure you subtract them from gross revenues to derive net revenues.\n4. Check footnotes and notes to the financial statements to confirm the calculation and any changes in revenue recognition policies.\n5. Validate the period’s consistency with the YTD definition used in the financials.\n6. Cross-check segment reporting (if applicable) to ensure all segments’ revenues reconcile to the total net revenues.\n7. Document the exact figure and any adjustments or footnotes related to it for use in further calculations or compliance review.    "
128    },
129    {
130      "role": "system",
131      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
132    {
133      "role": "user",
134      "content": "YTD Gross Profit"
135    },
136    {
137      "role": "assistant",
138      "content": "Data needed:\n- Gross profit (or gross margin) reported for the year-to-date (YTD) period, sourced from:\n  - Income Statement\n  - Notes to Financial Statements (if there’s a detailed breakdown)\n- The exact period covered by the YTD gross profit figure (e.g., January 1 to March 31, 2025)\n- Revenue (net or gross) and cost of goods sold (COGS) or direct costs for the YTD period to calculate gross profit if it’s not explicitly reported\n- Any adjustments or reclassifications to COGS or revenue during the YTD period (e.g., inventory adjustments, write-downs, restatements)\n- Supporting schedules or reconciliations (e.g., segment-level reporting) if gross profit is broken out by product line or segment\n- Notes explaining any changes in gross profit calculation or accounting policies (if applicable)\n\nHow to solve:\n1. Determine the period covered by the YTD gross profit figure (e.g., start of fiscal year to end of reporting period).\n2. Locate the gross profit amount on the Income Statement for the YTD period.\n3. If not directly reported, calculate gross profit as:\n   - YTD gross profit = YTD net revenues – YTD cost of goods sold (COGS).\n4. Verify adjustments to revenue or COGS that affect gross profit, such as inventory adjustments, restatements, or accounting policy changes.\n5. Cross-check supporting schedules for any segment-level disclosures to ensure they reconcile with the total YTD gross profit.\n6. Document the gross profit figure and any relevant adjustments or notes for future reference or compliance purposes.    "
139    },
140    {
141      "role": "system",
142      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
143    {
144      "role": "user",
145      "content": "YTD EBITDA Adjustments_Transaction Expenses"
146    },
147    {
148      "role": "assistant",
149      "content": "Data needed:\n- All transaction-related expenses recorded during the year-to-date (YTD) period, which may include:\n  - Advisory fees (legal, consulting, investment banking)\n  - Due diligence costs\n  - Transaction bonuses or commissions\n  - Regulatory and filing fees directly related to transactions\n- These expenses can be found in:\n  - Income Statement (often under operating expenses or separately disclosed)\n  - Notes to Financial Statements (disclosure of transaction expenses)\n  - Certificate of Compliance or Management Discussion & Analysis (MD&A) if transaction expenses are separately identified\n- The exact YTD period these expenses cover (e.g., January 1 to June 30)\n- Any reversals, refunds, or recoveries related to transaction expenses during the period\n- Supporting schedules or breakdowns detailing the composition of transaction expenses\n\nHow to solve:\n1. Identify the YTD period for which transaction expenses are being adjusted.\n2. Extract all transaction-related expense amounts from the Income Statement, Notes, Certificate of Compliance, or MD&A.\n3. Verify the nature of each expense to confirm it qualifies as a transaction expense for EBITDA adjustment purposes.\n4. Check for any reversals or refunds during the YTD period and adjust accordingly.\n5. Sum all qualified transaction expenses to calculate the total YTD EBITDA adjustment for transaction expenses.\n6. Document sources and calculations for audit or compliance review.    "
150    },
151    {
152      "role": "system",
153      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
154    {
155      "role": "user",
156      "content": "YTD EBITDA Adjustments_Cash Expenses"
157    },
158    {
159      "role": "assistant",
160      "content": "Data needed:\n- All cash expenses recorded during the year-to-date (YTD) period that are subject to EBITDA adjustments, such as:\n  - One-time or non-recurring cash costs\n  - Severance payments\n  - Litigation settlements paid in cash\n  - Restructuring cash costs\n  - Other unusual or infrequent cash outflows affecting EBITDA\n- These expenses can be located in:\n  - Income Statement (operating expenses or other expense categories)\n  - Notes to Financial Statements (disclosure of cash expenses)\n  - Certificate of Compliance or MD&A where such adjustments are detailed\n- The exact YTD period covered (e.g., January 1 to June 30)\n- Any reimbursements, recoveries, or offsets related to these cash expenses within the period\n- Supporting schedules or management reports detailing the cash expenses considered for adjustment\n\nHow to solve:\n1. Determine the YTD period applicable for the cash expense adjustments.\n2. Identify and extract all relevant cash expenses from the Income Statement, Notes, Certificate of Compliance, or MD&A.\n3. Confirm the nature of each cash expense to ensure it qualifies as an EBITDA adjustment item (one-time, unusual, non-recurring).\n4. Account for any reimbursements or recoveries during the YTD period and adjust the amounts accordingly.\n5. Sum all qualifying cash expenses to calculate the total YTD EBITDA cash expense adjustment.\n6. Maintain detailed documentation of all amounts, sources, and rationale for audit or compliance purposes.    "
161    },
162    {
163      "role": "system",
164      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
165    {
166      "role": "user",
167      "content": "YTD EBITDA Adjustments_Non-Cash Expenses"
168    },
169    {
170      "role": "assistant",
171      "content": "Data needed:\n- All non-cash expenses recorded during the year-to-date (YTD) period that affect EBITDA adjustments, including but not limited to:\n  - Depreciation and amortization\n  - Stock-based compensation\n  - Asset impairments or write-downs (non-cash portion)\n  - Deferred compensation expenses\n  - Other non-cash charges that are excluded from EBITDA calculations\n- These items can be found in:\n  - Income Statement (usually under operating expenses or separate line items)\n  - Notes to Financial Statements (disclosures on depreciation, amortization, stock comp, impairments)\n  - Certificate of Compliance or MD&A if non-cash adjustments are specifically detailed\n- The exact YTD period applicable (e.g., January 1 to June 30)\n- Any reversals or adjustments to non-cash expenses during the period\n- Supporting schedules or reconciliations breaking down non-cash expenses for the YTD period\n\nHow to solve:\n1. Determine the YTD period for the non-cash expense adjustments.\n2. Identify and extract all relevant non-cash expense amounts from the Income Statement, Notes, Certificate of Compliance, or MD&A.\n3. Confirm the nature of each non-cash expense to ensure it qualifies for EBITDA adjustment (excluded from EBITDA).\n4. Check for any reversals or corrections of non-cash expenses during the period and adjust accordingly.\n5. Sum all qualifying non-cash expenses to calculate the total YTD EBITDA non-cash expense adjustment.\n6. Document all sources, amounts, and rationale for audit and compliance purposes.    "
172    },
173    {
174      "role": "system",
175      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
176    {
177      "role": "user",
178      "content": "YTD EBITDA Adjustments_Proforma Non-Cash"
179    },
180    {
181      "role": "assistant",
182      "content": "Data needed:\n- All pro forma non-cash adjustments recorded during the year-to-date (YTD) period, which typically include:\n  - Non-cash charges or credits adjusted to reflect normalized or adjusted EBITDA\n  - Adjustments for non-recurring non-cash items excluded from pro forma EBITDA\n  - Non-cash expenses related to acquisition accounting (e.g., purchase price allocations)\n  - Stock-based compensation adjusted for pro forma presentation\n- These can be found in:\n  - Pro forma financial statements (often included in MD&A or notes)\n  - Income Statement or Adjusted EBITDA reconciliation schedules\n  - Notes to Financial Statements or Certificate of Compliance if pro forma adjustments are documented\n- The exact YTD period covered (e.g., January 1 to June 30)\n- Any reversals or corrections to pro forma non-cash adjustments within the period\n- Supporting reconciliations detailing the composition of pro forma non-cash adjustments\n\nHow to solve:\n1. Determine the YTD period applicable for pro forma non-cash adjustments.\n2. Identify and extract all relevant pro forma non-cash adjustment amounts from pro forma financials, reconciliation schedules, notes, or compliance certificates.\n3. Confirm that each non-cash item is properly classified as a pro forma adjustment consistent with EBITDA normalization principles.\n4. Check for any reversals, corrections, or updates to these adjustments during the period and adjust accordingly.\n5. Sum all qualifying pro forma non-cash adjustments to calculate the total YTD EBITDA pro forma non-cash adjustment.\n6. Document all amounts, sources, and rationales for transparency and audit purposes.    "
183    },
184    {
185      "role": "system",
186      "content": "Given a calculation, provide the exact RAW DATA-POINTS NEEDED FROM THE FOLLOWING FINANCIAL STATEMENTS: INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT, AND CERTIFICATE OF COMPLIANCE (IF APPLICABLE).\nBe concise, precise, and account for alternate terms used in different statements.\nWatch for key words (LTM, YTD, Prior yr, etc...).\n\nDo NOT assume any calculation is already done. For the “Data needed” section, include every necessary raw data point as well as any basic calculations required to derive the inputs.\n\nFormat your response exactly as below:\n\nData needed:\n\nHow to solve:"  },
187    {
188      "role": "user",
189      "content": "YTD EBITDA Adjustments_Others"
190    },
191    {
192      "role": "assistant",
193      "content": "Data needed:\n- Any other EBITDA adjustment items recorded during the year-to-date (YTD) period not covered by transaction, cash, non-cash, or pro forma categories, which may include:\n  - Unusual or infrequent expenses or income adjustments\n  - Restructuring expenses not classified under cash or transaction categories\n  - Legal settlements or claims (non-transactional)\n  - Foreign exchange gains or losses impacting EBITDA\n  - Management fees or related party adjustments\n- These items may be found in:\n  - Income Statement (various expense or income line items)\n  - Notes to Financial Statements (disclosure of unusual or special items)\n  - Certificate of Compliance, MD&A, or other management disclosures\n- The exact YTD period these items cover (e.g., January 1 to June 30)\n- Any reversals, corrections, or reclassifications affecting these adjustments during the period\n- Supporting details or schedules outlining the composition and justification of these other adjustments\n\nHow to solve:\n1. Determine the YTD period for which other EBITDA adjustments apply.\n2. Identify and extract all relevant “other” adjustment items from the Income Statement, Notes, Certificate of Compliance, MD&A, or management reports.\n3. Verify the nature of each item to confirm its appropriateness for EBITDA adjustment and classification as “other.”\n4. Check for any reversals, corrections, or reclassifications during the period and adjust accordingly.\n5. Aggregate all qualifying “other” adjustments to determine the total YTD EBITDA other adjustments.\n6. Document all sources, amounts, and rationale for compliance and audit purposes.    "
194    }
195  ]