NCI
Neo-Concept International Group Holdings Limited Class A
stock NASDAQ

Spot at time of post: 
* Silver: $63.55
* Gold: $4,338.39
PROOF: [https://coindex.app/a/FV4RlS](https://coindex.app/a/FV4RlS)
PHOTOS OF EACH ITEM WITH EACH ITEM LISTED
\*More photos available on request
Price is good with Silver under $65 | Gold Under $4,400 or until my next post

BIN FOR PRIORITY
\*I WILL NOT MESSAGE YOU FIRST\*

Account is 2FA secured and do not give out my password
Shipping:
* $13 USPS Priority (REQUIRED for above 4 ounces or anything bulky/large)
* $7 USPS GA (4 ounces or less ONLY)
* All orders will ship next business day
* Tracking and pictures will be provided
* Everything is packed very well and with care (see my great feedback)
Payment Accepted:
* Zelle (preferred)
* Venmo (preferred)
* Cashapp
* Paypal

Items for Sale:
**Pre-33 Gold: (Check Comps)**
🔥[1915 $5 Indian ICG MS61](https://coindex.app/a/aXVDYh)  $1150
🔥[1909 $5 Indian NCI MS63](https://coindex.app/a/23OA7a)  $1275
🔥[1912 $10 Indian NCI MS62](https://coindex.app/a/G7l5yI)  $2300
🔥[1893 $10 Liberty NGC MS62](https://coindex.app/a/jCp1gw)  $2300
🔥[1901 $5 Liberty NGC AU58](https://coindex.app/a/1sfVqj)  $1150
**Gold:**
[2022 1/10 oz Gold Reverse Proof Spanish Lynx](https://coindex.app/a/DHMbY7)  $525
[2020 1/10 oz Gold Canada Bald Eagle in sealed OGP](https://coindex.app/a/aGAaRS) $475
[1g Gold Monarch Precious Metals Ship](https://coindex.app/a/gHsPdA)  $160
[2012 1/4 Sovereign Great Britain First Strike PCGS PR69DCAM (mintage 7,579)](https://coindex.app/a/nyqd0o)  $400
**Hand Pours:**
🔥🔥🔥[12oz .9999% Canadian Silver Tomoko’s Enterprize Woman in Nude 1 of 1 Hand Pour w/ COA](https://coindex.app/a/nDl6QQ)  $995
[5oz Silver Monarch Precious Metals Viking Warrior w/ Double Axe Hand Pour](https://coindex.app/a/jxJ9hW)  $375
[2oz Silver Monarch Precious Metals Sugar Skull](https://coindex.app/a/dmQUfI)  $165
🔥[28.54g Silver Homer Simpson Lego Hand Pour](https://coindex.app/a/9T1W2i)  $195
🔥[14.38g Silver Labubu Hand Pour](https://coindex.app/a/jdzG5u)  $112
🔥2x [1oz Silver Mutiny Metals Plague Doctor UV Glow](https://coindex.app/a/tGtXsa)  $140 each
🔥[1/2oz Silver Mutiny Metals Plague Doctor Mask UV Glow](https://coindex.app/a/Yy6mVx)  $75
🔥[1/2oz Silver Mutiny Metals Grim Reaper UV Glow](https://coindex.app/a/ESPZ7o)  $75
🔥[1/2oz Silver Mutiny Metals Hangman UV Glow](https://coindex.app/a/LZcNxa)  $75
**NORFED:**
2x [2005 1oz Silver $20 NORFED Proof Like](https://coindex.app/a/v7kVas)  $135 each
**Engelhard:**
🔥[10oz Rare Canadian Hand Poured Bull Logo](https://coindex.app/a/Hd9eLL)  $950
[10 oz No Dot Bull Logo](https://coindex.app/a/MUUrXt)  $775
**Pandas:**
[2021 Panda NGC MS69](https://coindex.app/a/ysd5zf)  $130
[2007 25th Anniversary 1/4 oz - 1988 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/WwId6O)  $85
[2007 25th Anniversary 1/4 oz - 1991 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/9l4aMg)  $85
[2007 25th Anniversary 1/4 oz - 1992 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/I85YIC)  $85
[2007 25th Anniversary 1/4 oz - 1993 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/P4cIUa)  $85
[2007 25th Anniversary 1/4 oz - 1996 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/gH7XNi)  $85
[2007 25th Anniversary 1/4 oz - 1997 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/stpfLr)  $85
**Libertads, Mexican & Panama** 
🔥🔥[1796 8 Reales w/ Chop Marks & 1795 2 Reales](https://coindex.app/a/lIjaVW)  $250
[1983 Libertad (Capsule)](https://coindex.app/a/W91lMF)  $85
🔥[1981 Mexican 20 Centavos Mint Error Partial Brockage PCGS MS62](https://coindex.app/a/WAzOYO)  $150
[1932 Mexican Un Peso Open 9 KM-455 PCGS MS66](https://coindex.app/a/q8BA6J)  $115
🔥[1934 Panama Balboa NGC AU58](https://coindex.app/a/xBbXcE)  $150
**Silver Eagles:**
🔥1996 (Key Date) Silver Eagle Tube $1700  
🔥[2021 W (West Point) Eagle Landing Type 2 First Day of Issue NGC PF70 Ultra Cameo Signed by John M. Mercanti](https://coindex.app/a/eeyeJH)  $175
[1998 P Eagle NGC PF70 Ultra Cameo](https://coindex.app/a/haagVV)  $175
[2022 S Eagle PF70 Ultra Cameo Signed by Edmund C. Moy](https://coindex.app/a/0TWvME)  $110
[2020 W (West Point) Eagle First Strike PCGS MS69](https://coindex.app/a/6vTSdu)  $95
🔥[2006 20th Anniversary Eagle Set (West Point Proof, West Point Uncirculated & P Reverse Proof)](https://coindex.app/a/AozmiJ)  $275
**Morgans:**
🔥🔥[1885-CC (Carson City) Morgan PCGS MS63](https://coindex.app/a/nY17Va)  $900
🔥[1882-CC (Carson City) Morgan CAC MS64 in original GSA OGP](https://coindex.app/a/VpCit4)  $
🔥[1884-CC (Carson City Morgan CAC MS62 in original GSA OGP](https://coindex.app/a/WbKC3e)  $
[1883-O Morgan PCGS MS63 Old Green Label ](https://coindex.app/a/OVcOk9) $100
[1884 - O Morgan NGC MS63](https://coindex.app/a/dvqhP6)  $85
[1896 Morgan](https://coindex.app/a/0JYtQM)  $65
[1881 Morgan](https://coindex.app/a/kU1ecH)  $65
[1883-O Morgan](https://coindex.app/a/x8YzRW)  $65
[1885 Morgan](https://coindex.app/a/egpE92)  $65
**U.S. Mint Other:**
🔥🔥[1937 Proof Mercury Dime PCGS PR67 (Mintage:  )](https://coindex.app/a/iKfjie)  $700
🔥[1876-CC (Carson City) Sitting Quarter ](https://coindex.app/a/WPdCqV) $150
[1991-1995 P 50C World War II Anniversary Proof PF69 Ultra Cameo](https://coindex.app/a/daP9uY)  $40
**Canada**
[2022 1oz Silver Rhodium Plated Queen Elizabeth II’s Royal Cypher in OGP w/ COA (15k Mintage)](https://coindex.app/a/YpHUeR)  $125
**Australia**
2 x [2026 Kookaburra](https://coindex.app/a/MPoUqg)  $75 each
2x [2026 Koala](https://coindex.app/a/SboxWe)  $75 each
[1992 Emperor Penguin - Birds of Australia Piedfort in OGP](https://coindex.app/a/x4flx1)  $145
[2015 Australian Funnel Web Spider](https://coindex.app/a/43wBzR)  $75
**KOMSCO**
[2020 Chiwoo Cheonwang](https://coindex.app/a/eAbMT0)  $80
**Sexy Silver & Copper**
[Goddess of Elements Copper Rounds - 4x 1 oz - Goddess of Fire, Earth, Water & Wind ](https://coindex.app/a/miQL2R) $45 for all 5 
[Colorized Copper Nice/Naughty Baddie Red Head Nude](https://coindex.app/a/H8moGL)  $15
[Colorized Copper Nice/Naughty Baddie Black Hair ](https://coindex.app/a/xPG4Aq) $15
**Other**
🔥[2002 26.64g Silver Gold Plated USPS Heroes of 2001 First Class Stamp](https://coindex.app/a/vb9buh)  $85
🔥2x [2026 1oz Hot Wheels Monster Trucks Mega Wrex in OGP (5k Limited Mintage)](https://coindex.app/a/8NF4lm)  $86 each
2x [2019 1oz SilverTowne Apollo 11 50th Anniversary](https://coindex.app/a/yN9i6C)  $75 each
[2004 4oz Silver Washington Mint $10 Bill](https://coindex.app/a/dcwNAg)  $295 (Both Bills for $595)
[2005 4oz Silver Gold Plated Washington Mint $20 Bill](https://coindex.app/a/77Xer6)  $325 (Both Bills for $595)
[2026 SMI 250th U.S. Anniversary Privy Silver & Copper Tribute Rounds Package (6 rounds total, 3 Silver & 3 Copper) ](https://coindex.app/a/KAYFUS) $250
Morgan Silver & Copper Tribute, Buffalo Silver & Cooper Tribute & Eagle Silver & Copper Tribute
[2021 Samoa Seahorse (mintage 15,000)](https://coindex.app/a/8cnCYP) $75

Hey, just took a quick look through the model. Overall, I think it’s a solid foundation, but there are a few things I would probably consider revisiting in the next iteration 😊
I would probably model invested capital explicitly and introduce a terminal RONIC assumption rather than letting terminal FCF just fall out of the final-year capex, D&A and NWC numbers.
Based on the current 2030 numbers, I get net reinvestment of only around USD 0.9bn on c. USD 13.1bn of NOPAT. With 2.75% terminal growth, that seems to imply a RONIC of roughly 40%. That feels pretty high to me (however, happy to be corrected on that).
I suggest using the value-driver framework here, i.e. reinvestment rate = g / RONIC, and then solve for the reinvestment/capex needed in the terminal year. Otherwise you can quite easily end up with a terminal year where the company is growing without really reinvesting enough to support that growth (quite common mistake in DCF’s in my experience).
I would also revisit the PP&E schedule and the constant 11.1% D&A as a % of beginning PP&E. It works as a shortcut, but once capex starts moving around it can look a bit odd. If you want a nice modelling exercise you could build a separate D&A schedule based on existing PP&E + new annual capex. Painful the first time you do it haha, but rewarding when it is done (and can be copied to other models easily)
On NWC, The DPO calculation currently uses the full “accounts payable and accrued expenses” balance against COGS. Coca Cola’s 2025 balance was c. USD 14.8bn, but only c. USD 5.6bn of that was actual accounts payable. The rest includes things like marketing accruals, compensation accruals, lease liabilities etc. So… I’m not really sure the resulting 300+ day DPO is telling you much about supplier payment terms or how working capital will develop going forward.
I suggest to either 1) isolate actual AP and model the other accruals separately, or 2) just forecast normalized operating NWC as a % of sales for simplicity.
I initially wondered if leases were causing a cash flow issue, because that’s a pretty common DCF mistake, but having checked the 10-K I actually think you’re broadly fine there. Coca Cola had c. USD 405m of operating lease expense and c. USD 404m of operating lease cash payments in 2025, so there doesn’t seem to be a meaningful cash leakage missing from FCF. As long as you keep treating leases as operating expenses and don’t then also deduct the operating lease liability as debt, I think that part is internally consistent.
I would spend some time normalizing “other operating charges” though. The historical numbers include a lot of stuff that is clearly not normal recurring operating expense, for instance: BodyArmor impairments, fairlife contingent consideration remeasurement etc. If you want to improve the credibility of your baseline, I suggest to not just extrapolate the historical GAAP line. In fact, the current forecast at c. 2.55% of revenue gives you roughly USD 1.3bn of other operating charges every year, whereas Coca Cola only recorded USD 44m in H1 2026. Truth be told, this is always subjective, and I just wanted to flag that one-offs and special items are a black box which are incredibly difficult, and make Big4 Transacation Services departments a lot of money in M&A 😊
A few WACC / bridge points as well:
1)    The WACC uses USD 300.7bn of equity value, while the DCF sheet shows a current share price of USD 87.05. At USD 87.05 the market cap should be closer to USD 375bn, so I think you’re mixing valuation dates somewhere (unless my calculations are off). I also couldn’t see an explicit valuation date in the model, which would be useful to add.
2)    I would use market value of debt rather than book value where you can. Coca Cola discloses c. USD 43.9bn carrying value of long-term debt but only c. USD 39.4bn fair value. Adding the short-term debt gets you to around USD 40.9bn versus the USD 45.5bn currently used.
3)    In general it is best practice to add the source/methodology, for instance, it would be nice to understand how you retrieved the 0.35 beta and ERP. A 5.81% WACC feels… low? I don’t know, my experience within the consumer segment is extremely limited. But, with 2.75% terminal growth, you only have about a 3.1% WACC-g spread, so relatively small changes have a huge impact on value.
4)    On the same point, around 87% of the core EV seems to come from the terminal value. That’s not necessarily “wrong” for a company like Coca Cola, but it is definitely on the high side and means I would want to be very comfortable with the WACC, terminal growth and RONIC assumptions. Alternatively, you could model out 10 years instead of 5? Perhaps that won’t add much value seeing as Coca Cola is at its mature steady state stage already haha.
5)    I would also use mid-year discounting, or ideally exact stub-period discounting if this is supposed to be a current valuation. Your FY2026 is discounted as though all the cash arrives at the end of the year. Unless Coca Cola collects every dollar on December 31st, that’s unnecessarily harsh on the valuation.
Finally, I also noticed some stuff on the EV-EqV bridge:
You’re adding the c. USD 20.2bn of equity-method investments at book value, but Coca Cola actually discloses market values for a lot of the listed stakes. Monster, CCEP, KOF, CCHBC and CCBJ alone were worth around USD 19.6bn more than their accounting carrying values at FY2025 (with some tax leakage adjustments ofc.). And on NCI, I think the c. USD 2.1bn of non-controlling interests should be deducted in the EV-to-equity bridge, since the consolidated operating cash flows include subsidiaries that aren’t 100% owned by Coca Cola.
Overall though, I think it is a quality DCF with clean formatting. The main things I would consider revisiting for a next iteration are probably the terminal reinvestment framework, working capital build, valuation-date consistency and the EV-to-equity bridge.
 

Spot at time of post: 
* Silver: $63.55
* Gold: $4,338.39
PROOF: [https://coindex.app/a/FV4RlS](https://coindex.app/a/FV4RlS)
PHOTOS OF EACH ITEM WITH EACH ITEM LISTED
\*More photos available on request
Price is good with Silver under $65 | Gold Under $4,400 or until my next post

BIN FOR PRIORITY
\*I WILL NOT MESSAGE YOU FIRST\*

Account is 2FA secured and do not give out my password
Shipping:
* $13 USPS Priority (REQUIRED for above 4 ounces or anything bulky/large)
* $7 USPS GA (4 ounces or less ONLY)
* All orders will ship next business day
* Tracking and pictures will be provided
* Everything is packed very well and with care (see my great feedback)
Payment Accepted:
* Zelle (preferred)
* Venmo (preferred)
* Cashapp
* Paypal

Items for Sale:
**Pre-33 Gold: (Check Comps)**
🔥[1915 $5 Indian ICG MS61](https://coindex.app/a/aXVDYh)  $1150
🔥[1909 $5 Indian NCI MS63](https://coindex.app/a/23OA7a)  $1275
🔥[1912 $10 Indian NCI MS62](https://coindex.app/a/G7l5yI)  $2300
🔥[1893 $10 Liberty NGC MS62](https://coindex.app/a/jCp1gw)  $2300
🔥[1901 $5 Liberty NGC AU58](https://coindex.app/a/1sfVqj)  $1150
**Gold:**
[2022 1/10 oz Gold Reverse Proof Spanish Lynx](https://coindex.app/a/DHMbY7)  $525
[2020 1/10 oz Gold Canada Bald Eagle in sealed OGP](https://coindex.app/a/aGAaRS) $475
[1g Gold Monarch Precious Metals Ship](https://coindex.app/a/gHsPdA)  $160
[2012 1/4 Sovereign Great Britain First Strike PCGS PR69DCAM (mintage 7,579)](https://coindex.app/a/nyqd0o)  $400
**Hand Pours:**
🔥🔥🔥[12oz .9999% Canadian Silver Tomoko’s Enterprize Woman in Nude 1 of 1 Hand Pour w/ COA](https://coindex.app/a/nDl6QQ)  $995
[5oz Silver Monarch Precious Metals Viking Warrior w/ Double Axe Hand Pour](https://coindex.app/a/jxJ9hW)  $375
[2oz Silver Monarch Precious Metals Sugar Skull](https://coindex.app/a/dmQUfI)  $165
🔥[28.54g Silver Homer Simpson Lego Hand Pour](https://coindex.app/a/9T1W2i)  $195
🔥[14.38g Silver Labubu Hand Pour](https://coindex.app/a/jdzG5u)  $112
🔥2x [1oz Silver Mutiny Metals Plague Doctor UV Glow](https://coindex.app/a/tGtXsa)  $140 each
🔥[1/2oz Silver Mutiny Metals Plague Doctor Mask UV Glow](https://coindex.app/a/Yy6mVx)  $75
🔥[1/2oz Silver Mutiny Metals Grim Reaper UV Glow](https://coindex.app/a/ESPZ7o)  $75
🔥[1/2oz Silver Mutiny Metals Hangman UV Glow](https://coindex.app/a/LZcNxa)  $75
**NORFED:**
2x [2005 1oz Silver $20 NORFED Proof Like](https://coindex.app/a/v7kVas)  $135 each
**Engelhard:**
🔥[10oz Rare Canadian Hand Poured Bull Logo](https://coindex.app/a/Hd9eLL)  $950
[10 oz No Dot Bull Logo](https://coindex.app/a/MUUrXt)  $775
**Pandas:**
[2021 Panda NGC MS69](https://coindex.app/a/ysd5zf)  $130
[2007 25th Anniversary 1/4 oz - 1988 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/WwId6O)  $85
[2007 25th Anniversary 1/4 oz - 1991 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/9l4aMg)  $85
[2007 25th Anniversary 1/4 oz - 1992 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/I85YIC)  $85
[2007 25th Anniversary 1/4 oz - 1993 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/P4cIUa)  $85
[2007 25th Anniversary 1/4 oz - 1996 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/gH7XNi)  $85
[2007 25th Anniversary 1/4 oz - 1997 Panda Design - PF69 Ultra Cameo](https://coindex.app/a/stpfLr)  $85
**Libertads, Mexican & Panama** 
🔥🔥[1796 8 Reales w/ Chop Marks & 1795 2 Reales](https://coindex.app/a/lIjaVW)  $250
[1983 Libertad (Capsule)](https://coindex.app/a/W91lMF)  $85
🔥[1981 Mexican 20 Centavos Mint Error Partial Brockage PCGS MS62](https://coindex.app/a/WAzOYO)  $150
[1932 Mexican Un Peso Open 9 KM-455 PCGS MS66](https://coindex.app/a/q8BA6J)  $115
🔥[1934 Panama Balboa NGC AU58](https://coindex.app/a/xBbXcE)  $150
**Silver Eagles:**
🔥1996 (Key Date) Silver Eagle Tube $1700  
🔥[2021 W (West Point) Eagle Landing Type 2 First Day of Issue NGC PF70 Ultra Cameo Signed by John M. Mercanti](https://coindex.app/a/eeyeJH)  $175
[1998 P Eagle NGC PF70 Ultra Cameo](https://coindex.app/a/haagVV)  $175
[2022 S Eagle PF70 Ultra Cameo Signed by Edmund C. Moy](https://coindex.app/a/0TWvME)  $110
[2020 W (West Point) Eagle First Strike PCGS MS69](https://coindex.app/a/6vTSdu)  $95
🔥[2006 20th Anniversary Eagle Set (West Point Proof, West Point Uncirculated & P Reverse Proof)](https://coindex.app/a/AozmiJ)  $275
**Morgans:**
🔥🔥[1885-CC (Carson City) Morgan PCGS MS63](https://coindex.app/a/nY17Va)  $900
🔥[1882-CC (Carson City) Morgan CAC MS64 in original GSA OGP](https://coindex.app/a/VpCit4)  $
🔥[1884-CC (Carson City Morgan CAC MS62 in original GSA OGP](https://coindex.app/a/WbKC3e)  $
[1883-O Morgan PCGS MS63 Old Green Label ](https://coindex.app/a/OVcOk9) $100
[1884 - O Morgan NGC MS63](https://coindex.app/a/dvqhP6)  $85
[1896 Morgan](https://coindex.app/a/0JYtQM)  $65
[1881 Morgan](https://coindex.app/a/kU1ecH)  $65
[1883-O Morgan](https://coindex.app/a/x8YzRW)  $65
[1885 Morgan](https://coindex.app/a/egpE92)  $65
**U.S. Mint Other:**
🔥🔥[1937 Proof Mercury Dime PCGS PR67 (Mintage:  )](https://coindex.app/a/iKfjie)  $700
🔥[1876-CC (Carson City) Sitting Quarter ](https://coindex.app/a/WPdCqV) $150
[1991-1995 P 50C World War II Anniversary Proof PF69 Ultra Cameo](https://coindex.app/a/daP9uY)  $40
**Canada**
[2022 1oz Silver Rhodium Plated Queen Elizabeth II’s Royal Cypher in OGP w/ COA (15k Mintage)](https://coindex.app/a/YpHUeR)  $125
**Australia**
2 x [2026 Kookaburra](https://coindex.app/a/MPoUqg)  $75 each
2x [2026 Koala](https://coindex.app/a/SboxWe)  $75 each
[1992 Emperor Penguin - Birds of Australia Piedfort in OGP](https://coindex.app/a/x4flx1)  $145
[2015 Australian Funnel Web Spider](https://coindex.app/a/43wBzR)  $75
**KOMSCO**
[2020 Chiwoo Cheonwang](https://coindex.app/a/eAbMT0)  $80
**Sexy Silver & Copper**
[Goddess of Elements Copper Rounds - 4x 1 oz - Goddess of Fire, Earth, Water & Wind ](https://coindex.app/a/miQL2R) $45 for all 5 
[Colorized Copper Nice/Naughty Baddie Red Head Nude](https://coindex.app/a/H8moGL)  $15
[Colorized Copper Nice/Naughty Baddie Black Hair ](https://coindex.app/a/xPG4Aq) $15
**Other**
🔥[2002 26.64g Silver Gold Plated USPS Heroes of 2001 First Class Stamp](https://coindex.app/a/vb9buh)  $85
🔥2x [2026 1oz Hot Wheels Monster Trucks Mega Wrex in OGP (5k Limited Mintage)](https://coindex.app/a/8NF4lm)  $86 each
2x [2019 1oz SilverTowne Apollo 11 50th Anniversary](https://coindex.app/a/yN9i6C)  $75 each
[2004 4oz Silver Washington Mint $10 Bill](https://coindex.app/a/dcwNAg)  $295 (Both Bills for $595)
[2005 4oz Silver Gold Plated Washington Mint $20 Bill](https://coindex.app/a/77Xer6)  $325 (Both Bills for $595)
[2026 SMI 250th U.S. Anniversary Privy Silver & Copper Tribute Rounds Package (6 rounds total, 3 Silver & 3 Copper) ](https://coindex.app/a/KAYFUS) $250
Morgan Silver & Copper Tribute, Buffalo Silver & Cooper Tribute & Eagle Silver & Copper Tribute
[2021 Samoa Seahorse (mintage 15,000)](https://coindex.app/a/8cnCYP) $75

Hey, just took a quick look through the model. Overall, I think it’s a solid foundation, but there are a few things I would probably consider revisiting in the next iteration 😊
I would probably model invested capital explicitly and introduce a terminal RONIC assumption rather than letting terminal FCF just fall out of the final-year capex, D&A and NWC numbers.
Based on the current 2030 numbers, I get net reinvestment of only around USD 0.9bn on c. USD 13.1bn of NOPAT. With 2.75% terminal growth, that seems to imply a RONIC of roughly 40%. That feels pretty high to me (however, happy to be corrected on that).
I suggest using the value-driver framework here, i.e. reinvestment rate = g / RONIC, and then solve for the reinvestment/capex needed in the terminal year. Otherwise you can quite easily end up with a terminal year where the company is growing without really reinvesting enough to support that growth (quite common mistake in DCF’s in my experience).
I would also revisit the PP&E schedule and the constant 11.1% D&A as a % of beginning PP&E. It works as a shortcut, but once capex starts moving around it can look a bit odd. If you want a nice modelling exercise you could build a separate D&A schedule based on existing PP&E + new annual capex. Painful the first time you do it haha, but rewarding when it is done (and can be copied to other models easily)
On NWC, The DPO calculation currently uses the full “accounts payable and accrued expenses” balance against COGS. Coca Cola’s 2025 balance was c. USD 14.8bn, but only c. USD 5.6bn of that was actual accounts payable. The rest includes things like marketing accruals, compensation accruals, lease liabilities etc. So… I’m not really sure the resulting 300+ day DPO is telling you much about supplier payment terms or how working capital will develop going forward.
I suggest to either 1) isolate actual AP and model the other accruals separately, or 2) just forecast normalized operating NWC as a % of sales for simplicity.
I initially wondered if leases were causing a cash flow issue, because that’s a pretty common DCF mistake, but having checked the 10-K I actually think you’re broadly fine there. Coca Cola had c. USD 405m of operating lease expense and c. USD 404m of operating lease cash payments in 2025, so there doesn’t seem to be a meaningful cash leakage missing from FCF. As long as you keep treating leases as operating expenses and don’t then also deduct the operating lease liability as debt, I think that part is internally consistent.
I would spend some time normalizing “other operating charges” though. The historical numbers include a lot of stuff that is clearly not normal recurring operating expense, for instance: BodyArmor impairments, fairlife contingent consideration remeasurement etc. If you want to improve the credibility of your baseline, I suggest to not just extrapolate the historical GAAP line. In fact, the current forecast at c. 2.55% of revenue gives you roughly USD 1.3bn of other operating charges every year, whereas Coca Cola only recorded USD 44m in H1 2026. Truth be told, this is always subjective, and I just wanted to flag that one-offs and special items are a black box which are incredibly difficult, and make Big4 Transacation Services departments a lot of money in M&A 😊
A few WACC / bridge points as well:
1)    The WACC uses USD 300.7bn of equity value, while the DCF sheet shows a current share price of USD 87.05. At USD 87.05 the market cap should be closer to USD 375bn, so I think you’re mixing valuation dates somewhere (unless my calculations are off). I also couldn’t see an explicit valuation date in the model, which would be useful to add.
2)    I would use market value of debt rather than book value where you can. Coca Cola discloses c. USD 43.9bn carrying value of long-term debt but only c. USD 39.4bn fair value. Adding the short-term debt gets you to around USD 40.9bn versus the USD 45.5bn currently used.
3)    In general it is best practice to add the source/methodology, for instance, it would be nice to understand how you retrieved the 0.35 beta and ERP. A 5.81% WACC feels… low? I don’t know, my experience within the consumer segment is extremely limited. But, with 2.75% terminal growth, you only have about a 3.1% WACC-g spread, so relatively small changes have a huge impact on value.
4)    On the same point, around 87% of the core EV seems to come from the terminal value. That’s not necessarily “wrong” for a company like Coca Cola, but it is definitely on the high side and means I would want to be very comfortable with the WACC, terminal growth and RONIC assumptions. Alternatively, you could model out 10 years instead of 5? Perhaps that won’t add much value seeing as Coca Cola is at its mature steady state stage already haha.
5)    I would also use mid-year discounting, or ideally exact stub-period discounting if this is supposed to be a current valuation. Your FY2026 is discounted as though all the cash arrives at the end of the year. Unless Coca Cola collects every dollar on December 31st, that’s unnecessarily harsh on the valuation.
Finally, I also noticed some stuff on the EV-EqV bridge:
You’re adding the c. USD 20.2bn of equity-method investments at book value, but Coca Cola actually discloses market values for a lot of the listed stakes. Monster, CCEP, KOF, CCHBC and CCBJ alone were worth around USD 19.6bn more than their accounting carrying values at FY2025 (with some tax leakage adjustments ofc.). And on NCI, I think the c. USD 2.1bn of non-controlling interests should be deducted in the EV-to-equity bridge, since the consolidated operating cash flows include subsidiaries that aren’t 100% owned by Coca Cola.
Overall though, I think it is a quality DCF with clean formatting. The main things I would consider revisiting for a next iteration are probably the terminal reinvestment framework, working capital build, valuation-date consistency and the EV-to-equity bridge.