CloudyVessel Valuation
DCF investment analysis
Base Case · 10,000 TEU · $100M purchase price
Vessel inputs (18 fields)
NPV
$2.1m
IRR
10.6%
Signal
Marginal
Breakeven
$11.6k/day
Payback year
11
Scenarios
| Scenario | Inflation | Discount | NPV | IRR | Signal |
|---|---|---|---|---|---|
| Best | 1% | 8% | $8.4m | 14.2% | Favorable |
| Base | 3% | 10% | $2.1m | 10.6% | Marginal |
| Worst | 5% | 12% | -$3.6m | 8.1% | Unfavorable |
Signal band ±2.0pp around discount rate
Reset to base caseSensitivity · IRR vs revenue/day
Min $8k · Max $18kRevenue per day ($k)
Asset Discounted Cash Flow Tool
Our client builds container ships and needed a fast, consistent way to evaluate whether a new vessel investment pencils out before committing capital.
What we worked on
Custom Software
Background
We built a DCF valuation tool that takes vessel inputs - purchase price, TEU size, charter revenue, operating costs, drydock schedule - and returns NPV, IRR, and a clear investment signal in seconds. It runs sensitivity analysis on charter rates, models Best/Base/Worst case scenarios, and can compare up to 20 saved vessels side by side on one chart.
Calculation Detail
Base Case · 25-year schedule
| Year | Revenue | OpEx | Drydock | Free Cashflow |
|---|---|---|---|---|
| 1 | $17,885k | $3,760k | $0 | $13,610k |
| 5 | $17,885k | $4,231k | $5,000k | $8,074k |
| 10 | $17,885k | $4,905k | $5,000k | $7,308k |
| 15 | $17,885k | $5,687k | $5,000k | $6,419k |
| 20 | $17,885k | $6,592k | $5,000k | $5,390k |
| 25 | $17,885k | $7,642k | $0 | $9,196k |
Challenges
Every vessel valuation was a bespoke spreadsheet, rebuilt or copy-pasted for each deal. Formulas drifted between versions, comparing two vessels meant manually lining up two workbooks, and there was no shared source of truth for the assumptions behind a NPV or IRR number.
Compare vessels
Line item: Free cashflow
| Vessel | NPV | IRR | Signal |
|---|---|---|---|
| Pacific Voyager- 8,000 TEU | -$0.8m | 8.9% | Unfavorable |
| Base Case- 10,000 TEU | $2.1m | 10.6% | Marginal |
| Atlantic Trader- 12,000 TEU | $5.6m | 12.8% | Favorable |
Outcome
Every valuation now runs through the same tested engine, with NPV and IRR checked against a reference financial model so the numbers are trusted. Inputs can come from a manual form, a file upload, or a saved record, and the whole team compares vessels from one shared tool instead of emailing spreadsheets around.
Reference model
NPV/IRR validated against
Up to 20
Vessels compared on one chart
Best / Base / Worst
Investment scenarios modeled
Form, upload, or saved
Input methods supported
Want something like this?
Tell us what's eating your week, and we'll tell you what it would take to automate it.