AI Agents for Tax Due Diligence

Update the base-case DCF model of KVUE with U.S. total equity risk premium of 4.33%, the risk free rate with the 5-Year Treasury rate and the KVUE Close share price on 2025-12-15. Let's measure the impact of an increase in tax rate by 4 percentage points (apply to 2025E-2029E and the WACC tax shield) and the decrease in terminal growth rate by 0.25 percentage points. Reply back to me, giving the updated enterprise value, equity value and implied share price, rounded to two decimal places. Express enterprise value and equity value in millions.

Calculate the unlevered beta for Haleon (HLN) using Total Debt and Market Capitalization as of the end of FY2024. Assume 0.227 levered beta for HLN and a 21% Tax rate. Using the unlevered beta for HLN computed above, and the debt and equity values in the model, re-leverage the Beta for Kenvue and update the WACC with the new Re-levered Beta. Reply back with a message, giving the following results: - the New WACC - the New Implied Share Price. - the Variance in $ for Share Price (New-Original) Round all outputs to two decimal places.

Update the DCF model with the following changes - tax rate for the entire projection period (2025E-2029E) and the WACC build is now the implied tax rate from the second quarter of 2023, calculated as income tax expense over revenue, plus 10% - update beta to 1 - assume revenue growth rate in the projection period matches that of 2024A plus 75 basis points. - update terminal growth rate to be equal to the updated monthly revenue growth rate plus 50 basis points - assume final gross debt is increased by 50% and cash balance is now 10% of the absolute increased gross debt number What is equity value in millions rounded to the nearest whole number? Print your answer back to me as a short message.

Take the average close price for KVUE for the week of 12/15/2025 to 12/19/2025, apply a 10% premium, and input that figure in the DCF model. Re-calculate both the 1) cost of equity and 2) after-tax cost of debt. Output your answer as a reply here, rounded to two decimal points.

Replace the risk-free rate in the DCF model with the average of the 10 year and 20 year treasury rates as of 12/22/2025, and assume that the cost of debt is this average value plus 150 basis points. Finally, assume that the tax rate is revised up by 50 basis points for the projection period. What is the absolute difference in terminal value in the original calculation and this updated one? Output your result as a reply here, with millions rounded to two decimal places.

Using the REIT model, consider the following assumptions for the projected period between 2025 to 2029: 1) Assume the revenue growth for its service business equivalent to the overall company revenue growth 2) Assume that the EBITDA margin for the service business is 5 percentage points higher than the company EBITDA margin during the same forecast period 3) Assume depreciation equivalent to 2% of the annual revenues 4) Assume capex equal to 3% of the annual revenue 5) Assume investment in working capital equal to 1.5% of the annual revenue 6) Assume the effective tax rate is equal to 21% 7) Assume that the spin-off is done on a debt free, cash free basis 8) Assume the valuation date as of December 31, 2024 9) Assume a cost of equity of 12% and a terminal growth rate of 1% post the projected period. Compute the levered free cash flows and the implied equity value of its service business. Round all the values up to two decimals: - Cumulative Levered Free Cash Flows (2025 - 2029) - Terminal Value - Equity Value of the service business Reply here.

Perform a DCF analysis for Golden Everest using the REIT model with the following parameters: - Hold EBITDA margin constant at 42% throughout the projection period - Hold Capex % of Revenue constant at 22% throughout the projection period - Assume a WACC of 9% - Assume Terminal Value is equal to 11 times final projection year EBITDA - Assume Net Debt is as given for 2024A - End-of-year discounting (not mid-year convention) Give me your reply showing the Golden Everest Equity Value in $ millions, rounded to the nearest million.

Using the REIT model re-calculate the Implied REIT Price Per Share using the the 25th Percentile EV/EBITDA and 2025E Revenue Growth percentage of 5%. Return to me right here the price in $ for the same case used in the Executive Summary tab. Round to 2 decimal points.

