AI Agents for WACC and Cost of Capital Analysis

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/EBIT, and Deal value/OpFCF. Round all values to one decimal place.

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 calculate the values: - Replace risk-free rate with the 10-year treasury rate as of 1/2/26 with beta at 0.75 - Replace risk-free rate with the 10-year treasury rate as of 1/2/26 with beta at 1.00 - Replace risk-free rate with the 30-year treasury rate as of 1/2/26 with beta at 0.75 - Replace risk-free rate with the 30-year treasury rate as of 1/2/26 with beta at 1.00

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.

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 100 basis points Reply here with the terminal value. Round it to the nearest whole number in millions.

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 WACC by 60bps and update sales growth to 0.5% every year for the projection period to get your answer. Round it to two decimal places. Write out your answer here.

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 EV in thousands of dollars. Report EV/EBITDA to two decimal points. Calculate the following, and report it back to me with a message here: - Adjusted TTM EBITDA including SBC addback - Adjusted TTM EBITDA excluding SBC addback - EV as of 12/17/25 (use basic weighted-average shares from the latest 10-Q and include all lease liabilities) - EV / adjusted TTM EBITDA (incl SBC) - EV / adjusted TTM EBITDA (excl SBC) Note: Adjusted EBITDA defined as operating income and cash-flow non-cash addbacks, excluding non-cash operating lease cost.

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 in the DCF model: replace the risk-free rate with the 5-year Treasury rate as of Dec 15, 2025, and use 4.33% as the total equity risk premium for the United States of America. Then, apply the following changes for the forecast years 2025E-2029E: reduce the operating margin by 2 percentage points in each forecast year, set the yearly revenue growth rate to 1.22% in each forecast year, and set CAPEX equal to D&A in each forecast year. Keep everything else the same. When you reply, round the values to two decimal places, express in $millions.

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 final day - 52 week high closing price - 52 week low closing price - last 30 trading day VWAP - last 90 trading day VWAP Report percentages to one decimal place. Use unadjusted prices and calculate VWAP based on the daily closing prices. All dates are in MM/DD/YYYY format. Reply back with your answer here.

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.

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 derive the deal implied Kenvue market price per share at 16 Dec 25. What are the dollar spreads of Kenvue's unadjusted closing price (16 Dec 25) relative to this implied price? Print your final answer to me here. Give it to me as dollars and cents.

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 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 rate I want to know the implied share price, rounded to two decimal places. Can you tell me here?

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.

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 be exactly 0.00%? Assume KVUE' share price before applying a premium is the average closing daily price between 1/1/2025 and 06/30/2025. All other assumptions in the base merger model should not be changed. Return your result as a message, give it in dollars with 2 decimal places.

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.

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 (Median + MAD) approach, with cutoff = 3.0 for outliers (use the standard scaling constant). Then, use this average as exit multiple to calculate terminal value (TV) and baseline EV for Kenvue. What is the implied share price and the difference relative to the initial implied share price as per the DCF model? For final answers, round TV and EV in nearest million, share price and multiples to two decimal places. Carry full precision for intermediate calculations. Print your answer to me here.

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 whole number in millions? I want you to reply with your findings in here. To get the right answer, in the WACC build, assume that KVUE is able to refinance its outstanding debt to the following interest rates: - anything 2030 and shorter is the 5 year treasury rate as of 1/5/26 plus 50 basis points - anything 2033 and longer is the 10 year treasury rate as of 1/5/26 plus 50 basis points

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 until 2029E. 2. Increase existing 2025E – 2029E operating margins by 0.1%. 3. Increase D&A as a % of Net Sales by 0.1% in 2025E, and hold the resulting value flat for 2026E–2029E 4. Increase Operating Current Assets as % of Net Sales in 2025E to 2024A + 0.1% stepping up by 0.1% per year until 2029E. 5. Increase Operating Current Liabilities as % of Net Sales in 2025E to 2024A +0.1% stepping up by 0.1% per year until 2029E. Revise the following financial metrics: 6. Update the WACC calculation in the DCF model by using the 10-year Treasury rate as of Dec 12, 2025 7. Reduce the cost of debt by 0.1%. 8. Add 0.1% to the terminal growth rate. Output the following 1. The revised WACC incorporating the above changes. 2. Difference in the sum of unlevered free cash flow from 2025E – 2029E between the model with the above changes and the original model 3. Difference in terminal value between the model with the above changes and the original model 4. Difference in enterprise value between the model with the above changes and the original model 5. % change in enterprise value between the model with the above changes and the original model 6. Revised implied share price in the model with the above changes 7. % change in revised implied share price between the model with the above changes and the original model Round the implied share price and % values to 2 decimal places and all other values to 0 decimal places. Reply to me with your answer here.

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.

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.

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 exit multiple. Provide values to one decimal place. Write out your reply to me here.

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.

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.

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 net debt 5/ Maximum amount of revolver drawn Term Loan A: Amount: $1.8bn Term: 7 years, straight line amortising Rate: 7-year US Treasury (market rate) + 225bps Arrangement Fee: 0.75% Term Loan B: Amount: $600m Term: 10 years, bullet repayment Rate: 10-year US Treasury (market rate) + 275bps Arrangement Fee: 0.75% Revolver: Amount: $600m Rate: 5.5% Round percentages and multiples to two decimal places, and dollar amounts in millions, rounded to the nearest whole number. Assume market rates from 28-Nov-2025 (U.S. Treasury Daily CMT).

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. Update revenue growth rate for 2027 to achieve this. Then adjust operating expenses (excluding R&D) in year 2028 so that its 2024-2028 CAGR is one half PWSC's 2019-2023 G&A CAGR. Lastly, update the DCF with the average 10-year treasury rate for 12/2/2025 - 12/19/2025.

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 two decimal places: - Implied DCF share price with a terminal growth rate of 1.25% and 5-year risk free rate of 12/12/2025 - Implied DCF share price with a terminal growth rate of 1.25% and 7-year risk free rate of 12/12/2025 - Implied DCF share price with a terminal growth rate of 1.75% and 5-year risk free rate of 12/12/2025 - Implied DCF share price with a terminal growth rate of 1.75% and 7-year risk free rate of 12/12/2025

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 and the 5 year treasury rates as of 12/22/2025 plus 100 basis points. Set revenue growth rate to 12% for the entirety of the projection period and update the equity beta to 1.3. Don't edit any files, just print your answer back here.

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 comparable analysis file with the lowest EV/Revenue multiple. 2. Replace KSchool's gross margin rate for the projection periods with the FY 2024 gross margin of the competitor identified above and add +10%. 3. Replace KSchool's Operating expenses rate for the projection periods as the average of SG&A expenses as a percentage of revenue of the competitor from FY 2021 to FY 2024. 4. Update the risk-free rate to be the 20 year treasury yield from Oct 20, 2025.

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. The client wants to make the following adjustments to the DCF model. - Revise the COGS assumptions for both Cost of Product & Cost of software and rentals as a % of Revenue, and make it a three-year moving average for 2025E and future years. For years 2026E, 2027E, 2028E and 2029E, add 25 basis points to each year's three-year moving average. Update the gross profit based on these assumptions - Revise the Selling, general and administrative expenses by making it a three-year moving average for 2025E and future years - Revise the Research and development expenses to 10% of sales for years 2026E through 2029E if prior years discounted cashflows exceed $1,000 mm and apply a three-year moving average for years where discounted cashflows are below $1,000 mm - Revise the revenue growth assumptions by changing 2025E growth to -0.5% for both Sales of Product & Sales of Software and Rentals. For years 2026E through 2029E, use a three year moving average for each year and subtract 50 basis points from that calculated growth rate each year - Use a WACC calculated by using only Zimmer Biomet and Smith & Nephew in WACC Calculation as comparables - Use a terminal growth rate of 1.5% Return a short message explaining to me: 1. Sum of Discounted Value of cashflows for 2025E through 2029E excluding the terminal value. 2. Terminal Value. 3. Discounted Terminal Value. 4. Enterprise Value 5. Discounted Terminal Value as a percentage of Enterprise Value.

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 for MMM to the XLI ETF. Using the CAPM, calculate the cost of equity (Ke) for each company. Assume an expected market return of 12% and a risk-free rate of 3.95%. Print the answers back here. Use the accretion dilution model for stock prices for SOLV and MMM. Use the XLV Healthcare ETF and XLI Industrials ETF files for stock prices for the XLV and XLI ETFs. Use adjusted close prices. Present betas as a decimal, rounded to two decimal places. Present the cost of equity as a percentage, rounded to 1 decimal place.

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 following incremental assumptions: - Revenue Growth Rate: 2.0% beginning in FY25E through the end of the forecast period FY29E - SOLV Interest Rate: 5.50% to forecast interest expense - Other expense (income), net: Remains $0.00 in each period - Cost of Equity: Use the average of cost of equity of the three comps used in the WACC calculation (Exclude Zimmer Biomet) - Capex: 110.0% of D&A beginning in FY25E through the end of the forecast period FY29E With all that, calculate the implied price per share to 2 decimal places. Reply straight back to me here.

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 Flows (2025–2029) - Terminal Free Cash Flow (2029) - Terminal Growth Rate (g) - WACC Assume that 3M ownership stake = 20% and: 1. Compute 3M’s stake value using the current DCF Enterprise Value. 2. Reduce each of the FCFs for 2025–2029 by 10% and recalculate the PV of those 5 cash flows using the 7.6% WACC. 3. Recalculate the Terminal Value using the reduced 2029 FCF but keeping the same 3% terminal growth rate and 7.6% WACC. 4. Combine the new PV(FCFs) and PV(TV) to estimate a downside Enterprise Value, and compute the implied downside stake value for 3M. 5. Calculate the percentage loss based on the implied stake values Present your findings in a new deck with: - 3M's Current Implied Stake Value - Sum of PV of Revised Discounted FCFs - Recalculated Terminal Value discounted to the Present - 3M's Revised Stake Value - Percentage Loss

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. - Change Research & Development expenses as % of Sales to 15% wherein the discounted cashflow is higher than $1,100 mm in the preceding year, and to 10% wherein the discounted cashflow is lower than $1,100 mm in the preceding year for the years 2026E through 2029E. - Remove the comparable Koninklijke Philips from the WACC calculation. - Change the terminal growth rate to 2.0%. - Convert fixed CAPEX to a % of sales, and project using the last 3-year moving average to calculate it for the years 2025E through 2029E. - Update the discounting with 1/12 for 2025E, given that we are at the start of Dec 2025. Adjust the future years discounting convention accordingly. - Pull shares outstanding and Net debt from the "Assumptions S1" tab. Round the final deliverable to two decimal places and express in $ terms. Give me your response right here.

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 1.15 2. Risk free rate is 4.00% 3. Equity risk premium is 5.50% 4. Calculate cost of equity using CAPM: Risk-free rate + Beta*Equity Risk Premium 5. Implied Return = SOLV Net Income/Purchase Price Paid 6. Assume Spread is calculated by Implied Return - WACC 7. For PF WACC, use 3M's existing cost of debt from Scenario 1 and assume the incremental acquisition debt carries a 10.00% interest rate (consistent with Scenario 1 assumptions). Print the output here. Format all final percentages to two decimal places.