# Calculation for NPV / VAN

NPV
Edited on Aug 24, 2019
2.1 k Views

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.

## Overview of answers

• Date ascending
• Date descending

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

(edited)

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

(edited)

Francesco gave the best answer
Content Creator
#1 Coach for Sessions (4.000+) | 1.400+ 5-Star Reviews | Proven Success (➡ InterviewOffers.com) | Ex BCG | 9Y+ Coaching
4,075
Meetings
28,725