Nautech MX-Proyecciones-30ABR2018.xlsx

16 jul. 2018 - $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.
122KB Größe 11 Downloads 11 vistas
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