Operação
DRE operacional (USALI)
Uniform System of Accounts for the Lodging Industry: departamentais, undistributed, fixos, EBITDA, reserva de FF&E e NOI. Cenário Base.
Ocupação estabilizada
72,7%
ADR estabilizado
R$ 609
Nominal, BRL
Margem EBITDA
29,6%
NOI estabilizado
R$ 15.8 mi
Receita, GOP e margem EBITDA
Receita por centro de resultado
| C1 | C2 | C3 | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 | Y9 | Y10 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Hospedagem | R$ 0 | R$ 0 | R$ 0 | R$ 20.767.939 | R$ 24.400.146 | R$ 28.248.318 | R$ 32.403.386 | R$ 37.476.699 | R$ 39.261.117 | R$ 41.130.499 | R$ 43.206.941 | R$ 45.140.526 | R$ 47.289.850 |
| Restaurante principal | R$ 0 | R$ 0 | R$ 0 | R$ 4.324.777 | R$ 4.859.196 | R$ 5.432.955 | R$ 6.139.502 | R$ 7.047.769 | R$ 7.364.919 | R$ 7.696.340 | R$ 8.064.710 | R$ 8.404.596 | R$ 8.782.802 |
| Bar & Lanches | R$ 0 | R$ 0 | R$ 0 | R$ 1.261.393 | R$ 1.417.265 | R$ 1.584.612 | R$ 1.790.688 | R$ 2.055.599 | R$ 2.148.101 | R$ 2.244.766 | R$ 2.352.207 | R$ 2.451.340 | R$ 2.561.651 |
| Rooftop Bar | R$ 0 | R$ 0 | R$ 0 | R$ 606.729 | R$ 681.703 | R$ 762.196 | R$ 858.966 | R$ 988.741 | R$ 1.033.234 | R$ 1.079.730 | R$ 1.128.318 | R$ 1.179.092 | R$ 1.232.151 |
| Eventos — locação de espaços | R$ 0 | R$ 0 | R$ 0 | R$ 1.412.670 | R$ 1.761.964 | R$ 2.139.834 | R$ 2.444.138 | R$ 2.717.154 | R$ 2.839.426 | R$ 2.967.200 | R$ 3.100.724 | R$ 3.240.256 | R$ 3.386.068 |
| Eventos — banquetes & catering | R$ 0 | R$ 0 | R$ 0 | R$ 3.007.620 | R$ 3.751.278 | R$ 4.555.775 | R$ 5.203.649 | R$ 5.784.908 | R$ 6.045.229 | R$ 6.317.264 | R$ 6.601.541 | R$ 6.898.610 | R$ 7.209.048 |
| Eventos — AV, equipamentos e serviços | R$ 0 | R$ 0 | R$ 0 | R$ 637.980 | R$ 795.726 | R$ 966.377 | R$ 1.103.804 | R$ 1.227.102 | R$ 1.282.321 | R$ 1.340.026 | R$ 1.400.327 | R$ 1.463.342 | R$ 1.529.192 |
| SPA | R$ 0 | R$ 0 | R$ 0 | R$ 277.362 | R$ 311.636 | R$ 348.433 | R$ 392.670 | R$ 451.996 | R$ 472.336 | R$ 493.591 | R$ 515.802 | R$ 539.013 | R$ 563.269 |
| Fitness & Multiuso | R$ 0 | R$ 0 | R$ 0 | R$ 106.015 | R$ 119.115 | R$ 133.180 | R$ 150.089 | R$ 172.765 | R$ 180.539 | R$ 188.664 | R$ 197.153 | R$ 206.025 | R$ 215.296 |
| Coworking | R$ 0 | R$ 0 | R$ 0 | R$ 47.021 | R$ 52.832 | R$ 59.070 | R$ 66.570 | R$ 76.627 | R$ 80.076 | R$ 83.679 | R$ 87.445 | R$ 91.380 | R$ 95.492 |
| Lojas (locação) | R$ 0 | R$ 0 | R$ 0 | R$ 75.676 | R$ 95.758 | R$ 112.435 | R$ 117.494 | R$ 122.782 | R$ 128.307 | R$ 134.081 | R$ 140.114 | R$ 146.419 | R$ 153.008 |
| Estacionamento | R$ 0 | R$ 0 | R$ 0 | R$ 245.581 | R$ 275.927 | R$ 308.508 | R$ 347.677 | R$ 400.205 | R$ 418.214 | R$ 437.034 | R$ 456.700 | R$ 477.252 | R$ 498.728 |
| Outras receitas | R$ 0 | R$ 0 | R$ 0 | R$ 446.330 | R$ 531.144 | R$ 614.195 | R$ 694.070 | R$ 796.749 | R$ 832.603 | R$ 870.070 | R$ 911.714 | R$ 950.138 | R$ 992.895 |
| Receita total | R$ 0 | R$ 0 | R$ 0 | R$ 33.217.093 | R$ 39.053.692 | R$ 45.265.888 | R$ 51.712.702 | R$ 59.319.095 | R$ 62.086.421 | R$ 64.982.941 | R$ 68.163.696 | R$ 71.187.990 | R$ 74.509.450 |
Custo de pessoal (visão expandida)
A DRE não trata a folha como linha única. O custo de pessoal é construído de baixo para cima no módulo People Planning & Workforce Model e aqui aparece decomposto por natureza, por departamento e pela linha USALI que o recebe.
Folha (sem turnover)
R$ 18.500.682
Custo de turnover
R$ 1.129.267
Custo de pessoal all-in
R$ 19.629.949
% da receita total
30,2%
Demonstração de resultados
| C1 | C2 | C3 | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 | Y9 | Y10 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Receita bruta | R$ 0 | R$ 0 | R$ 0 | R$ 33.217.093 | R$ 39.053.692 | R$ 45.265.888 | R$ 51.712.702 | R$ 59.319.095 | R$ 62.086.421 | R$ 64.982.941 | R$ 68.163.696 | R$ 71.187.990 | R$ 74.509.450 |
| (–) Tributos sobre receita | R$ 0 | R$ 0 | R$ 0 | (R$ 3.159.776) | (R$ 3.714.982) | (R$ 4.305.918) | (R$ 4.919.171) | (R$ 5.642.729) | (R$ 5.905.971) | (R$ 6.181.502) | (R$ 6.484.072) | (R$ 6.771.758) | (R$ 7.087.711) |
| Receita líquida | R$ 0 | R$ 0 | R$ 0 | R$ 30.057.317 | R$ 35.338.709 | R$ 40.959.970 | R$ 46.793.532 | R$ 53.676.366 | R$ 56.180.450 | R$ 58.801.439 | R$ 61.679.624 | R$ 64.416.232 | R$ 67.421.738 |
| (–) Custos de hospedagem | R$ 0 | R$ 0 | R$ 0 | (R$ 4.374.038) | (R$ 5.220.157) | (R$ 6.053.717) | (R$ 6.860.633) | (R$ 7.898.192) | (R$ 8.277.305) | (R$ 8.674.616) | (R$ 9.115.905) | (R$ 9.527.366) | (R$ 9.984.679) |
| (–) Custos de A&B e acessórios | R$ 0 | R$ 0 | R$ 0 | (R$ 6.937.867) | (R$ 8.179.587) | (R$ 9.519.174) | (R$ 10.832.745) | (R$ 12.288.305) | (R$ 12.878.144) | (R$ 13.496.294) | (R$ 14.162.493) | (R$ 14.823.034) | (R$ 15.534.540) |
| Lucro departamental | R$ 0 | R$ 0 | R$ 0 | R$ 18.745.412 | R$ 21.938.965 | R$ 25.387.079 | R$ 29.100.154 | R$ 33.489.869 | R$ 35.025.001 | R$ 36.630.528 | R$ 38.401.226 | R$ 40.065.832 | R$ 41.902.519 |
| (–) Administrativas & Gerais | R$ 0 | R$ 0 | R$ 0 | (R$ 2.051.024) | (R$ 2.608.809) | (R$ 3.120.280) | (R$ 3.400.867) | (R$ 3.706.627) | (R$ 3.912.829) | (R$ 4.130.507) | (R$ 4.371.033) | (R$ 4.602.881) | (R$ 4.858.965) |
| (–) Marketing & Vendas | R$ 0 | R$ 0 | R$ 0 | (R$ 1.596.898) | (R$ 1.998.606) | (R$ 2.378.662) | (R$ 2.626.326) | (R$ 2.904.299) | (R$ 3.066.604) | (R$ 3.237.984) | (R$ 3.427.136) | (R$ 3.610.028) | (R$ 3.811.793) |
| (–) Manutenção (POM) | R$ 0 | R$ 0 | R$ 0 | (R$ 1.257.052) | (R$ 1.596.933) | (R$ 1.900.447) | (R$ 2.048.772) | (R$ 2.207.289) | (R$ 2.314.431) | (R$ 2.426.777) | (R$ 2.550.900) | (R$ 2.668.101) | (R$ 2.797.623) |
| (–) Utilidades | R$ 0 | R$ 0 | R$ 0 | (R$ 1.442.964) | (R$ 1.784.375) | (R$ 2.106.101) | (R$ 2.319.977) | (R$ 2.560.680) | (R$ 2.686.052) | (R$ 2.817.567) | (R$ 2.962.540) | (R$ 3.100.243) | (R$ 3.252.051) |
| (–) Tecnologia | R$ 0 | R$ 0 | R$ 0 | (R$ 310.426) | (R$ 400.857) | (R$ 479.365) | (R$ 510.179) | (R$ 541.491) | (R$ 567.632) | (R$ 595.035) | (R$ 625.355) | (R$ 653.875) | (R$ 685.442) |
| GOP | R$ 0 | R$ 0 | R$ 0 | R$ 12.087.048 | R$ 13.549.386 | R$ 15.402.223 | R$ 18.194.033 | R$ 21.569.482 | R$ 22.477.452 | R$ 23.422.658 | R$ 24.464.262 | R$ 25.430.705 | R$ 26.496.645 |
| (–) IPTU | R$ 0 | R$ 0 | R$ 0 | (R$ 398.605) | (R$ 468.644) | (R$ 543.191) | (R$ 620.552) | (R$ 711.829) | (R$ 745.037) | (R$ 779.795) | (R$ 817.964) | (R$ 854.256) | (R$ 894.113) |
| (–) Seguros | R$ 0 | R$ 0 | R$ 0 | (R$ 448.626) | (R$ 470.160) | (R$ 492.728) | (R$ 516.379) | (R$ 541.165) | (R$ 567.141) | (R$ 594.364) | (R$ 622.893) | (R$ 652.792) | (R$ 684.126) |
| (–) Base fee de gestão | R$ 0 | R$ 0 | R$ 0 | (R$ 830.427) | (R$ 976.342) | (R$ 1.131.647) | (R$ 1.292.818) | (R$ 1.482.977) | (R$ 1.552.161) | (R$ 1.624.574) | (R$ 1.704.092) | (R$ 1.779.700) | (R$ 1.862.736) |
| (–) Incentive fee | R$ 0 | R$ 0 | R$ 0 | (R$ 725.223) | (R$ 812.963) | (R$ 924.133) | (R$ 1.091.642) | (R$ 1.294.169) | (R$ 1.348.647) | (R$ 1.405.359) | (R$ 1.467.856) | (R$ 1.525.842) | (R$ 1.589.799) |
| EBITDA | R$ 0 | R$ 0 | R$ 0 | R$ 9.684.167 | R$ 10.821.276 | R$ 12.310.524 | R$ 14.672.642 | R$ 17.539.342 | R$ 18.264.467 | R$ 19.018.566 | R$ 19.851.456 | R$ 20.618.115 | R$ 21.465.871 |
| (–) Reserva de FF&E | R$ 0 | R$ 0 | R$ 0 | (R$ 996.513) | (R$ 1.171.611) | (R$ 1.357.977) | (R$ 1.551.381) | (R$ 1.779.573) | (R$ 1.862.593) | (R$ 1.949.488) | (R$ 2.044.911) | (R$ 2.135.640) | (R$ 2.235.283) |
| NOI | R$ 0 | R$ 0 | R$ 0 | R$ 8.687.654 | R$ 9.649.666 | R$ 10.952.548 | R$ 13.121.261 | R$ 15.759.769 | R$ 16.401.874 | R$ 17.069.078 | R$ 17.806.546 | R$ 18.482.475 | R$ 19.230.587 |
| (–) Depreciação e amortização | R$ 0 | R$ 0 | R$ 0 | (R$ 7.459.056) | (R$ 7.459.056) | (R$ 7.459.056) | (R$ 7.459.056) | (R$ 7.459.056) | (R$ 7.459.056) | (R$ 7.459.056) | (R$ 7.459.056) | (R$ 7.459.056) | (R$ 7.459.056) |
| EBIT | R$ 0 | R$ 0 | R$ 0 | R$ 1.228.598 | R$ 2.190.609 | R$ 3.493.491 | R$ 5.662.205 | R$ 8.300.713 | R$ 8.942.817 | R$ 9.610.022 | R$ 10.347.489 | R$ 11.023.419 | R$ 11.771.531 |
| (–) Despesas financeiras | R$ 0 | R$ 0 | R$ 0 | (R$ 4.409.789) | (R$ 4.409.789) | (R$ 4.094.804) | (R$ 3.779.819) | (R$ 3.464.834) | (R$ 3.149.849) | (R$ 2.834.864) | (R$ 2.519.879) | (R$ 2.204.894) | (R$ 1.889.909) |
| LAIR | R$ 0 | R$ 0 | R$ 0 | (R$ 3.181.191) | (R$ 2.219.180) | (R$ 601.313) | R$ 1.882.386 | R$ 4.835.879 | R$ 5.792.968 | R$ 6.775.157 | R$ 7.827.610 | R$ 8.818.524 | R$ 9.881.621 |
| (–) IRPJ e CSLL | R$ 0 | R$ 0 | R$ 0 | R$ 0 | R$ 0 | R$ 0 | (R$ 448.008) | (R$ 1.150.939) | (R$ 1.378.726) | (R$ 1.612.487) | (R$ 2.588.027) | (R$ 2.998.298) | (R$ 3.359.751) |
| Lucro líquido | R$ 0 | R$ 0 | R$ 0 | (R$ 3.181.191) | (R$ 2.219.180) | (R$ 601.313) | R$ 1.434.378 | R$ 3.684.939 | R$ 4.414.242 | R$ 5.162.670 | R$ 5.239.583 | R$ 5.820.226 | R$ 6.521.870 |