Forecast operational expenses are impacted by a rising inflation of 2% in the REIT model. The increase is able to be passed on only for Services revenues. Assume the proportion of operating expenses deriving from Service revenue is equal to its proportion of total revenue in 2024. Calculate the inflation-adjusted enterprise value and target share price in 2025 for Golden Everest based on REIT industry capitalization rate of 5.5%. Print the answer here. Present monetary values in $ million rounded to nearest whole number, and share prices in $ to 2 decimal places.

Calculate which data center company in the peer group has generated the strongest revenue growth, and highest Adjusted EBITDA margins over 2022-2024. 1. Only analyze the period of 2022-2024 2. Rank each company in the peer group on their revenue growth from 2021-2024 (CAGR) 3. Rank each company in the peer group on their EBITDA margin 4. The company with the highest average ranking of the two metrics is considered the strongest, if there is a tie, the company with the largest increase in EBITDA margin (absolute percentage point increase from 2022 to 2024) is considered stronger 5. Adjusted EBITDA should be calculated by taking net income and adding back income taxes, interest expense, depreciation and amortization 6. Three companies should be analyzed: American Tower, Equinix, Digital Realty 7. For American Tower, only utilize financials from the data center portion of the business from 2022-2024 for calculations Tell me the strongest company; and return the averages of all the companies for: 1. annualized revenue growth, 2. average Adjusted EBITDA Margin, and 3. adjusted EBITDA margin increase. All percentages should be rounded to 2 decimal places. Print the answer here.

In the existing sheet for the REIT model, create a sensitivity table for 2029E Net Income. Show Revenue Growth Step-up at 50 basis points and 100 basis points. Show EBITDA Margin Step-up at 20 basis points and 40 basis points. Round all final numbers to the nearest million. To calculate the correct values, assume that revenue growth in 2025E starts at 8.0% and increases by the same amount every year of the projection period, referred to as the "Revenue Growth Step-up". Assume that EBITDA Margin % starts at 44.0% and increases by the same amount every year of the projection period, referred to as the "EBITDA Margin Step-up".

Using the 'Projections (C-Corp)' tab in Golden_Everest_REIT_Analysis compute the Net Income for 2029E given the following scenario: - Assume tax rates are 15.0% for 2025E through 2029E - If net income exceeds $1,300M in a given year, update the revenue growth % for all subsequent years. - Use the average of the growth rates shown on the "Projected Financials" slide in the Project_Titan_Presentation v3.pptx file. Compare the 2029E Net Income computed for the above scenario to the original 2029E Net Income by providing each Net Income figure and their dollar difference. Present in $M and round to nearest whole number. Write back your answers as a message.

Calculate the price per share that a strategic buyer would need to offer for Golden Everest to consider an acquisition instead of a REIT conversion. Reply to me here with the minimum required share price. Round all final numbers to two decimal places. I want the 2027 expected share price discounted to 11/21/2025 (18 months) for “C-Corp Low”, “C-Corp Mid”, “C-Corp High”, “REIT Low”, “REIT Mid”, and “REIT High”. Assumptions: 1. It will take 18 months post REIT conversion for the stock to appreciate to fair value, assuming mid-2027 for this process to complete. 2. The discount rate is 4%. 3. Use the low, mid, and high multiples found in the model. 4. Assume the price needed to consider the acquisition is 10% above the valuation for the REIT using the mid multiple. 5. Reference 2025E EV/EBITDA multiples for C-Corp and REIT conversion, and pull 2027E EBITDA values from the model.

Calculate Unlevered Free Cash Flow in 2025E, 2026E, 2027E, 2028E and 2029E. In the Golden Everest Financial Model, there is an error in the unlevered free cash flow build in the Projections, "Projections (C-Corp)", tab. Please use the correct formula to calculate Unlevered Free Cash Flow based on the Projections. Additionally, use the following assumptions: - Change in Working Capital: -1.0% of Revenues between 2025E and 2029E - D&A: 11.50% of Revenues in 2025E and 12.0% of Revenues from 2026E through 2029E - Capex: 24.0% of Revenues in 2025E, 22.0% of Revenues in 2026E, 21.0% of Revenues in 2027E, and 20% of Revenues in 2028E and 2029E Round output financial figures to 2 decimal points. $ must be in millions. Give me your response as a reply right here.

