{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet3","index":0,"n_rows":141,"n_cols":128,"rows_kept":141,"cut":false,"hidden":false,"merged":[[56,54,56,56],[74,1,74,3],[86,1,86,3],[89,1,89,3],[59,1,59,3],[71,1,71,3],[56,1,56,3],[37,1,37,16],[14,7,14,9],[18,7,18,9],[44,54,44,56],[44,1,44,3],[20,7,20,9],[131,1,131,3],[101,1,101,3],[104,1,104,3],[116,1,116,3],[119,1,119,3],[3,12,4,12],[33,1,33,3],[22,1,22,2],[6,1,6,4],[3,10,4,10],[8,1,8,4],[12,1,12,4],[16,7,16,9],[3,9,4,9],[6,5,6,6],[10,1,10,4],[6,7,6,9],[3,0,4,5],[8,5,8,6],[10,5,10,6],[12,5,12,6]]}
[]
[]
[]
["OPS Obrigações Mota-Engil SPGS 2024-2029",null,null,null,null,null,"TANB",0.05,null,"Data Simulação:",{"$f":"+TODAY()","v":"2024-09-30"}]
[null,null,null,null,null,null,"Prazo","5 anos"]
[]
[null,"Montante a investir",null,null,null,2500,null,"(Introduza o montante do investimento)"]
[]
[null,"TANB",null,null,null,0.05]
[]
[null,"TIR Líquida de Impostos e Comissões",null,null,null,{"$f":"XIRR(BF57:DX57,BF45:DX45)","v":2.0847138762474061E-2}]
[]
[null,"Juros Líquidos de Impostos e Comissões",null,null,null,{"$f":"+SUM(E57:R57,E72:Q72,E87:R87,E102:R102,E117:R117,E132:R132)","v":211.71499999999742},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sim","Internet",null,"Continente"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Não","Balcão/Telefone",null,"Madeira"]
[null,"O Cliente já paga Comissão de Serviço de Bolsa ?",null,null,null,2,null,"(Escolha a opção correta)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Açores"]
[null,null,null,null,null,555]
[null,"O Cliente tem Notas de Lançamento digitais?",null,null,null,1,null,"(Escolha a opção correta)"]
[]
[null,"Canal de Subscrição",null,null,null,1,null,"(Escolha a opção correta)"]
[]
[null,"Regime Fiscal",null,null,null,1,null,"(Escolha a opção correta)"]
[]
[null,"Rubricas",null,"Preçário","Cash-Flows Totais"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":3},{"$f":"+SUM(E46:R46,E61:R61,E76:R76,E91:R91,E106:R106,E121:R121)","v":-183}]
[null,"Comissão de Subscrição*",null,{"$f":"IF($F$19=1,5,IF(F7<2666.667,12,IF(F7<250000,0.45%*F7,0.325%*F7)))","v":5},{"$f":"+SUM(E48:R48,E63:R63,E78:R78,E93:R93,E108:R108,E123:R123)","v":-5}]
[null,"Imposto do Selo",null,0.04,{"$f":"+SUM(E49:R49,E64:Q64,E79:R79,E94:R94,E109:R109,E124:R124)","v":-0.2}]
[null,"Pagamento de Juros Bruto",null,"-",{"$f":"+SUM(E50:R50,E65:R65,E80:R80,E95:R95,E110:R110,E125:R125)","v":625}]
[null,"IRS",null,{"$f":"+IF($F$21=1, 28%, IF($F$21=2, 28%, IF($F$21=3,19.6%,17.5%)))","v":0.28000000000000003},{"$f":"+SUM(E51:R51,E66:R66,E81:R81,E96:R96,E111:R111,E126:R126)","v":-175}]
[null,"Comissão Rendimentos **",null,0.01,{"$f":"+SUM(E52:R52,E67:Q67,E82:R82,E97:R97,E112:R112,E127:R127)","v":-4.5000000000000009}]
[null,"Comissão Reembolso **",null,2E-3,{"$f":"+SUM(E53:R53,E68:R68,E83:R83,E98:R98,E113:R113,E128:R128)","v":-5}]
[null,"Portes",null,{"$f":"+IF(OR($F$17=2,$F$21=2,$F$21=4),0.4,0)","v":0},{"$f":"+SUM(E54:R54,E69:R69,E84:R84,E99:R99,E114:R114,E129:R129)","v":0}]
[null,"Despesas Expediente**",null,{"$f":"+IF(OR($F$17=2,$F$21=2,$F$21=4),1.05,0)","v":0},{"$f":"+SUM(E55:R55,E70:R70,E85:R85,E100:R100,E115:R115,E130:R130)","v":0}]
[null,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},{"$f":"+SUM(E56:R56,E71:R71,E86:R86,E101:R101,E116:R116,E131:R131)","v":-44.274999999999991}]
[null,"TOTAL",null,null,{"$f":"+SUM(E24:E33)","v":208.02500000000003}]
[null,"* Acresce IS"]
[null,"** Acresce IVA"]
[]
[null,"Disclamer:\nOs valores constantes da presente simulação correspondem à taxa interna de rentabilidade (TIR) para um investimento na OPS Mota-Engil SPGS 2024-2029, ao Preço de Emissão, assumindo que as mesmas são detidas por um investidor residente em território português, que serão mantidas até ao vencimento e reembolsadas na maturidade a 100% do valor nominal e que os cupões recebidos são reinvestidos a uma taxa de juro equivalente à TIR obtida.\n\nA Oferta é uma oferta pública de subscrição em Portugal e destina-se a investidores indeterminados, ou seja, ao público em geral, desde que sejam pessoas residentes ou com estabelecimento em Portugal.  A Oferta não constitui uma oferta ou promoção de venda, compra ou subscrição de quaisquer títulos, particularmente no que respeita a qualquer pessoa a quem estejam legalmente vedadas essas operações, ou em qualquer jurisdição onde seja considerada ilegal a respetiva venda, compra ou subscrição das Obrigações, designadamente os Estados Unidos da América, a Área Económica Europeia (incluindo Reino Unido e Holanda), Austrália, Canadá, África do Sul e o Japão. \nEm particular as Obrigações não foram nem serão registadas ao abrigo do US Securities Act de 1933 ou de qualquer outra legislação sobre valores mobiliários aplicável nos Estados Unidos da América e não podem ser, direta ou indiretamente, promovidas ou vendidas nos Estados Unidos da América, ou em qualquer dos seus territórios e possessões ou áreas que se encontrem sujeitas a essa jurisdição, ou a uma “US Person” ou em seu benefício, conforme disposto na Rule 902(k), Regulation S do US Securities Act de 1933. \n"]
[]
[]
[]
[null,"DETALHES"]
[]
[null,null,null,null,2024,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,null,null,null,2025,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,2027,null,null,null,null,null,null,null,null,null,null,null,null,null,2028,null,null,null,null,null,null,null,null,null,null,null,null,null,2029]
[null,"Preçário",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BF45","v":"2024-10-11"},"2024-10-31","2024-11-29",{"$f":"BI45","v":"2024-12-31"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preçário",null,null,"2024-10-11","2024-10-31","2024-11-29","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-16","2025-04-30","2025-05-30","2025-06-30","2025-07-31","2025-08-29","2025-09-30","2025-10-16","2025-10-31","2025-11-28","2025-12-31","2026-01-30","2026-02-27","2026-03-31","2026-04-16","2026-04-30","2026-05-29","2026-06-30","2026-07-31","2026-08-31","2026-09-30","2026-10-16","2026-10-30","2025-11-30","2025-12-31","2027-01-29","2027-02-26","2027-03-31","2027-04-16","2027-04-30","2027-05-31","2027-06-30","2027-07-30","2027-08-31","2027-09-30","2027-10-18","2027-10-29","2027-11-30","2027-12-30","2028-01-31","2028-02-29","2028-03-31","2028-04-17","2028-04-28","2028-05-31","2028-06-30","2028-07-31","2028-08-31","2028-09-29","2028-10-16","2028-10-31","2028-11-30","2028-12-29","2029-01-31","2029-02-28","2029-03-30","2029-04-16","2029-04-30","2029-05-31","2029-06-30","2029-07-31","2029-08-31","2029-09-29","2029-10-16"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":3},null,null,null,null,null,null,null,null,null,null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comissão Guarda Títulos **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":3},null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},-3,-3,-3,-3,null,{"$f":"-$D$46","v":-3},-3,-3,-3,-3,-3,null,{"$f":"-$D$46","v":-3},-3,-3,-3,-3,-3,null,-3,-3,-3,-3,-3,-3,null,-3,-3,-3,-3,-3,-3,null,-3,-3,-3,-3,-3,-3,null,-3,-3,-3,-3,-3,-3,null,-3,-3,-3,-3,-3,-3,null,-3,-3,-3,{"$f":"-$D$46","v":-3},-3,-3,null,{"$f":"-$D$46","v":-3},-3,-3,-3,-3,-3]
[null,"Investimento",null,"-",null,null,null,null,null,null,null,null,null,null,{"$f":"-$F$7","v":-2500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Investimento",null,"-",{"$f":"-F7","v":-2500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F7","v":2500}]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":5},null,null,null,null,null,null,null,null,null,null,{"$f":"-$D$48","v":-5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comissão de Subscrição**",null,{"$f":"BF25","v":0},{"$f":"-D48","v":-5}]
[null,"Imposto do Selo",null,0.04,null,null,null,null,null,null,null,null,null,null,{"$f":"+$O$48*$D$49","v":-0.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Imposto do Selo",null,0.04,{"$f":"+BF48*$D$49","v":-0.2}]
[null,"Pagamento de Juros Bruto",null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pagamento de Juros Bruto",null,"-",null,null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5}]
[null,"IRS",null,{"$f":"+IF($F$21=1, 28%, IF($F$21=2, 28%, IF($F$21=3,19.6%,17.5%)))","v":0.28000000000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRS",null,{"$f":"+IF($F$21=1, 28%, IF($F$21=2, 28%, IF($F$21=3,19.6%,17.5%)))","v":0.28000000000000003},null,null,null,null,null,null,null,{"$f":"+-BM50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-BT50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-CA50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-CH50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-CO50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-CV50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-DC50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-DJ50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-DQ50*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-DX50*$D$51","v":-17.5}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comissão Rendimentos **",null,0.01,null,null,null,null,null,null,null,{"$f":"-((BM50+BM51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((BT50+BT51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((CA50+CA51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((CH50+CH51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((CO50+CO51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((CV50+CV51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((DC50+DC51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((DJ50+DJ51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((DQ50+DQ51)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((DX50+DX51)*$D$52)","v":-0.45}]
[null,"Comissão Reembolso **",null,2E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Comissão Reembolso **",null,2E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-$D$53*$F$7","v":-5}]
[null,"Portes",null,{"$f":"+IF($F$17=1,0,0.4)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(O$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Portes",null,{"$f":"+IF($F$17=1,0,0.4)","v":0},{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(BF$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(BM$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(BT$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(CA$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(CH$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(CO$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(CV$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(DC$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(DJ$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(DQ$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(DR$91=\"\",-$D$54,0)))*2","v":0}]
[null,"Despesas Expediente**",null,{"$f":"+IF($F$17=1,0,1.05)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(O$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Despesas Expediente**",null,{"$f":"+IF($F$17=1,0,1.05)","v":0},{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(BF$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(BM$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(BT$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(CA$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(CH$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(CO$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(CV$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(DC$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(DJ$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(DQ$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(DR$91=\"\",-$D$55,0)))*2","v":0}]
[null,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},null,null,null,null,null,null,null,null,null,null,{"$f":"+(O46+O52+O53+O55)*$D$56","v":-0.69000000000000006},{"$f":"+(P46+P52+P53+P55)*$D$56","v":-0.69000000000000006},{"$f":"+(Q46+Q52+Q53+Q55)*$D$56","v":-0.69000000000000006},{"$f":"+(R46+R52+R53+R55)*$D$56","v":-0.69000000000000006},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},{"$f":"+(BF46+BF52+BF53+BF55)*$D$56","v":0},{"$f":"+(BG46+BG52+BG53+BG55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(BL46+BL52+BL53+BL55)*$D$56","v":-0.69000000000000006},{"$f":"+(BM46+BM52+BM53+BM55)*$D$56","v":-0.10350000000000001},{"$f":"+(BN46+BN52+BN53+BN55)*$D$56","v":-0.69000000000000006},{"$f":"+(BO46+BO52+BO53+BO55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(BT46+BT52+BT53+BT55)*$D$56","v":-0.10350000000000001},-0.69000000000000006,{"$f":"+(BV46+BV52+BV53+BV55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,{"$f":"+(BX46+BX52+BX53+BX55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,{"$f":"+(CA46+CA52+CA53+CA55)*$D$56","v":-0.10350000000000001},{"$f":"+(CB46+CB52+CB53+CB55)*$D$56","v":-0.69000000000000006},{"$f":"+(CC46+CC52+CC53+CC55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(CH46+CH52+CH53+CH55)*$D$56","v":-0.10350000000000001},{"$f":"+(CI46+CI52+CI53+CI55)*$D$56","v":-0.69000000000000006},{"$f":"+(CJ46+CJ52+CJ53+CJ55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(CO46+CO52+CO53+CO55)*$D$56","v":-0.10350000000000001},{"$f":"+(CP46+CP52+CP53+CP55)*$D$56","v":-0.69000000000000006},{"$f":"+(CQ46+CQ52+CQ53+CQ55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(CV46+CV52+CV53+CV55)*$D$56","v":-0.10350000000000001},{"$f":"+(CW46+CW52+CW53+CW55)*$D$56","v":-0.69000000000000006},{"$f":"+(CX46+CX52+CX53+CX55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(DC46+DC52+DC53+DC55)*$D$56","v":-0.10350000000000001},{"$f":"+(DD46+DD52+DD53+DD55)*$D$56","v":-0.69000000000000006},{"$f":"+(DE46+DE52+DE53+DE55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(DJ46+DJ52+DJ53+DJ55)*$D$56","v":-0.10350000000000001},{"$f":"+(DK46+DK52+DK53+DK55)*$D$56","v":-0.69000000000000006},{"$f":"+(DL46+DL52+DL53+DL55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,{"$f":"+(DN46+DN52+DN53+DN55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,{"$f":"+(DQ46+DQ52+DQ53+DQ55)*$D$56","v":-0.10350000000000001},{"$f":"+(DR46+DR52+DR53+DR55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,{"$f":"+(DT46+DT52+DT53+DT55)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(DX46+DX52+DX53+DX55)*$D$56","v":-1.2535000000000001}]
[null,"Cash-Flows",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(O46:O56)","v":-2508.89},{"$f":"+SUM(P46:P56)","v":-3.69},{"$f":"+SUM(Q46:Q56)","v":-3.69},{"$f":"+SUM(R46:R56)","v":-3.69},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash-Flows",null,null,{"$f":"+SUM(BF46:BF56)","v":-2505.1999999999998},{"$f":"+SUM(BG46:BG56)","v":-3.69},-3.69,-3.69,-3.69,-3.69,{"$f":"+SUM(BL46:BL56)","v":-3.69},{"$f":"+SUM(BM46:BM56)","v":44.4465},{"$f":"+SUM(BN46:BN56)","v":-3.69},{"$f":"+SUM(BO46:BO56)","v":-3.69},-3.69,-3.69,-3.69,-3.69,{"$f":"+SUM(BT46:BT56)","v":44.4465},-3.69,-3.69,-3.69,{"$f":"+SUM(BX46:BX56)","v":-3.69},-3.69,-3.69,{"$f":"+SUM(CA46:CA56)","v":44.4465},{"$f":"+SUM(CB46:CB56)","v":-3.69},-3.69,-3.69,-3.69,-3.69,-3.69,44.4465,{"$f":"+SUM(CI46:CI56)","v":-3.69},{"$f":"+SUM(CH46:CH56)","v":44.4465},-3.69,-3.69,-3.69,-3.69,44.4465,{"$f":"+SUM(CP46:CP56)","v":-3.69},{"$f":"+SUM(CQ46:CQ56)","v":-3.69},-3.69,-3.69,-3.69,-3.69,{"$f":"+SUM(CV46:CV56)","v":44.4465},{"$f":"+SUM(CW46:CW56)","v":-3.69},-3.69,-3.69,-3.69,-3.69,-3.69,44.4465,{"$f":"+SUM(DD46:DD56)","v":-3.69},-3.69,-3.69,-3.69,-3.69,-3.69,{"$f":"+SUM(DJ46:DJ56)","v":44.4465},{"$f":"+SUM(DK46:DK56)","v":-3.69},-3.69,-3.69,{"$f":"+SUM(DN46:DN56)","v":-3.69},-3.69,-3.69,44.4465,{"$f":"+SUM(DR46:DR56)","v":-3.69},-3.69,{"$f":"+SUM(DT46:DT56)","v":-3.69},-3.69,-3.69,-3.69,{"$f":"+SUM(DX47:DX56)","v":2538.2965000000004}]
[]
[null,null,null,null,2025]
[null,"Preçário",null,null,{"$f":"BJ45","v":"2025-01-31"},{"$f":"BK45","v":"2025-02-28"},"2025-03-31","2025-04-16","2025-04-30","2025-05-30","2025-06-30","2025-07-31","2025-08-29","2025-09-30","2025-10-16","2025-10-31","2025-11-28","2025-12-31"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},-3,-3,-3,-3,null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3}]
[null,"Investimento",null,"-"]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":5}]
[null,"Imposto do Selo",null,0.04]
[null,"Pagamento de Juros Bruto",null,"-",null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5}]
[null,"IRS",null,{"$f":"+IF($F$21=1, 28%, IF($F$21=2, 28%, IF($F$21=3,19.6%,17.5%)))","v":0.28000000000000003},null,null,null,{"$f":"+-H65*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-O65*$D$51","v":-17.5}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,{"$f":"-((H65+H66)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((O65+O66)*$D$52)","v":-0.45}]
[null,"Comissão Reembolso **",null,2E-3]
[null,"Portes",null,{"$f":"+IF($F$17=1,0,0.4)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(H$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(O$46=\"\",-$D$54,0)))","v":0}]
[null,"Despesas Expediente**",null,{"$f":"+IF($F$17=1,0,1.05)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(H$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(O$46=\"\",-$D$55,0)))","v":0}]
[null,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},{"$f":"+(E61+E67+E68+E70)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,{"$f":"+(H61+H67+H68+H70)*$D$56","v":-0.10350000000000001},{"$f":"+(I61+I67+I68+I70)*$D$56","v":-0.69000000000000006},-0.69000000000000006,{"$f":"+(K61+K67+K68+K70)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.10350000000000001,-0.69000000000000006,{"$f":"+(Q61+Q67+Q68+Q70)*$D$56","v":-0.69000000000000006},{"$f":"+(R61+R67+R68+R70)*$D$56","v":-0.69000000000000006}]
[null,"Cash-Flows",null,null,{"$f":"+SUM(E61:E71)","v":-3.69},-3.69,-3.69,{"$f":"+SUM(H61:H71)","v":44.4465},{"$f":"+SUM(I61:I71)","v":-3.69},{"$f":"+SUM(J61:J71)","v":-3.69},{"$f":"+SUM(K61:K71)","v":-3.69},{"$f":"+SUM(L61:L71)","v":-3.69},{"$f":"+SUM(M61:M71)","v":-3.69},{"$f":"+SUM(N61:N71)","v":-3.69},{"$f":"+SUM(O61:O71)","v":44.4465},{"$f":"+SUM(P61:P71)","v":-3.69},{"$f":"+SUM(Q61:Q71)","v":-3.69},{"$f":"+SUM(R61:R71)","v":-3.69}]
[]
[null,null,null,null,2026]
[null,"Preçário",null,null,{"$f":"BX45","v":"2026-01-30"},{"$f":"BY45","v":"2026-02-27"},"2026-03-31","2026-04-16","2026-04-30","2026-05-29","2026-06-30","2026-07-31","2026-08-31","2026-09-30","2026-10-16","2026-10-30","2025-11-30","2025-12-31"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},-3,-3,-3,-3,null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3}]
[null,"Investimento",null,"-"]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":5}]
[null,"Imposto do Selo",null,0.04]
[null,"Pagamento de Juros Bruto",null,"-",null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5}]
[null,"IRS",null,{"$f":"+IF($F$21=1, 28%, IF($F$21=2, 28%, IF($F$21=3,19.6%,17.5%)))","v":0.28000000000000003},null,null,null,{"$f":"+-H80*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-O80*$D$51","v":-17.5}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,{"$f":"-((H80+H81)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((O80+O81)*$D$52)","v":-0.45}]
[null,"Comissão Reembolso **",null,2E-3]
[null,"Portes",null,{"$f":"+IF($F$17=1,0,0.4)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(H$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(O$46=\"\",-$D$54,0)))","v":0}]
[null,"Despesas Expediente**",null,{"$f":"+IF($F$17=1,0,1.05)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(H$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(O$46=\"\",-$D$55,0)))","v":0}]
[null,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},{"$f":"+(E76+E82+E83+E85)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,{"$f":"+(H76+H82+H83+H85)*$D$56","v":-0.10350000000000001},{"$f":"+(I76+I82+I83+I85)*$D$56","v":-0.69000000000000006},-0.69000000000000006,{"$f":"+(K76+K82+K83+K85)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(O76+O82+O83+O85)*$D$56","v":-0.10350000000000001},{"$f":"+(P76+P82+P83+P85)*$D$56","v":-0.69000000000000006},{"$f":"+(Q76+Q82+Q83+Q85)*$D$56","v":-0.69000000000000006},{"$f":"+(R76+R82+R83+R85)*$D$56","v":-0.69000000000000006}]
[null,"Cash-Flows",null,null,{"$f":"+SUM(E76:E86)","v":-3.69},-3.69,-3.69,44.4465,{"$f":"+SUM(I76:I86)","v":-3.69},{"$f":"+SUM(J76:J86)","v":-3.69},{"$f":"+SUM(K76:K86)","v":-3.69},-3.69,-3.69,-3.69,44.4465,{"$f":"+SUM(P76:P86)","v":-3.69},{"$f":"+SUM(Q76:Q86)","v":-3.69},{"$f":"+SUM(R76:R86)","v":-3.69}]
[]
[null,null,null,null,2027]
[null,"Preçário",null,null,{"$f":"CL45","v":"2027-01-29"},{"$f":"CM45","v":"2027-02-26"},"2027-03-31","2027-04-16","2027-04-30","2027-05-31","2027-06-30","2027-07-30","2027-08-31","2027-09-30","2027-10-18","2027-10-29","2027-11-30","2027-12-30"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},-3,-3,-3,-3,null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3}]
[null,"Investimento",null,"-"]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":5}]
[null,"Imposto do Selo",null,0.04]
[null,"Pagamento de Juros Bruto",null,"-",null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5}]
[null,"IRS",null,{"$f":"+IF($F$21=1, 28%, IF($F$21=2, 28%, IF($F$21=3,19.6%,17.5%)))","v":0.28000000000000003},null,null,null,{"$f":"+-H95*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-O95*$D$51","v":-17.5}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,{"$f":"-((H95+H96)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((O95+O96)*$D$52)","v":-0.45}]
[null,"Comissão Reembolso **",null,2E-3]
[null,"Portes",null,{"$f":"+IF($F$17=1,0,0.4)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(H$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(O$46=\"\",-$D$54,0)))","v":0}]
[null,"Despesas Expediente**",null,{"$f":"+IF($F$17=1,0,1.05)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(H$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(O$46=\"\",-$D$55,0)))","v":0}]
[null,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},{"$f":"+(E91+E97+E98+E100)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,{"$f":"+(H91+H97+H98+H100)*$D$56","v":-0.10350000000000001},{"$f":"+(I91+I97+I98+I100)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(O91+O97+O98+O100)*$D$56","v":-0.10350000000000001},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006]
[null,"Cash-Flows",null,null,{"$f":"+SUM(E91:E101)","v":-3.69},-3.69,-3.69,44.4465,{"$f":"+SUM(I91:I101)","v":-3.69},-3.69,-3.69,-3.69,-3.69,-3.69,44.4465,{"$f":"+SUM(P91:P101)","v":-3.69},{"$f":"+SUM(Q91:Q101)","v":-3.69},{"$f":"+SUM(R91:R101)","v":-3.69}]
[]
[null,null,null,null,2028]
[null,"Preçário",null,null,{"$f":"CZ45","v":"2028-01-31"},{"$f":"DA45","v":"2028-02-29"},"2028-03-31","2028-04-17","2028-04-28","2028-05-31","2028-06-30","2028-07-31","2028-08-31","2028-09-29","2028-10-16","2028-10-31","2028-11-30","2028-12-29"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},-3,-3,-3,-3,null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3}]
[null,"Investimento",null,"-"]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":5}]
[null,"Imposto do Selo",null,0.04]
[null,"Pagamento de Juros Bruto",null,"-",null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5}]
[null,"IRS",null,{"$f":"+IF($F$21=1, 28%, IF($F$21=2, 28%, IF($F$21=3,19.6%,17.5%)))","v":0.28000000000000003},null,null,null,{"$f":"+-H110*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-O110*$D$51","v":-17.5}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,{"$f":"-((H110+H111)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((O110+O111)*$D$52)","v":-0.45}]
[null,"Comissão Reembolso **",null,2E-3]
[null,"Portes",null,{"$f":"+IF($F$17=1,0,0.4)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(H$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(O$46=\"\",-$D$54,0)))","v":0}]
[null,"Despesas Expediente**",null,{"$f":"+IF($F$17=1,0,1.05)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(H$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(O$46=\"\",-$D$55,0)))","v":0}]
[null,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},{"$f":"+(E106+E112+E113+E115)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,{"$f":"+(H106+H112+H113+H115)*$D$56","v":-0.10350000000000001},{"$f":"+(I106+I112+I113+I115)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(O106+O112+O113+O115)*$D$56","v":-0.10350000000000001},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006]
[null,"Cash-Flows",null,null,{"$f":"+SUM(E106:E116)","v":-3.69},-3.69,-3.69,44.4465,{"$f":"+SUM(I106:I116)","v":-3.69},-3.69,-3.69,-3.69,-3.69,-3.69,44.4465,{"$f":"+SUM(P106:P116)","v":-3.69},{"$f":"+SUM(Q106:Q116)","v":-3.69},{"$f":"+SUM(R106:R116)","v":-3.69}]
[]
[null,null,null,null,2029]
[null,"Preçário",null,null,{"$f":"DN45","v":"2029-01-31"},{"$f":"DO45","v":"2029-02-28"},"2029-03-30","2029-04-16","2029-04-30","2029-05-31","2029-06-30","2029-07-31","2029-08-31","2029-09-29","2029-10-16"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},null,{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},{"$f":"-$D$46","v":-3},-3,-3]
[null,"Investimento",null,"-",null,null,null,null,null,null,null,null,null,null,{"$f":"F7","v":2500}]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":5}]
[null,"Imposto do Selo",null,0.04]
[null,"Pagamento de Juros Bruto",null,"-",null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":62.5}]
[null,"IRS",null,{"$f":"+IF($F$21=1, 28%, IF($F$21=2, 28%, IF($F$21=3,19.6%,17.5%)))","v":0.28000000000000003},null,null,null,{"$f":"+-H125*$D$51","v":-17.5},null,null,null,null,null,null,{"$f":"+-O125*$D$51","v":-17.5}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,{"$f":"-((H125+H126)*$D$52)","v":-0.45},null,null,null,null,null,null,{"$f":"-((O125+O126)*$D$52)","v":-0.45}]
[null,"Comissão Reembolso **",null,2E-3,null,null,null,null,null,null,null,null,null,null,{"$f":"-D128*$F$7","v":-5}]
[null,"Portes",null,{"$f":"+IF($F$17=1,0,0.4)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(H$46=\"\",-$D$54,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(H$46=\"\",-$D$54,0)))","v":0}]
[null,"Despesas Expediente**",null,{"$f":"+IF($F$17=1,0,1.05)","v":0},null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(H$46=\"\",-$D$55,0)))","v":0},null,null,null,null,null,null,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$55,IF(H$46=\"\",-$D$55,0)))","v":0}]
[null,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},{"$f":"+(E121+E127+E128+E130)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,{"$f":"+(H121+H127+H128+H130)*$D$56","v":-0.10350000000000001},{"$f":"+(I121+I127+I128+I130)*$D$56","v":-0.69000000000000006},-0.69000000000000006,{"$f":"+(K121+K127+K128+K130)*$D$56","v":-0.69000000000000006},-0.69000000000000006,-0.69000000000000006,-0.69000000000000006,{"$f":"+(O121+O127+O128+O130)*$D$56","v":-1.2535000000000001}]
[null,"Cash-Flows",null,null,{"$f":"+SUM(E121:E131)","v":-3.69},{"$f":"+SUM(F121:F131)","v":-3.69},-3.69,{"$f":"+SUM(H121:H131)","v":44.4465},-3.69,{"$f":"+SUM(J121:J131)","v":-3.69},{"$f":"+SUM(K121:K131)","v":-3.69},-3.69,-3.69,-3.69,2538.2965000000004]
[]
[]
[]
[]
[]
[]
[]
[null,"* Acresce IS"]
[null,"** Acresce IVA"]