46/111 runs · avg score 50%
Cross-benchmark category
Merger Models
Compare AI agent runs for Merger Models: prompts, scores, grades, and public traces. This page showcases APEX-Agents tasks that test whether AI agents can build and update merger models, including accretion/dilution, exchange ratio, and pro forma EPS analysis.
M&A modeling AIAccretion/dilution, exchange ratio, pro forma EPS
112Tasks
5Primary
1Benchmarks
Published model evidence
A quick view of shareable runs in this category. Open task and trace pages for the prompt, response, files, and grading details.
43/112 runs · avg score 47%
39/112 runs · avg score 41%
36/112 runs · avg score 39%
Primary tasks
5 tasks with this category as their main focus.
In the Accretion / Dilution Model, there is an error in the calculation of Cost of Product and Cost of Software and Rentals. Calculate the correct revised implied Enterprise Value after the divestitur…
Reference 2024 ATR annual report to calculate Aptar Group's cash conversion cycle for FY2024, using FY2024 ending balance only. Output the cash conversion cycle in days, rounded to the nearest whole n…
Using the 2024 ATR annual report, reply to me with the absolute performance difference between ATR shares and the Peer Group in 2024 as a percentage (round this to two decimal places).
If the value of ATRs holdings of Goldrain and YAT appreciated by 5% and 10% respectively, from the end of 2024, while all other equity investments remained constant, what would the new total value of …
Calculate and report the adjusted diluted EPS growth for FY2023 to FY2024 for Amcor and unadjusted diluted EPS growth for The Aptar Group, rounded to the nearest whole percentage. Use the Amcor and AT…
Related tasks
107 tasks that also exercise this work as part of a broader assignment.
Using a discounted cash flow (DCF) model, what is the implied share price under the following assumptions: - Revenue growth is 2.0 percentage points lower than the current growth rates in each year fr…
Output two values for me: 1. The implied share price using the Gordon growth method 2. The implied share price using the exit multiple approach You will need to update the DCF model with the followin…
What is the EV and implied share price of CNS in the DCF model using both Gordon growth model and exit multiple approach if each business segment grows as outlined below over the projection period of …
To evaluate where economic value is created in the BBDC & TPVG merger, use the comps and merger models to build a four step value creation bridge. Write your reply to me here. Set the merger model to…
Please get the most recent financial year’s EV/FCF multiples (cutoff date 20 Dec 2025) for the public comparables, as per the slides deck, to calculate a cleaned average using the Modified z-score (Me…
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 HL…
Solventum (SOLV) announced a $2.0 billion strategic expansion funded with 70% debt and 30% equity, which caused its share price to increase by 5% relative to the closing price on 11/18/2025. Using the…
Perform a value-creation analysis based on scenario 1 using the accretion dilution model to assess whether Scenario 1 creates or destroys value for 3M Shareholders. Assumptions: 1. 3M Levered Beta is…
Update KVUE's share price to the closing price as of 1/5/26 and 2029E revenue growth rate to that of 2025E. What is discounted free cash flow in 2029E, including terminal value, rounded to the nearest…
From the LBO, assume a 15% premium is offered to CNS holders and max transaction leverage of Term loan B is $1,040. What is the revised IRR and MoM for 2029E, rounded to one decimal place? Reply here.
Provide the mean implied equity value for CNS from the Comparables and Precedents using 2025E EBITDA, as well as the implied equity value from the DCF and LBO using the base DCF and assumed offer pric…
Using the LBO model calculate FY2025 interest expense and the corresponding FY2025 Adj. EBITDA / Interest Coverage ratio based on the capital structure sized at 4.5x entry gross leverage (Gross Debt /…
Using the LBO model, what would the revenue growth % in 2025E have to be to yield an IRR of 20.0% in 2029E? Round to 2 decimal places. Reply to me in here please.
Using the DCF calculate the implied levered FCF yield for CNS in 2030E for (1) the perpetuity growth method and (2) the exit multiple method. Assume a 10% WACC, 2% terminal growth rate, and an 11x exi…
Using the precedents and DCF analysis calculate an implied share price for CNS to 2 decimal places. Exclude transactions where the target had <$90 B in AUM. Using the forward EBITDA from the DCF, assu…
Your task is to evaluate the impact of financing constraints on Project Vanguard's take-private economics and develop a revised LBO case reflecting a capped leverage scenario using the LBO model. • T…
Please calculate the DCF value per share applying the midyear convention. Keep all other assumptions the same in the existing model. Provide your answer right here, rounded to the nearest cent
Assume that CNS has been taken private as of the start of FY25E. The new PE owners have decided to reduce employee compensation by 50% of the value of stock-based compensation in the previous LBO fore…
Can we see what the DCF per share value is if the terminal value is based on EV / AUM of the peer set? Let's exclude AMG and JHG for purposes of this exercise. Assume that AUM grows linearly with man…
Management believes that the appropriate valuation of the DCF terminal value is the EV / mgmt. fees portfolio multiple of the asset managers peer set per the comparables analysis excluding JHG and AMG…
Using the merger model, assume BBDC's share price falls by 15% after deal announcement but before the new share issuance to TPVG shareholders. Using the 9M TTM 2025 financial account, calculate the re…
Evaluate acquisition of WhiteHorse Finance (WHF) by editing the ‘Target-TPVG’ tab in merger model using WHF’s 2024 financials. Use a share price of $7.20 (as of 11/26/2025). Output two sensitivity an…
Using the comps file, refine the BBDC peer set and rebuild the valuation range as of 18 Nov 2025. Use operating data for the 9M to end of 2025Q3 to derive implied prices. 1. Exclude all peers with AU…
If BBDC was to merge with TPVG, what would be the pro forma industry exposure for Business Services (investments at fair value as a percentage of total, based on end of September 30, 2025 data)? Use…
If BBDC had effectively merged with TPVG at the end of September 2025, what would be the expected synergies (in dollars) in one and a half years post-closing? You can assume the synergies equal 10% o…
Assume that TVPG raised additional $70 million mezzanine capital ($30 million - equity capital raise from it's current shareholders at a discounted issue price of $6.0 per share and $40 million - debt…
Assume BBDC's share to fall by 5% and TPVG's share rose by 12% post-deal and pre-issuance. The final proposed ownership split is BBDC - 75% and TPVG - 25%, maintain other assumptions constant. Creat…
Using the merger model, recalculate the post-deal pro forma balance sheet in the “Post-Deal Proforma” tab under the following assumptions: - 50% cash consideration - 20% of balance sheet cash is used …
Assume that TVPG raised additional $70 million mezzanine capital ($30 million - equity capital raise from it's current shareholders at a discounted issue price of $6.0 per share and $40 million - debt…
Recalculate "Additional paid-in capital" that factors in share buy-back of 10 million shares by BBDC. Print the answer as a reply to me here. Assume that the transaction was financed using cash on th…
Consider FDUS as a potential target, use the last 6-month median share price as of 11/19/2025 in the FDUS file and the Nine Months Ended September 30 account from the FDUS 9/30 10Q. Your task is to ca…
Calculate the accretion / dilution of both BBDC and TVPG shareholders, sensitized for different Cash consideration and Bid Premium. Edit the existing merger model and add two sensitivity analyses: on…
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 …
Use "Comp Analysis – Modify" as a clean version of Comp Analysis. Replace peers WhiteHorse Finance (WHF) and TriplePoint Venture Growth BDC corps. (TPVG) and replace with SLR Investment Corp. (SLRC), …
Use the BBDC valuation model as a template and a prepare a full valuation of SLR INVESTMENT CORP. (SLRC) as of FY 2024. - Use the median of peer trading multiples - Retrieve the SLRC’s required data f…
In the Accretion / Dilution Model, assume stock-based compensation equals 3% of the sum of operating expenses and cost of goods sold, calculated using the model’s existing methodology, and added back …
In the Accretion / Dilution Model, use the capital structure and shares outstanding assumptions for Solventum (SOLV) to calculate levered free cash flow and price per share. Specifically, use the foll…
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 Acc…
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 …
Evaluate the sensitivity of EPS impact to synergies and cost of new debt for the acquisition of SOLV by MMM using the accretion dilution model. Create a new tab in the file, with a table to show EPS …
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 mode…
We want to do some historical analysis. Using stock prices for the 250 trading days up to Nov 19, 2025, calculate the beta for SOLVM to the XLV ETF. Then over the same time period, calculate the beta …
Present all $ output values in million, round all output values to 1 decimal place. Get the following directly from the accretion dilution model: - Enterprise Value (DCF output) - PV of Free Cash Flo…
Using the accretion dilution model, produce the deliverables outlined below. Round all the figures to whole numbers, present monetary amounts in $ mm and display percentages to two decimals places. …
Using the 3Q 2025 3M 10Q and the accretion dilution model, calculate the following deliverables. Present all values in millions ($mm), number of shares in millions (mm), and round to whole numbers. Fo…
Using the merger model and 0000066740-25-000089, please calculate: 1. The Number of Shares Repurchased. 2. The Revised Enterprise Value. 3. The Revised EV/EBITDA multiple for 3M. 4. The Revised P/E ra…
Calculate the intrinsic value per share of Solventum based on these assumptions. Use the accretion dilution model. - Lower the gross margin % to 52% for the forecast period 2026E through 2029E. - Ch…
Benchmark the results for Elastic NV Q2'FY26 (ending 10/31/2025) against their industry peers as reported in Public Comparables (for Q2). 1. Calculate the public comparables mean (average) for Market…
Run a single downside scenario where all modeled sensitivity factors receive a 20% shock, in the direction that would adversely impact IRR. What would the new IRR & Sponsor Equity Value be? Use the LB…
Return the Year 1 - Year 5 CAGR for Adjusted EBITDA. Round to two decimal places and display percentages with %. Write your answer straight back. I want you to use this info to update values in the …
I want you to tell me for Year 1 - Year 5: (1) Total revenue CAGR(2) Subscription Cost of Revenue CAGR (3) Sales and Marketing Expenses CAGR (4) EBITDA CAGR But first adjust revenue growth rate to be…
Print out here the updated IRR and MOIC, rounded to two decimal places. Use the precedent transactions document and LBO model to complete the analysis. Assumptions: 1. Adjust the LBO model to have t…
Make adjustments to the Year 5 growth rate to reach the following Year 1 - Year 5 CAGR for Total Revenue: 22%. Use the LBO model to complete the analysis, but just reply right here. Round value to one…
Reply back to me an updated IRR and MOIC. Round final numbers to two decimal places. Use the LBO and comps models to complete the analysis. Follow these assumptions: 1. Remove any comps with Enterpri…
Use the LBO model. I want some new analyses: - Decrease the “Premium” from 35.0% to 25.0% on the "LBO" tab - Decrease the “Adj. EBITDA Multiple” from 40.0x to 25.0x on the "LBO" tab - Update revenue g…
Please use the LBO model to calculate the sponsor equity value and IRR for Year 5. Then report the sponsor equity value in US dollars, rounded to the nearest million (e.g., $1,000). Also, report the I…
Using the assumptions below, calculate the sponsor equity value and IRR for Year 5. Then, report the sponsor equity value in US dollars, rounded to the nearest million (e.g., $1,000). Report the IRR a…
Please create a new scenario within the LBO model to assess the impact on Elastic’s Net Profit, assuming that for all years over the projection period (Year 1 to Year 5), Research and Development expe…
Use the LBO model to assess the impact of a lower interest rate environment on the Year 5 exit IRR% target. 1. Decrease the existing senior debt cost by 50 bps starting at the beginning of Year 2. Th…
Please evaluate the impact on Elastic's IRR% at exit, assuming a slowdown in Total Revenues growth. Return the following here: Year 5 Adj. EBITDA, EV value at Exit, Net Debt at Exit, Sponsor Equity Va…
Please assess the impact of reducing the entry premium by 5% and illustrate the potential impact on the deal return. Use the LBO model. 1. Reduce the deal premium by 5%, from 35% to 30%. 2. Reduce t…
Please create a new scenario within the LBO model to assess if the sponsor can still meet the 20% IRR target at the Year 5 exit, given higher Net Working Capital needs. 1. Increase accounts receivabl…
Assess if the sponsor can still meet the 20% IRR target at the Year 5 exit, given higher cost of revenues. 1. Increase subscription cost as % of subscription revenues by 1 percentage point in Year 1,…
Assess how much certain business drivers must move to bring IRR below 20%. The stock price has fallen to $87.00. Use the LBO model for the info. 1. Find the critical point (percentages to 2 decimal …
Update the LBO analysis tab "Copy of LBO". It needs to include a single potential add on acquisition in FY2027E. Assess the impacts on the 5-year LBO analysis. Use SOFR actual data. Add to that tab, t…
Output the year 5 Equity Value to Sponsors and IRR (with a 5 year exit). From the existing LBO model, update values to both a 20% equity rollover from existing shareholders and a 10% management option…
Use Planet Fitness' latest financial model, in the"Copy of LBO" tab, and sensitize $ operating expenditure each year by +/- 5% against the base case for each year from 2026 through 2030; calculate the…
Use Planet Fitness' latest financial model that Advent updated based on their specifications and assess Advent’s “ability to pay” to reach 25% IRR after 5 years if there are net revenue synergies betw…
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 remaini…
Use the valuation model, updating the 'Per Share' and 'Premium' values for the low, mid, and high cases to reflect Blackstone’s acquisition of Company X and the assumptions below. Reply back to me wi…
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 s…
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 p…
Calculate the 2030E discounted EV/Revenue multiples for West Pharmaceutical, Stevanato Group, Schott Pharma, and Aptar Group. Reference the valuation model on the "Trading Comps" tab. Note that the fi…
Assume that 10% of Aptar's Asian pharma revenue will shift entirely into European pharma revenue. Retroactively apply this to 2024 financials. Refer to the 2024 ATR report. Return a short message with…
ATR is expecting to write down the goodwill related to Pharma to zero following the merger with GXI. Referring to the 2024 ATR 10K calculate the new total ending Goodwill under this write down scenari…
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 stan…
Create a new Spreadsheet for me. Please compute a new Adjusted EBITDA value for the following companies: West Pharmaceutical, Stevanato Group, Schlott Pharma, Berry Global, Aptar Group using the board…
Please access the 2024 Huhtamaki Annual Report and calculate the Net Sales per employee at end of period for 2023 and 2024. Reply to me here with the the Euros per Employee, rounded to the nearest ful…
Using the 2024 ATR annual report, analyze the results of a 15% tariff on Aptar Group’s FY2024 net income. Assume the 15% applies only to Cost of Sales, exclusive of depreciation and amortization. Roun…
In The Aptar Group's 2024 annual report, extract global revenue for the Pharma segment in 2023 and 2024. Compute the aggregate dollar change in thousands of USD adjusted for 7.1% 2024 global inflation…
From Becton Dickinson's FY2025 Annual Report assume the FDA finds that one violation regarding the Alaris SE infusion pumps, and decides the company is in violation, and enforces the consent decree on…
Calculate the incremental Enterprise Value the Gerresheimer acquisition will add to the Aptar Group. Only reference the board presentation. Assume multiples for The Aptar Group remain constant and ref…
Calculate the updated PV of FCF. Output it here. Round it to the nearest whole number, with zero decimals. Print your answer as a reply back here. Account for: 1. Identify the competitor in the compa…
Use the LBO model with the following indicative debt package to calculate these values --> then, return them back to me here 1/ Equity contribution 2/ Central case IRR 3/ Central case MOIC 4/ Exit ne…
Can you help me calculate a new implied share price, rounded to two decimal places? Return your answer to me here Update the DCF so that its 2024-2028 R&D CAGR is equal to PWSC's 2019-2023 R&D CAGR. …
Referencing the KSchool DCF, how much does the company need to increase or decrease 2023's earnings to have it's P/E ratio in 2023 equal to the sector average for communication services as of 1/1/2026…
Using KSchool's DCF, update the 2026 revenue growth rate so that the 2024-2028 Revenue CAGR is equal to INST's 2019-2023 selling and marketing expense CAGR. Then make it a 6-year projection period an…
I want to know the implied DCF share price with a revised scenario, rounded to two decimal points. Do your calculate by updating the cost of debt in the DCF model to be the average between the 1 year…
Using the DCF model, update the equity risk premium to be the risk-free rate plus 150 basis points and the cost of debt to be the risk-free rate plus 300 basis points Output the following rounded to …
Calculate the 2027P equity value implied by the LBO output. Replace the 2027P exit EBITDA multiple with the average calculated FY2023 EV/EBITDA multiple for CHGG and LOPE. Present the result to me he…
Calculate the 2028P equity value implied by the LBO output, assuming an exit multiple of 32.0x. Present your result to me as a message in here, rounded to the nearest $ million. Use the following co…
Please audit the financials of the smallest company in our Refined Comps table by market cap using only the IS, CFS, and BS from sec filings and data tools available to you. Report Adjusted EBITDA and…
Please run an upside DCF scenario for Kenvue assuming slightly better revenue growth and margins changing the following metrics: 1. Revise 2025E revenue growth rate to 2% stepping up by 0.1% per year …
In a hypothetical acquisition of Kenvue by Kimberly Clark (merger), at what Kimberly Clark share price would accretion for Pro Forma 2025 EPS for the combined company (Kenvue and Kimberly Clark) would…
For the Kenvue deal, please send over the below draft figures for pre-deal target multiples for FY24. Utilize potential median deal value Return to me a message with: Deal value/EBITDA, Deal value/EB…
From the figures in merger model, please recalculate the stock portion of the offering price (exchange ratio with 5 decimals) using Kimberly-Clark unadjusted closing share price at 31 Oct 25, and then…
Please calculate the implied premium / discount of the offer price as proposed to the client relative to the following KVUE share prices, using the values up to 12/08/2025: - Closing price on the fin…
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 im…
KVUE's cost of debt is updated to be the risk-free rate plus 100 basis points. Reply to me with KVUE's enterprise value, rounded to the nearest whole number in millions. Use the following situation to…
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 co…
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 …
Use the DCF model, and make the following changes: - update net sales growth rate in 2029E to be the 2023A actual figure - update long-term growth rate to the 30-year treasury rate as of 1/2/26 minus …
If you updated the long-term growth rate in the DCF model to be the percentage increase in CPI in 2025 from January 1, 2025 to November 1, 2025, what is the updated implied share price? Also, increase…
Reply back to me with the P/E ratio for KVUE, rounded to two decimal points. Use the implied share price in the DCF model and diluted EPS from the annual financials dated 12/23/2025.
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. F…
Update the DCF model to tell us the following: - Assume operating margin % from 2025E-2029E is updated to KVUE's 2019 operating margin plus 50 basis points - Add 25 basis points to terminal growth rat…
Reply back to me with the following values: - Implied share price. - Enterprise value - % weight of PV of terminal value in the total new EV. To get to the right answer, update the WACC calculation …