{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Ferreycorp","Calculadora Dividendos","Dividends Calculator"],"not_rendered":{"charts":0,"images":1,"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":"Ferreycorp","index":0,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Exercise for the calculation of Ferreycorp's benefits period 2021",null,12000]
[]
[null,null,null,null,{"$f":"+E47*0.128456563","v":0}]
[]
[null,null,"Cálculo de beneficios correspondientes al período 2021 (dividendo ordinario a ser pagado el 4 de mayo de 2022)"]
[null,null,"Number of Shares as of 18.04.2022"]
[]
[]
[]
[null,null,"Número de acciones al 18.04.2022",null,{"$f":"+E54*0.128456563","v":0}]
[]
[]
[null,null,"Number of Shares as of 18.04.2022"]
[]
[null,null,"Liquidación Dividendos Jurídicas Nacionales - Pago 18 de mayo de 2022"]
[]
[null,null,"Número de acciones al 18.04.2022"]

{"sheet":"Calculadora Dividendos","index":1,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[[40,1,41,1],[40,5,41,5],[40,6,41,6],[40,7,41,7],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,1,39,1],[40,4,41,4],[5,1,5,11],[8,1,10,1],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,6,8,7],[8,8,10,8],[8,9,10,9],[8,10,10,10],[8,11,10,11],[33,1,35,1],[24,11,26,11],[33,7,35,7],[33,6,35,6],[33,5,35,5],[24,1,26,1],[24,2,26,2],[24,9,26,9],[24,10,26,10],[24,3,26,3],[24,4,26,4],[24,5,26,5],[24,6,24,7],[24,8,26,8]]}
[]
[]
[]
[]
[]
[null,"REPARTO DE DIVIDENDOS "]
[]
[]
[null,"AÑO","NÚMERO DE ACCIONES","VALOR NOMINAL UNITARIO","CAPITAL SOCIAL (S/)","UTILIDAD NETA MENOS RESERVAS (S/)","REPARTO DE DIVIDENDOS DE ACUERDO A LA POLÍTICA VIGENTE",null,"DIVIDENDOS EN EFECTIVO (S/)","% DE LAS UTILIDADES QUE SE DISTRIBUYEN","DIVIDENDO EN EFECTIVO POR ACCIÓN (%)","DIVIDENDO POR ACCIÓN (S/)"]
[null,null,null,null,null,null,0.05,0.5]
[null,null,null,null,null,null,"LÍMITE INFERIOR \n(5% DEL CAPITAL)","LÍMITE SUPERIOR \n(50% DE LA UTILIDAD DE LIBRE DISPONIBILIDAD)"]
[null,2003,205000000,1.1000000000000001,{"$f":"+C12*D12","v":225500000.00000003},18268787,{"$f":"E12*$G$10","v":11275000.000000002},{"$f":"F12*$H$10","v":9134393.5},{"$f":"+H12","v":9134393.5},{"$f":"I12/F12","v":0.5},0.05,{"$f":"+G12/C12","v":5.5000000000000007E-2}]
[null,2004,218000000,1.1000000000000001,239800000.00000003,24793743,11990000.000000002,{"$f":"F13*$H$10","v":12396871.5},{"$f":"+G13","v":11990000.000000002},{"$f":"I13/F13","v":0.48358975084963984},0.05,5.5000000000000007E-2]
[null,2005,241980000,1.1000000000000001,266178000.00000003,27127826,13308900.000000002,13563913,{"$f":"+G14","v":13308900.000000002},0.49059957845497837,0.05,5.5000000000000007E-2]
[null,2006,258360000,1.1000000000000001,284196000,79972754.400000006,14209800,39986377.200000003,28419600,0.35536602700781805,0.1,5.5E-2]
[null,2007,305128115,1.1000000000000001,335640926.5,114345493,16782046.324999999,57172746.5,40289899,0.35235231352756508,{"$f":"+G16/E16","v":4.9999999999999996E-2},5.5E-2]
[null,2008,377680455,1.1000000000000001,415448500.50000006,72400381,20772425.025000006,36200190.5,20772425,0.28691043766744817,0.05,5.5000000000000014E-2]
[null,2009,424816167,1.1000000000000001,467297783.70000005,90452887,23364889.185000002,45226443.5,28037867,0.30997205208054884,0.06,6.6000000000000003E-2]
[null,2010,482691963,1.1000000000000001,530961159.30000007,124528171,26548057.965000004,62264085.5,31857670,0.2558270128290891,0.06,6.6000000000000003E-2]
[null,2011,698402606,1,698402606,146736476,34920130.300000004,73368238,41904156,0.28557422900083823,0.06,0.06]
[null,2012,803234873,1,803234873,158285551.96000001,40161743.649999999,79142775.980000004,48194092,0.30447562271620987,0.06,0.06]
[]
[]
[]
[null,"EJERCICIO","NÚMERO DE ACCIONES","VALOR NOMINAL UNITARIO","CAPITAL SOCIAL (S/)","UTILIDAD NETA MENOS RESERVAS (S/)","REPARTO DE DIVIDENDOS DE ACUERDO A LA POLÍTICA VIGENTE",null,"DIVIDENDOS EN EFECTIVO (S/)","% DE LAS UTILIDADES QUE SE DISTRIBUYEN","DIVIDENDO EN EFECTIVO POR ACCIÓN (%)","EFECTIVO DIVIDENDO POR ACCIÓN"]
[null,null,null,null,null,null,0.05,0.6]
[null,null,null,null,null,null,"LÍMITE INFERIOR \n(5% DEL CAPITAL)","LÍMITE SUPERIOR \n(60% DE LA UTILIDAD DE LIBRE DISPONIBILIDAD)"]
[null,2013,945227102,1,{"$f":"+C28*D28","v":945227102},92996130.799999997,{"$f":"E28*$G$26","v":47261355.100000001},{"$f":"F28*$H$26","v":55797678.479999997},{"$f":"+H28","v":55797678.479999997},0.6,{"$f":"I28/C28","v":5.9030976113505468E-2},{"$f":"K28","v":5.9030976113505468E-2}]
[null,2014,1014326324,1,{"$f":"+C29*D29","v":1014326324},117973036.19,{"$f":"E29*$G$26","v":50716316.200000003},70783821.714000002,60859579.439999998,0.51587702923898104,0.06,{"$f":"K29","v":0.06}]
[null,2015,1014326324,1,1014326324,145589380.93000001,50716316.200000003,87353628.557999998,87353628.557999998,0.6,8.6119847716778761E-2,{"$f":"K30","v":8.6119847716778761E-2}]
[null,2015,985224370,1,1014326324,145589380.93000001,{"$f":"E31*$G$26","v":50716316.200000003},87353628.557999998,87353628.557999998,{"$f":"I31/F31","v":0.6},8.8663690442411611E-2,8.8660000000000003E-2]
[null,2016,968687484,1,1014326324,207390441.34999999,50716316.200000003,124434264.80999999,124434264.81,0.6,0.12845656299405639,{"$f":"+K32","v":0.12845656299405639}]
[null,2017,975683029,1,975683029,240311481.11000001,{"$f":"E33*$G$26","v":48784151.450000003},144186888.66600001,132171314.61,{"$f":"I33/F33","v":0.54999999999791938},0.13546542338187989,{"$f":"+K33","v":0.13546542338187989}]
[null,2018,975683029,1,975683029,202525643.22999999,{"$f":"E34*$G$26","v":48784151.450000003},121515385.94,30123185.25,{"$f":"I34/$F$34","v":0.14873763524251762},{"$f":"+I34/C34","v":3.0873946102018344E-2},{"$f":"+K34","v":3.0873946102018344E-2}]
[null,null,975683029,1,975683029,null,null,null,50000000,{"$f":"I35/$F$34","v":0.24688231674058711},{"$f":"+L35","v":5.1246151172000001E-2},5.1246151172000001E-2]
[null,null,975683029,1,975683029,null,null,null,50000000,{"$f":"I36/$F$34","v":0.24688231674058711},{"$f":"+L36","v":5.1246151172000001E-2},5.1246151172000001E-2]
[null,2019,958404238,1,{"$f":"+C37*D37","v":958404238},244854693.59,48748151.450000003,{"$f":"F37*H26","v":146912816.15399998},{"$f":"146912816.15","v":146912816.15000001},{"$f":"I37/F37","v":0.59999999998366382},{"$f":"+L37","v":0.15328899000000001},0.15328899000000001]
[null,2020,"948’554,069 ",1,975683029,143948109.56,{"$f":"+F38*G26","v":7197405.4780000001},{"$f":"+F38*H26","v":86368865.736000001},86368865.739999995,0.60000000002778775,{"$f":"+L38","v":9.1053181425000004E-2},9.1053181425000004E-2]
[null,2021,"946’143,295",1,975683029,376054298.01999998,18802714.901000001,225632578.81199998,100000000,0.26591904553815687,0.10569223555100001,0.10569223555100001]
[null,null,946063288,1,958894238,null,null,null,125632578.81,0.33408095445652475,0.13279511044,0.13279511044]
[null,2022,944959670,1,946063288,418879443.56999999,47303164.400000006,251327666.13999999,120000000,0.28647860820591092,0.12698954654858444,0.12698954654899999]
[null,null,944990670,1,null,null,null,null,131327666.14,0.31352139178931443,0.13897244735760195,0.13897244736]
[]
[]
[]
[]
[]
[]
[null,null,"Sr Accionista: Para efectuar el cálculo deberá llenar el recuadro que le corresponda según su número de acciones. "]
[]
[null,null,"Cálculo de beneficios correspondientes al período 2022 (dividendo ordinario a ser pagado el 05 de mayo de 2023)"]
[]
[]
[null,null,"Liquidación Dividendos Personas Naturales y Juridicas Extranjeras - Pago 05 de mayo de 2023"]
[]
[null,null,"Número de acciones al 17.03.2023",null,null,0]
[null,null,"Dividendo",null,null,{"$f":"+($F$56*L42)","v":0}]
[null,null,"Impuesto a la renta",null,null,{"$f":"+$F$57*0.05","v":0}]
[null,null,"Neto a pagar",null,null,{"$f":"+F57-F58","v":0}]
[]
[null,null,"Liquidación Dividendos Jurídicas Nacionales - Pago 05 de mayo de 2023"]
[]
[null,null,"Número de acciones al 17.03.2023"]
[null,null,"Dividendo",null,null,{"$f":"+(F63*L41)","v":0}]
[null,null,"Neto a pagar",null,null,{"$f":"+F64","v":0}]

