{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Informações Gerais","Projeções de ativo","Projeção do patr. de cobertura","Renda Fixa \"na curva\""],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Informações Gerais","index":0,"n_rows":51,"n_cols":1,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["SUPERINTENDÊNCIA NACIONAL DE PREVIDÊNCIA COMPLEMENTAR"]
["Planilhas para o estudo técnico disposto na Instrução Previc nº 23/2015"]
[]
[]
[]
[]
[]
["Orientações para preenchimento das planilhas:"]
[]
["Preencher as células em branco das planilhas: Projeções de ativo, Projeção do patr. de cobertura e Renda fixa \"na curva\"."]
[]
["Projeções de ativo"]
[]
["As projeções de ativo devem ser feitas em termos reais descontados do índice inflacionário;"]
["O \"Índice de inflação\" deve ser selecionado na lista suspensa; e"]
["A rubrica \"Projeção do índice inflacionário\" deve ser expressas em termos anuais."]
[]
["Fluxos de ativo"]
["Os fluxos anuais se referem ao total de recursos movimentados anualmente;"]
["Os fluxos devem ser descritos em termos reais;"]
["Os fluxos anuais de investimento e desinvestimento devem ser informados líquidos despesas;"]
["São consideradas receitas os rendimentos tais quais dividendos, alugueis e cupons (ganhos de capital, venda por valor superior ao de compra, não devem ser inseridos como receitas);"]
["A rubrica \"Transferências ao PGA\" deve conter as estimativas de valores anuais transferidos ao PGA referentes exclusivamente a deduções dos investimentos; e"]
["A rubrica \"Transferências ao PGA\" deve ser informada como valor positivo, caso haja reversão de valor do PGA aos investimentos dos planos, devem ser inseridos com sinal negativo."]
[]
["Saldos de ativo"]
["Os saldos anuais se referem às projeções de saldo ao final de cada exercício; e"]
["A rubrica \"Outros ativos\" deve ter o conteúdo detalhado em documento anexo."]
[]
["Rentabilidades"]
["As rentabilidades de cada segmento e do plano devem ser expresso em termos líquidos e anuais."]
[]
["Projeção do patrimônio de cobertura"]
[]
["Todos os fluxos devem ser evidenciados com base nos fluxo reais e posicionados ao final de cada exercício;"]
["Tanto as entradas, quanto as saídas devem ser lançadas em valor absoluto;"]
["O primeiro ano da planilha deverá conter os fluxos realizados no ano anterior ao ano de referência do estudo e, nos anos posteriores, deverão ser projetados (estimados) os fluxos anuais, até o ano do último pagamento de benefício previsto para o plano;"]
["Todos os fluxos devem ser evidenciados líquidos de parcelas referentes a custeio administrativo e de eventuais despesas administrativa ou de investimento;"]
["Os fluxos anuais devem ser projetados em conformidade com as hipóteses e premissas adotadas na última avaliação atuarial do plano de benefícios;"]
["A Rentabilidade Real Projetada deve corresponder à taxa informada na planilha \"Rentabilidades\" que compõe esta pasta de trabalho;"]
["O Patrimônio Projetado deve corresponder ao patrimônio de cobertura rentabilizado pela taxa real e descontado do fluxo de caixa apurado em cada exercício;"]
["O último ano do fluxo de Patrimônio Projetado deve corresponder ao patrimônio residual do plano, se houver; e"]
["As rubricas \"Outros receitas\" e \"Outras despesas\" devem ter o conteúdo detalhados em documento anexo."]
[]
["Renda Fixa \"na curva\""]
[]
["A coluna \"Taxa de apropriação dos juros\" somente deve ser preenchida se houver componente pré-fixado na remuneração do título."]
["A coluna \"Expectativa média para o indexador\" se refere a taxa média do indexador expressa em termos anuais e calculada entre a data de referência do estudo e o vencimento do título."]

