Advanced financial modeling and industry databases
Dozens of sector and market databases feed maps and financial models. The analysis continues in Excel, with editable assumptions and formulas.
Databases
Consults official databases to support the analysis.
For the access channel at the Port of Imbituba in Santa Catarina, Brazil, Plannk uses 2,623 berthings from 2019 to 2025 to project scenarios through 2040. The data comes from Brazil’s National Waterway Transportation Agency (ANTAQ).
How has cargo throughput changed at the Port of Imbituba in Santa Catarina, Brazil?
- Source
- Brazil’s National Waterway Transport Agency (ANTAQ)
- Period
- 2019–2025
- Measure
- Gross weight
Throughput grew 23% from 2019 to 2025
Port total, in million tonnes
- 2019
- 5.76
- 2024
- 8.32
- 2025
- 7.07
Maps
Plots routes and compares distances to the port.
Plannk connects mines in 12 Southern Brazilian municipalities to the Port of Santos in São Paulo, Brazil: 14 road routes from 440 to 1,530 km, with the rail network overlaid on the map.
Routes to the Port of Santos run from 440 to 1,530 km
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 of Santos in São Paulo, Brazil.
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: Brazilian Institute of Geography and Statistics (IBGE)Checked 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.
- RailwaysRailway alignments
- PortsPort locations within the area
- AirportsAirport locations
- 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.
Geographic boundaries: Brazilian Institute of Geography and Statistics (IBGE)
Financial modeling
In this study, owned silos are not worth the investment.
Plannk compared building two 60,000-tonne grain silos with paying for third-party storage. The Brazilian study assessed three ten-year scenarios in under three hours.
Owned or outsourced grain storage
Agribusiness
BRL · Brazilian real
10 years
Above 216 thousand t a year, the volume goes to third-party storage
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 all three scenarios, projected returns fall short of the investment after accounting for the time value of money (negative NPV).
- 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 inventory turnover or grain volume and run the model 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 from the published Brazilian study, in Brazilian reais. The model assumes 1.8 inventory cycles per year.
Open the full study (in Portuguese). Opens in a new tab.Market Radar
Compares financial assets and market history.
You choose the financial assets or investment hypothesis. Plannk compares the available data series in Market Radar.
Finds companies by investment hypothesis
Industrial software companies
Assets found for analysis ABC
Market conditions · Filters: Score · Price swings · Relative strength (RSI)
A and B rise together, and C swings the other way
Change from a starting value of 100 · example values
Sources to go deeper
Official announcements · Regulatory filings · News and research
Alerts on what changed
Market conditions · Indicators · Alerts in the saved configuration
Export to Excel
Series · Correlation · Research · .xlsx
A, B and C are fictional assets without real-time quotes. RSI compares the strength of recent gains and losses. Coverage depends on the asset and source.
View values by step
| Step | A | B | C |
|---|---|---|---|
| 1 | Value: 100Change: Starting value, no previous step | Value: 100Change: Starting value, no previous step | Value: 100Change: Starting value, no previous step |
| 2 | Value: 103Change: +3 | Value: 102Change: +2 | Value: 98Change: −2 |
| 3 | Value: 101Change: −2 | Value: 101Change: −1 | Value: 102Change: +4 |
| 4 | Value: 106Change: +5 | Value: 104Change: +3 | Value: 100Change: −2 |
| 5 | Value: 105Change: −1 | Value: 102Change: −2 | Value: 103Change: +3 |
| 6 | Value: 110Change: +5 | Value: 106Change: +4 | Value: 101Change: −2 |
| 7 | Value: 108Change: −2 | Value: 105Change: −1 | Value: 104Change: +3 |
| 8 | Value: 113Change: +5 | Value: 109Change: +4 | Value: 102Change: −2 |
| 9 | Value: 116Change: +3 | Value: 110Change: +1 | Value: 105Change: +3 |
Frequently asked questions
How do Plannk databases complement web research?
Web research finds publications; databases let you filter records by period and location. Plannk brings results into tables, charts, maps and files, respecting what each field measures and the source’s coverage and update limits.
Do the spreadsheets have editable formulas?
Calculations and assumptions within scope use auditable formulas and editable cells. Imported data, values captured on a specific date and some intermediate results may remain as identified values.
What happens when an important assumption has no source?
It is labeled as an assumption, with its origin and owner, separately from confirmed data. Scenarios and variations show how much the result depends on that value.
Can I compare internal spreadsheets with public or market sources?
Yes, in Modeling, the Superagent or the Resolver. Spreadsheets stay in the project, outside the database catalog; check units, periods, currencies and criteria before combining data.
Does Market Radar cover every asset and work in real time?
No. Market Radar covers only the markets and assets available in the platform and does not operate in real time. Update frequency varies by asset class and source.
What do I need to start a financial model?
Provide the objective, time horizon, operating assumptions, investments, costs, financing, taxes and scenarios. An existing spreadsheet can serve as a reference for the assumptions.