Investment Banking World 246

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.