Model out the NPV of distributions shareholders would receive under REIT conversion. - There's the $1.2 billion E&P purge that gets taxed as ordinary income at 37% (E&P purge occurs at Year 0, annual distributions occur at end of Years 1–5). - There are ongoing REIT dividends in the $650-750mm range that qualify for the 20% Section 199A deduction. - Apply 199A only to annual REIT distributions; do not apply 199A to the E&P purge (tax purge at 37%). - Run sensitivities across 10%, and 12% discount rates over a 5-year horizon. Show discount rates vs distribution levels, populated with respective after-tax NPV per share. Then, show me the base case NPV as a percentage of both the strategic offer and current trading price. Round NPV per share to 2 decimal places. Round percentages to 1 decimal place. Create an xlsx that has all of your results.

Golden Everest's management team plans to issue a 10-year debenture of $3,000 million at an interest rate of 5% at the end of 2025E. Use the REIT model to model Golden Everest's year-end cash balances in 2025E, 2026E, and 2027E under C-Corp, no change in the dividend policy with the debenture. Additionally, model Golden Everest's year-end cash balances in 2025E, 2026E, and 2027E under the REIT structure and with the debenture. Assume under the REIT structure, management decides to distribute 92.5% of net income as a dividend. Write a message to me, explaining the following: - Golden Everest's year-end cash balances in 2025E, 2026E, and 2027E under C-corp structure. - Golden Everest's year-end cash balances in 2025E, 2026E, and 2027E under REIT structure. Present monetary values in $ million rounded to nearest whole number.

Calculate the weighted average cost of capital (WACC) for Golden Everest. Write back your reply, accounting for the following: - Utilize the REIT structure mid case scenario for 2025E in the model. - Presume the REIT pays 90% of its taxable income. - Use the REIT's net debt level, instead of gross debt for WACC calculations, and presume the interest rate stays the same as the C-corp. - The corporate tax rate is 15% for both C-corp and REIT. - State the weighted average cost of capital as a percentage, round to 2 decimal places.

Using the REIT model, recalculate the fair value of Golden Everest with C-Corp status using a three-stage unlevered DCF. For Stage 1, use the unlevered cash flows from 2025E to 2029E on the “Projections (C-Corp)” tab. Assume the valuation date is December 1, 2025 and use the midyear adjustment approach for Stage 1, which assumes CFs are generated halfway through each period rather than at period-end for any partial periods. For Stage 2, grow unlevered FCF at a 5% annual pace for 12 years until 2041). For stage 3, use a perpetuity growth rate of 1%. Assume WACC is 11%. For present value calculations, use a 365 day count. Get me back (1) present value of stage 1 cash flows; (2) present value of stage 2 cash flows; (3) present value of terminal value; and (4) equity value per share. State all values in millions and rounded to the nearest whole number, except equity value per share, which you should show in dollars and cents. Print your reply here.

Edit the Valuation Summary tab of the REIT model, showing the implied upside/downside percentage for the Mid case of Scenario 1: Current Valuation. - EV/EBITDA multiple: use 50% and 55% of the average multiple for Data Center REITs on the Comparable Companies tab, excluding the highest and lowest companies by market cap. - Current trading price: two columns as 10% and 20% higher than the Strategic Offer share price. Assume revenue growth % is now 9% and EBITDA Margin % is now 41% for the entirety of the projection period and use 2029E EBITDA instead of 2025E EBITDA in the Mid case of Scenario 1: Current Valuation. Round to the nearest two decimal points.

I want the Output Levered FCF for 2029E, rounded to the nearest million. - Revenue growth: starts at 7.0% and increases by 0.5% per year in the projection period - EBITDA margin %: starts at 44.0% and increases by 0.1% per year in the projection period - Capex % of revenue: starts at 23.0% and decreases by 0.5% per year in the projection period - Tax rate: 20.0% every year of the projection period Use the Projections (C-Corp) tab in the REIT model. Give me the answer right back here.

