{"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":104,"n_cols":101,"rows_kept":104,"cut":false,"hidden":false,"merged":[[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],[56,1,56,3],[8,5,8,6],[10,5,10,6],[12,5,12,6],[44,1,44,3],[37,1,37,16],[14,7,14,9],[18,7,18,9],[20,7,20,9],[74,1,74,3],[86,1,86,3],[89,1,89,3],[101,1,101,3],[59,1,59,3],[71,1,71,3],[43,97,43,110],[88,4,88,17],[73,4,73,17],[58,4,58,17],[43,4,43,17],[44,55,44,57],[56,55,56,57],[43,69,43,82],[43,58,43,68],[43,83,43,96],[43,26,43,31]]}
[]
[]
[]
["OPS/OPT Obrigações Benfica SAD 2024-2027",null,null,null,null,null,"TANB","5,10%",null,"Data Simulação:",{"$f":"+TODAY()","v":"2024-04-03"}]
[null,null,null,null,null,null,"Prazo","3 anos"]
[]
[null,"Montante a investir",null,null,null,2500,null,"(Introduza o montante do investimento)"]
[]
[null,"TANB",null,null,null,5.0999999999999997E-2]
[]
[null,"TIR Líquida de Impostos e Comissões",null,null,null,{"$f":"XIRR(BG57:DG57,BG45:DG45)","v":3.4762451052665705E-2}]
[]
[null,"Juros Líquidos de Impostos e Comissões",null,null,null,{"$f":"+SUM(E57:R57,E72:R72,E87:R87,E102:R102)","v":259.10258000000067},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,1,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,"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":0},{"$f":"+SUM(E46:R46,E61:R61,E76:R76,E91:R91)","v":0}]
[null,"Comissão de Subscrição*",null,{"$f":"IF($F$19=1,6.5,IF(F7<2666.667,12,IF(F7<250000,0.45%*F7,0.325%*F7)))","v":6.5},{"$f":"+SUM(E48:R48,E63:R63,E78:R78,E93:R93)","v":-6.5}]
[null,"Imposto do Selo",null,0.04,-0.26]
[null,"Pagamento de Juros Bruto",null,"-",382.49999999999994]
[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},-107.1]
[null,"Comissão Rendimentos **",null,0.01,-2.7539999999999996]
[null,"Comissão Reembolso **",null,2E-3,-5]
[null,"Portes",null,{"$f":"+IF(OR($F$17=2,$F$21=2,$F$21=4),0.4,0)","v":0},0]
[null,"Despesas Expediente**",null,{"$f":"+IF(OR($F$17=2,$F$21=2,$F$21=4),1.05,0)","v":0},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},-1.78342]
[null,"TOTAL",null,null,{"$f":"+SUM(E24:E33)","v":259.10257999999999}]
[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/OPT Benfica SAD 2024-2027, 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,null,2024,null,null,null,null,null,null,null,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,"Preçário",null,null,null,null,null,"2024-04-24","2024-04-30","2024-05-31","2024-06-28","2024-07-31","2024-08-30","2024-09-30","2024-10-24","2024-10-31","2024-11-29","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,null,"Preçário",null,null,"2024-04-24","2024-04-30","2024-05-31","2024-06-28","2024-07-31","2024-08-30","2024-09-30","2024-10-24","2024-10-31","2024-11-29","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-24","2025-04-30","2025-05-30","2025-06-30","2025-07-31","2025-08-29","2025-09-30","2025-10-24","2025-10-31","2025-11-28","2025-12-31","2026-01-30","2026-02-27","2026-03-31","2026-04-24","2026-04-30","2026-05-29","2026-06-30","2026-07-31","2026-08-31","2026-09-30","2026-10-23","2026-10-30","2026-11-30","2026-12-31","2027-01-29","2027-02-26","2027-03-31","2027-04-26"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":0},null,null,null,null,{"$f":"-$D$46","v":0},0,0,0,0,0,null,{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","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,"Comissão Guarda Títulos **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":0},null,{"$f":"-$D$46","v":0},0,0,0,0,0,null,{"$f":"-$D$46","v":0},0,0,0,0,0,null,{"$f":"-$D$46","v":0},0,0,0,0,0,null,{"$f":"-$D$46","v":0},0,0,0,0,0,null,{"$f":"-$D$46","v":0},0,0,0,0,0,null,{"$f":"-$D$46","v":0},0,0,0,0,0]
[null,"Investimento",null,"-",null,null,null,{"$f":"-F7","v":-2500},null,null,null,null,null,null,{"$f":"-R7","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,null,"Investimento",null,"-",{"$f":"-F7","v":-2500},null,null,null,null,null,null,{"$f":"-BQ7","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,{"$f":"F7","v":2500}]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":6.5},null,null,null,{"$f":"-D48","v":-6.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,null,null,null,null,null,null,null,null,"Comissão de Subscrição**",null,{"$f":"BF25","v":0},{"$f":"-D48","v":-6.5}]
[null,"Imposto do Selo",null,0.04,null,null,null,{"$f":"+H48*$D$49","v":-0.26},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+BG48*$D$49","v":-0.26}]
[null,"Pagamento de Juros Bruto",null,"-",null,null,null,null,null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":63.749999999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":63.749999999999993},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":63.749999999999993},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":63.749999999999993},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":63.749999999999993},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":63.749999999999993},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":63.749999999999993}]
[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,{"$f":"+-O50*$D$51","v":-17.850000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+-BN50*$D$51","v":-17.850000000000001},null,null,null,null,null,null,{"$f":"+-BU50*$D$51","v":-17.850000000000001},null,null,null,null,null,null,{"$f":"+-CB50*$D$51","v":-17.850000000000001},null,null,null,null,null,null,{"$f":"+-CI50*$D$51","v":-17.850000000000001},null,null,null,null,null,null,{"$f":"+-CP50*$D$51","v":-17.850000000000001},null,null,null,null,null,null,{"$f":"+-CW50*$D$51","v":-17.850000000000001}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,null,null,null,null,null,null,null,{"$f":"-((O50+O51)*$D$52)","v":-0.45899999999999991},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"-((BN50+BN51)*$D$52)","v":-0.45899999999999991},null,null,null,null,null,null,{"$f":"-((BU50+BU51)*$D$52)","v":-0.45899999999999991},null,null,null,null,null,null,{"$f":"-((CB50+CB51)*$D$52)","v":-0.45899999999999991},null,null,null,null,null,null,{"$f":"-((CI50+CI51)*$D$52)","v":-0.45899999999999991},null,null,null,null,null,null,{"$f":"-((CP50+CP51)*$D$52)","v":-0.45899999999999991},null,null,null,null,null,null,{"$f":"-((CW50+CW51)*$D$52)","v":-0.45899999999999991}]
[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,"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,{"$f":"-$D$53*$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(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,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(BG$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(BN$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(BW$45=\"\",-$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(CB$61=\"\",-$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(CK$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(CP$61=\"\",-$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(CW$91=\"\",-$D$54,0)))*2","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BG$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(BN$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(BW$45=\"\",-$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(CB$61=\"\",-$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(CK$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(CP$61=\"\",-$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(CW$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,{"$f":"+(H46+H52+H53+H55)*$D$56","v":0},0,0,0,0,0,0,-0.10556999999999998,0,0,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,"IVA",null,{"$f":"+IF($F$21=1, 23%, IF($F$21=2, 22%, IF($F$21=3,16%,17.5%)))","v":0.23},{"$f":"+(BG46+BG52+BG53+BG55)*$D$56","v":0},{"$f":"+(BH46+BH52+BH53+BH55)*$D$56","v":0},0,0,0,0,0,-0.10556999999999998,0,0,0,0,0,0,-0.10556999999999998,0,0,0,0,0,0,-0.10556999999999998,0,0,0,0,0,0,-0.10556999999999998,0,0,0,0,0,0,-0.10556999999999998,0,0,0,0,0,0,-1.2555700000000001]
[null,"Cash-Flows",null,null,null,null,null,{"$f":"+SUM(H46:H56)","v":-2506.7600000000002},0,0,0,0,0,0,45.335429999999988,0,0,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,"Cash-Flows",null,null,{"$f":"+SUM(BG46:BG56)","v":-2506.7600000000002},0,0,0,0,0,0,45.335429999999988,0,0,0,0,0,0,45.335429999999988,0,0,0,0,0,0,45.335429999999988,0,0,0,0,0,0,45.335429999999988,0,0,0,0,0,0,45.335429999999988,0,0,0,0,0,0,2539.1854300000005]
[]
[null,null,null,null,2025]
[null,"Preçário",null,null,"2025-01-31","2025-02-28","2025-03-31","2025-04-24","2025-04-30","2025-05-30","2025-06-30","2025-07-31","2025-08-29","2025-09-30","2025-10-24","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":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0},null,{"$f":"-$D$46","v":0},0,0,0,0,0,null,{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0}]
[null,"Investimento",null,"-"]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":6.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":63.749999999999993},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":63.749999999999993}]
[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.850000000000001},null,null,null,null,null,null,{"$f":"+-O65*$D$51","v":-17.850000000000001}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,{"$f":"-((H65+H66)*$D$52)","v":-0.45899999999999991},null,null,null,null,null,null,{"$f":"-((O65+O66)*$D$52)","v":-0.45899999999999991}]
[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$61=\"\",-$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$61=\"\",-$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},0,0,-0.10556999999999998,0,0,0,0,0,0,-0.10556999999999998,0,0,0]
[null,"Cash-Flows",null,null,{"$f":"+SUM(E61:E71)","v":0},0,0,45.335429999999988,0,0,0,0,0,0,45.335429999999988,0,0,{"$f":"+SUM(R61:R71)","v":0}]
[]
[null,null,null,null,2026]
[null,"Preçário",null,null,"2026-01-30","2026-02-27","2026-03-31","2026-04-24","2026-04-30","2026-05-29","2026-06-30","2026-07-31","2026-08-31","2026-09-30","2026-10-23","2026-10-30","2026-11-30","2026-12-31"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0},null,{"$f":"-$D$46","v":0},0,0,0,0,0,null,{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0}]
[null,"Investimento",null,"-"]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":6.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":63.749999999999993},null,null,null,null,null,null,{"$f":"+$F$7*$F$9*((6*30)/360)","v":63.749999999999993}]
[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.850000000000001},null,null,null,null,null,null,{"$f":"+-O80*$D$51","v":-17.850000000000001}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,{"$f":"-((H80+H81)*$D$52)","v":-0.45899999999999991},null,null,null,null,null,null,{"$f":"-((O80+O81)*$D$52)","v":-0.45899999999999991}]
[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$61=\"\",-$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$61=\"\",-$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},0,0,-0.10556999999999998,0,0,0,0,0,0,-0.10556999999999998,0,0,0]
[null,"Cash-Flows",null,null,{"$f":"+SUM(E76:E86)","v":0},{"$f":"+SUM(F76:F86)","v":0},0,45.335429999999988,0,0,0,0,{"$f":"+SUM(M76:M86)","v":0},{"$f":"+SUM(N76:N86)","v":0},{"$f":"+SUM(O76:O86)","v":45.335429999999988},{"$f":"+SUM(P76:P86)","v":0},{"$f":"+SUM(Q76:Q86)","v":0},{"$f":"+SUM(R76:R86)","v":0}]
[]
[null,null,null,null,2027]
[null,"Preçário",null,null,"2027-01-29","2027-02-26","2027-03-31","2027-04-23"]
[null,"Comissão Serviço Bolsa **",null,{"$f":"+IF($F$15=1,0,IF($F$19=1,3,3))","v":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0},{"$f":"-$D$46","v":0}]
[null,"Investimento",null,"-",null,null,null,{"$f":"F7","v":2500}]
[null,"Comissão de Subscrição**",null,{"$f":"D25","v":6.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":63.749999999999993}]
[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.850000000000001}]
[null,"Comissão Rendimentos **",null,0.01,null,null,null,{"$f":"-((H95+H96)*$D$52)","v":-0.45899999999999991}]
[null,"Comissão Reembolso **",null,2E-3,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,{"$f":"+IF($F$17=1,0,IF(AND($F$15=2,OR($F$21=2,$F$21=4)),-$D$54,IF(H$91=\"\",-$D$54,0)))*2","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$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},{"$f":"+(E91+E97+E98+E100)*$D$56","v":0},{"$f":"+(F91+F97+F98+F100)*$D$56","v":0},{"$f":"+(G91+G97+G98+G100)*$D$56","v":0},{"$f":"+(H91+H97+H98+H100)*$D$56","v":-1.2555700000000001}]
[null,"Cash-Flows",null,null,{"$f":"+SUM(E91:E101)","v":0},{"$f":"+SUM(F91:F101)","v":0},{"$f":"+SUM(G91:G101)","v":0},{"$f":"+SUM(H91:H101)","v":2539.1854300000005}]
[null,"* Acresce IS"]
[null,"** Acresce IVA"]