|

|
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. |
 |