Using the information in the REIT model, create a new sheet: - Re-run the Scenario3: REIT Conversion analysis in sheet "Valuation Summary" using FFO multiples in place of the current EBITDA multiples - Run a low case using Iron Mountain's FFO multiple - Run a High case using Digital Realty's FFO multiple Tell me this info for Low and High cases: - REIT Equity Value ($mm) - Implied REIT Price Per Share - Premium to Current Share price of $42.50 as of 11/21/25 Calculate Golden Everest's 2025E FFO metric by using Digital Realty's implied FFO value (from the information within the "Comparable Companies" tab ) as % of LQA Adjusted EBITDA for the period QE 3/31/2023 within the investor presentation Format all outputs as follows: - Round all dollar figures to 1 decimal place in millions ($m) and express in "$X.X" format - Round all percentages to 1 decimal place - Share price should be to two decimal places

For each year, calculate Levered FCF less Dividends Paid. Assuming a 9% discount rate, output the net present value (NPV) of Levered FCF less Dividends Paid over the projection period, rounded to a full million. Refer to REIT model and adjust Golden Everest Base Case Projections (C-Corp Status) as follows: - Hold Capex % of Revenue constant at 22% over the projection period - Assume Dividend per Share is fixed at 1.60 in 2025E, increasing 0.40 per year over the projection period. Print your answer to me here via a short message.

Using the REIT model, assess the downside REIT scenario for Golden Everest if data center REIT multiples compress 30% during a longer than expected conversion period of 12 months. Reply to me in here with a message which states the expected price in 12 months of Golden Everest in this downside scenario and the expected total return of the stock over that period. Round all numbers to 2 decimal points. Assumptions: 1. Stock price will be calculated off of 2026 expected earnings 2. Dividends are not re-invested 3. Only half of the REIT premium (post-compression) vs C-Corps will be realized over the 12 months 4. No change in net debt

Planet Fitness is looking to divest its entire 281 stores, which it owns as of September 30, 2025, to a franchise owner. Round all results to two decimal places and present it in $mm. Using the LBO model, perform a DCF analysis for the company as per the base case scenario for the projected cash flows for the 281 stores, and assume the following: 1) Assume that the average revenue per store increases by 5% YoY for every quarter from Q4 2025 through the end of 2030 2) Assume EBITDA margin for the business remains at 39% every quarter from Q4 2025 through the end of 2030 2) Assume that the effective tax rate is 20% 3) Assume that the depreciation rate is 5% of the revenue 4) Assume that maintenance capex is 2% of sales and there is no growth capex 5) Assume a discount rate of 12% and terminal growth rate of 2% 6) Do the enterprise valuation as of December 31, 2025 Print here the FCFF for 2026 to 2030. Also give the Enterprise Value of the corporate-owned store business

Planet Fitness is considering the acquisition of 100% stake in The Gym Group and taking it private in order to expand its presence within the UK. Using GYM H1 2025 and GYM annual 2024 docs, consider the following assumptions: 1) Assume the full year 2025 revenue equal to LTM revenue June 2025 2) Assume the full year 2025 Group Adjusted EBITDA less normalized rent equal to LTM Group Adjusted EBITDA less normalized rent June 2025. 3) Assume the annual revenue growth is 3% for all years going forward beginning January 1, 2026 4) Assume the annual margin expansion going forward beginning January 1, 2026 is 50 bps 5) Assume that GBP/USD exchange rate is equal to 1.31 as of December 31, 2025 and GBP will appreciate 2% every year beginning January 1, 2026 6) Assume that Depreciation and Amortization is 5% of the revenue and the existing debt at the end of June 30, 2025 is refinanced at a rate of 3.00% for an amortization term of 5 years based on equal payments. For interest expense computation, consider it based on the opening balance. 7) Assume that there is no other operating income or expenses and effective tax rate is 10%. 8) Assume there's no capex or change in NWC during the projection period. 9) Assume the 100% acquisition in The Gym Group is announced at 11x EV/ 2025 Group Adjusted EBITDA less normalized rent on December 31, 2025. 10) Assume the net debt as of June 30, 2025. 11) Assume that The Gym Group provides dividends to the parent on December 30 every year to a maximum of its Profit after tax. 12) Assume that the exit multiple at the end of December 31, 2030 is 12x EV / 2025 Group Adjusted EBITDA less normalized rent. 13) Assume that there is no interest income on cash during the projection period and no cash balance at the end of December 31, 2030. Return for me a message with the Equity Value for 100% stake purchase of The Gym Group. Also give me the 2026 to 2030 dividends, and the IRR for Planet Fitness (post FX conversion). In your answer, round the percentages and the millions to two decimal places.

