1/2 runs · avg score 50%
Cross-benchmark category
DCF Valuation
Compare AI agent runs for DCF Valuation: prompts, scores, grades, and public traces. This page showcases APEX-Agents tasks that test whether AI agents can update investment banking valuation models, modify WACC assumptions, calculate terminal value, and produce precise implied share prices from Excel-based DCF models.
Financial modeling AIWACC, terminal value, implied share price, FCF sensitivity
132Tasks
0Primary
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.
52/132 runs · avg score 47%
51/131 runs · avg score 46%
46/132 runs · avg score 41%
34/132 runs · avg score 32%
Related tasks
132 tasks that also exercise this work as part of a broader assignment.
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…
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 Inco…
Based on the attached findings from the top 3 research firms, what is CompliSure’s expected revenue ($M) in 2030 for each scenario? For each scenario, please assume that the overall market size in 20…
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…
Run a new DCF scenario. Make the following changes to the metrics in the projection period for Solventum: - Update Sales of Product, Sales of Software, and Rentals from 2025 to 2029 to be a 2-year mov…
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 “Projectio…
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 …
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 d…
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…
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. - …
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…
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 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 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…
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…
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, 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…
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…
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. …
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 …
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, "Project…
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 …
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 a…
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 f…
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, annua…
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 incom…
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…
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 …
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 p…
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…
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 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 m…
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…
Calculate operating cost before D&A as a percentage of sales ("operating cost margin") for each of GYM, Life Time, Planet Fitness, and Xponential fitness for each year from FY2021 to FY2024 before D&A…
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…
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 …
Update the LBO model to include an incentive payment structure of PLTF management post-transaction. Assess the impacts on the 5-year LBO analysis. Management is eligible for these payments each year …
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 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, I want you to tell me updated values for: (1) Implied Net Debt, (2) Sponsor Equity Value and (3) IRR for Year 5. # Assumptions -Increase the interest rate of the secured term loa…
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, rounded to the nearest million, and report the IRR as a percentage rounded to one decimal pla…
Calculate the sponsor equity value and IRR for FY2030, then report the sponsor equity value in US dollars, rounded to the nearest million. Report the IRR to one decimal place. Reference the LBO mode…
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…
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, and conduct an ability to pay analysis around Advent's target IRR of 25%. Create a new xlsx sheet, then round all calculated values to two decimal places f…
Conduct a 5-year IRR sensitivity analysis using Planet Fitness' financial model. Model the impact if, starting Q1 2026, Planet Fitness opens 10 additional Franchisee-owned stores each quarter, compare…
Conduct a 5-year IRR sensitivity analysis using Planet Fitness' latest financial model that Advent updated based on their specifications (v7). Assess the impact if Planet Fitness reduces National adve…
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…
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…
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 +…
Use the MFC model to reply to me with the updated Retained Cash and ending Long-term debt in FY2030 under the following assumptions. Report in Canadian dollars (C$), rounded to the nearest million. …
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…
Using Option B in the MFC model, the refinancing in conjunction with a equity private placement (preferred stock), update to upsize the preferred tranche to $1.5bn and for interest to be payment-in-ki…
Muskrat Falls Corp's (MFC) owners have decided to pursue option A (Case 1), i.e. the debt refinancing only option, and hold MFC as an investment and selling at the end of FY35. Assume the following: …
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 MFC model we made. MFC has chosen to proceed with a debt-only refinancing at market rates (Option A / Case 1). At the start of each year, it decides to issue new debt up to a maximum of 4.0x …
Muskrat Falls Corp (MFC) has decided on a debt-only refinancing at market rates, i.e. Option A (Case 1 of the model "toggle") in the MFC model. MFC is valued at 12x EV / NTM EBITDA. Please calculate …
Please use assumptions below for a more aggressive financial forecast, which is termed the "SuperUpside" case: - The drivers of the SuperUpside case adds to the "Upside" case the difference between t…
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 th…
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…
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…
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 …