The numbers come from 50 sector databases and reach Excel with formulas.
Queries reach Brazil's ANTAQ port berthings, IBGE production data and Comex Stat foreign trade, by period and territory. The map measures each route, and the model comes out as a spreadsheet ready for the committee.
ANTAQ’s 2,623 berthings underpin the port’s demand through 2040.
For the study of the Brazilian port of Imbituba, the query split the 2019 to 2025 berthings by year and cargo profile. The figures went straight into the three scenarios and the study’s spreadsheet.
Port cargo movements
How do cargo movements at Imbituba vary by year and cargo profile?
- Source
- ANTAQ · Brazilian port cargo movements
- Requested period
- 2019–2025
- Measure
- Gross weight
Million tonnes per year
- 2019
- 5.76
- 2024
- 8.32
- 2025
- 7.07
The map measures 14 routes from Southern Brazil’s mines to the Port of Santos.
The published study locates mineral producers in 12 municipalities of Paraná, Santa Catarina and Rio Grande do Sul and traces the road route from each one to the port, from 440 to 1,530 km, with railways as a layer.
Routes to the Port of Santos
Coal, limestone, clay and other mineral origins in Paraná, Santa Catarina and Rio Grande do Sul, with the approximate road distance of each route to the port.
14 routes12 origin municipalities
| Origin | Approx. distance |
|---|---|
| Rio Branco do SulPR → SP | ≈ 440 km |
| BotuveráSC → SP | ≈ 670 km |
| CandiotaRS → SP | ≈ 1,530 km |
- Highlighted routes
- Other study routes
Redrawn from the published study · approximate road distances
Geographic boundaries: IBGEChecked on
Railways, ports and airports along the way
The railway network, ports and airports of Southern Brazil come in as layers over the study routes.
- PortsPort locations within the area
- AirportsAirport locations
- RailwaysRailway alignments
- Study routes
Reference layers over the study routes.
Infrastructure: Plannk geographic base.
The national railway network
At national scale, the four study states sit within Brazil’s railway network.
- Study states
- Railways
Railway alignments, with no indication of operation or freight. Infrastructure: Plannk geographic base.
In under three hours, the model showed the silos do not pay off.
A grain trader is deciding between building two 60,000-tonne silos and continuing to pay for storage. The ten-year model comes out in Excel with formulas and shows negative NPV across the three origination volumes.
Owned or outsourced storage
Agribusiness
BRL · Brazilian real
10 years
Scenarios
Volumes in thousand metric tonnes per year
Annual volume300
Owned capacity: 216Outsourced excess: 84
Annual volume450
Owned capacity: 216Outsourced excess: 234
Annual volume600
Owned capacity: 216Outsourced excess: 384
In this study, NPV remains negative across all three volume scenarios.
- Nominal cost of capital
- 17.21%
- Internal rate of return
- −0.8%
- Construction investment
- R$ 181.0 m
- Additional working capital
- ≈ R$ 32.3 m
Edit and run again
You change the turnover or the volume and run it again.
Download Excel
The workbook carries the assumptions and the calculations in formulas.
Compare building owned silos with outsourced storage. Consider the reference documents and the study’s three volume scenarios over ten years.
Figures come from the published Brazilian study; turnover of 1.8 is an assumption and all monetary values remain in Brazilian reais.
Open the full study (in Portuguese). Opens in a new tab.The thesis becomes a list of assets to investigate.
You start from your own list or a thesis such as “industrial software companies”, and Radar puts the series on the same chart, with the correlation of returns. The move that stands out goes on to in-depth research.
Your list or preset
Market regime
Scanner: Score · Volatility · RSI
Compare how assets behave
Discovery by thesis
Industrial software companies
Candidates to investigate · A / B / C
Explore the sources
- Official announcements
- Regulatory filings
- News and research
Track what changed
Regime · Signals · Alerts on a saved preset
Take the analysis to Excel
Series · Correlation · Research · .xlsx
Series A, B and C for comparison. No real-time quotes. Coverage depends on the asset and source.
Frequently asked questions
How do Plannk databases complement web research?
Research finds publications; databases let you query records, filter periods and areas, and compare measures. Each query respects the meaning of the fields and the limits of the source. Results can feed tables, charts, maps and deliverables, with coverage and freshness specific to each database.
Are spreadsheet numbers connected to formulas or merely pasted values?
Core calculations and assumptions included in scope use auditable formulas and editable cells. Imported data, snapshots, and some intermediate results may remain as recorded values identified in the model.
What happens when an important assumption has no source?
It should enter as an assumption, with a clear origin and owner recorded next to it. Scenarios and sensitivities then show how much the conclusion depends on that value.
Can I compare internal spreadsheets with public or market sources?
Yes. Use spreadsheets in Modeling, the Superagent or the Resolver and compare them with available public sources. They stay in the project and do not enter the database catalog. Align units, periods, currencies and criteria before combining results.
Does Market Radar cover every asset and work in real time?
No. Radar covers only the markets and assets available in the platform, and is neither universal nor real-time. Coverage and frequency vary by asset class and source.
What material helps start a financial model?
Provide the decision objective, horizon, operating assumptions, investments, costs, financing, tax treatment, and scenarios to compare. If any of this already exists in a spreadsheet, it can serve as the assumptions workbook.
The scenarios show how much the decision depends on each assumption.
Bring the question, the assumptions you already have, and what you need to compare before choosing.