Using the LBO analysis, conduct a Purchase Price Allocation to show the amount of pro-forma goodwill created from this transaction. Also show the allocable purchase premium. Round all monetary values to the nearest million. Write back the results as a message to me in here. # Assumptions - Balance sheet figures sourced from the "Balance Sheet" tab, using FY25E data (as of Q425) - Intangible Assets Write Up: Intangible asset allocation %: 10.0%. Useful life assumption: 15 years - PP&E Write Up: PP&E write up %: 10.0%. Useful life assumption: 8 years - Tax rate of 25%

We need to review Summit's historical distributions. Write me a memo analyzing whether Summit's shareholder distributions are in accordance with US tax code. Cite the exact tax code in each instance (short citations are acceptable). Reply to me right in here please.

Review the due diligence file relative to the S-Corp election of Summit Filing Solutions. Determine whether the S-Corporation election was timely made, the date on which it became effective, and any risks arising from the late election. Draft a short memo with your conclusions and include an evaluation of any reasonable cause statement provided for any untimely filing. Send back your memo in a new DOCX file that you create from scratch.

Summit Filing Solutions, Inc. bought a building in 2018 for $350k. It spent $250k on the buildout. It sold the building on June 20, 2022 for $1.2M. Review the diligence memo and current cap table. State the amount Laura Kensington owed in federal income taxes attributable to this transaction if her taxable income was $220k in 2022 (assuming no other deductions or credits, or any retroactive changes to the tax treatment). Write me a message, and give the exact dollar amount.

We have been asked to determine whether the S-corporation election of Summit Filing Solutions, Inc. ("Summit"), which Summit claims was effective on 1/1/19, was terminated. Please analyze Summit's Shareholder Agreement, Summit's Income Schedule, and the Office Lease Agreement between Summit and Anderson Instruments. Please disregard issues arising under 26 U.S.C. sec. 1361(b)(1). Please prepare a concise memorandum in a new DOCX file you make, briefly explaining your conclusions and citing to appropriate authority.

Review the due diligence file for Summit Filing Solutions, Inc. and identify any potential deficiencies relative to its claimed status as an S-Corporation. Draft a set of indemnities, for incorporation into the Harbor Bridge share purchase agreement, covering the claimed S-Corporation status and specifically referencing any potential deficiencies in the file relative to that status. Reply back to me here, outlining what you find.

Revise the Stock Purchase Agreement. I want you to edit the existing file. I want you to protect the Buyer given a potential $399,540 tax exposure tied to Summit’s potentially invalid S-Corp election. Update the agreement to include strong seller reps, warranties, covenants, and indemnities to protect the buyer, as well as tax-related pre-closing and post-closing obligations so that any liabilities associated with the S-Corporation issue are borne by the Sellers.

Summit filed Form 2553 (Rev B) with the Internal Revenue Service ("IRS") on February 19, 2019. Do you see any potential problems under Treasury Regulation 1.1362-6(b)? Give me your analysis back here so I can decide what to do.

Harbor Bridge has recently expressed concern that certain provisions of Summit's Amended and Restated Shareholder Agreement may be inconsistent with Summit's S-Corp election under 26 U.S.C. § 1361 and 26 C.F.R. § 1.1361-1(l). Please examine the shareholder agreement and draft a concise amendment to the agreement to correct any potential deficiencies which may invalidate Summit's S-Corp election. Put everything in a new docx file.

