Quick Fix Summary
Need company financials or a valuation model fast? Pop into Capital IQ, grab the Excel plug-in from MyCapitalIQ → Downloads, log in with your usual credentials, then fire up the Valuation → WACC template. The numbers fill in themselves—no copy-paste marathons.
What’s Happening
Capital IQ is a market-intelligence platform from S&P Global.
It takes messy financial data from more than 62,000 public companies and 4.4 million private firms and turns it into clean, apples-to-apples numbers. The Excel plug-in then hands you a live data feed so you can refresh models without retyping every line.
Step-by-Step Solution
Log in, install the plug-in, open the WACC template, and let the data pour in.
- Log In & Download Head to MyCapitalIQ → Downloads. Pick the Windows 64-bit or 32-bit version that matches your Excel install. Download, run the installer, and you’re halfway there.
- Install & Authenticate After the installer finishes, open Excel. A shiny new Capital IQ tab shows up in the ribbon. Click Settings and punch in the same email and password you use for the web portal. No extra accounts to remember.
- Open the WACC Template From the Capital IQ tab, drill down to Templates → Valuation → WACC. The template opens with all the formulas already wired up and placeholders ready for your company ticker.
- Populate & Calculate Drop your company’s ticker into the cell—AAPL for Apple, for example. Hit Ctrl + Alt + C to refresh. The WACC output flips to the latest numbers in seconds.
If This Didn’t Work
Check your connection, confirm the plug-in version, and verify your permissions.
- Offline Mode Make sure your computer is online. The plug-in won’t pull live data if it’s stuck on airplane mode or a coffee-shop Wi-Fi that blocks downloads. Behind a corporate proxy? Set it in Capital IQ Settings → Proxy so the plug-in can phone home.
- Version Mismatch Uninstall the plug-in, then grab the newest build from MyCapitalIQ → Downloads. As of 2026, Excel 2019 (build 16.0.10001 or newer) is the oldest version that still plays nice.
- Permission Issue Double-check your Capital IQ profile—you need at least “Analyst” level access. If you’re staring at an “Access Denied” error, ping your subscription manager and ask for a quick permissions bump.
Prevention Tips
Keep the plug-in fresh, back up your work, and sanity-check your assumptions.
- Run a quarterly plug-in update from MyCapitalIQ → About → Check for Updates so you don’t get blindsided by a compatibility hiccup.
- Store a backup of your WACC template in OneDrive with version history turned on (File → Info → Version History). One stray click won’t wipe out weeks of tweaks.
- Before you lock in a WACC number, cruise over to Coverage → Earnings Call Transcripts and read what management says about debt covenants and capital costs. Their commentary can save you from using stale inputs.
