No bid, month 12
- Input
- R$ 300 mil, 180 meses
- Expected output
- total R$ 512 mil | última parcela 3.705
Effective cost of 8.55% a year.
Carregando ferramenta… / Loading tool…
consorcio embedded bid how it works simulator
Under Bids, adjustment, insurance and assumptions, fill in the free and embedded bid as a percentage of the credit and choose whether the bid reduces the payment or the term. You set the contemplation month; the bid is what makes it plausible.
Effective cost of 8.55% a year.
Present value rises from R$ 290,000 to R$ 304,000.
The last common fund installments disappear.
You get less credit and top up from your pocket.
The tool warns that the bid was capped.
It depends on when you need the asset and what money earns. For a R$ 300,000 home, a 180-month consórcio with an 18% admin fee and 2% reserve fund, a 15-year SAC loan at 11.5% with R$ 60,000 down, index and appreciation of 4.5% and fixed income at 10% gross, the consórcio contemplated in month 36 costs about R$ 289,000 in today's money, against R$ 350,000 for the loan. Investing the payment and buying in cash costs about R$ 203,000, but the home only arrives in month 120. The more urgent the asset, the more the loan makes sense.
The rule for ranking bids (highest percentage, fixed bid or another criterion) comes from the group regulations. The calculator does not predict whether your bid wins: you choose the contemplation month and it computes the cost.
The limit depends on the group regulations, and the rule only allows the modality (art. 13). The tool accepts any value up to what is left of the common fund and warns when it caps.
Reducing the term cuts the last installments, which are the most inflated by the index, and leaves a smaller total. Reducing the payment eases the monthly cash flow. The group contract says what is allowed; simulate both.
In today's money, the lowest-cost path is: Invest the payment and buy in cash, at R$156,456.
Consórcio contemplated in month 36: R$231,822, against R$302,868 for the loan. That is R$71,046 less.
In any contemplation month, the consórcio comes out cheaper than the loan under these assumptions.
Investing the consórcio payment and buying in cash takes until month 104 to own the asset and costs R$156,456.
Assumptions: asset appreciates 4.7% a year, credit adjusted 4.7% a year, fixed income at 14.8% gross, or 12.6% after the 15% tax, which is also the discount rate.
R$231,822
R$302,868
R$156,456
Present value: the sum of everything that leaves your pocket (down payment, payments, bid, top-up and waiting cost), discounted at 12.6% a year. Lower present value means more wealth at the end, because the asset is the same on all three paths.
If contemplation depended only on a draw, with equal odds every month, the expected cost would be R$225,404 (best month: R$221,402; worst: R$233,514).
| Month | Present-value cost | Versus the loan | Effective cost p.a. | Total paid in contract |
|---|---|---|---|---|
| 1 | R$222,129 | -R$80.7K | 7.5% | R$519,896 |
| 6 | R$227,558 | -R$75.3K | 8.1% | R$519,896 |
| 12 | R$233,514 | -R$69.4K | 8.8% | R$519,896 |
| 24 | R$232,638 | -R$70.2K | 9.8% | R$519,896 |
| 36 | R$231,822 | -R$71.0K | 11.3% | R$519,896 |
| 48 | R$231,064 | -R$71.8K | 13.8% | R$519,896 |
| 60 | R$230,359 | -R$72.5K | 18.1% | R$519,896 |
| 72 | R$229,703 | -R$73.2K | 26.7% | R$519,896 |
| 96 | R$228,526 | -R$74.3K | n/a | R$519,896 |
| 120 | R$227,508 | -R$75.4K | n/a | R$519,896 |
| 150 | R$223,740 | -R$79.1K | n/a | R$519,896 |
| 180 | R$225,525 | -R$77.3K | n/a | R$519,896 |
Green: the consórcio costs less than the loan. Amber: it costs more. Effective cost n/a: what you would already have saved covers over 70% of the credit, and the rate stops being informative.
Simulation with editable assumptions, not advice. Check fees, index, bid and contemplation rules in the group contract and in the bank offer.