{"sheet":"Dividends Calculator","index":2,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":true,"merged":[[24,6,24,7],[24,8,26,8],[24,9,26,9],[24,10,26,10],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[24,5,26,5],[36,1,37,1],[36,5,37,5],[36,6,37,6],[36,7,37,7],[5,1,5,11],[8,1,10,1],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,6,8,7],[8,8,10,8],[8,9,10,9],[8,10,10,10],[24,11,26,11],[8,11,10,11]]}
[]
[]
[]
[]
[]
[null,"DIVIDENDS DISTRIBUTION"]
[]
[]
[null,"YEAR","NUMBER OF SHARES","UNIT NOMINAL VALUE","SHARE CAPITAL (S/.)","NET INCOME MINUS RESERVES (S/.)","DIVIDENDS DISTRIBUTION ACCORDING TO CURRENT POLICY",null,"CASH DIVIDEND (S/.)","% OF THE INCOME DISTRIBUTION","CASH DIVIDEND PER SHARE (%)","CASH DIVIDEND PER SHARE (S/.)"]
[null,null,null,null,null,null,0.05,0.5]
[null,null,null,null,null,null,"INFERIOR LIMIT\n(5% OF SHARE CAPITAL)","SUPERIOR LIMIT\n(50% OF FREE DISPOSITION INCOME)"]
[null,2003,205000000,1.1000000000000001,{"$f":"+C12*D12","v":225500000.00000003},18268787,{"$f":"E12*$G$10","v":11275000.000000002},{"$f":"F12*$H$10","v":9134393.5},{"$f":"+H12","v":9134393.5},{"$f":"I12/F12","v":0.5},0.05,{"$f":"+G12/C12","v":5.5000000000000007E-2}]
[null,2004,218000000,1.1000000000000001,239800000.00000003,24793743,11990000.000000002,{"$f":"F13*$H$10","v":12396871.5},{"$f":"+G13","v":11990000.000000002},{"$f":"I13/F13","v":0.48358975084963984},0.05,5.5000000000000007E-2]
[null,2005,241980000,1.1000000000000001,266178000.00000003,27127826,13308900.000000002,13563913,{"$f":"+G14","v":13308900.000000002},0.49059957845497837,0.05,5.5000000000000007E-2]
[null,2006,258360000,1.1000000000000001,284196000,79972754.400000006,14209800,39986377.200000003,28419600,0.35536602700781805,0.1,5.5E-2]
[null,2007,305128115,1.1000000000000001,335640926.5,114345493,16782046.324999999,57172746.5,40289899,0.35235231352756508,{"$f":"+G16/E16","v":4.9999999999999996E-2},5.5E-2]
[null,2008,377680455,1.1000000000000001,415448500.50000006,72400381,20772425.025000006,36200190.5,20772425,0.28691043766744817,0.05,5.5000000000000014E-2]
[null,2009,424816167,1.1000000000000001,467297783.70000005,90452887,23364889.185000002,45226443.5,28037867,0.30997205208054884,0.06,6.6000000000000003E-2]
[null,2010,482691963,1.1000000000000001,530961159.30000007,124528171,26548057.965000004,62264085.5,31857670,0.2558270128290891,0.06,6.6000000000000003E-2]
[null,2011,698402606,1,698402606,146736476,34920130.300000004,73368238,41904156,0.28557422900083823,0.06,0.06]
[null,2012,803234873,1,803234873,158285551.96000001,40161743.649999999,79142775.980000004,48194092,0.30447562271620987,0.06,0.06]
[]
[]
[]
[null,"YEAR","NUMBER OF SHARES","UNIT NOMINAL VALUE","SHARE CAPITAL (S/.)","NET INCOME MINUS RESERVES (S/.)","DIVIDENDS DISTRIBUTION ACCORDING TO CURRENT POLICY",null,"CASH DIVIDEND (S/.)","% OF THE INCOME DISTRIBUTION","CASH DIVIDEND PER SHARE (%)","CASH DIVIDEND PER SHARE (S/.)"]
[null,null,null,null,null,null,0.05,0.6]
[null,null,null,null,null,null,"INFERIOR LIMIT\n(5% OF SHARE CAPITAL)","SUPERIOR LIMIT\n(60% OF FREE DISPOSITION INCOME)"]
[null,2013,945227102,1,{"$f":"+C28*D28","v":945227102},92996130.799999997,{"$f":"E28*$G$26","v":47261355.100000001},{"$f":"F28*$H$26","v":55797678.479999997},{"$f":"+H28","v":55797678.479999997},0.6,{"$f":"I28/C28","v":5.9030976113505468E-2},{"$f":"K28","v":5.9030976113505468E-2}]
[null,2014,1014326324,1,{"$f":"+C29*D29","v":1014326324},117973036.19,{"$f":"E29*$G$26","v":50716316.200000003},70783821.714000002,60859579.439999998,0.51587702923898104,0.06,{"$f":"K29","v":0.06}]
[null,2015,1014326324,1,1014326324,145589380.93000001,50716316.200000003,87353628.557999998,87353628.557999998,0.6,8.6119847716778761E-2,{"$f":"K30","v":8.6119847716778761E-2}]
[null,2015,985224370,1,1014326324,145589380.93000001,50716316.200000003,87353628.557999998,87353628.557999998,0.6,8.8663690442411611E-2,8.8660000000000003E-2]
[null,2016,968687484,1,1014326324,207390441.34999999,50716316.200000003,124434264.80999999,124434264.81,0.6,0.12845656299405639,{"$f":"+K32","v":0.12845656299405639}]
[null,2017,975683029,1,975683029,240311481,{"$f":"E33*$G$26","v":48784151.450000003},144186888.59999999,132171314.59999999,{"$f":"I33/F33","v":0.55000000020806328},0.13546542337163067,{"$f":"+K33","v":0.13546542337163067}]
[null,2018,975683029,1,975683029,202252643.22999999,48784151.450000003,121515385.94,{"$f":"+H34","v":121515385.94},0.6008098781770369,0.12454391675188192,{"$f":"+K34","v":0.12454391675188192}]
[null,2019,958404238,1,{"$f":"+C35*D35","v":958404238},244854693.59,{"$f":"+F35*$G$26","v":12242734.679500001},{"$f":"+F35*$H$26","v":146912816.15399998},{"$f":"+H35","v":146912816.15399998},{"$f":"+I35/F35","v":0.6},0.15328899000000001,0.15328899000000001]
[null,2020,"948’554,069 ",1,975683029,143948109.56,7197405.4780000001,86368865.736000001,86368865.739999995,0.60000000002778775,9.1053181425000004E-2,9.1053181425000004E-2]
[null,2021,"946’143,295",1,975683029,376054298.01999998,18802714.901000001,225632578.81199998,100000000,0.26591904553815687,0.10569223555100001,0.10569223555100001]
[null,null,"946’063,288",1,958894238,null,null,null,125632578.81,0.33408095445652475,0.13279511044,0.13279511044]
[]
[]
[]
[]
[]
[null,null,"Mr. Shareholder: In order to proceed with the calculation, it is necessary to fill out the corresponding box according to your number of shares."]
[]
[null,null,"Exercise for the calculation of Ferreycorp's benefits period 2021"]
[]
[]
[null,null,"Dividend Liquidation for Natural Person and Foreign Entities - First Payment"]
[]
[null,null,"Number of Shares as of 18.04.2022"]
[null,null,"Dividend",null,null,{"$f":"+F51*L38","v":0}]
[null,null,"Income tax",null,null,{"$f":"+(F52*5%)","v":0}]
[null,null,"Net to pay",null,null,{"$f":"+F52-F53","v":0}]
[]
[null,null,"Dividend Liquidation for Peruvian Legal Person - First Payment"]
[]
[null,null,"Number of Shares as of 18.04.2022"]
[null,null,"Dividend",null,null,{"$f":"+F58*L38","v":0}]
[null,null,"Net to pay",null,null,{"$f":"+F59","v":0}]