Review Summit's records to determine how Summit can correct any potential questions about the validity of its S corporation tax election. Write a tax memo and put it in a New document (docx) for me to review later.

As you know, Harbor Bridge Private Equity sent initial inquiries to Summit Filing Solutions ("Summit") on matters related to Summit's S-Corp election. Laura Kensington, Summit's Acting CEO, responded with a letter explaining Summit's non-proportionate distributions (there were two instances) and the potential ineligible (non-resident alien) shareholder. She indicated that the shareholders would be willing to make representations and warranties (to be incorporated into the share purchase agreement) on the matters addressed in her letter. Please review the due diligence file and draft the representations and warranties, specifically to address any bad facts and/or identified deficiencies in light of the responses set forth in Ms. Kensington's letter. Reply to me here with your view as a short message.

Assume that the Internal Revenue Service denies relief for the transfer of shares to Carrie Canuck, an ineligible shareholder. What amount of taxes (federal plus state) would be owed by Summit Filing Solutions Inc. ("Summit") as a result of the denial for each taxable year, until the earliest time Summit can requalify and file a tax election to become an S corporation, or up to the last year for which we have data, whichever is earlier? - Assume that the federal tax rate is 21% for ordinary business income and the California tax rate is 8.84% for ordinary business income. - Assume that the ordinary business income for each month of the year was exactly 1/12 of the respective year's ordinary business income. - Round values to two decimal places. Print your reply back to me here.

The Private Equity Sponsor wants to extract cash via a "Dividend Recapitalization" at the end of 2027. Using the MFC model, you must size the Maximum Special Dividend the company can pay while remaining compliant with a strict Debt Service Coverage Ratio (DSCR) covenant. Report the 2027 CFADS, Max Total Debt, and the Net Special Dividend ($000s). Reply back here with the numbers. Scenarios: 1. Timing: The dividend recap transaction closes at the end of Fiscal Year 2027. Use 2027 forecast data. 2. Covenant Constraint: - Pro Forma DSCR, defined as CFADS / debt service, must be at least 1.40x. - Cash Taxes (Override): Calculate normalized cash taxes as 25.0% for the purpose of dividend recap 3. New Debt Structure: - The company will refinance all existing debt into a new Senior Facility. - Interest Rate: 6.5% (Fixed). - Mandatory Amortization: 1.0% of Principal per year. - Total Service Constant: 7.5% (Interest + Amort). 4. Dividend Recap Transaction Fees: 2.0% of the Incremental Debt Raised (New Total Debt - Old Existing Debt). Instructions: 1. Calculate 2027 CFADS using the override tax assumption. 2. Solve for the Maximum Total Debt Capacity allowed by the 1.40x DSCR constraint. 3. Calculate the Incremental Debt (Max Total Debt - Existing 2027 Year-End Debt). 4. Deduct dividend recap transaction fees to find the Net Special Dividend.

Use the MFC model to return Implied Total Enterprise Value (in Canadian dollars, C$, rounded to the nearest million) under the following assumptions. 1. Refinancing + EPP - Decrease the Refinancing + EPP spread from 3.5% to 2.5%. - Preferred equity issuance size increased to C$2,000,000, along with the preferred dividend rate decreased to 7.5%. - Hold revenue growth constant at 7.0% per year from FY2026 to FY2032. 2. Discounted cash flow analysis scenario with the following specifications: - Begin with the change in cash for each year from FY2026 through FY2032, and add back both preferred dividends and tax-affected interest expense in order to derive unlevered free cash flow for each period to be discounted to net present value. - Apply a WACC of 12.0% - For each year, calculate the net present value of the unlevered free cash flow using 2025 as year 0.. - Utilize an exit EBITDA multiple of 15.0x. Give me the information in your reply here.

Please calculate the total value of a MFC privatization by the provincial government at a bid value of 11x LTM EBITDA, which composes of both the (a) upfront proceeds from the sale and (b) value of the tax stream, assuming the following using the MFC model: * The province receives 1/3 share of the corporate tax (the other 2/3 going to the federal government) * Given its "super-priority", the discount rate on the tax stream is 4% * The terminal growth rate of the tax stream is expected to be the 2032 revenue growth rate of MFC Please provide your response to me here, in millions of dollars that are rounded to the nearest million.

