Schedule mock interviews on the Meeting Board, join the latest community discussions in our Consulting Q&A and find like-minded Interview Partners to connect and practice with!
Back to overview

Calculation for NPV / VAN

Hello, 

could someone tell me, how they come up with the NPV/ VAN calculation here and there required price? 

http://www.archeryconsulting.fr/files/etude-cas-archery_FR.pdF

thanks. 

1
3.5k
17
Be the first to answer!
Nobody has responded to this question yet.
Top answer
edited on Aug 24, 2019
#1 Coach for Sessions (4.500+) | 1.500+ 5-Star Reviews | Proven Success: ➡ interviewoffers.com | Ex BCG | 10Y+ Coaching

Hi Anonymous,

the link you posted seems not working, could you please post the full question? We can then provide an answer to it.

Best,

Francesco

---

EDIT

The new link works, thanks.

The solution is quite bad explained indeed.

For the NPV in the first case, you get -50M as follows:

Data:

  • Investment: 300M
  • Quantity: 500k
  • Price: 1850
  • Cost: 1800
  • Discount rate: 10%

Thus profit margin is 50. Multiplied times 500k you get 25M. Using the perpetuity formula with 10% discount rate, you get 250M in the lifetime of operations (25M/10%).

Thus the net result is -300M+250M = -50M

For the minimum price, you get 2025 as follows.

Data:

  • Investment: 300M
  • Old quantity: 300k
  • Old price: 2300
  • Old cost: 2000
  • New quantity: 500k
  • New price: x
  • New cost: 1800
  • Discount rate: 10%

For some reasons not clearly explained, the case assumes that you will produce the 300k at the old cost, plus the additional 500k at the new cost. Thus:

New profits – Investment = Old profits

((x-2000)*300k)/10% +((x-1800)*500k)/10%-300M=((2300-2000)*300k)/10%

Where x is the minimum price. Solving the equation you get

x*3M-6B+x*5M-9B-300M=900M

x=16.2B/8M=2025

Hope this helps,
Francesco

Anonymous
on Aug 22, 2019
It should actually work, this is the case example on archery http://www.archeryconsulting.fr/files/etude-cas-archery_FR.pdf Thanks!
Similar Questions
Consulting
How should I explain a change in course at university? Will it be asked of me?
on Apr 14, 2025
Global
10
3.8k
Top answer by
Alessa
Coach
xMcKinsey & Company | xBCG | +200 individual & group coachings | feel free to schedule a 15 min intro call for free
81
10 Answers
3.8k Views
+7
Consulting
Just did the Mckinsey Solve Game (January 2025) - got some questions/insights
on Apr 24, 2025
Global
5
4.1k
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
42
5 Answers
4.1k Views
+2
Consulting
Want IAPP AIGP (Artificial Intelligence Governance Professional) Exam sample Questions
on Apr 14, 2025
Global
4
2.6k
Top answer by
Hagen
Coach
#1 recommended coach | >95% success rate | 8+ years consulting, 8+ years coaching and 7+ years interviewing experience
56
4 Answers
2.6k Views
+1
How likely are you to recommend us to a friend or fellow student?
0 = Not likely
10 = Very likely
Thanks for your feedback! Your opinion helps us make PrepLounge even better.