Formula | Time period (n) | 1 | 2 | 3 | |||
Year | 2018 | 2019 | 2020 | 2021 | Perpetuity | ||
Pn = Pn*(1-9%) | Production (P) | 1,820,000 | 1,656,200 | 1,507,142 | 1,371,499 | 1,248,064 | |
Pb Year 4 = Year 3 Pb*(1+7%) | Price per barrel (Pb) | 65.2 | 60.2 | 55.2 | 50.2 | 53.71 | |
Cost per barrel (Cb) | 25.2 | 25.2 | 25.2 | 25.2 | 25.2 | ||
P*Pb | Revenue ('R) | 118,664,000 | 99,703,240 | 83,194,238 | 68,849,261 | 67,033,533 | |
P*Cb | Total cost ('C) | 45,864,000 | 41,736,240 | 37,979,978 | 34,561,780 | 31,451,220 | |
R-C | Net income (NI) | 72,800,000 | 57,967,000 | 45,214,260 | 34,287,481 | 35,582,313 | |
[(1+7%)*(1-9%)]-1 | Growth rate of revenue after 2021 (g1) | -2.63% | |||||
R perpetuity/(c-g1) where c = 11% | Horizon value of Revenue in 2022 (HVr) | 491,808,753 | |||||
Since production is decreasing at 9% p.a. and cost per barrel is constant, annual cost per barrel will also decrease @ -9% | Growth rate of cost after 2021 (g2) | -9% | |||||
Total cost perpetuity/(c-g2) where c = 11% | Horizon value of Total Cost in 2022 (HVtc) | 157,256,101 | |||||
HVr - HVtc | Horizon value net income (HVni) | 334,552,652 | |||||
NI + HVni | Total cash flows (TCF) | 57,967,000 | 45,214,260 | 34,287,481 | 334,552,652 | ||
1/(1+11%)^n | Discount factor @ 11% | 0.901 | 0.812 | 0.731 | 0.659 | ||
TCF*Discount factor | PV of TCF | 52,222,523 | 36,696,908 | 25,070,710 | 220,380,195 | ||
Sum of all PVs | Total present value (TPV) | 334,370,335 | |||||
Shares O/S (s) | 7,200,000 | ||||||
TPV/s | Price per share (Ps) | 46.44 | |||||
a). Share value (at the end of 2018) = $46.99 | |||||||
b-1). EPS/P ratio: | |||||||
EPS in 2018 = net income/shares outstanding = 72,800,000/7,200,000 = 10.11 | |||||||
EPS/P = 10.11/46.99 = 0.215 (or 21.5%) | |||||||
b-2). No, it is not equal to the cost of capital. | |||||||
Note: The only point of note in this question is the calculation of horizon value. Revenues and costs in perpetuity have to be calculated separately since both have different perpetual growth rates |
answer please Problem 4-28 Valuing a business Permian Partners (PP) produces from aging oil fields in...
Problem 4-20 Two-stage DCF model Compost Science Inc. (CSI) is in the business of converting Boston's sewage sludge into fertilizer. The business is not in itself very profitable. However, to induce CSI to remain in business, the Metropolitan District Commission (MDC) has agreed to pay whatever amount is necessary to yield CSI a 14% book return on equity. At the end of the year, CSI is expected to pay a $5 dividend. It has been reinvesting 40% of earnings and...