The current standalone DCF valuation does not include synergies. In the valuation model, re-run the analysis to include synergies, integration, and transaction costs. In the accretion dilution model project, the "Synergies" and "ProForma_Combined" tabs contain these assumptions. 1. Update the vauation model "Project_Rheingold_Valuation_Model(final)" 2. Implement One-Time Integration Costs (After-Tax), Transaction Costs (After-Tax), and EBITDA Synergy (pre-tax) into the DCF analysis, maintaining all existing DCF assumptions. 3. Report back for me: "Sum of PV of FCF (2026-2030)", "PV of Terminal Value", "Enterprise Value", "Implied EV/EBITDA(2025E)", "Implied EV/Revenue(2025E)". 4. Round all final monetary values (millions) and multiples to one decimal place.

You have access to the accretion dilution model. Create a new sheet and tell me the Proforma Interest Coverage for 2027 and 2028. In doing so, assume: - Aptar's Interest expense as a percentage of sales in sheet "Aptar_Historicals" is now 2% for the projection period (2025E - 2030E) - Aptar's Total OPEX as a percentage of sales in sheet "Aptar_Historicals" is now 25% for the projection period (2025E - 2030E) - Aptar's Tax Rate as a percentage of sales in sheet "Aptar_Historicals" is now 35% for the projection period (2025E - 2030E) - Interest on Existing debt remains unchanged. - Cost synergies target in sheet "Synergies" is 35% - Synergies in sheet "Synergies" will be 50% realized in 2025, 2026 and 2027 and 100% in 2028 and after - Cost to achieve synergies in sheet "Synergies" will be 0% Perform the calculations in Euros in thousands and round to one decimal place.

Determine the effective interest rate of The Aptar Group acquiring Gerresheimer at a 35% premium. Then compare that effective interest rate to the effective interest rate of The Aptar Group as a standalone without acquisition. Use the board presentation to calculate the effective interest rates. Round the interest rates to one decimal point. Assume a 25% corporate tax rate. Create a New Sheet file with the Effective Interest Rate for Aptar Standalone and Aptar with Acquisition.

Determine the current Capital Account for Pacific Pension Fund in HarborView Fund I, LP. The following financial events have occurred since inception of the Fund (unless otherwise stated, assume Gross Asset Value is identical to adjusted cost basis): - aggregate Profit of $10,000,000 in 2024 - aggregate Loss of $10,000,000 in 2025 - reduction of Gross Asset Value of $10,000,000 for an asset ("Asset 1") that was not reflected in taxable income - assume no management or other fees need to be applied, as they are reflected in Profit and Loss disclosed above. The above includes the following: - gain on sale of Asset 1 above declared taxable gain in the amount of $10,000,000 - gain on the sale of Asset 2 of $5,000,000. Now, reply to me here with your answer.

Assume that no transaction happens with SOLV. Now, calculate the impact of a large investment in AI for MMM shareholders as an alternative capital allocation strategy using the accretion dilution model. Print me back the answer right here, showing: Total new debt from MMM's AI related initiatives Total debt Total after tax Interest Expense PF Net Income Pro Forma EPS EPS accretion/dilution Ending cash Using the following assumptions calculate the impact to EPS for MMM shareholders assuming no transaction with SOLV: - Required investment in technology of $5 billion - half of the investment to be financed from cash in hand and the rest with new debt at a 8.5% cost - Reduction in work force resulting cost savings pre tax of $1 billion - Severance cost associated with the reduction in work force of $4 billion to be financed with $500 million of cash in hand and the rest with new debt at a 12% cost. Assume 50% of the total severance costs will be paid upfront and the remainder over a 4 year period in equal amounts with the first payment beginning in year 1. These costs should be accounted as an expense and not capitalized. Any remaining cash from the debt not used upfront goes to the balance sheet - Increase in power costs associated with the investment in AI of $600 million per year - Apply an incremental 10% tax on power cost for every $100 million of power spend as a pollution compensation policy. Assume the 10% tax doubles for every $100 million of incremental spend. Assume this tax is embedded in the cost. - Assume to bolster balance sheet, MMM also issues equity for equivalent of $2 billion dollars at a issuing price of $250 dollars per share Remember in your answer: EPS should have two decimals. Percentages should have two decimals. All other values given as $ in millions, no decimals.