{"sheet":"Projeções de ativo","index":1,"n_rows":78,"n_cols":139,"rows_kept":78,"cut":false,"hidden":false,"merged":[[46,0,46,1],[48,0,48,1],[15,0,15,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[17,0,17,1],[18,0,18,1],[36,0,36,1],[41,0,41,1],[16,0,16,1],[21,0,21,1],[26,0,26,1],[31,0,31,1],[28,0,28,1],[29,0,29,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[11,0,11,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[23,0,23,1],[24,0,24,1],[19,0,19,1],[20,0,20,1],[22,0,22,1],[44,0,44,1],[45,0,45,1],[5,0,5,1],[51,0,51,1],[52,0,52,1],[39,0,39,1],[40,0,40,1],[42,0,42,1],[43,0,43,1],[35,0,35,1],[37,0,37,1],[38,0,38,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[27,0,27,1],[72,0,72,1],[73,0,73,1],[47,0,47,1],[53,0,53,1],[54,0,54,1],[63,0,63,1],[50,0,50,1],[60,0,60,1],[61,0,61,1],[77,0,77,1],[30,0,30,1],[25,0,25,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[64,0,64,1],[76,0,76,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1]]}
[null,null,"As projeções estão descitas em termos:"]
[null,null,"Reais"]
["EXERCÍCIOS",null,2015,{"$f":"C3+1","v":2016},{"$f":"D3+1","v":2017},{"$f":"E3+1","v":2018},{"$f":"F3+1","v":2019},{"$f":"G3+1","v":2020},{"$f":"H3+1","v":2021},{"$f":"I3+1","v":2022},{"$f":"J3+1","v":2023},{"$f":"K3+1","v":2024},{"$f":"L3+1","v":2025},{"$f":"M3+1","v":2026},{"$f":"N3+1","v":2027},{"$f":"O3+1","v":2028},{"$f":"P3+1","v":2029},{"$f":"Q3+1","v":2030},{"$f":"R3+1","v":2031},{"$f":"S3+1","v":2032},{"$f":"T3+1","v":2033},{"$f":"U3+1","v":2034},{"$f":"V3+1","v":2035},{"$f":"W3+1","v":2036},{"$f":"X3+1","v":2037},{"$f":"Y3+1","v":2038},{"$f":"Z3+1","v":2039},{"$f":"AA3+1","v":2040},{"$f":"AB3+1","v":2041},{"$f":"AC3+1","v":2042},{"$f":"AD3+1","v":2043},{"$f":"AE3+1","v":2044},{"$f":"AF3+1","v":2045},{"$f":"AG3+1","v":2046},{"$f":"AH3+1","v":2047},{"$f":"AI3+1","v":2048},{"$f":"AJ3+1","v":2049},{"$f":"AK3+1","v":2050},{"$f":"AL3+1","v":2051},{"$f":"AM3+1","v":2052},{"$f":"AN3+1","v":2053},{"$f":"AO3+1","v":2054},{"$f":"AP3+1","v":2055},{"$f":"AQ3+1","v":2056},{"$f":"AR3+1","v":2057},{"$f":"AS3+1","v":2058},{"$f":"AT3+1","v":2059},{"$f":"AU3+1","v":2060},{"$f":"AV3+1","v":2061},{"$f":"AW3+1","v":2062},{"$f":"AX3+1","v":2063},{"$f":"AY3+1","v":2064},{"$f":"AZ3+1","v":2065},{"$f":"BA3+1","v":2066},{"$f":"BB3+1","v":2067},{"$f":"BC3+1","v":2068},{"$f":"BD3+1","v":2069},{"$f":"BE3+1","v":2070},{"$f":"BF3+1","v":2071},{"$f":"BG3+1","v":2072},{"$f":"BH3+1","v":2073},{"$f":"BI3+1","v":2074},{"$f":"BJ3+1","v":2075},{"$f":"BK3+1","v":2076},{"$f":"BL3+1","v":2077},{"$f":"BM3+1","v":2078},{"$f":"BN3+1","v":2079},{"$f":"BO3+1","v":2080},{"$f":"BP3+1","v":2081},{"$f":"BQ3+1","v":2082},{"$f":"BR3+1","v":2083},{"$f":"BS3+1","v":2084},{"$f":"BT3+1","v":2085},{"$f":"BU3+1","v":2086},{"$f":"BV3+1","v":2087},{"$f":"BW3+1","v":2088},{"$f":"BX3+1","v":2089},{"$f":"BY3+1","v":2090},{"$f":"BZ3+1","v":2091},{"$f":"CA3+1","v":2092},{"$f":"CB3+1","v":2093},{"$f":"CC3+1","v":2094},{"$f":"CD3+1","v":2095},{"$f":"CE3+1","v":2096},{"$f":"CF3+1","v":2097},{"$f":"CG3+1","v":2098},{"$f":"CH3+1","v":2099},{"$f":"CI3+1","v":2100},{"$f":"CJ3+1","v":2101},{"$f":"CK3+1","v":2102},{"$f":"CL3+1","v":2103},{"$f":"CM3+1","v":2104},{"$f":"CN3+1","v":2105},{"$f":"CO3+1","v":2106},{"$f":"CP3+1","v":2107},{"$f":"CQ3+1","v":2108},{"$f":"CR3+1","v":2109},{"$f":"CS3+1","v":2110},{"$f":"CT3+1","v":2111},{"$f":"CU3+1","v":2112},{"$f":"CV3+1","v":2113},{"$f":"CW3+1","v":2114},{"$f":"CX3+1","v":2115},{"$f":"CY3+1","v":2116},{"$f":"CZ3+1","v":2117},{"$f":"DA3+1","v":2118},{"$f":"DB3+1","v":2119},{"$f":"DC3+1","v":2120},{"$f":"DD3+1","v":2121},{"$f":"DE3+1","v":2122},{"$f":"DF3+1","v":2123},{"$f":"DG3+1","v":2124},{"$f":"DH3+1","v":2125},{"$f":"DI3+1","v":2126},{"$f":"DJ3+1","v":2127},{"$f":"DK3+1","v":2128},{"$f":"DL3+1","v":2129},{"$f":"DM3+1","v":2130},{"$f":"DN3+1","v":2131},{"$f":"DO3+1","v":2132},{"$f":"DP3+1","v":2133},{"$f":"DQ3+1","v":2134},{"$f":"DR3+1","v":2135},{"$f":"DS3+1","v":2136},{"$f":"DT3+1","v":2137},{"$f":"DU3+1","v":2138},{"$f":"DV3+1","v":2139},{"$f":"DW3+1","v":2140},{"$f":"DX3+1","v":2141},{"$f":"DY3+1","v":2142},{"$f":"DZ3+1","v":2143},{"$f":"EA3+1","v":2144},{"$f":"EB3+1","v":2145},{"$f":"EC3+1","v":2146},{"$f":"ED3+1","v":2147},{"$f":"EE3+1","v":2148},{"$f":"EF3+1","v":2149},{"$f":"EG3+1","v":2150},2151]
[]
["FLUXOS DE ATIVO"]
["FLUXOS DE ATIVO",null,{"$f":"SUM(C7+C12+C17+C22+C27+C32+C37+C42+C47)","v":0},{"$f":"SUM(D7+D12+D17+D22+D27+D32+D37+D42+D47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BP7+BP12+BP17+BP22+BP27+BP32+BP37+BP42+BP47)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(EB7+EB12+EB17+EB22+EB27+EB32+EB37+EB42+EB47)","v":0},0,0,0,0,0,0,0]
["Títulos públicos federais (mantidos até o vencimento)",null,{"$f":"C8-C9-C10+C11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI8-AI9-AI10+AI11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO8-BO9-BO10+BO11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CU8-CU9-CU10+CU11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA8-EA9-EA10+EA11","v":0},0,0,0,0,0,0,0,0]
[" - Investimentos"]
[" - Desinvestimentos"]
[" - Receitas"]
[" - Despesas"]
["Títulos públicos federais (para negociação)",null,{"$f":"C13-C14-C15+C16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI13-AI14-AI15+AI16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO13-BO14-BO15+BO16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CU13-CU14-CU15+CU16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA13-EA14-EA15+EA16","v":0},0,0,0,0,0,0,0,0]
[" - Investimentos"]
[" - Desinvestimentos"]
[" - Receitas"]
[" - Despesas"]
["Renda fixa (exceto títulos públicos federais)",null,{"$f":"C18-C19-C20+C21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI18-AI19-AI20+AI21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO18-BO19-BO20+BO21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CU18-CU19-CU20+CU21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA18-EA19-EA20+EA21","v":0},0,0,0,0,0,0,0,0]
[" - Investimentos"]
[" - Desinvestimentos"]
[" - Receitas"]
[" - Despesas"]
["Renda variável",null,{"$f":"C23-C24-C25+C26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI23-AI24-AI25+AI26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO23-BO24-BO25+BO26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CU23-CU24-CU25+CU26","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA23-EA24-EA25+EA26","v":0},0,0,0,0,0,0,0,0]
[" - Investimentos"]
[" - Desinvestimentos"]
[" - Receitas"]
[" - Despesas"]
["Investimentos estruturados",null,{"$f":"C28-C29-C30+C31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI28-AI29-AI30+AI31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO28-BO29-BO30+BO31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CU28-CU29-CU30+CU31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA28-EA29-EA30+EA31","v":0},0,0,0,0,0,0,0,0]
[" - Investimentos"]
[" - Desinvestimentos"]
[" - Receitas"]
[" - Despesas"]
["Investimentos no exterior",null,{"$f":"C33-C34-C35+C36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI33-AI34-AI35+AI36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO33-BO34-BO35+BO36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CU33-CU34-CU35+CU36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA33-EA34-EA35+EA36","v":0},0,0,0,0,0,0,0,0]
[" - Investimentos"]
[" - Desinvestimentos"]
[" - Receitas"]
[" - Despesas"]
["Operação com participantes",null,{"$f":"C38-C39-C40+C41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI38-AI39-AI40+AI41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO38-BO39-BO40+BO41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CU38-CU39-CU40+CU41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA38-EA39-EA40+EA41","v":0},0,0,0,0,0,0,0,0]
[" - Investimentos"]
[" - Desinvestimentos"]
[" - Receitas"]
[" - Despesas"]
["Imóveis",null,{"$f":"C43-C44-C45+C46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI43-AI44-AI45+AI46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO43-BO44-BO45+BO46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"CU43-CU44-CU45+CU46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA43-EA44-EA45+EA46","v":0},0,0,0,0,0,0,0,0]
[" - Investimentos"]
[" - Desinvestimentos"]
[" - Receitas"]
[" - Despesas"]
["Outros",null,{"$f":"-C48+C49","v":0},{"$f":"D48-D49-D50+D51","v":0},{"$f":"E48-E49-E50+E51","v":0},{"$f":"F48-F49-F50+F51","v":0},{"$f":"G48-G49-G50+G51","v":0},{"$f":"H48-H49-H50+H51","v":0},{"$f":"I48-I49-I50+I51","v":0},{"$f":"J48-J49-J50+J51","v":0},{"$f":"K48-K49-K50+K51","v":0},{"$f":"L48-L49-L50+L51","v":0},{"$f":"M48-M49-M50+M51","v":0},{"$f":"N48-N49-N50+N51","v":0},{"$f":"O48-O49-O50+O51","v":0},{"$f":"P48-P49-P50+P51","v":0},{"$f":"Q48-Q49-Q50+Q51","v":0},{"$f":"R48-R49-R50+R51","v":0},{"$f":"S48-S49-S50+S51","v":0},{"$f":"T48-T49-T50+T51","v":0},{"$f":"U48-U49-U50+U51","v":0},{"$f":"V48-V49-V50+V51","v":0},{"$f":"W48-W49-W50+W51","v":0},{"$f":"X48-X49-X50+X51","v":0},{"$f":"Y48-Y49-Y50+Y51","v":0},{"$f":"Z48-Z49-Z50+Z51","v":0},{"$f":"AA48-AA49-AA50+AA51","v":0},{"$f":"AB48-AB49-AB50+AB51","v":0},{"$f":"AC48-AC49-AC50+AC51","v":0},{"$f":"AD48-AD49-AD50+AD51","v":0},{"$f":"AE48-AE49-AE50+AE51","v":0},{"$f":"AF48-AF49-AF50+AF51","v":0},{"$f":"AG48-AG49-AG50+AG51","v":0},{"$f":"AH48-AH49-AH50+AH51","v":0},{"$f":"AI48-AI49-AI50+AI51","v":0},{"$f":"AJ48-AJ49-AJ50+AJ51","v":0},{"$f":"AK48-AK49-AK50+AK51","v":0},{"$f":"AL48-AL49-AL50+AL51","v":0},{"$f":"AM48-AM49-AM50+AM51","v":0},{"$f":"AN48-AN49-AN50+AN51","v":0},{"$f":"AO48-AO49-AO50+AO51","v":0},{"$f":"AP48-AP49-AP50+AP51","v":0},{"$f":"AQ48-AQ49-AQ50+AQ51","v":0},{"$f":"AR48-AR49-AR50+AR51","v":0},{"$f":"AS48-AS49-AS50+AS51","v":0},{"$f":"AT48-AT49-AT50+AT51","v":0},{"$f":"AU48-AU49-AU50+AU51","v":0},{"$f":"AV48-AV49-AV50+AV51","v":0},{"$f":"AW48-AW49-AW50+AW51","v":0},{"$f":"AX48-AX49-AX50+AX51","v":0},{"$f":"AY48-AY49-AY50+AY51","v":0},{"$f":"AZ48-AZ49-AZ50+AZ51","v":0},{"$f":"BA48-BA49-BA50+BA51","v":0},{"$f":"BB48-BB49-BB50+BB51","v":0},{"$f":"BC48-BC49-BC50+BC51","v":0},{"$f":"BD48-BD49-BD50+BD51","v":0},{"$f":"BE48-BE49-BE50+BE51","v":0},{"$f":"BF48-BF49-BF50+BF51","v":0},{"$f":"BG48-BG49-BG50+BG51","v":0},{"$f":"BH48-BH49-BH50+BH51","v":0},{"$f":"BI48-BI49-BI50+BI51","v":0},{"$f":"BJ48-BJ49-BJ50+BJ51","v":0},{"$f":"BK48-BK49-BK50+BK51","v":0},{"$f":"BL48-BL49-BL50+BL51","v":0},{"$f":"BM48-BM49-BM50+BM51","v":0},{"$f":"BN48-BN49-BN50+BN51","v":0},{"$f":"BO48-BO49-BO50+BO51","v":0},{"$f":"BP48-BP49-BP50+BP51","v":0},{"$f":"BQ48-BQ49-BQ50+BQ51","v":0},{"$f":"BR48-BR49-BR50+BR51","v":0},{"$f":"BS48-BS49-BS50+BS51","v":0},{"$f":"BT48-BT49-BT50+BT51","v":0},{"$f":"BU48-BU49-BU50+BU51","v":0},{"$f":"BV48-BV49-BV50+BV51","v":0},{"$f":"BW48-BW49-BW50+BW51","v":0},{"$f":"BX48-BX49-BX50+BX51","v":0},{"$f":"BY48-BY49-BY50+BY51","v":0},{"$f":"BZ48-BZ49-BZ50+BZ51","v":0},{"$f":"CA48-CA49-CA50+CA51","v":0},{"$f":"CB48-CB49-CB50+CB51","v":0},{"$f":"CC48-CC49-CC50+CC51","v":0},{"$f":"CD48-CD49-CD50+CD51","v":0},{"$f":"CE48-CE49-CE50+CE51","v":0},{"$f":"CF48-CF49-CF50+CF51","v":0},{"$f":"CG48-CG49-CG50+CG51","v":0},{"$f":"CH48-CH49-CH50+CH51","v":0},{"$f":"CI48-CI49-CI50+CI51","v":0},{"$f":"CJ48-CJ49-CJ50+CJ51","v":0},{"$f":"CK48-CK49-CK50+CK51","v":0},{"$f":"CL48-CL49-CL50+CL51","v":0},{"$f":"CM48-CM49-CM50+CM51","v":0},{"$f":"CN48-CN49-CN50+CN51","v":0},{"$f":"CO48-CO49-CO50+CO51","v":0},{"$f":"CP48-CP49-CP50+CP51","v":0},{"$f":"CQ48-CQ49-CQ50+CQ51","v":0},{"$f":"CR48-CR49-CR50+CR51","v":0},{"$f":"CS48-CS49-CS50+CS51","v":0},{"$f":"CT48-CT49-CT50+CT51","v":0},{"$f":"CU48-CU49-CU50+CU51","v":0},{"$f":"CV48-CV49-CV50+CV51","v":0},{"$f":"CW48-CW49-CW50+CW51","v":0},{"$f":"CX48-CX49-CX50+CX51","v":0},{"$f":"CY48-CY49-CY50+CY51","v":0},{"$f":"CZ48-CZ49-CZ50+CZ51","v":0},{"$f":"DA48-DA49-DA50+DA51","v":0},{"$f":"DB48-DB49-DB50+DB51","v":0},{"$f":"DC48-DC49-DC50+DC51","v":0},{"$f":"DD48-DD49-DD50+DD51","v":0},{"$f":"DE48-DE49-DE50+DE51","v":0},{"$f":"DF48-DF49-DF50+DF51","v":0},{"$f":"DG48-DG49-DG50+DG51","v":0},{"$f":"DH48-DH49-DH50+DH51","v":0},{"$f":"DI48-DI49-DI50+DI51","v":0},{"$f":"DJ48-DJ49-DJ50+DJ51","v":0},{"$f":"DK48-DK49-DK50+DK51","v":0},{"$f":"DL48-DL49-DL50+DL51","v":0},{"$f":"DM48-DM49-DM50+DM51","v":0},{"$f":"DN48-DN49-DN50+DN51","v":0},{"$f":"DO48-DO49-DO50+DO51","v":0},{"$f":"DP48-DP49-DP50+DP51","v":0},{"$f":"DQ48-DQ49-DQ50+DQ51","v":0},{"$f":"DR48-DR49-DR50+DR51","v":0},{"$f":"DS48-DS49-DS50+DS51","v":0},{"$f":"DT48-DT49-DT50+DT51","v":0},{"$f":"DU48-DU49-DU50+DU51","v":0},{"$f":"DV48-DV49-DV50+DV51","v":0},{"$f":"DW48-DW49-DW50+DW51","v":0},{"$f":"DX48-DX49-DX50+DX51","v":0},{"$f":"DY48-DY49-DY50+DY51","v":0},{"$f":"DZ48-DZ49-DZ50+DZ51","v":0},{"$f":"EA48-EA49-EA50+EA51","v":0},{"$f":"EB48-EB49-EB50+EB51","v":0},{"$f":"EC48-EC49-EC50+EC51","v":0},{"$f":"ED48-ED49-ED50+ED51","v":0},{"$f":"EE48-EE49-EE50+EE51","v":0},{"$f":"EF48-EF49-EF50+EF51","v":0},{"$f":"EG48-EG49-EG50+EG51","v":0},{"$f":"EH48-EH49-EH50+EH51","v":0},{"$f":"EI48-EI49-EI50+EI51","v":0}]
[" - Fluxos de dívida contratada"]
[" - Transferências ao PGA"]
[]
["SALDOS DE ATIVO"]
["SALDO DO ATIVO",null,{"$f":"SUM(C53:C62)","v":0},{"$f":"SUM(D53:D62)","v":0},{"$f":"SUM(E53:E62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BQ53:BQ62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(EC53:EC62)","v":0},0,0,0,0,0,0]
["Títulos públicos federais (mantidos até o vencimento)"]
["Títulos públicos federais (para negociação)"]
["Renda fixa (exceto títulos públicos federais)"]
["Renda variável"]
["Investimentos estruturados"]
["Investimentos no exterior"]
["Operação com participantes"]
["Imóveis"]
["Dívidas contratadas"]
["Outros ativos"]
[]
["RENTABILIDADES"]
["RENTABILIDADE DO PLANO",null,{"$f":"C66","v":0},{"$f":"D66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EB66","v":0},0,0,0,0,0,0,0]
["Plano"]
["Títulos públicos federais (mantidos até o vencimento)"]
["Títulos públicos federais (para negociação)"]
["Renda fixa (exceto títulos públicos federais)"]
["Renda variável"]
["Investimentos estruturados"]
["Investimentos no exterior"]
["Operação com participantes"]
["Imóveis"]
[]
["ÍNDICE DE INFLAÇÃO:","IPCA"]
["PROJEÇÃO DO ÍNDICE INFLACIONÁRIO",null,{"$f":"C78","v":0},{"$f":"D78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BP78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EB78","v":0},0,0,0,0,0,0,0]
["Projeção do índice inflacionário"]

{"sheet":"Projeção do patr. de cobertura","index":2,"n_rows":22,"n_cols":138,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["EXERCÍCIOS",2015,{"$f":"B2+1","v":2016},{"$f":"C2+1","v":2017},{"$f":"D2+1","v":2018},2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,{"$f":"BP2+1","v":2082},2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,{"$f":"CK2+1","v":2103},{"$f":"CL2+1","v":2104},{"$f":"CM2+1","v":2105},{"$f":"CN2+1","v":2106},{"$f":"CO2+1","v":2107},{"$f":"CP2+1","v":2108},{"$f":"CQ2+1","v":2109},{"$f":"CR2+1","v":2110},{"$f":"CS2+1","v":2111},{"$f":"CT2+1","v":2112},{"$f":"CU2+1","v":2113},{"$f":"CV2+1","v":2114},{"$f":"CW2+1","v":2115},{"$f":"CX2+1","v":2116},{"$f":"CY2+1","v":2117},{"$f":"CZ2+1","v":2118},{"$f":"DA2+1","v":2119},{"$f":"DB2+1","v":2120},{"$f":"DC2+1","v":2121},{"$f":"DD2+1","v":2122},{"$f":"DE2+1","v":2123},{"$f":"DF2+1","v":2124},{"$f":"DG2+1","v":2125},{"$f":"DH2+1","v":2126},{"$f":"DI2+1","v":2127},{"$f":"DJ2+1","v":2128},{"$f":"DK2+1","v":2129},{"$f":"DL2+1","v":2130},{"$f":"DM2+1","v":2131},{"$f":"DN2+1","v":2132},{"$f":"DO2+1","v":2133},{"$f":"DP2+1","v":2134},{"$f":"DQ2+1","v":2135},{"$f":"DR2+1","v":2136},{"$f":"DS2+1","v":2137},{"$f":"DT2+1","v":2138},{"$f":"DU2+1","v":2139},{"$f":"DV2+1","v":2140},{"$f":"DW2+1","v":2141},{"$f":"DX2+1","v":2142},{"$f":"DY2+1","v":2143},{"$f":"DZ2+1","v":2144},{"$f":"EA2+1","v":2145},{"$f":"EB2+1","v":2146},{"$f":"EC2+1","v":2147},{"$f":"ED2+1","v":2148},{"$f":"EE2+1","v":2149},{"$f":"EF2+1","v":2150},{"$f":"EG2+1","v":2151}]
[]
["FLUXOS DE SEGURIDADE E OUTROS"]
["Recebimentos",{"$f":"SUM(B6:B9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BN6:BN9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(CL6:CL9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" - Contribuições Normais"]
[" - Contribuições Extraordinárias"]
[" - Utilização de Fundos Previdenciais"]
[" - Outras Receitas"]
["Pagamentos",{"$f":"-SUM(B11:B17)","v":0},{"$f":"-SUM(C11:C17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-SUM(BO11:BO17)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-SUM(EA11:EA17)","v":0},0,0,0,0,0,0,0]
[" - Benefícios Programados"]
[" - Benefícios de Risco"]
[" - Diferenças de Benefícios (demandas judiciais)"]
[" - Resgates"]
[" - Portabilidade"]
[" - Constituição de Fundos Previdenciais"]
[" - Outros Pagamentos"]
[]
["PATRIMÔNIO DE COBERTURA"]
["Fluxo de Caixa",{"$f":"B5+B10","v":0},{"$f":"C5+C10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"BO5+BO10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"EA5+EA10","v":0},0,0,0,0,0,0,0]
[" - Rentabilidade Real Projetada"]
[" - Patrimônio de Cobertura Projetado"]

{"sheet":"Renda Fixa \"na curva\"","index":3,"n_rows":5,"n_cols":13,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"DI"]
["Data de Aquisição ou reclassificação","ISIN","Nome do Título","Emissor","Data de Vencimento","Indexador","Percentual do indexador","Expectativa média para o Indexador","Taxa de apropriação dos juros","Preço unitário","Quantidade",null,"SELIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,"IPCA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"IGP-M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"INPC"]