Key Dates DSCR Minimum Average: 405584025.xls: Summary
Key Dates DSCR Minimum Average: 405584025.xls: Summary
Key Dates DSCR Minimum Average: 405584025.xls: Summary
Key dates
Macroeconomic parameters
Operating Costs
MMRA assumptions
Amount (USD Mn) Till Contract Year
Annual provisions made for funding the MMRA maj.mnt.1 maj.mnt.cy.1 6
a/c $1.30
Annual provisions made for funding the MMRA maj.mnt.2 maj.mnt.cy.2 22
a/c $1.90
Post Tax interest earned on MMRA cash balance int.inc.mmra 0.00%
O&M Costs
Total cost in ('000s) 1st contract year Proportion of Fixed in total cost Proportion of foreign cost in Cost in ('000s) in 1st year of
total cost Simple Cycle operations
RFP assumptions
Working capital
LD assumptions
Combined Cycle
LD amount 100 US$/MW per Day 66666 US$ per Day
112500 US$ per Day
Maximum delay 365 Days 12.5%
Maximum LD (US$ millions) $12.45 $26.88
LD amount $0.00 $0.00
Performance shortfall
Dependable capacity
Simple cycle PPA EPC
LD amount 1000 US$/kW 1800 US$/kW
Rejection limit 10.00% 5.00%
Rejection limit in MW 22.20 11.10
Maximum LD $22.20 $19.98
No. of KW in a MW 1000
Check for leap year
Year number should be divisble by and 400
Year number should be divisble by 4
No. of hours in a day 24
Comment Comment All figures in millions Taka unless mentioned otherwise
Comment US$ Comment.us All figures in millions US$ unless mentioned otherwise
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 6-Apr-14 6-Apr-15 6-Apr-16 6-Apr-17 6-Apr-18 6-Apr-19
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 5-Apr-14 5-Apr-15 5-Apr-16 5-Apr-17 5-Apr-18 5-Apr-19 5-Apr-20
No. of days in period 89.00 92.00 92.00 92.00 64.00 365.00 366.00 365.00 365.00 365.00 366.00
Period number -5.00 -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00 4.00 5.00
Contract Year number 0.00 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00 5.00 6.00
No. of months in period 3.00 3.00 3.00 3.00 2.10 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 1-Feb-15 1-Feb-16 1-Feb-17 1-Feb-18 1-Feb-19 1-Feb-20
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 31-Jan-15 31-Jan-16 31-Jan-17 31-Jan-18 31-Jan-19 31-Jan-20 31-Jan-21
Period number -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00 4.00 5.00 6.00
Financial Year number 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00
Shareholder Funds 3,380.43 4,363.39 4,820.13 5,236.84 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42
Surplus from Profit and Loss 28.17 167.98 294.97 415.37 429.36 429.36 429.36 782.67 1,246.75 1,762.37 2,333.58
Subordinated Debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Senior Debt 8,016.34 10,369.96 11,507.34 12,558.55 14,053.30 13,733.62 13,237.69 12,653.84 12,029.95 11,336.83 10,570.53
Working Capital Facility 43.14 149.26 150.17 151.09 152.20 448.32 454.66 473.84 486.86 500.50 514.46
Short term debt Facillity 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Deferred tax liability 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payables 13.96 58.01 58.73 59.46 59.65 62.48 65.76 68.83 72.24 75.82 79.92
Total Liabilities & Equity 11,482.04 15,108.61 16,831.34 18,421.31 20,545.94 20,525.20 20,038.90 19,830.60 19,687.23 19,526.94 19,349.91
Gross Fixed Assets 11,268.10 14,544.64 16,067.09 17,456.15 19,504.74 19,504.74 19,547.97 19,593.36 19,772.09 19,822.13 19,874.68
Accumulated Depreciation 6.81 40.69 80.87 124.87 221.89 807.03 1,392.82 1,979.94 2,570.42 3,164.34 3,759.79
Net Fixed Assets 11,261.29 14,503.95 15,986.22 17,331.28 19,282.85 18,697.70 18,155.14 17,613.41 17,201.66 16,657.79 16,114.89
Fx loss 129.71 190.05 261.85 340.85 401.78 763.81 1,115.25 1,452.63 1,774.29 2,078.80 2,364.31
Receivables 57.10 207.27 208.90 210.55 211.85 510.80 520.42 542.67 559.10 576.32 594.38
Reserves
DSRA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
MMRA 0.00 0.00 0.00 0.00 0.00 100.82 161.07 221.89 152.18 214.03 276.33
Cash 33.95 207.34 374.36 538.63 649.46 452.07 87.02 0.00 0.00 0.00 0.00
Total Assets 11,482.04 15,108.61 16,831.34 18,421.31 20,545.94 20,525.20 20,038.90 19,830.60 19,687.23 19,526.94 19,349.91
Reserves (orig) 0.00 0.00 0.00 0.00 0.00 100.82 161.07 221.89 152.18 214.03 276.33
Reserves (copy) 95.97 100.21 129.37 341.70 1,850.62 1,972.85 1,992.65 2,250.03 2,372.82 2,239.97 2,457.00
Reserves (copy) in US$ millions $1.29 $1.34 $1.71 $4.50 $24.23 $25.44 $25.03 $27.54 $28.30 $26.02 $27.81
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 6-Apr-14 6-Apr-15 6-Apr-16 6-Apr-17 6-Apr-18 6-Apr-19
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 5-Apr-14 5-Apr-15 5-Apr-16 5-Apr-17 5-Apr-18 5-Apr-19 5-Apr-20
No. of days in period 89.00 92.00 92.00 92.00 64.00 365.00 366.00 365.00 365.00 365.00 366.00
Period number -5.00 -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00 4.00 5.00
Contract Year number 0.00 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00 5.00 6.00
No. of months in period 3.00 3.00 3.00 3.00 2.10 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 1-Feb-15 1-Feb-16 1-Feb-17 1-Feb-18 1-Feb-19 1-Feb-20
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 31-Jan-15 31-Jan-16 31-Jan-17 31-Jan-18 31-Jan-19 31-Jan-20 31-Jan-21
Period number -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00 4.00 5.00 6.00
Financial Year number 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00 5.00 6.00 7.00
Subordinated Debt $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Senior Debt $114.52 $148.14 $164.39 $179.41 $200.76 $196.19 $189.11 $180.77 $171.86 $161.95 $151.01
Working Capital Facility $0.62 $2.13 $2.15 $2.16 $2.17 $6.40 $6.50 $6.77 $6.96 $7.15 $7.35
Short term debt Facillity $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Payables $0.20 $0.83 $0.84 $0.85 $0.85 $0.89 $0.94 $0.98 $1.03 $1.08 $1.14
Total Liabilities & Equity $164.03 $215.84 $240.45 $263.16 $293.51 $293.22 $286.27 $283.29 $281.25 $278.96 $276.43
Gross Fixed Assets $160.97 $207.78 $229.53 $249.37 $278.64 $278.64 $279.26 $279.91 $282.46 $283.17 $283.92
Accumulated Depreciation $0.10 $0.58 $1.16 $1.78 $3.17 $11.53 $19.90 $28.28 $36.72 $45.20 $53.71
Net Fixed Assets $160.88 $207.20 $228.37 $247.59 $275.47 $267.11 $259.36 $251.62 $245.74 $237.97 $230.21
Receivables $0.82 $2.96 $2.98 $3.01 $3.03 $7.30 $7.43 $7.75 $7.99 $8.23 $8.49
Reserves
DSRA $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MMRA $0.00 $0.00 $0.00 $0.00 $0.00 $1.44 $2.30 $3.17 $2.17 $3.06 $3.95
Cash $0.48 $2.96 $5.35 $7.69 $9.28 $6.46 $1.24 $0.00 $0.00 $0.00 $0.00
Total Assets $164.03 $215.84 $240.45 $263.16 $293.51 $293.22 $286.27 $283.29 $281.25 $278.96 $276.43
Start Date 6-Apr-20 6-Apr-21 6-Apr-22 6-Apr-23 6-Apr-24 6-Apr-25 6-Apr-26 6-Apr-27 6-Apr-28 6-Apr-29 6-Apr-30
End Date 5-Apr-21 5-Apr-22 5-Apr-23 5-Apr-24 5-Apr-25 5-Apr-26 5-Apr-27 5-Apr-28 5-Apr-29 5-Apr-30 5-Apr-31
No. of days in period 365.00 365.00 365.00 366.00 365.00 365.00 365.00 366.00 365.00 365.00 365.00
Period number 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00
Contract Year number 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-21 1-Feb-22 1-Feb-23 1-Feb-24 1-Feb-25 1-Feb-26 1-Feb-27 1-Feb-28 1-Feb-29 1-Feb-30 1-Feb-31
End Date 31-Jan-22 31-Jan-23 31-Jan-24 31-Jan-25 31-Jan-26 31-Jan-27 31-Jan-28 31-Jan-29 31-Jan-30 31-Jan-31 31-Jan-32
Period number 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00
Financial Year number 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00
Shareholder Funds ### 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42 5,851.42
Surplus from Profit and Loss ### 3,000.14 3,734.19 4,532.04 5,393.43 6,416.03 7,479.95 8,650.12 9,976.68 9,976.68 9,976.68 9,976.68
Subordinated Debt ### 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Senior Debt ### 9,738.50 8,813.58 7,802.55 6,700.71 5,406.71 4,039.74 2,529.14 817.84 419.71 0.00 0.00
Working Capital Facility ### 529.52 547.15 556.76 584.94 589.48 602.99 620.96 666.16 647.27 656.35 674.83
Short term debt Facillity ### 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Deferred tax liability ### 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Payables ### 83.65 87.80 92.15 96.99 101.67 106.71 112.00 117.88 161.64 169.85 178.29
Total Liabilities & Equity ### 19,203.24 19,034.14 18,834.92 18,627.48 18,365.32 18,080.81 17,763.64 17,429.98 17,056.72 16,654.30 16,681.23
Gross Fixed Assets ### 20,288.48 20,346.41 20,407.24 20,650.75 20,717.81 20,788.23 21,057.80 21,300.41 21,555.15 21,822.62 22,103.47
Accumulated Depreciation ### 4,362.24 4,971.76 5,583.07 6,198.94 6,819.46 7,442.05 8,069.74 8,705.12 9,347.95 9,998.62 10,657.51
Net Fixed Assets ### 15,926.24 15,374.65 14,824.18 14,451.81 13,898.35 13,346.18 12,988.05 12,595.29 12,207.19 11,824.00 11,445.96
Fx loss ### 2,629.01 2,870.85 3,087.47 3,276.59 3,434.53 3,557.82 3,643.65 3,687.54 3,703.73 3,709.27 3,709.27
Receivables ### 613.17 634.95 648.91 681.93 691.15 709.70 732.96 784.03 808.91 826.20 853.12
Reserves
DSRA ### 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
MMRA ### 34.80 153.70 274.37 217.15 341.29 467.12 398.98 363.12 320.58 270.90 213.60
Cash ### 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16.32 23.93 459.27
Total Assets ### 19,203.24 19,034.14 18,834.92 18,627.48 18,365.32 18,080.81 17,763.64 17,429.98 17,056.72 16,654.30 16,681.23
Reserves (orig) ### 34.80 153.70 274.37 217.15 341.29 467.12 398.98 363.12 320.58 270.90 213.60
Reserves (copy) ### 2,478.29 1,294.58 1,488.54 1,421.82 603.70 862.67 858.51 926.61 1,032.24 1,321.78 0.00
Reserves (copy) in US$ millions ### $27.33 $13.91 $15.58 $14.50 $6.00 $8.35 $8.10 $8.52 $9.24 $11.53 $0.00
Start Date 6-Apr-20 6-Apr-21 6-Apr-22 6-Apr-23 6-Apr-24 6-Apr-25 6-Apr-26 6-Apr-27 6-Apr-28 6-Apr-29 6-Apr-30
End Date 5-Apr-21 5-Apr-22 5-Apr-23 5-Apr-24 5-Apr-25 5-Apr-26 5-Apr-27 5-Apr-28 5-Apr-29 5-Apr-30 5-Apr-31
No. of days in period 365.00 365.00 365.00 366.00 365.00 365.00 365.00 366.00 365.00 365.00 365.00
Period number 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00
Contract Year number 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-21 1-Feb-22 1-Feb-23 1-Feb-24 1-Feb-25 1-Feb-26 1-Feb-27 1-Feb-28 1-Feb-29 1-Feb-30 1-Feb-31
End Date 31-Jan-22 31-Jan-23 31-Jan-24 31-Jan-25 31-Jan-26 31-Jan-27 31-Jan-28 31-Jan-29 31-Jan-30 31-Jan-31 31-Jan-32
Period number 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00
Financial Year number 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00
Subordinated Debt ### $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Senior Debt ### $139.12 $125.91 $111.47 $95.72 $77.24 $57.71 $36.13 $11.68 $6.00 $0.00 $0.00
Working Capital Facility ### $7.56 $7.82 $7.95 $8.36 $8.42 $8.61 $8.87 $9.52 $9.25 $9.38 $9.64
Short term debt Facillity ### $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Payables ### $1.19 $1.25 $1.32 $1.39 $1.45 $1.52 $1.60 $1.68 $2.31 $2.43 $2.55
Total Liabilities & Equity ### $274.33 $271.92 $269.07 $266.11 $262.36 $258.30 $253.77 $249.00 $243.67 $237.92 $238.30
Gross Fixed Assets ### $289.84 $290.66 $291.53 $295.01 $295.97 $296.97 $300.83 $304.29 $307.93 $311.75 $315.76
Accumulated Depreciation ### $62.32 $71.03 $79.76 $88.56 $97.42 $106.32 $115.28 $124.36 $133.54 $142.84 $152.25
Net Fixed Assets ### $227.52 $219.64 $211.77 $206.45 $198.55 $190.66 $185.54 $179.93 $174.39 $168.91 $163.51
Receivables ### $8.76 $9.07 $9.27 $9.74 $9.87 $10.14 $10.47 $11.20 $11.56 $11.80 $12.19
Reserves
DSRA ### $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MMRA ### $0.50 $2.20 $3.92 $3.10 $4.88 $6.67 $5.70 $5.19 $4.58 $3.87 $3.05
Cash ### $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.23 $0.34 $6.56
Total Assets ### $274.33 $271.92 $269.07 $266.11 $262.36 $258.30 $253.77 $249.00 $243.67 $237.92 $238.30
Short term debt Facillity ### 0.00 0.00 0.00 0.00 0.00
Net Deferred tax liability ### 0.00 0.00 0.00 0.00 0.00
Total Liabilities & Equity ### 16,709.37 16,738.57 16,851.73 16,884.41 16,918.80
Reserves
DSRA ### 0.00 0.00 0.00 0.00 0.00
MMRA ### 148.16 74.03 -9.37 -102.64 -150.33
Short term debt Facillity ### $0.00 $0.00 $0.00 $0.00 $0.00
Total Liabilities & Equity ### $238.71 $239.12 $240.74 $241.21 $241.70
Reserves
DSRA ### $0.00 $0.00 $0.00 $0.00 $0.00
MMRA ### $2.12 $1.06 -$0.13 -$1.47 -$2.15
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 6-Apr-14 6-Apr-15 6-Apr-16 6-Apr-17
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 5-Apr-14 5-Apr-15 5-Apr-16 5-Apr-17 5-Apr-18
No. of days in period 89.00 92.00 92.00 92.00 64.00 365.00 366.00 365.00 365.00
Period number -5.00 -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00
Contract Year number 0.00 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00
No. of months in period 3.00 3.00 3.00 3.00 2.10 12.00 12.00 12.00 12.00
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 1-Feb-15 1-Feb-16 1-Feb-17 1-Feb-18
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 31-Jan-15 31-Jan-16 31-Jan-17 31-Jan-18 31-Jan-19
Period number -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00 4.00
Financial Year number 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00 5.00
Operating Revenue (excluding fuel cost) 85.65 310.90 313.35 315.82 222.45 3,064.81 3,122.51 3,256.01 3,354.61
Payments for fuel 163.31 608.37 615.90 623.52 437.92 3,951.19 4,128.63 4,310.03 4,514.71
Operating Costs 27.92 116.03 117.46 118.92 83.51 499.86 526.05 550.61 577.90
Cost of fuel 159.25 593.22 600.56 607.99 427.01 3,871.11 4,064.90 4,252.81 4,462.48
Operating Profit 61.79 210.03 211.23 212.44 149.84 2,645.04 2,660.18 2,762.62 2,828.94
Interest income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Interest on working capital, finance charges 0.83 2.69 4.03 3.99 4.72 41.86 62.71 64.14 65.90
Interest on term debt (Senior and Subordinated) 25.66 33.64 40.04 44.05 34.10 581.13 563.89 541.54 516.43
Depreciation 6.81 33.88 40.18 44.00 97.02 585.14 585.79 587.12 590.48
Profit Before Tax 28.48 139.81 126.98 120.40 14.00 1,436.90 1,447.79 1,569.82 1,656.13
Tax paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Deferred tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Profit After Tax 28.48 139.81 126.98 120.40 14.00 1,436.90 1,447.79 1,569.82 1,656.13
Dividends 0.00 0.00 0.00 0.00 0.00 1,436.90 1,447.79 1,216.51 1,192.05
Transferred to Balance Sheet 28.48 139.81 126.98 120.40 14.00 0.00 0.00 353.31 464.08
Interest income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Interest on working capital, finance charges $0.01 $0.04 $0.06 $0.06 $0.07 $0.60 $0.90 $0.92 $0.94
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 6-Apr-14 6-Apr-15 6-Apr-16 6-Apr-17
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 5-Apr-14 5-Apr-15 5-Apr-16 5-Apr-17 5-Apr-18
No. of days in period 89.00 92.00 92.00 92.00 64.00 365.00 366.00 365.00 365.00
Period number -5.00 -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00
Contract Year number 0.00 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00
No. of months in period 3.00 3.00 3.00 3.00 2.10 12.00 12.00 12.00 12.00
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 1-Feb-15 1-Feb-16 1-Feb-17 1-Feb-18
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 31-Jan-15 31-Jan-16 31-Jan-17 31-Jan-18 31-Jan-19
Period number -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00 4.00
Financial Year number 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00 5.00
Interest on term debt (Senior and Subordinated) $0.37 $0.48 $0.57 $0.63 $0.49 $8.30 $8.06 $7.74 $7.38
Depreciation $0.10 $0.48 $0.57 $0.63 $1.39 $8.36 $8.37 $8.39 $8.44
Profit Before Tax $0.41 $2.00 $1.81 $1.72 $0.20 $20.53 $20.68 $22.43 $23.66
Tax paid $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Deferred tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Profit After Tax $0.41 $2.00 $1.81 $1.72 $0.20 $20.53 $20.68 $22.43 $23.66
Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $20.53 $20.68 $17.38 $17.03
Transferred to Balance Sheet $0.41 $2.00 $1.81 $1.72 $0.20 $0.00 $0.00 $5.05 $6.63
Start Date 6-Apr-18 6-Apr-19 6-Apr-20 6-Apr-21 6-Apr-22 6-Apr-23 6-Apr-24 6-Apr-25 6-Apr-26 6-Apr-27
End Date 5-Apr-19 5-Apr-20 5-Apr-21 5-Apr-22 5-Apr-23 5-Apr-24 5-Apr-25 5-Apr-26 5-Apr-27 5-Apr-28
No. of days in period 365.00 366.00 365.00 365.00 365.00 366.00 365.00 365.00 365.00 366.00
Period number 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00
Contract Year number 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-19 1-Feb-20 1-Feb-21 1-Feb-22 1-Feb-23 1-Feb-24 1-Feb-25 1-Feb-26 1-Feb-27 1-Feb-28
End Date 31-Jan-20 31-Jan-21 31-Jan-22 31-Jan-23 31-Jan-24 31-Jan-25 31-Jan-26 31-Jan-27 31-Jan-28 31-Jan-29
Period number 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00
Financial Year number 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00
Operating Revenue (excluding fuel cost) 3,457.95 3,566.29 3,679.04 3,809.68 3,893.45 4,091.55 4,146.90 4,258.19 4,397.75 4,704.21
Payments for fuel 4,730.99 4,972.45 5,222.61 5,469.21 5,732.52 6,026.41 6,301.75 6,608.49 6,961.22 7,309.78
Operating Costs 606.56 639.35 669.20 702.37 737.20 775.90 813.32 853.65 895.99 943.02
Cost of fuel 4,683.24 4,928.71 5,175.28 5,427.44 5,695.40 5,993.45 6,273.42 6,584.81 6,933.30 7,290.88
Operating Profit 2,899.14 2,970.69 3,057.18 3,149.07 3,193.37 3,348.61 3,361.91 3,428.23 3,529.69 3,780.08
Interest income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Interest on working capital, finance charges 67.40 68.94 70.56 72.36 73.90 75.97 77.80 78.89 80.66 75.02
Interest on term debt (Senior and Subordinated) 489.00 458.51 425.03 388.15 347.39 302.82 252.08 195.51 134.28 65.49
Depreciation 593.91 595.45 602.45 609.52 611.30 615.87 620.53 622.59 627.69 635.37
Profit Before Tax 1,748.83 1,847.79 1,959.14 2,079.04 2,160.77 2,353.95 2,411.51 2,531.24 2,687.06 3,004.20
Tax paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Deferred tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Profit After Tax 1,748.83 1,847.79 1,959.14 2,079.04 2,160.77 2,353.95 2,411.51 2,531.24 2,687.06 3,004.20
Dividends 1,233.22 1,276.58 1,292.58 1,344.98 1,362.92 1,492.56 1,388.90 1,467.32 1,516.90 1,677.64
Transferred to Balance Sheet 515.62 571.21 666.56 734.05 797.85 861.38 1,022.61 1,063.91 1,170.17 1,326.57
Interest income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Interest on working capital, finance charges $0.96 $0.98 $1.01 $1.03 $1.06 $1.09 $1.11 $1.13 $1.15 $1.07
Start Date 6-Apr-18 6-Apr-19 6-Apr-20 6-Apr-21 6-Apr-22 6-Apr-23 6-Apr-24 6-Apr-25 6-Apr-26 6-Apr-27
End Date 5-Apr-19 5-Apr-20 5-Apr-21 5-Apr-22 5-Apr-23 5-Apr-24 5-Apr-25 5-Apr-26 5-Apr-27 5-Apr-28
No. of days in period 365.00 366.00 365.00 365.00 365.00 366.00 365.00 365.00 365.00 366.00
Period number 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00
Contract Year number 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-19 1-Feb-20 1-Feb-21 1-Feb-22 1-Feb-23 1-Feb-24 1-Feb-25 1-Feb-26 1-Feb-27 1-Feb-28
End Date 31-Jan-20 31-Jan-21 31-Jan-22 31-Jan-23 31-Jan-24 31-Jan-25 31-Jan-26 31-Jan-27 31-Jan-28 31-Jan-29
Period number 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00
Financial Year number 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00
Interest on term debt (Senior and Subordinated) $6.99 $6.55 $6.07 $5.54 $4.96 $4.33 $3.60 $2.79 $1.92 $0.94
Depreciation $8.48 $8.51 $8.61 $8.71 $8.73 $8.80 $8.86 $8.89 $8.97 $9.08
Profit Before Tax $24.98 $26.40 $27.99 $29.70 $30.87 $33.63 $34.45 $36.16 $38.39 $42.92
Tax paid $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Deferred tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Profit After Tax $24.98 $26.40 $27.99 $29.70 $30.87 $33.63 $34.45 $36.16 $38.39 $42.92
Dividends $17.62 $18.24 $18.47 $19.21 $19.47 $21.32 $19.84 $20.96 $21.67 $23.97
Transferred to Balance Sheet $7.37 $8.16 $9.52 $10.49 $11.40 $12.31 $14.61 $15.20 $16.72 $18.95
Start Date 6-Apr-28 6-Apr-29 6-Apr-30 6-Apr-31 6-Apr-32 6-Apr-33 6-Apr-34 6-Apr-35
End Date 5-Apr-29 5-Apr-30 5-Apr-31 5-Apr-32 5-Apr-33 5-Apr-34 5-Apr-35 5-Apr-36
No. of days in period 365.00 365.00 365.00 366.00 365.00 365.00 365.00 366.00
Period number 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00
Contract Year number 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-29 1-Feb-30 1-Feb-31 1-Feb-32 1-Feb-33 1-Feb-34 1-Feb-35 1-Feb-36
End Date 31-Jan-30 31-Jan-31 31-Jan-32 31-Jan-33 31-Jan-34 31-Jan-35 31-Jan-36 31-Jan-37
Period number 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00
Financial Year number 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00
Operating Revenue (excluding fuel cost) 4,853.44 4,957.20 5,118.73 5,287.62 5,462.81 6,141.74 6,337.83 6,544.17
Payments for fuel 7,640.70 8,010.41 8,399.28 8,832.19 9,278.34 9,716.17 10,183.75 10,705.92
Operating Costs 1,293.12 1,358.81 1,426.34 1,500.26 1,571.69 1,649.87 1,733.59 1,823.44
Cost of fuel 7,629.81 8,007.06 8,403.94 8,845.15 9,287.99 9,740.13 10,220.68 10,755.56
Operating Profit 3,571.20 3,601.75 3,687.73 3,774.40 3,881.47 4,467.92 4,567.31 4,671.09
Interest income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Interest on working capital, finance charges 76.52 73.43 75.02 77.12 79.30 85.72 92.24 94.76
Interest on term debt (Senior and Subordinated) 21.57 7.38 0.00 0.00 0.00 0.00 0.00 0.00
Depreciation 642.83 650.67 658.89 667.53 676.60 686.12 696.11 618.43
Profit Before Tax 2,830.29 2,870.28 2,953.82 3,029.76 3,125.57 3,696.08 3,778.95 3,957.90
Tax paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Deferred tax 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Profit After Tax 2,830.29 2,870.28 2,953.82 3,029.76 3,125.57 3,696.08 3,778.95 3,957.90
Interest income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Interest on working capital, finance charges $1.09 $1.05 $1.07 $1.10 $1.13 $1.22 $1.32 $1.35
Start Date 6-Apr-28 6-Apr-29 6-Apr-30 6-Apr-31 6-Apr-32 6-Apr-33 6-Apr-34 6-Apr-35
End Date 5-Apr-29 5-Apr-30 5-Apr-31 5-Apr-32 5-Apr-33 5-Apr-34 5-Apr-35 5-Apr-36
No. of days in period 365.00 365.00 365.00 366.00 365.00 365.00 365.00 366.00
Period number 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00
Contract Year number 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-29 1-Feb-30 1-Feb-31 1-Feb-32 1-Feb-33 1-Feb-34 1-Feb-35 1-Feb-36
End Date 31-Jan-30 31-Jan-31 31-Jan-32 31-Jan-33 31-Jan-34 31-Jan-35 31-Jan-36 31-Jan-37
Period number 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00
Financial Year number 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00
Interest on term debt (Senior and Subordinated) $0.31 $0.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Depreciation $9.18 $9.30 $9.41 $9.54 $9.67 $9.80 $9.94 $8.83
Profit Before Tax $40.43 $41.00 $42.20 $43.28 $44.65 $52.80 $53.99 $56.54
Tax paid $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Deferred tax $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Profit After Tax $40.43 $41.00 $42.20 $43.28 $44.65 $52.80 $53.99 $56.54
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 6-Apr-14 6-Apr-15 6-Apr-16
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 5-Apr-14 5-Apr-15 5-Apr-16 5-Apr-17
No. of days in period 89.00 92.00 92.00 92.00 64.00 365.00 366.00 365.00
Period number -5.00 -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00
Contract Year number 0.00 0.00 0.00 0.00 0.00 1.00 2.00 3.00
No. of months in period 3.00 3.00 3.00 3.00 2.10 12.00 12.00 12.00
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 1-Feb-15 1-Feb-16 1-Feb-17
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 31-Jan-15 31-Jan-16 31-Jan-17 31-Jan-18
Period number -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00
Financial Year number 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00
Operating Profit 61.79 210.03 211.23 212.44 149.84 2,645.04 2,660.18 2,762.62
Interest income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Change in working capital 43.14 106.12 0.92 0.92 1.11 296.12 6.34 19.18
Change in working capital funded by working capital facility 43.14 106.12 0.92 0.92 1.11 296.12 6.34 19.18
Income tax paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Cash utilised for Major Maintenance expenditure 0.00 0.00 0.00 0.00 0.00 0.00 43.23 45.39
Transfer to the MMRA 0.00 0.00 0.00 0.00 0.00 100.82 60.25 60.82
Interest on working capital, finance charges 0.83 2.69 4.03 3.99 4.72 41.86 62.71 64.14
Surplus cash from operations 60.96 207.34 207.20 208.45 145.12 2,502.36 2,493.99 2,592.27
Capital expenditure 2,803.49 3,276.55 1,522.45 1,389.06 2,048.59 0.00 0.00 0.00
Draw down of shareholder funds 841.05 982.96 456.73 416.72 614.58 0.00 0.00 0.00
Draw down of Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Draw down of Senior term debt 1,962.18 2,293.28 1,065.57 972.21 1,433.82 0.00 0.00 0.00
Surplus cash available for debt service 60.70 207.04 207.06 208.32 144.93 2,502.36 2,493.99 2,592.27
Interest on Senior term debt 25.66 33.64 40.04 44.05 34.10 581.13 563.89 541.54
Interest on Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Repayment of Senior term debt 0.00 0.00 0.00 0.00 0.00 681.72 847.36 921.23
Repayment of Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash after debt service 35.04 173.39 167.02 164.27 110.83 1,239.51 1,082.74 1,129.49
Transfer to the DSRA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash after DSRA 35.04 173.39 167.02 164.27 110.83 1,239.51 1,082.74 1,129.49
Drawdown of short term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Repayment of short term debt 1.09 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash available for distribution 33.95 173.39 167.02 164.27 110.83 1,239.51 1,082.74 1,129.49
Dividends 0.00 0.00 0.00 0.00 0.00 1,436.90 1,447.79 1,216.51
Change in cash 33.95 173.39 167.02 164.27 110.83 -197.40 -365.05 -87.02
Opening Cash (Orig) 0.00 33.95 207.34 374.36 538.63 649.46 452.07 87.02
Closing Cash 33.95 207.34 374.36 538.63 649.46 452.07 87.02 0.00
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 6-Apr-14 6-Apr-15 6-Apr-16
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 5-Apr-14 5-Apr-15 5-Apr-16 5-Apr-17
No. of days in period 89.00 92.00 92.00 92.00 64.00 365.00 366.00 365.00
Period number -5.00 -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00
Contract Year number 0.00 0.00 0.00 0.00 0.00 1.00 2.00 3.00
No. of months in period 3.00 3.00 3.00 3.00 2.10 12.00 12.00 12.00
Start Date 1-Feb-13 1-May-13 1-Aug-13 1-Nov-13 1-Feb-14 1-Feb-15 1-Feb-16 1-Feb-17
End Date 30-Apr-13 31-Jul-13 31-Oct-13 31-Jan-14 31-Jan-15 31-Jan-16 31-Jan-17 31-Jan-18
Period number -4.00 -3.00 -2.00 -1.00 0.00 1.00 2.00 3.00
Financial Year number 0.00 0.00 0.00 0.00 1.00 2.00 3.00 4.00
DSRA
Transfer to/(from) DSRA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
DSRA balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
DSRA required 88.09 88.09 88.09 68.19 910.34 910.34 910.34 910.34
Cost of LC in lieu of DSRA 0.29 0.29 0.29 0.22 2.07 11.83 11.83 11.83
DSRA Funded as Project Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
DSRA Funded as Project Cost Copy $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MMRA
Scheduled Major Maintenance Cost (US$ million 100% Fixed
and Foreign)
Scheduled (Real
Major CY basis) Cost (US$ million 100% Fixed
Maintenance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.48 $0.48
and Foreign) (Nominal CY basis) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.54 $0.56
MMRA
Opening $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.30 $2.06
Addition (i.e provisioned in P&L) $0.00 $0.00 $0.00 $0.00 $0.00 $1.30 $1.30 $1.30
Draw down (i.e. utilised for expenditure) $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.54 $0.56
MMRA a/c balance $0.00 $0.00 $0.00 $0.00 $0.00 $1.30 $2.06 $2.80
Cost of LC in lieu of MMRA $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Cash available for debt service 60.70 207.04 207.06 208.32 144.93 2,502.36 2,493.99 2,592.27
DSCR
Total Debt service 25.66 33.64 40.04 44.05 34.10 1,262.85 1,411.25 1,462.77
Total DSCR 1.98 1.77 1.77
Start/End of Total debt service 10.00
Senior Debt service 25.66 33.64 40.04 44.05 34.10 1,262.85 1,411.25 1,462.77
Senior Debt DSCR 1.98 1.77 1.77
Start/End of Senior debt service 10.00
LLCR
NPV of Cash available for debt service 47,840.21 47,633.18 47,426.12 47,217.79 47,072.87 44,570.51 42,076.52 39,484.25
LLCR - Total Debt 5.97 4.59 4.12 3.76 3.35 3.25 3.18 3.12
LLCR - Senior Debt 5.97 4.59 4.12 3.76 3.35 3.25 3.18 3.12
Start Date 6-Apr-17 6-Apr-18 6-Apr-19 6-Apr-20 6-Apr-21 6-Apr-22 6-Apr-23 6-Apr-24 6-Apr-25
End Date 5-Apr-18 5-Apr-19 5-Apr-20 5-Apr-21 5-Apr-22 5-Apr-23 5-Apr-24 5-Apr-25 5-Apr-26
No. of days in period 365.00 365.00 366.00 365.00 365.00 365.00 366.00 365.00 365.00
Period number 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00
Contract Year number 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-18 1-Feb-19 1-Feb-20 1-Feb-21 1-Feb-22 1-Feb-23 1-Feb-24 1-Feb-25 1-Feb-26
End Date 31-Jan-19 31-Jan-20 31-Jan-21 31-Jan-22 31-Jan-23 31-Jan-24 31-Jan-25 31-Jan-26 31-Jan-27
Period number 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00
Financial Year number 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00
Operating Profit 2,828.94 2,899.14 2,970.69 3,057.18 3,149.07 3,193.37 3,348.61 3,361.91 3,428.23
Interest income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Change in working capital 13.02 13.64 13.96 15.06 17.63 9.61 28.18 4.55 13.51
Change in working capital funded by working capital facility 13.02 13.64 13.96 15.06 17.63 9.61 28.18 4.55 13.51
Income tax paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Cash utilised for Major Maintenance expenditure 178.73 50.04 52.55 413.80 57.93 60.83 243.51 67.06 70.42
Transfer to the MMRA -69.71 61.85 62.30 -241.52 118.90 120.67 -57.22 124.14 125.83
Interest on working capital, finance charges 65.90 67.40 68.94 70.56 72.36 73.90 75.97 77.80 78.89
Surplus cash from operations 2,654.02 2,719.85 2,786.90 2,814.34 2,899.88 2,937.97 3,086.35 3,092.91 3,153.09
Capital expenditure 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Draw down of shareholder funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Draw down of Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Draw down of Senior term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash available for debt service 2,654.02 2,719.85 2,786.90 2,814.34 2,899.88 2,937.97 3,086.35 3,092.91 3,153.09
Interest on Senior term debt 516.43 489.00 458.51 425.03 388.15 347.39 302.82 252.08 195.51
Interest on Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Repayment of Senior term debt 945.55 997.64 1,051.82 1,096.73 1,166.75 1,227.66 1,290.97 1,451.94 1,490.26
Repayment of Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash after debt service 1,192.05 1,233.22 1,276.58 1,292.58 1,344.98 1,362.92 1,492.56 1,388.90 1,467.32
Transfer to the DSRA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash after DSRA 1,192.05 1,233.22 1,276.58 1,292.58 1,344.98 1,362.92 1,492.56 1,388.90 1,467.32
Drawdown of short term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Repayment of short term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash available for distribution 1,192.05 1,233.22 1,276.58 1,292.58 1,344.98 1,362.92 1,492.56 1,388.90 1,467.32
Dividends 1,192.05 1,233.22 1,276.58 1,292.58 1,344.98 1,362.92 1,492.56 1,388.90 1,467.32
Change in cash 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Opening Cash (Orig) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Closing Cash 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Start Date 6-Apr-17 6-Apr-18 6-Apr-19 6-Apr-20 6-Apr-21 6-Apr-22 6-Apr-23 6-Apr-24 6-Apr-25
End Date 5-Apr-18 5-Apr-19 5-Apr-20 5-Apr-21 5-Apr-22 5-Apr-23 5-Apr-24 5-Apr-25 5-Apr-26
No. of days in period 365.00 365.00 366.00 365.00 365.00 365.00 366.00 365.00 365.00
Period number 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00
Contract Year number 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-18 1-Feb-19 1-Feb-20 1-Feb-21 1-Feb-22 1-Feb-23 1-Feb-24 1-Feb-25 1-Feb-26
End Date 31-Jan-19 31-Jan-20 31-Jan-21 31-Jan-22 31-Jan-23 31-Jan-24 31-Jan-25 31-Jan-26 31-Jan-27
Period number 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00
Financial Year number 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00
DSRA
Transfer to/(from) DSRA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
DSRA balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
DSRA required 910.34 910.34 910.34 910.34 910.34 910.34 910.34 910.34 910.34
Cost of LC in lieu of DSRA 11.83 11.83 11.83 11.83 11.83 11.83 11.83 11.83 11.83
DSRA Funded as Project Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
DSRA Funded as Project Cost Copy $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MMRA
Scheduled Major Maintenance Cost (US$ million 100% Fixed
and Foreign)
Scheduled (Real
Major CY basis) Cost (US$ million 100% Fixed
Maintenance $1.80 $0.48 $0.48 $3.60 $0.48 $0.48 $1.83 $0.48 $0.48
and Foreign) (Nominal CY basis) $2.13 $0.58 $0.59 $4.56 $0.62 $0.64 $2.48 $0.67 $0.68
MMRA
Opening $2.80 $1.97 $2.69 $3.39 $0.73 $2.01 $3.27 $2.69 $3.92
Addition (i.e provisioned in P&L) $1.30 $1.30 $1.30 $1.90 $1.90 $1.90 $1.90 $1.90 $1.90
Draw down (i.e. utilised for expenditure) $2.13 $0.58 $0.59 $4.56 $0.62 $0.64 $2.48 $0.67 $0.68
MMRA a/c balance $1.97 $2.69 $3.39 $0.73 $2.01 $3.27 $2.69 $3.92 $5.14
Cost of LC in lieu of MMRA $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Cash available for debt service 2,654.02 2,719.85 2,786.90 2,814.34 2,899.88 2,937.97 3,086.35 3,092.91 3,153.09
DSCR
Total Debt service 1,461.97 1,486.63 1,510.32 1,521.76 1,554.90 1,575.05 1,593.79 1,704.02 1,685.77
Total DSCR 1.82 1.83 1.85 1.85 1.86 1.87 1.94 1.82 1.87
Start/End of Total debt service
Senior Debt service 1,461.97 1,486.63 1,510.32 1,521.76 1,554.90 1,575.05 1,593.79 1,704.02 1,685.77
Senior Debt DSCR 1.82 1.83 1.85 1.85 1.86 1.87 1.94 1.82 1.87
Start/End of Senior debt service
LLCR
NPV of Cash available for debt service 36,830.23 34,110.37 31,323.47 28,509.13 25,609.25 22,671.28 19,584.93 16,492.02 13,338.92
LLCR - Total Debt 3.06 3.01 2.96 2.93 2.91 2.91 2.92 3.05 3.30
LLCR - Senior Debt 3.06 3.01 2.96 2.93 2.91 2.91 2.92 3.05 3.30
Start Date 6-Apr-26 6-Apr-27 6-Apr-28 6-Apr-29 6-Apr-30 6-Apr-31 6-Apr-32 6-Apr-33 6-Apr-34
End Date 5-Apr-27 5-Apr-28 5-Apr-29 5-Apr-30 5-Apr-31 5-Apr-32 5-Apr-33 5-Apr-34 5-Apr-35
No. of days in period 365.00 366.00 365.00 365.00 365.00 366.00 365.00 365.00 365.00
Period number 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00
Contract Year number 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-27 1-Feb-28 1-Feb-29 1-Feb-30 1-Feb-31 1-Feb-32 1-Feb-33 1-Feb-34 1-Feb-35
End Date 31-Jan-28 31-Jan-29 31-Jan-30 31-Jan-31 31-Jan-32 31-Jan-33 31-Jan-34 31-Jan-35 31-Jan-36
Period number 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00
Financial Year number 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00
Operating Profit 3,529.69 3,780.08 3,571.20 3,601.75 3,687.73 3,774.40 3,881.47 4,467.92 4,567.31
Interest income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Change in working capital 17.97 45.20 -18.89 9.08 18.48 18.91 20.27 103.38 22.22
Change in working capital funded by working capital facility 17.97 45.20 -18.89 9.08 18.48 18.91 20.27 103.38 22.22
Income tax paid 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Cash utilised for Major Maintenance expenditure 269.57 242.61 254.74 267.48 280.85 294.89 309.64 325.12 341.38
Transfer to the MMRA -68.14 -35.86 -42.54 -49.67 -57.30 -65.44 -74.13 -83.40 -93.27
Interest on working capital, finance charges 80.66 75.02 76.52 73.43 75.02 77.12 79.30 85.72 92.24
Surplus cash from operations 3,247.60 3,498.32 3,282.48 3,310.52 3,389.16 3,467.83 3,566.66 4,140.47 4,226.96
Capital expenditure 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Draw down of shareholder funds 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Draw down of Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Draw down of Senior term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash available for debt service 3,247.60 3,498.32 3,282.48 3,310.52 3,389.16 3,467.83 3,566.66 4,140.47 4,226.96
Interest on Senior term debt 134.28 65.49 21.57 7.38 0.00 0.00 0.00 0.00 0.00
Interest on Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Repayment of Senior term debt 1,596.43 1,755.19 414.32 425.25 0.00 0.00 0.00 0.00 0.00
Repayment of Subordinated term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash after debt service 1,516.90 1,677.64 2,846.60 2,877.89 3,389.16 3,467.83 3,566.66 4,140.47 4,226.96
Transfer to the DSRA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash after DSRA 1,516.90 1,677.64 2,846.60 2,877.89 3,389.16 3,467.83 3,566.66 4,140.47 4,226.96
Drawdown of short term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Repayment of short term debt 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Surplus cash available for distribution 1,516.90 1,677.64 2,846.60 2,877.89 3,389.16 3,467.83 3,566.66 4,140.47 4,226.96
Dividends 1,516.90 1,677.64 2,830.29 2,870.28 2,953.82 3,029.76 3,125.57 3,696.08 3,778.95
Change in cash 0.00 0.00 16.32 7.61 435.34 438.08 441.09 444.39 448.01
Opening Cash (Orig) 0.00 0.00 0.00 16.32 23.93 459.27 897.35 1,338.44 1,782.83
Closing Cash 0.00 0.00 16.32 23.93 459.27 897.35 1,338.44 1,782.83 2,230.84
Start Date 6-Apr-26 6-Apr-27 6-Apr-28 6-Apr-29 6-Apr-30 6-Apr-31 6-Apr-32 6-Apr-33 6-Apr-34
End Date 5-Apr-27 5-Apr-28 5-Apr-29 5-Apr-30 5-Apr-31 5-Apr-32 5-Apr-33 5-Apr-34 5-Apr-35
No. of days in period 365.00 366.00 365.00 365.00 365.00 366.00 365.00 365.00 365.00
Period number 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00
Contract Year number 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00
No. of months in period 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00 12.00
Start Date 1-Feb-27 1-Feb-28 1-Feb-29 1-Feb-30 1-Feb-31 1-Feb-32 1-Feb-33 1-Feb-34 1-Feb-35
End Date 31-Jan-28 31-Jan-29 31-Jan-30 31-Jan-31 31-Jan-32 31-Jan-33 31-Jan-34 31-Jan-35 31-Jan-36
Period number 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00
Financial Year number 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00
DSRA
Transfer to/(from) DSRA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
DSRA balance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
DSRA required 910.34 217.94 216.31 0.00 0.00 0.00 0.00 0.00 0.00
Cost of LC in lieu of DSRA 11.83 2.83 2.81 0.00 0.00 0.00 0.00 0.00 0.00
DSRA Funded as Project Cost $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
DSRA Funded as Project Cost Copy $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MMRA
Scheduled Major Maintenance Cost (US$ million 100% Fixed
and Foreign)
Scheduled (Real
Major CY basis) Cost (US$ million 100% Fixed
Maintenance $1.75 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50
and Foreign) (Nominal CY basis) $2.54 $2.23 $2.28 $2.33 $2.39 $2.44 $2.50 $2.56 $2.61
MMRA
Opening $5.14 $4.50 $4.17 $3.79 $3.35 $2.87 $2.32 $1.73 $1.07
Addition (i.e provisioned in P&L) $1.90 $1.90 $1.90 $1.90 $1.90 $1.90 $1.90 $1.90 $1.90
Draw down (i.e. utilised for expenditure) $2.54 $2.23 $2.28 $2.33 $2.39 $2.44 $2.50 $2.56 $2.61
MMRA a/c balance $4.50 $4.17 $3.79 $3.35 $2.87 $2.32 $1.73 $1.07 $0.36
Cost of LC in lieu of MMRA $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Cash available for debt service 3,247.60 3,498.32 3,282.48 3,310.52 3,389.16 3,467.83 3,566.66 4,140.47 4,226.96
DSCR
Total Debt service 1,730.70 1,820.69 435.88 432.63 0.00 0.00 0.00 0.00 0.00
Total DSCR 1.88 1.92 7.53 7.65
Start/End of Total debt service 30.00
Senior Debt service 1,730.70 1,820.69 435.88 432.63 0.00 0.00 0.00 0.00 0.00
Senior Debt DSCR 1.88 1.92 7.53 7.65
Start/End of Senior debt service 30.00
LLCR
NPV of Cash available for debt service 10,091.32 6,593.00 3,310.52 0.00 0.00 0.00 0.00 0.00 0.00
LLCR - Total Debt 3.99 8.06 7.89
LLCR - Senior Debt 3.99 8.06 7.89
DSRA
Transfer to/(from) DSRA 0.00
DSRA balance 0.00
DSRA required 0.00
Cost of LC in lieu of DSRA 0.00
LLCR
NPV of Cash available for debt service 0.00
LLCR - Total Debt
LLCR - Senior Debt
Other Ratios
Liquidity Ratios: Min Avg
Current Ratio = Current Assets/Current Liabilities 4.86 6.99
Quick Ratio = Current Assets – Inventory/ Current Liabilities 4.86 6.99