P&L $ AMOUNTS IN USD (except noted) Monday, 16 de July de 2018
El material adjunto que puede incluir proyecciones financieras ha sido preparado únicamente por el proyecto y puede contener declaraciones de escenarios futuros que involucran riesgos e incertidumbres. Cualquiera de estas declaraciones de proyecciones no representan garantías de resultados, desempeños o logros.
MODIFY CELLS IN THIS FORMAT ONLY YEAR/MONTH
2017
2018
2019
2020
2021
2022
# DAYS
365
366
365
365
365
366
REVENUES
.
Maritime Transport Service
$0
$0
$2,622,000
$10,420,750
$15,622,000
$20,898,600
Charter by Day Charter by Hour Charter by Pax/seat Charter by Ton/m2 on deck
$0
$0
$966,000
$3,193,750
$5,110,000
$6,405,000
$0
$0
$331,200
$1,971,000
$2,628,000
$3,952,800
$0
$0
$772,800
$3,066,000
$4,599,000
$6,148,800
$0
$0
$552,000
$2,190,000
$3,285,000
$4,392,000
Fuel surcharge to clients
$0
$0
$2,359,461
$8,571,636
$13,506,183
$17,713,156
Fuel surcharge for "By day Service" Fuel surcharge for "By day Service" Fuel surcharge for "By day Service"
$0
$0
$1,913,076
$6,396,744
$10,389,371
$13,218,773
$0
$0
$191,308
$1,151,414
$1,558,406
$2,379,379
$0
$0
$255,077
$1,023,479
$1,558,406
$2,115,004
Margin over fuel surcharge
$0
$0
$2,357
$8,563
$13,493
$17,695
Platform use Fee
$0
$0
$4,600
$18,250
$27,375
$36,600
Fee from operators for platform usage
$0
$0
$4,600
$18,250
$27,375
$36,600
Others
$0
$0
$0
$0
$0
$0
Others
$0
$0
$0
$0
$0
$0
$0
$0
$4,986,061
$19,010,636
$29,155,558
$38,648,356
$0
$97,196
$237,610
$313,047
$315,785
$318,552
Total revenue OPEX
Fixed Electronic Platform O&M Administrative expenses Marketing Expenses Others Variable
$0
$0
$64,980
$117,675
$120,413
$123,180
$0
$97,196
$160,630
$171,372
$171,372
$171,372
$0
$0
$12,000
$24,000
$24,000
$24,000
$0
$0
$0
$0
$0
$0
$0
$0
$1,351,972
$5,252,701
$7,933,711
$10,534,185
Vessels Charter Payment intermediary (Conekta, PayPal, etc.) Others Installation Electronic Platform Design & Development Installation Expenses Others Fuel cost Total Opex P&L
$0
$0
$1,324,800
$5,146,500
$7,774,500
$10,321,200
$0
$0
$27,172
$106,201
$159,211
$212,985
$0
$0
$0
$0
$0
$0
$0
$7,258
$155,080
$0
$0
$0
$0
$7,258
$155,080
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,357,104
$8,563,073
$13,492,690
$17,695,461
$0
$104,454
$4,101,765
$14,128,822
$21,742,186
$28,548,198
2017
2018
2019
2020
2021
2022
OPERATING REVENUES
$0
$0
$4,986,061
$19,010,636
$29,155,558
$38,648,356
OPEX
$0
$104,454
$4,101,765
$14,128,822
$21,742,186
$28,548,198
$0
-$104,454
$884,295
$4,881,815
$7,413,372
$10,100,159
EBITDA MARGIN
#DIV/0!
DEPRECIATION EBIT MARGIN
#DIV/0!
18%
26%
25%
26%
$0
$0
$0
$0
$0
$0
$0
-$104,454
$884,295
$4,881,815
$7,413,372
$10,100,159
#DIV/0!
#DIV/0!
18%
26%
25%
26%
INTEREST INCOME
$0
$0
$0
$0
$0
$0
INTEREST COST
$0
$0
$0
$0
$0
$0
NET FINANCIALS
$0
$0
$0
$0
$0
$0
$0
-$104,454
$884,295
$4,881,815
$7,413,372
$10,100,159
EBT MARGIN
#DIV/0!
TAX
#DIV/0!
$0 NET PROFIT MARGIN
$0 #DIV/0!
18%
$0 -$104,454 #DIV/0!
26%
25%
26%
$334,431
$1,464,544
$2,224,012
$3,030,048
$549,865
$3,417,270
$5,189,361
$7,070,111
11%
18%
18%
18%
$3,862,681
$9,052,041
$16,122,153
2020
2021
2022
ACCUMULATED PROFIT ACCUMULATED PROFIT
$0
CASHFLOW
2017
-$104,454
2018
$445,411
2019
Income
$0
$0
$4,986,061
$19,010,636
$29,155,558
$38,648,356
Cash contributions
$0
$334,478
$42,843
$0
$0
$0
Loans
$0
$0
$0
$0
$0
$0
Total Income
$0
$334,478
$5,028,904
$19,010,636
$29,155,558
$38,648,356
Opex
$0
$104,454
$4,101,765
$14,128,822
$21,742,186
$28,548,198
Loans (k+i)
$0
$0
$0
$0
$0
$0
Others
$0
$0
$0
$0
$0
$0
Taxes
$0
$0
$334,431
$1,464,544
$2,224,012
$3,030,048
Total Expenses
$0
$104,454
$4,436,196
$15,593,366
$23,966,197
$31,578,245
Income - Expenses
$0
$230,024
$592,708
$3,417,270
$5,189,361
$7,070,111
Initial Cashflow
$0
$0
$230,024
$822,732
$4,240,002
$9,429,363
$0
$230,024
$822,732
$4,240,002
$9,429,363
$16,499,474
2020
2021
Expenses
Final Cashflow MÍNIMO
-
.
2017
2018
2019
2022
2023
2024
2025
2026
2027
2028
2029
365
365
365
366
365
365
365
$26,042,750
$31,262,250
$31,262,250
$31,347,900
$31,262,250
$31,262,250
$31,262,250
$8,303,750
$9,581,250
$9,581,250
$9,607,500
$9,581,250
$9,581,250
$9,581,250
$4,599,000
$5,913,000
$5,913,000
$5,929,200
$5,913,000
$5,913,000
$5,913,000
$7,665,000
$9,198,000
$9,198,000
$9,223,200
$9,198,000
$9,198,000
$9,198,000
$5,475,000
$6,570,000
$6,570,000
$6,588,000
$6,570,000
$6,570,000
$6,570,000
$22,883,165
$27,304,007
$27,716,395
$28,211,658
$28,559,950
$28,991,307
$29,429,178
$17,396,558
$20,376,125
$20,683,877
$21,053,476
$21,313,395
$21,635,303
$21,962,073
$2,810,213
$3,667,702
$3,723,098
$3,789,626
$3,836,411
$3,894,355
$3,953,173
$2,676,394
$3,260,180
$3,309,420
$3,368,556
$3,410,143
$3,461,649
$3,513,932
$22,860
$27,277
$27,689
$28,183
$28,531
$28,962
$29,400
$45,625
$54,750
$54,750
$54,900
$54,750
$54,750
$54,750
$45,625
$54,750
$54,750
$54,900
$54,750
$54,750
$54,750
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$48,971,540
$58,621,007
$59,033,395
$59,614,458
$59,876,950
$60,308,307
$60,746,178
$321,260
$323,997
$323,997
$324,042
$323,997
$323,997
$323,997
$125,888
$128,625
$128,625
$128,670
$128,625
$128,625
$128,625
$171,372
$171,372
$171,372
$171,372
$171,372
$171,372
$171,372
$24,000
$24,000
$24,000
$24,000
$24,000
$24,000
$24,000
$0
$0
$0
$0
$0
$0
$0
$13,186,412
$15,758,104
$15,758,104
$15,801,277
$15,758,104
$15,758,104
$15,758,104
$12,921,000
$15,439,500
$15,439,500
$15,481,800
$15,439,500
$15,439,500
$15,439,500
$265,412
$318,604
$318,604
$319,477
$318,604
$318,604
$318,604
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$22,860,305
$27,276,731
$27,688,706
$28,183,474
$28,531,418
$28,962,344
$29,399,779
$36,367,977
$43,358,832
$43,770,807
$44,308,794
$44,613,520
$45,044,445
$45,481,880
2023
2024
2025
2026
2027
2028
2029
$48,971,540
$58,621,007
$59,033,395
$59,614,458
$59,876,950
$60,308,307
$60,746,178
$36,367,977
$43,358,832
$43,770,807
$44,308,794
$44,613,520
$45,044,445
$45,481,880
$12,603,564
$15,262,176
$15,262,588
$15,305,664
$15,263,430
$15,263,861
$15,264,299
26%
26%
26%
26%
25%
25%
25%
$0
$0
$0
$0
$0
$0
$0
$12,603,564
$15,262,176
$15,262,588
$15,305,664
$15,263,430
$15,263,861
$15,264,299
26%
26%
26%
26%
25%
25%
25%
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$12,603,564
$15,262,176
$15,262,588
$15,305,664
$15,263,430
$15,263,861
$15,264,299
26%
26%
26%
26%
25%
25%
25%
$3,781,069
$4,578,653
$4,578,776
$4,591,699
$4,579,029
$4,579,158
$4,579,290
$8,822,494
$10,683,523
$10,683,811
$10,713,965
$10,684,401
$10,684,703
$10,685,009
18%
18%
18%
18%
18%
18%
18%
$24,944,647
$35,628,170
$46,311,981
$57,025,946
$67,710,347
$78,395,050
$89,080,059
2023
2024
2025
2026
2027
2028
2029
$48,971,540
$58,621,007
$59,033,395
$59,614,458
$59,876,950
$60,308,307
$60,746,178
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$48,971,540
$58,621,007
$59,033,395
$59,614,458
$59,876,950
$60,308,307
$60,746,178
$36,367,977
$43,358,832
$43,770,807
$44,308,794
$44,613,520
$45,044,445
$45,481,880
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$3,781,069
$4,578,653
$4,578,776
$4,591,699
$4,579,029
$4,579,158
$4,579,290
$40,149,046
$47,937,484
$48,349,584
$48,900,493
$49,192,549
$49,623,604
$50,061,169
$8,822,494
$10,683,523
$10,683,811
$10,713,965
$10,684,401
$10,684,703
$10,685,009
$16,499,474
$25,321,968
$36,005,491
$46,689,302
$57,403,267
$68,087,668
$78,772,371
$25,321,968
$36,005,491
$46,689,302
$57,403,267
$68,087,668
$78,772,371
$89,457,380
2023
2024
2025
2026
2027
2028
2029