Cookie and Privacy Settings

This website uses cookies to enable essential functions like the user login and sessions. We also use cookies and third-party tools to improve your surfing experience on preplounge.com. You can choose to activate only essential cookies or all cookies. You can always change your preference in the cookie and privacy settings. This link can also be found in the footer of the site. If you need more information, please visit our privacy policy.

Data processing in the USA: By clicking on "I accept", you also consent, in accordance with article 49 paragraph 1 sentence 1 lit. GDPR, to your data being processed in the USA (by Google LLC, Facebook Inc., LinkedIn Inc., Stripe, Paypal).

Manage settings individually I accept
expert
Expert with best answer

Francesco

100% Recommendation Rate

3,469 Meetings

16,944 Q&A Upvotes

USD 449 / Coaching

1

Calculation for NPV / VAN

NPV

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.

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 answer

  • Upvotes
  • Date ascending
  • Date descending
Best Answer
Book a coaching with Francesco

100% Recommendation Rate

3,469 Meetings

16,944 Q&A Upvotes

USD 449 / 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

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! — Anonymous on Aug 22, 2019 (edited)

Related case(s)

Smart Meters

Solved 31.6k times
Smart Meters The municipal utility Hamburg Energized is a local energy retail (power and gas) and distribution grid company active in the city of Hamburg. The majority of shares of Hamburg Energized is held by the city itself. As the distribution system operator of Hamburg, Hamburg Energized is responsible for the operations and maintenance of the gas and electricity grid on customer level. In the course of the energy transition in Germany, the responsible board member for the technical grid operations, Jan Bremer, thinks about deploying Smart Meters in the gas and electricity grid. He approaches you with the request to conduct a feasibility analysis and to give a clear recommendation whether or not Hamburg Energized should use Smart Meters in its gas and electricity grid in the future.
4.4 5 699
| Rating: (4.4 / 5.0)

The municipal utility Hamburg Energized is a local energy retail (power and gas) and distribution grid company active in the city of Hamburg. The majority of shares of Hamburg Energized is held by the city itself. As the distribution system operator of Hamburg, Hamburg Energized is responsible for t ... Open whole case

Caribbean Island – MBB Final Round

Solved 7.3k times
Caribbean Island – MBB Final Round A wealthy client has recently bought an island in the Caribbean. She has engaged us to identify possible uses for her new island.
4.6 5 394
| Rating: (4.6 / 5.0)

A wealthy client has recently bought an island in the Caribbean. She has engaged us to identify possible uses for her new island. Open whole case

PE Portfolio Strategy

Solved 6.7k times
PE Portfolio Strategy We are a private equity firm operating primarily in the automotive industry. We would like you to figure out whether we should increase our portfolio in the sensor market or not. We would like you to do a profit/margin growth potential analysis and tell us how we can add value to this company given the other companies in our portfolio.
4.1 5 365
| Rating: (4.1 / 5.0)

We are a private equity firm operating primarily in the automotive industry. We would like you to figure out whether we should increase our portfolio in the sensor market or not. We would like you to do a profit/margin growth potential analysis and tell us how we can add value to this company given ... Open whole case

Cutting Carbs - Divestiture in the Electrical Power Market

Solved 2.1k times
Cutting Carbs - Divestiture in the Electrical Power Market Our client is Energy England, one of northern England’s largest electric utility companies. They were created over the past decade through an aggressive series of mergers of existing utility companies each specializing in a single energy generation source. Recently, the CEO has embarked on an initiative to return to the core of the business. She is looking to increase free cash flow and cash reserves in order to prepare the business for evolving future trends.   The following can be verbally provided to interviewee if asked: Energy England is made up of assets across the energy-generation space. These include coal, gas, nuclear, and wind We are looking to divest from just one of our previous acquisitions (i.e one target is sufficient) There are no specific goals/metrics – the client trusts our judgement
4.3 5 42
| Rating: (4.3 / 5.0)

Our client is Energy England, one of northern England’s largest electric utility companies. They were created over the past decade through an aggressive series of mergers of existing utility companies each specializing in a single energy generation source. Recently, the CEO has embarked on an initi ... Open whole case