Description
An excel spreadsheet showing the workings of MW Petroleum case
Prove Undeveloped Resources Cash From Operations Capital expenditures WACC Variance NPV of Cash flow from operations NPV of Capex Strike Price Exercise price Days Riskfree rate Stddev European call option
Year 1 4 17.5 -13.5 13% 35% 91.76 45.65 91.76 45.65 365 8% 0.1225 #NAME? 61.4 Rs. 473.50
Year 2 11.9 17.7 -5.8 Rs. 40.80
Year 3 12.9 5.3 7.6
3 Year 4 9.3 4.1 5.2
4 Year 5 8.1 3.5 4.6
Rs. 10.84
46.11 Rs. 56.95
75.1
62.2
37.4
53.2
5 Year 6 8 1.3 6.7
6 Year 7 9.8 0.1 9.7
7 Year 8 12.8 0.3 12.5
8 9 10 11 12 13 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 16 15.2 14.9 14.7 15.4 16.6 0 0.1 8.1 0 0.2 0 16 15.1 6.8 14.7 15.2 16.6
70.7
80.2
80.7
85.3
76.5
72.5
74.3
68.5
63.8
14 Year 15 82.9 0 82.9
341.1
doc_318423927.xls
An excel spreadsheet showing the workings of MW Petroleum case
Prove Undeveloped Resources Cash From Operations Capital expenditures WACC Variance NPV of Cash flow from operations NPV of Capex Strike Price Exercise price Days Riskfree rate Stddev European call option
Year 1 4 17.5 -13.5 13% 35% 91.76 45.65 91.76 45.65 365 8% 0.1225 #NAME? 61.4 Rs. 473.50
Year 2 11.9 17.7 -5.8 Rs. 40.80
Year 3 12.9 5.3 7.6
3 Year 4 9.3 4.1 5.2
4 Year 5 8.1 3.5 4.6
Rs. 10.84
46.11 Rs. 56.95
75.1
62.2
37.4
53.2
5 Year 6 8 1.3 6.7
6 Year 7 9.8 0.1 9.7
7 Year 8 12.8 0.3 12.5
8 9 10 11 12 13 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 16 15.2 14.9 14.7 15.4 16.6 0 0.1 8.1 0 0.2 0 16 15.1 6.8 14.7 15.2 16.6
70.7
80.2
80.7
85.3
76.5
72.5
74.3
68.5
63.8
14 Year 15 82.9 0 82.9
341.1
doc_318423927.xls