Introduction     Future Value     Present Value     Net Present Value I     Net Present Value II     Discount Rate   Expected NPV

   Decision Tree     Utility     Opportunity and Sunk Costs  Evaluating Oil Rights    Free Rider    Strategy

NPV Part II...

The example used in the previous section assumes that you will be the sole owner of a deep well. In OilFinancier rules, this will never happen: you must form a partnership to drill any well.

So a more realistic example may involve you being approached by three other financiers to drill a deep well. They propose that each financier contributes $75,000 for the drilling of the well and shares 15% of the revenue (the remaining 40% goes to the owner of the oil rights). Should you take this deal?

You should go back to your spreadsheet. In the table below, we are assuming a $75,000 capital investment, an initial cash flow of $3,600 per day ($24,000 x 0.15), and a discount rate as being 2.5%.

Day Discount Factor Cash Flow Discounted Cash Flow Cumulative

1

1.0000

-75,000

-75,000

-75,000

2

0.9750

0

0

-75,000

3

0.9506

0

0

-75,000

4

0.9269

0

0

-75,000

5

0.9037

0

0

-75,000

6

0.8811

3,600

3,172

-71,828

7

0.8591

3,546

3,046

-68,782

8

0.8376

3,493

2,926

-65,856

9

0.8167

3,440

2,810

-63,047

10

0.7962

3,389

2,698

-60,348

11

0.7763

3,338

2,591

-57,757

12

0.7569

3,288

2,489

-55,268

13

0.7380

3,239

2,390

-52,878

14

0.7195

3,190

2,295

-50,583

15

0.7016

3,142

2,204

-48,378

16

0.6840

3,095

2,117

-46,261

17

0.6669

3,049

2,033

-44,228

18

0.6502

3,003

1,953

-42,276

19

0.6340

2,958

1,875

-40,400

20

0.6181

2,913

1,801

-38,599

21

0.6027

2,870

1,730

-36,870

22

0.5876

2,827

1,661

-35,209

23

0.5729

2,784

1,595

-33,614

24

0.5586

2,743

1,532

-32,082

25

0.5446

2,701

1,471

-30,610

26

0.5310

2,661

1,413

-29,197

27

0.5177

2,621

1,357

-27,840

28

0.5048

2,582

1,303

-26,537

29

0.4922

2,543

1,252

-25,285

30

0.4799

2,505

1,202

-24,083

31

0.4679

2,467

1,154

-22,929

32

0.4562

2,430

1,109

-21,820

33

0.4448

2,394

1,065

-20,756

34

0.4337

2,358

1,023

-19,733

35

0.4228

2,322

982

-18,751

36

0.4123

2,288

943

-17,808

37

0.4019

2,253

906

-16,902

38

0.3919

2,220

870

-16,033

39

0.3821

2,186

835

-15,197

40

0.3725

2,153

802

-14,395

41

0.3632

2,121

770

-13,624

42

0.3542

2,089

740

-12,885

43

0.3453

2,058

711

-12,174

44

0.3367

2,027

682

-11,491

45

0.3282

1,997

655

-10,836

46

0.3200

1,967

629

-10,207

47

0.3120

1,937

605

-9,602

48

0.3042

1,908

581

-9,022

49

0.2966

1,880

558

-8,464

50

0.2892

1,851

535

-7,929

In this case, the NPV at 50 days is negative. From the size of the discounted cash flow at Day 50, it looks like you would need to extend the spreadsheet about another 20 days to see a positive NPV.

These numbers are telling you to stay away from this proposal. Perhaps the owner of the oil rights should look at reducing his take of the revenues to entice you into being a partner. Or perhaps the partnership should look at negotiating a subsequent deep well to make this deal work. If you believe your financial techniques are sound and you have the proper discount rate, don’t sacrifice them to make a deal. You are better off investing elsewhere in the seminar.

Knowing when to stay away from bad deals is a part of doing good business. I hope this attribute will be reinforced as part of your business instincts with this seminar.

Note the discount factor of the two examples at Day 50. In the first example, with a 1% discount rate, the discount factor was 0.61. In the 2.5% example, the discount factor was 0.29. This shows that the larger the discount rate, the harsher future cash flows are discounted. At higher discount rates, cash flows at Day 50 would have very little impact on the NPV calculation. I encourage you to experiment with your own spreadsheet to determine the relationships of discount rates and Net Present Value.


Top