Estimate impact to EPS of MMM divesting 1/3, 2/3 or 100% of its holdings in SOLV. Using the accretion dilution model, calculate the EPS impact of selling the different amounts of shares. Assume that MMM has to pay a 20% tax on the proceeds from the divestiture of the first 1/3 of the shares, a 25% tax on the next 1/3 and a 30% tax on the last 1/3 of the shares. Assume that net proceeds from the divestiture are invested in an instruments that pays an 8% interest rate upfront and that interest income is taxed at 35%. Tell me: 1- Percentage of SOLV Divested 2- EPS Accretion / Dilution 3- Pro forma net income Pro forma net income should incorporate the impact of investment of net proceeds from divestiture at 8% and after tax. All figures should be presented with two decimals. Output the final results by making a new Spreadsheet file.

Under Scenario 1 in the Accretion / Dilution Model, 3M will use 50% debt / 50% equity. $250 million in pre-synergies were identified. Use the following assumptions in the Assumptions S1 tab of the Accretion / Dilution model: - Pre-Tax Synergies: $250mm - Control Premium: 25% - % Stock: 50% - % Debt: 50% - Interest Rate on New Debt: 8% - Fees: 1.5% of Updated Take-Private Enterprise Value - Solventum Share Price: Use the Solventum VWAP for the 75 trading days up to November 19, 2025. To calculate the price for each trading day in VWAP, use the formula (High + Low + Close) / 3 We need the Revised Accretion / Dilution percentage for 3M. Round percentages to 2 decimals points. Write back to me with your response now.

What if BBDC change target and achieve a partial merger with FIDUS Investment Corporation (FDUS) instead of TriplePoint Venture Growth BDC Corp. (TPVG)? Use the FDUS SEC filings as of Q3 2025 and Q4 2024 to modify the 9M 2025 section of the income sheet in the merger model - Input the target share price of $19.21. Set the Financial account to "9M TTM 2025". - Assume that the BDDC / FDUS EBIT synergies will be 1.75x greater than the potential BBDC / TVPG EBIT synergies. Recalculate the pro-forma EBIT, the net investment income before tax, the net increase (decrease) in net assets from operations, and the net investment income per share. Round the net investment income per share to two decimal places. Apart from the net investment income per share, present the results rounded to USD thousands. Print your answer back here.

Assume a scenario where CompliSure can achieve best-in-class R&D rates (low) and gross margin rates based on 2024 competitor benchmarks for years 2025 through 2030, if best-in-class is better than the existing forecast. Recalculate CompliSure's Net Income for 2025-2030. Round final answers to the nearest thousand. - Assume Depreciation & Amortization remains the same value - Income Tax Expense remains the same % of Pre-Tax Income - And all other costs remain the same as a percentage of revenue - Use the financials from 2016 to 2025 and the 5 year forecast for your calculations. Reply back to me the values.

If CompliSure experiences the changes outlined in the attachment starting in 2026, what is the expected impact to free cash flow in 2030? Assume Interest Expense remains the same % of EBIT, and Income Tax Expense remains the same % of Pre-Tax Income. Round answer to the nearest thousand. Write your response here as a message.

Can you please help me re-evaluate and state the adjusted 2030 net income for Complisure? The 2030 adjusted net income will be based on the three key assumptions: 1) New Sales and marketing spend, and New hosting and infrastructure in accordance with the attached expense growth rate file only, beyond 2025, 2) All other spending would remain similar to the 2026 baseline figures, 3) Tax rates would be identical to those in effect in the 2026 baseline figures. Use the latest version of the 5-year forecast. Round the final answer to 2 decimal places in M. Please provide your answer directly here.