10/16 runs · avg score 84%
Cross-benchmark category
Comparable Company Analysis
Compare AI agent runs for Comparable Company Analysis: prompts, scores, grades, and public traces. This page showcases APEX-Agents tasks that test whether AI agents can perform comparable company analysis, screen peers, calculate valuation multiples, and interpret EV/EBITDA, EV/FCF, P/E, and P/NAV outputs.
Comps automationEV/EBITDA, EV/FCF, P/E, P/NAV, peer screening
94Tasks
7Primary
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.
3/6 runs · avg score 86%
38/93 runs · avg score 49%
38/94 runs · avg score 50%
36/94 runs · avg score 47%
28/94 runs · avg score 38%
Primary tasks
7 tasks with this category as their main focus.
Using HarFeast's baseline diagnostic dataset, assess the impact of predictive maintenance on HarFeast's scrap rate. We will pilot predictive maintenance only on equipment a) whose scheduled hours per …
Using HarFeast's equipment data by location and quality losses dataset, we will consider all canned vegetables assets with a scrap rate > 5% and with unplanned downtime hours above the plant median fo…
Review industry reports to determine the range of industry-wide reductions in force (RIFs). Using Impact’s revised SG&A breakdown, calculate the cost savings Impact would achieve by reducing its sales…
Using the latest materials cost reduction analysis, assume Impact reduces its 2025 materials cost with current supplier relationships by 20%. Benchmark Impact's resulting 2025 materials cost as a perc…
I feel good about our current assessment of the valuation, but I’d like to do some forward-looking assessments. Can you use the historical Sector Median PE volatility data to determine which of the cu…
1. What is the digital lever that Sarah Jenkins, David Chen, and Mike Russo agree will deliver the fastest and biggest boost to HarFeast's Gross Margin? 2. Assuming HarFeast adopts the chosen digi…
Can you calculate the total labor variance in hours (favorable should be positive) and dollars for the Illinois and Wisconsin plants? A positive variance should mean that Total Actual Hours are less t…
Related tasks
87 tasks that also exercise this work as part of a broader assignment.
HarborView requires all customer documents to be sent to their offices in the Cayman Islands headquarters, including information of Hong Kong customers. We’ve also already sent them documents as part …
We have received a claim from Thomas Whitaker’s counsel asserting that Magnolia breached its obligations by failing to provide weekly communication to Mr. Whitaker's family. Provide the strongest argu…
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 sa…
Use the churn and WinLoss data, and assume the following: - Competitor Loss Ratio = (Total Contract Value of Lost deals/Total Contract Value of all deals) - If competitor-lost deal value exceeds the…
I'm trying to get a sense of which HarFeast employees are most ready for the digital training rollout. Can you pull the workforce survey data and identify all employees who are above their role type's…
Create a new slide pptx, summarizing the comparable SaaS deals' target company name, purchase price, ARR, and ARR multiple. Include all targets for which we have an individual case study and use only…
Based on the attached table, with the asking price for each company, which competitors would have a higher 2024 ARR multiple than CompliSure even if their SMB customer count declined by 75%? State the…
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…
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 …
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…
Prepare an analysis regarding Livyra's Bencontra promotional activities. Take a look at the case file, paying close attention to the email communications as well as the relevant case law, statutes and…
Can you please evaluate the outage causes that affect each country the most, in terms of total outage duration? Categorize hazards relating to flooding or storms as the "Weather - Storm" cause and tho…
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…
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…
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…
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, 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…
Compare the average tenure of Solventum's board members to the average of its peers' board members (excluding Solventum). Give their average tenure. Then, state which is larger and by how many years. …
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…
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 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…
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 …
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 pr…
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 averag…
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…
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…
Use the LBO analysis, update it to assume that Planet Fitness stock option tranches outstanding. I want to see the Year 5 IRR, flexing premium paid and exit multiple. # Assumptions -All options are v…
Using the LBO model, update the analysis to reflect a go-forward plan which emphasizes an increased investment on franchisee-owned stores. Output the implied Sponsor Equity Value and IRR for Year 5. …
Calculate the sponsor equity value and IRR for FY2030, then report the sponsor equity value in US dollars as a reply. Round $ to the nearest million and report the IRR % to one decimal place. 1. Ref…
Conduct a 5-year IRR sensitivity analysis using Planet Fitness' latest financial model that Advent updated based on their specifications (v7). Assess the IRR impact to Advent if the terms of the debt …
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…
You have the MFC model. Calculate the implied sponsor equity at entry in FY2032 and report it in Canadian dollars (C$), rounded to the nearest million. Respond by printing out back to me. Reference t…
You have the MFC model. Calculate the Total Debt / EBITDA in FY2030 and report it in multiple, rounded to one decimal place. Print your answer to me here. Reference the "Refinancing (Option A +B)” ta…
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 +…
Calculate an updated implied sponsor equity at entry with FY2032 exit. Use the MFC LBO model and the assumptions below: - Reduce the TL-B leverage multiple from 3.0x LTM EBITDA while lowering the yie…
Calculate a normalized market capitalization for AES using data from the comps file and the following approach: - Calculate the volume‑weighted average price (VWAP) for AES Corporation over the 250 t…
Assume that Muskrat Falls Corp's (MFC) owners have decided on an LBO process. Blackstone has decided to bid for the business via its infrastructure fund. Please calculate Blackstone's "ability to pay"…
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…
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…
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…
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…
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…
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 …
We just received a Civil Investigative Demand from the Federal Communications Commission (“FCC”) regarding our text marketing campaign to promote our reverse mortgage product. The interrogatories i…