Calculation for NPV / VAN

NPV
Bearbeitet am 24. Aug. 2019
1 Antwort
2,9 T. Views
Anonym A fragte am 22. Aug. 2019

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.

Übersicht der Antworten

Upvotes
  • Upvotes
  • Datum aufsteigend
  • Datum absteigend
Beste Antwort
Francesco
Experte
Content Creator
bearbeitete eine Antwort am 24. Aug. 2019
#1 Coach for Sessions (4.000+) | 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

(editiert)

War diese Antwort hilfreich?
Anonym am 22. Aug. 2019

It should actually work, this is the case example on archery http://www.archeryconsulting.fr/files/etude-cas-archery_FR.pdf Thanks!

(editiert)

Francesco gab die beste Antwort

Francesco

Content Creator
#1 Coach for Sessions (4.000+) | 1.500+ 5-Star Reviews | Proven Success (➡ InterviewOffers.com) | Ex BCG | 10Y+ Coaching
4.512
Meetings
43.942
Q&A Upvotes
387
Awards
5,0
1616 Bewertungen
Wie wahrscheinlich ist es, dass du uns einem Freund oder Kommilitonen empfiehlst?
0
1
2
3
4
5
6
7
8
9
10
0 = Nicht wahrscheinlich
10 = Sehr wahrscheinlich