Barka-3 IPP Project Financial Modeling Summary
June 25th, 2015
OMR Mn
COP (OMR millions) Capex Interest Capitalised Annual Total % Cumulative Total %
2011 16.7 4.1 20.9 6% 20.9 6%
2012 68.2 3.2 71.4 22% 92.3 29%
2013 115.6 6.6 122.2 38% 214.5 66%
2014 98.0 10.4 108.4 34% 322.9 100%
Total 298.5 24.4 322.9 100%
% 92% 8% 100%
COP
350.0 300.0
3.50
Cumulative Total
3.00
Annual Total 250.0
DSCR LLCR
2.50
200.0
2.00 150.0
MOF (OMR millions) Debt Equity Total Asset
2011 16.3 4.6 20.9
2012 55.6 15.8 71.4
2013 95.2 27.0 122.2
2014 84.4 24.0 108.4
Total 251.5 71.4 322.9
% 78% 22% 100%
1.50
100.0
1.00
50.0
0.50
‐ 2011
2012
2013
2014
OMR Mn Debt/Equity
3.52
IRR Project Equity
10% 14%
DSCR Average MAX MIN
1.49 2.02 1.13
300.0
200.0
Financial C/f 100.0
Av O/s Drawdown
LLCR Average MAX MIN
1.63 2.07 1.35
0.0
Repayment Amount Undrawn Amount
(100.0)
(200.0)
(300.0) *
This excel file is only for financial modeling practice purpose. Deferred tax,other income from LD and other activities during construction stage (2010~2013) are needed to be incoporated and adjusted. To get more precise result, further development with more relevant data is required.
Ji Won Seo
[email protected] http://pfcasestudy.blogspot.com https://www.linkedin.com/profile/view?id=69053747&trk=nav_responsive_tab_profile Source: Al Suwadi Power Company SAOG IPO Prospectus
