Project Vantrell — Healthcare IT Valuation
A 2-hour Healthcare IT / Special Committee Valuation case study with a complete model answer
Modeled After
Qatalyst Partners
Special committee valuation for a healthcare technology and business process outsourcing company: comparables split into two labeled cohorts, an Evolution of Street EBITDA Estimates Over Time page annotated with the events that moved consensus, analyst price targets with each broker's methodology itemized, cost of capital across both historical and predicted betas, and a net operating loss schedule run to expiry
Structure and exhibit set are modeled after Qatalyst Partners. The company, the financials and every figure in this case are entirely our own.
The Situation
Vantrell Care Analytics, Inc. (Nasdaq: VNTC) sells two things that do not share an economic model.
Vantrell Care Analytics, Inc.
- Sector
- Health information technology — half subscription software, half outsourced revenue-cycle services, reported as two segments since February 2026
- Size
- Geography
- United States; Nasdaq-listed
- Ownership
- Situation
The Prompt
You are the financial advisor to the Special Committee of the Board of Directors of Vantrell Care Analytics, Inc.
Supporting Materials
What you are handed at the start of the case, in the format a real process would use.
What You Have to Produce
The deliverables, in the order the committee will read them. The exercise runs 120 minutes.
PART 1
Declare the membership criterion before you name anybody
PART 2
Screen the extract, and make the screen testable
PART 3
Two cohorts, and the dispersion inside each before the difference between them
PART 4
Restate both cohorts onto a charged earnings basis
PART 5
The evolution of street estimates, and which half of the company moved
PART 6
Cost of capital on two beta measures, and a discounted cash flow that charges the cost
PART 7
The loss carryforwards, to expiry and under an ownership change
PART 8
Price targets with methodology, the football field, and the recommendation
How to Approach It
The order a strong candidate works in, and why. This is the shape of the answer — the finished answer deck and Excel model are in the solution set below.
- 01
Write the criterion down before you open the extract properly
- 02
Screen on the descriptive fields, never on the ratio column
- 03
Build the dispersion rows before you build the summary row
- 04
Restate onto the charged basis and check the direction, not the magnitude
- 05
Place the subject on every measure, including the ones that disagree
- 06
Keep the two earnings bases apart, and keep the tax attribute outside the multiples
- 07
Sort the price targets by the methodology behind them
- 08
Derive both bounds from rules, and say both halves of the answer
Key Concepts
The ideas this case is built on. Know these cold and the case becomes a question of execution rather than knowledge.
A membership criterion, declared in advance
A peer set is an argument, and the criterion is what the argument rests on. Declaring the test and the threshold before any constituent is named is what makes the set testable: a reader can apply your rule to the raw extract and get your cohorts back. Declared afterwards, the same rule is a description of the set you had already chosen. The strongest version also shows the threshold falls in a gap in the observed data rather than through a cluster, so that any threshold inside that gap yields the same split — which turns the choice into a measurement.
Cohorted comparables rather than one peer group
When a company's two halves are priced several turns apart by the market, a single blended peer median lands somewhere no company in the file actually trades. Splitting the universe into labeled cohorts and carrying a range from each onto the football field keeps the disagreement visible instead of averaging it away. The cost is that you now have to say which cohort the subject belongs to, and defend it — which is exactly the question a blended median exists to avoid.
Dispersion is reported before difference is claimed
The distance between two cohort medians means nothing on its own. What licenses the split is the relationship between that distance and the spread inside each cohort: whether the interquartile ranges are disjoint, whether the full ranges overlap, and whether either cohort's internal spread is wider than the gap between them. Print all of it. A book that prints two medians and no spread has claimed a separation it has not shown, and the caveat is more persuasive than the headline because it proves you looked.
Adjusted EBITDA, the add-back, and moving onto a charged basis
Trading multiples in this sector are struck on Adjusted EBITDA because that is what the market quotes and the only basis on which the constituents can be compared. But adding back stock-based compensation is an omission with a direction, and different cohorts add back very different shares of their earnings. So restate every constituent onto a basis that charges the cost, print both, and state which way charging it moves the comparison. The direction is a computed fact, not an intuition, and a document that claims it without computing it will be wrong roughly half the time.
The evolution of street estimates over time
A forward multiple is a ratio whose denominator has a history. Charting consensus for a single fixed forward year across many quarters, and annotating each inflection with the event that caused it, shows whether the estimate the offer is a multiple of has held or has been walked down. It does not change the multiple you apply, but it tells the committee how much weight the denominator can bear, and splitting the revision by segment usually shows the deterioration is concentrated somewhere the consolidated line hides.
Historical beta and predicted beta
A historical beta is a regression on realized returns over a fixed window; a predicted beta is a fundamental estimate shrunk toward the market. They are not two measurements of one quantity, and the predicted measure is systematically less dispersed because of how it is built rather than because the companies are more alike. Running both through the unlevering and relevering exercise gives four cost-of-capital builds instead of one point estimate, and a range built from four disclosed builds is far easier to defend than a single number with a footnote.
A net operating loss schedule run to expiry
A large carryforward is worth valuing properly rather than netting into the balance sheet. Pre-2018 federal losses expire on a twenty-year clock and are not subject to the eighty percent limitation; post-2017 losses never expire and are. That asymmetry sets the usage order — use the vintages that can actually be lost first — and running the schedule to expiry against projected taxable income shows how much is used, how much expires unused, and what the cash tax saved is worth today. It is a non-operating asset, so it belongs in the bridge and never inside a multiple.
Section 382 and why the limitation is not solved
An acquisition of the shares a holder does not already own is an ownership change, and section 382 caps annual use of pre-change losses at the equity value of the loss corporation immediately before the change multiplied by the long-term tax-exempt rate. The cap is therefore a function of the price paid, which makes solving for a price that depends on it circular. The correct treatment is to evaluate the limitation at the price on the table and print it. The gap between the standalone value and the limited value is a negotiating fact: it is worth more in the company's hands than in the buyer's.
Analyst price targets with the methodology itemised
A target on its own is somebody's opinion and averaging seven of them produces a more confident opinion, not a better one. Printed beside the stated methodology and the peer basis behind it, the same seven targets become evidence about where the disagreement lives. When the targets sort cleanly by peer basis, the spread is the same membership question your own analysis is about, answered independently by seven people who each had to answer it.
A significant minority holder is not a controlling stockholder
Roughly a third of the vote and two board seats is influence rather than control, and controlled-company and squeeze-out language imports a standard of conduct this transaction is not subject to. What protects the minority here is contractual and structural — an independent committee with authority to refuse, and a non-waivable majority-of-the-minority vote — and the ordering matters. Conditions present in the initial proposal letter, before any economic negotiation, are worth considerably more than conditions conceded after a price round.
What Makes It Hard
The specific traps in this case — the places candidates lose the assessment without noticing.
Check Your Answer
Type the figures you produced and find out how many are right before you open the worked answer. You get a verdict and, where you are off, a pointer to the part of the build to re-check — never the number itself. Everything you type stays on this device.
How to type a figure. Digits, with an optional unit: 1,234.5, $1,234.5, 2.6x, 21.4%. For a negative use (20.0) or -20.0. Enter as many decimals as you carried — precision is never penalised.
What the Case Asked For
The arithmetic is only half of it. Tick off what you actually produced — this half is yours to score, because nothing can grade a written recommendation from a checkbox.
The Model Answer
The worked answer in full: answer deck and Excel model, built the way a banker would actually build them. It is a reference, not a submission — a strong answer under the clock is far shorter.
What the Solution Covers
- —Two-cohort comparable company construction
- —Evolution of street estimates over time
- —Analyst price targets with methodology itemized
- —Historical and predicted beta
- —Net operating loss schedule to expiry
- —Football field with cohort-specific ranges
Answer Deck
Full model answer, banker-formatted
Upgrade to Diamond
Sign up and upgrade to Diamond to unlock the answer deck, the Excel model and the audio walkthrough.
Get StartedThe Excel Model
The model is linked and tied out end to end — every schedule, every formula and every check, in the file itself.
Downloads are available to Diamond members
Excel Model and PowerPoint Deck and Answer Deck (PDF) — yours to open, edit and rebuild
Walkthrough
A conversational walkthrough of how to approach the case under time pressure — where to start, what to cut, and how the recommendation gets defended.
Audio Walkthrough
How to approach Project Vantrell — Healthcare IT Valuation
60-second preview — upgrade to Diamond for the full walkthrough
Frequently Asked Questions
Why not just use one peer group and take a median?
Because on this universe a blended median lands where no company in the file actually trades. Half of the comparable set sells subscription software and half sells outsourced labor, and those two things are priced several turns apart by the market. Averaging them produces a number that looks neutral but embeds a decision about how much of each business you think you are buying — and it embeds it where nobody can argue with it. Splitting the set puts the decision on the page where the committee can see it and take a view, which is the whole point of the exercise.
How do I choose the threshold without it looking arbitrary?
Do not defend the number; defend its position. Sort the observed values of your criterion and look for a gap. If your threshold falls inside a gap that contains no company at all, then every threshold inside that gap produces the same two cohorts, and the split no longer depends on the particular number you picked. Say that on the page, with the width of the gap. If instead your threshold cuts through a cluster of companies, then a small move changes the answer, and you have a choice dressed up as a test — which a reader will spot immediately.
The subject company sits between the two cohorts. Isn't that a problem with the criterion?
No — it is the case. A criterion that placed the subject comfortably would not be testing anything. What you owe the committee is a placement based on where the company is today, on the rule you declared, kept separate from any statement about where its own plan carries it and in which year. Those are different claims carrying different weights, and your football field has to make the difference visible — decide which ranges are evidence about the company as it is disclosed today and which are reference, label them accordingly, and be ready to say why. A reader who can take the answer off the picture without knowing which is which has been handed a conclusion rather than an analysis.
Should the trading multiples run on management's numbers or on consensus?
Consensus, without exception, and the reason is worth stating on the page. A trading multiple is a fact about what the market pays for the number the market has, so it has to be struck on the number the market has. A discounted cash flow is a view about what the business will earn, so it runs on the plan. Mixing them — applying a peer multiple derived from consensus to management's higher forecast — is the commonest way a comparables page flatters a company that has just guided down, and it is very hard to spot once it is buried in a cell.
How much detail does the estimate-revision chart really need?
More than feels necessary, because it is the page that establishes how much weight the denominator can carry. Chart one fixed forward year across every quarter you have, annotate the inflections with the events recorded in those quarters, and state the cumulative revision. Then split it by segment. On a company with two halves, the consolidated revision usually hides the fact that one half is delivering and the other is deteriorating — and that split cuts both for and against the thesis, which is exactly why both readings belong on the page.
Is the tax attribute really worth its own page?
When it is worth more than a turn of forward earnings, yes. At that size it exceeds the distance between adjacent companies in the peer set, so a book that nets it into the bridge without saying so is burying something material. Run the schedule to expiry so the committee can see how much is used and how much is lost, keep it outside every trading multiple because it is a non-operating asset, and then price it a second time under the section 382 limitation. The gap between the two is the clearest illustration in the file of something the buyer will pay less for than the company is worth holding.
What should the recommendation actually contain?
A price to counter at, a price below which you recommend against proceeding, and the rule that produced each. Both should be derived from the same bridge as every other figure in the book rather than picked, and each should be rounded in the direction that keeps its own claim true — an ask rounds up, a floor rounds up, and a ceiling truncates. Then say the answer in both directions in one paragraph: what the proposal does support as well as what it does not. A recommendation that only says one of those is easier to write and far easier for the other side to dismantle.
About This Healthcare IT / Special Committee Valuation Case Study
Healthcare IT / Special Committee Valuation case study for investment banking interviews. 120-minute format covering two-cohort comparable company construction, evolution of street estimates over time, analyst price targets with methodology itemized. Includes the full prompt, a model answer deck, a tied-out Excel model and an audio walkthrough.
This case study sits in Investment Banking, under Healthcare & Life Sciences. Every case ships with the full prompt, the supporting materials, a complete model answer and an audio walkthrough of the judgment behind the recommendation.
120-Minute Format
The time limit a real assessment would give you
Answer Deck
Included in the model answer
Excel Model
Included in the model answer
Audio Walkthrough
How to approach the case under time pressure
200K+ students have used IB Vine to help land offers at top firms.
Moelis & Co.
“I loved IB Vine. I’m going into Private Capital Advisory (PCA); you have the lessons on there for PCA and that was actually a game changer. I went into those interviews and knew about the core PCA concepts like net asset value, primary fundraising vs. secondary advisory, etc. I swear I was on IB Vine like a few hours a day. The opportunity to have that learning section and go through the questions people submit and everything — there’s no better tool out there. I loved the guides/lessons. The user interface is amazing. The way you’ve simplified it is so spectacular — it’s just so much easier to digest. It’s fun to use too; I’d rather use IB Vine than scroll through a guide. To be honest, I think the product is perfect. I genuinely owe you a big thanks.”
Moelis & Co.
“IB Vine is a tool we really love to use in the club I’m a part of, and there’s really no other resource like it. You guys do a phenomenal job with the question bank. I recruited specifically for Energy banking, and IB Vine was my most used resource for generalist questions (which were about 50% of my interview questions; the rest being Energy-specific); the majority of such questions I saw in interviews were at least similar (if not the same) to the ones on IB Vine.”
Perella Weinberg
“Once I read through the BIWS learning guides, I really didn’t refer to them again. I didn’t even really run through the 400 question guide once I found IB Vine, which I heard about through one of my classmates. We even get a free subscription (like most business schools) to Wall Street Prep, and if I’m being completely honest, I never even logged in to WSP. IB Vine is pretty much the only tool I used (along with our club question bank & mock interviews with peers) and it was invaluable for recruiting.”
Cantor Fitzgerald
“What a platform, made such a huge difference. I did superdays at Evercore, PJT, M. Klein and Barclays among others from a non-target school and did not miss a single technical in any interview process through prepping with IB Vine.”
Barclays
“Very accurate questions and all of the solutions are easy to follow. At least 10 of the questions I studied through this platform appeared in my Round 1 or Superday interviews.”
TD Securities
“THANK YOU SO MUCH IB VINE, I COULD NOT HAVE DONE THIS WITHOUT YOU, SERIOUSLY!!! IB Vine was the best website ever. I spent at least two hours on this daily (seriously) from October through I get my offer in February.”
Citadel
“I’m doing public equities this summer and next. I know the name is “IB Vine” but at the undergrad level a lot of the technicals across public equities are the same as investment banking. I recommend your software to all my friends!”
Piper Sandler
“I loved this site! 1000% this is the best resource I used in the process.”
Lazard
“This was the greatest tool ever. I genuinely enjoyed running through the technicals/behaviorals and it was very helpful!”
Houlihan Lokey
“IB Vine was the most helpful resource I had during recruiting. I will continue to promote it to other students at WashU and elsewhere.”
Jefferies
“Awesome product, helped me crush my technicals in my interviews and land a great role. Thank you, seriously was a huge help.”
Morgan Stanley
“Very helpful to get real-life questions unlike the 400 guide, especially for merger math. Built deeper understanding of key concepts.”
Houlihan Lokey
“Extremely helpful study tool that carried me through the recruitment process from start to end.”
Evercore
“You guys are doing great work over there with IB Vine. Absolute staple for interview prep.”
Rothschild
“IB Vine was incredibly helpful and I am forever thankful for all the help.”
RBC
“IB Mock was amazing - I used it for multiple hours. Also the flashcards and the lessons features on IB Vine were fantastic. Thank you!”
Dragoneer
“IB Vine is such a great platform, really impressive. There is so much value in this. The audio podcasts / mock interview library are pretty incredible.”
Case Study Preparation
Explore All Case Studies
100+ case studies, each with the full prompt, supporting materials and an audio walkthrough; most also ship a model answer deck and a tied-out Excel model.
Every case has a public page like this one. The member library is the signed-in index members work through.