Spreadsheet: 62585d1263498745-calculation-dependant-on-if-a-date-falls-within-a-range-data-and-projection
Sheet: Data

 |  |  |  |  | rate 1 |  |  | rate 2 |  |  | rate 3 |  |  | rate 4
Vessel | Vessel Class (TEU) | Length of Charter | Cumulative Charter Life | Charterer | Base Rate | effective for (yr) | effective until | Base Rate Change | effective for (yr) | effective until | Option Rate | effective for (yr) | effective until | Option Rate | effective for (yr) | effective until | Shipbuilder | Purchase price ($ [NAME]) | Estimated Delivery Date | Year Built | Contract End date | Total Contract days
CSCL Zeebrugge | 9600 | 12 years | 12 | CSCL Asia | 34 | 6 |  | 34.5 |  |  |  |  |  |  |  |  |  |  | 2007-03-15 00:00:00 | 2007
CSCL Long Beach | 9600 | 12 years | 12 | CSCL Asia | 34 | 6 |  | 34.5 |  |  |  |  |  |  |  |  |  |  | 2007-07-05 00:00:00 | 2007
[NAME] | 8500 | 12 years + one 3-year option | 15 | CSCL Asia | 29.5 | 6 |  | 29.8 | 6 |  | 30 |  |  |  |  |  |  |  | 2004-12-04 00:00:00 | 2004
CSCL Africa | 8500 | 12 years + one 3-year option | 15 | CSCL Asia | 29.5 | 6 |  | 29.8 | 6 |  | 30 |  |  |  |  |  |  |  | 2005-01-24 00:00:00 | 2005
[NAME] | 4800 | 5 years + two 1 year options + one 2 year option | 9 | APM | 23.45 | 5 |  | 22.4 | 1 |  | 21.4 | 1 |  | 20.4 |  |  |  |  | 2006-11-06 00:00:00 | 1989
[NAME] | 4800 | 5 years + two 1 year options + one 2 year option | 9 | APM | 23.45 | 5 |  | 22.4 | 1 |  | 21.4 | 1 |  | 20.4 |  |  |  |  | 2006-11-20 00:00:00 | 1988
[NAME] | 4800 | 5 years + two 1 year options + one 2 year option | 9 | APM | 23.45 | 5 |  | 22.4 | 1 |  | 21.4 | 1 |  | 20.4 |  |  |  |  | 2006-11-06 00:00:00 | 1989
[NAME] | 4800 | 5 years + two 1 year options + one 2 year option | 9 | APM | 23.45 | 5 |  | 22.4 | 1 |  | 21.4 | 1 |  | 20.4 |  |  |  |  | 2006-11-06 00:00:00 | 1989
CSCL Hamburg | 4250 | 10 years + one 2 year option | 12 | CSCL Asia | 18 | 5 |  | 18.3 | 5 |  | 19 |  |  |  |  |  |  |  | 2001-07-03 00:00:00 | 2001
[NAME] | 4250 | 10 years + one 2 year option | 12 | CSCL Asia | 18.3 | 5 |  | 18.3 | 5 |  | 19 |  |  |  |  |  |  |  | 2001-09-20 00:00:00 | 2001
CSCL Ningbo | 4250 | 10 years + one 2 year option | 12 | CSCL Asia | 19.7 | 5 |  | 19.933 | 5 |  | 19.733 |  |  |  |  |  |  |  | 2002-06-15 00:00:00 | 2002
CSCL Dalian | 4250 | 10 years + one 2 year option | 12 | CSCL Asia | 19.7 | 5 |  | 19.933 | 5 |  | 19.733 |  |  |  |  |  |  |  | 2002-09-04 00:00:00 | 2002
CSCL Felixstowe | 4250 | 10 years + one 2 year option | 12 | CSCL Asia | 19.7 | 5 |  | 19.933 | 5 |  | 19.733 |  |  |  |  |  |  |  | 2002-10-15 00:00:00 | 2002
CSCL Vancouver | 4250 | 12 years | 12 | CSCL Asia | 17 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 2005-02-16 00:00:00 | 2005
[NAME] | 4250 | 12 years | 12 | CSCL Asia | 17 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 2005-04-19 00:00:00 | 2005
CSCL New York | 4250 | 12 years | 12 | CSCL Asia | 17 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 2005-05-26 00:00:00 | 2005
[NAME] | 4250 | 12 years | 12 | CSCL Asia | 17 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 2005-08-17 00:00:00 | 2005
CSCL Brisbane | 4250 | 12 years | 12 | CSCL Asia | 17 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 2005-09-15 00:00:00 | 2005
New Delhi Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 | 2 |  | 19 |  |  |  |  |  |  |  | 2005-10-18 00:00:00 | 2005
Dubai Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 | 2 |  | 19 |  |  |  |  |  |  |  | 2006-01-03 00:00:00 | 2006
Jakarta Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 | 2 |  | 19 |  |  |  |  |  |  |  | 2006-02-21 00:00:00 | 2006
Saigon Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 |  |  | 19 |  |  |  |  |  |  |  | 2006-04-06 00:00:00 | 2006
Lahore Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 |  |  | 19 |  |  |  |  |  |  |  | 2006-07-11 00:00:00 | 2006
Rio Grande Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 |  |  | 19 |  |  |  |  |  |  |  | 2006-10-20 00:00:00 | 2006
Santos Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 |  |  | 19 |  |  |  |  |  |  |  | 2006-11-13 00:00:00 | 2006
Rio de Janeiro Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 |  |  | 19 |  |  |  |  |  |  |  | 2007-03-28 00:00:00 | 2007
Manila Express | 4250 | 3 years + seven 1-year exensions + two 1 year options |  | HL USA | 18 | 10 |  | 18.5 |  |  | 19 |  |  |  |  |  |  |  | 2007-05-23 00:00:00 | 2007
COSCO Fuzhou | 3500 | 12 years | 12 | COSCON | 19 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 2007-03-27 00:00:00 | 2007
COSCO Yingkou | 3500 | 12 years | 12 | COSCON | 19 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 2007-07-05 00:00:00 | 2007
CSCL Panama | 2500 | 12 years | 12 | CSCL Asia | 16.75 | 6 |  | 16.9 |  |  |  |  |  |  |  |  |  |  | 2008-05-15 00:00:00 | 2008
CSCL Montevideo | 2500 | 12 years | 12 | CSCL Asia | 16.75 | 6 |  | 16.9 |  |  |  |  |  |  |  |  |  |  | 2008-09-06 00:00:00 | 2008
[NAME] | 2500 | 12 years | 12 | CSCL Asia | 16.75 | 6 |  | 16.9 |  |  |  |  |  |  |  |  |  |  | 2008-08-11 00:00:00 | 2008
CSCL Lima | 2500 | 12 years | 12 | CSCL Asia | 16.75 | 6 |  | 16.9 |  |  |  |  |  |  |  |  |  |  | 2008-10-15 00:00:00 | 2008
[NAME] | 2500 | 12 years | 12 | CSCL Asia | 16.75 | 6 |  | 16.9 |  |  |  |  |  |  |  |  |  |  | 2008-11-08 00:00:00 | 2008
[NAME] | 2500 | 12 years | 12 | CSCL Asia | 16.75 | 6 |  | 16.9 |  |  |  |  |  |  |  |  |  |  | 2008-12-01 00:00:00 | 2008
Hull No. S452 | 13100 | 12 years | 12 | COSCON | 55 | 12 |  |  |  |  |  |  |  |  |  |  | HSHI | 165.3
Hull No. 2177 | 13100 | 12 years | 12 | COSCON | 55 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 165.3
Hull No. S453 | 13100 | 12 years | 12 | COSCON | 55 | 12 |  |  |  |  |  |  |  |  |  |  | HSHI | 165.3
Hull No. 2178 | 13100 | 12 years | 12 | COSCON | 55 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 165.3
Hull No. S454 | 13100 | 12 years | 12 | COSCON | 55 | 12 |  |  |  |  |  |  |  |  |  |  | HSHI | 165.3
Hull No. 2179 | 13100 | 12 years | 12 | COSCON | 55 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 165.3
Hull No. 2180 | 13100 | 12 years | 12 | COSCON | 55 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 165.3
Hull No. 2181 | 13100 | 12 years | 12 | COSCON | 55 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 165.3
COSCO Japan | 8500 | 12 years + three one-year options | 15 | COSCON | 42.9 | 12 |  | 43.4 |  |  |  |  |  |  |  |  | HHI | 122.4
COSCO Korea | 8500 | 12 years + three one-year options | 15 | COSCON | 42.9 | 12 |  | 43.4 |  |  |  |  |  |  |  |  | HHI | 122.4
COSCO Philippines | 8500 | 12 years + three one-year options | 15 | COSCON | 42.9 | 12 |  | 43.4 |  |  |  |  |  |  |  |  | HHI | 122.4
COSCO Malaysia | 8500 | 12 years + three one-year options | 15 | COSCON | 42.9 | 12 |  | 43.4 |  |  |  |  |  |  |  |  | HHI | 122.4
COSCO Indonesia | 8500 | 12 years + three one-year options | 15 | COSCON | 42.9 | 12 |  | 43.4 |  |  |  |  |  |  |  |  | HHI | 122.4
COSCO Thailand | 8500 | 12 years + three one-year options | 15 | COSCON | 42.9 | 12 |  | 43.4 |  |  |  |  |  |  |  |  | HHI | 122.4
COSCO Pakistan | 8500 | 12 years + three one-year options | 15 | COSCON | 42.9 | 12 |  | 43.4 |  |  |  |  |  |  |  |  | HHI | 122.4
COSCO Vietnam | 8500 | 12 years + three one-year options | 15 | COSCON | 42.9 | 12 |  | 43.4 |  |  |  |  |  |  |  |  | HHI | 122.4
[NAME] | 5100 | 12 years | 12 | MOL | 28.9 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 77.4
MOL Eminence | 5100 | 12 years | 12 | MOL | 28.9 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 77.4
MOL Emissary | 5100 | 12 years | 12 | MOL | 28.9 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 77.4
MOL Empire | 5100 | 12 years | 12 | MOL | 28.9 | 12 |  |  |  |  |  |  |  |  |  |  | HHI | 77.4
Hull No. 1851 | 4500 | 12 years + two three- year options | 18 | K-Line | 34.25 | 6 |  | 34.5 | 6 |  | 37.5 | 3 |  | 42.5 |  |  | Samsung | Leased
Hull No. 1852 | 4500 | 12 years + two three- year options | 18 | K-Line | 34.25 | 6 |  | 34.5 | 6 |  | 37.5 | 3 |  | 42.5 |  |  | Samsung | Leased
Hull No. 1853 | 4500 | 12 years + two three- year options | 18 | K-Line | 34.25 | 6 |  | 34.5 | 6 |  | 37.5 | 3 |  | 42.5 |  |  | Samsung | Leased
Hull No. 1854 | 4500 | 12 years + two three- year options | 18 | K-Line | 34.25 | 6 |  | 34.5 | 6 |  | 37.5 | 3 |  | 42.5 |  |  | Samsung | Leased
Hull No. 1855 | 4500 | 12 years + two three- year options | 18 | K-Line | 34.25 | 6 |  | 34.5 | 6 |  | 37.5 | 3 |  | 42.5 |  |  | Samsung | Leased
[NAME] | 4250 | 6 years | 6 | [NAME] | 25.9 | 6 |  |  |  |  |  |  |  |  |  |  | New Jiangsu | 61.4
[NAME] Lumaco | 4250 | 6 years | 6 | [NAME] | 25.9 | 6 |  |  |  |  |  |  |  |  |  |  | New Jiangsu | 61.4
[NAME] | 4250 | 6 years | 6 | [NAME] | 25.9 | 6 |  |  |  |  |  |  |  |  |  |  | New Jiangsu | 61.4
[NAME] | 4250 | 6 years | 6 | [NAME] | 25.9 | 6 |  |  |  |  |  |  |  |  |  |  | New Jiangsu | 61.4
CSCL Callao | 2500 | 12 years | 12 | CSCL Asia | 16.75 | 6 |  | 16.9 |  |  |  |  |  |  |  |  | Jiangsu | 41.4
[NAME] | 2500 | 12 years | 12 | CSCL Asia | 16.75 | 6 |  | 16.9 |  |  |  |  |  |  |  |  | Jiangsu | 41.4
[NAME] | 2500 | 10 years | 10 | K-Line | 17.9 | 10 |  |  |  |  |  |  |  |  |  |  | Jiangsu | 41.4
Calicanto Bridge | 2500 | 10 years | 10 | K-Line | 17.9 | 10 |  |  |  |  |  |  |  |  |  |  | Jiangsu | 41.4