Tipo de Cambio

TAREA Fecha Tipo cambio

1. Calcular las columnas faltantes en cada 16/03/2019 2.925
cuadro.
2. Crear la tabla dinámica de la muestra. 17/03/2019 2.994
3. Responder las preguntas finales
18/03/2019 2.800
19/03/2019 2.915
20/03/2019 2.761

21/03/2019 2.721

22/03/2019 2.766

23/03/2019 2.787

24/03/2019 2.795

25/03/2019 2.900

26/03/2019 2.964

ESTADO DE CUENTAS VEN

Fecha
Cliente Contrato Distrito
Vencimiento

ABANTO CHAVEZ JAVIER LUIS 1091263 22/03/2019 LINCE

ABANTO MENDO MARIA ESTHER 1071851 24/03/2019 LA VICTORIA

ACARAPI CASTILLO SIXTO ALBERTO 1126611 24/03/2019 LINCE

ACEVEDO JAEN HUMBERTO RICARDO 968765 21/03/2019 SAN MIGUEL

ACOSTA ATILIO GARCIA OYA A 553651 25/03/2019 LA VICTORIA

ACOSTA GUEVARA YESSICA MARIA 1456423 22/03/2019 SAN MIGUEL

ADANAQUE RISCO BEATRIZ 1201525 20/03/2019 SAN MIGUEL

AGUIRRE BRAVO EDGAR DAVID 461385 21/03/2019 SAN MIGUEL

ALARCON MENDOZA CONSUELO 889938 18/03/2019 SAN MIGUEL

ALBUJAR CHAVEZ JONATHAN JOAO 243493 23/03/2019 SAN MIGUEL

ALIAGA PICHILINGUE ULISES 1112439 16/03/2019 LA VICTORIA

ALMORA CASTILLO ROBERTO ANTONIO 1134083 22/03/2019 LINCE

ALTAMIRANO DIAZ JESSICA LIZET 1069836 19/03/2019 CALLAO

ALVAREZ CAMPOS JOSE LUIS 1099367 18/03/2019 LIMA

ANDRADE VICTOR ZENON ESPIN 194600 25/03/2019 LA VICTORIA

ANTONIO CCENTE CRESCENCIO 1197557 18/03/2019 LA VICTORIA

APOLAYA PILLACA LUZ ANGELICA 1167306 19/03/2019 LA VICTORIA

APONTE OSCAR LUIS ACUÑA DE 42213 23/03/2019 SURCO

AQUINO EVELYN TERESA OJEDA 34487 19/03/2019 MIRAFLORES

ARANDA ANTONIO ABDON COTER 271119 17/03/2019 LA VICTORIA

ARAPA ZAPATA RODOLFO 143464 21/03/2019 SAN MIGUEL

ARESTEGUI PAYE VICTOR HUGO 871443 23/03/2019 SAN MIGUEL

ARIVILCA QUISPE ABRAHAM 1173109 16/03/2019 LA VICTORIA

ARRIOLA CAQUE MIGUEL ANGEL 1087267 18/03/2019 MIRAFLORES

ARRIOLA TUEROS JOSE ALBERTO 1074788 17/03/2019 LA VICTORIA

ARTEAGA MORON JENNY SANDRA 958468 18/03/2019 SAN MIGUEL

ARTOLA ROJAS HILDA ROSA 1606549 16/03/2019 SAN MIGUEL

ATAUYUCO LUNA VERONICA 1092051 24/03/2019 SAN BORJA

BACA LLERENA JORGE LUIS 34789 17/03/2019 SAN MIGUEL

BALAREZO MINAYA ARNALDO JULIAN 343418 18/03/2019 SAN ISIDRO

BARRENECHEA PASTOR ANTONIO 1154285 20/03/2019 CALLAO

BARRETO ALVARADO EDWARD CLEMENT 1038694 21/03/2019 SAN ISIDRO

BARRETO BARDALES IVAN RICARDO 1099331 24/03/2019 LINCE

BARRIOS IPENZA HUGO AUGUSTO 1160230 25/03/2019 LA VICTORIA

BEGAZO RAMIREZ ORLANDO JOSE 1063021 24/03/2019 SURCO

BELLIDO ANGULO GERALD MARLON 1064377 18/03/2019 SAN BORJA

BELTRAN BARDALES FRANCISCO 1089555 20/03/2019 SAN BORJA

BENAVIDES CABRERA ELI 1046416 19/03/2019 LA VICTORIA

BENITES PEREZ GRACIELA ROSALINDA 1036199 16/03/2019 SAN BORJA

BENITO GONZALES NERIO FIDEL 250139 17/03/2019 SAN MIGUEL

BERRIOS AQUIJE CARMEN BEATRIZ 969877 19/03/2019 LINCE

BOCANEGRA VELASQUEZ SANTIAGO FERNAN 1212551 24/03/2019 MIRAFLORES

BOLIVAR NAVARRO ROMULO MARTIN 524751 25/03/2019 SAN MIGUEL

BOSSIO ERCILLA JUAN MANUEL 939056 20/03/2019 SAN MIGUEL

BOZA SEAS JORGE LUIS 455776 20/03/2019 SAN MIGUEL

BRICEÑO IMAN VICTOR 936367 19/03/2019 SAN MIGUEL

BRINTHON KERR ERICH 1012008 17/03/2019 SAN ISIDRO

BUSTAMANTE SOLARI MARIO LUIS 1010898 17/03/2019 LA VICTORIA

CABRERA RAMON VASQUEZ REY 156327 18/03/2019 LA VICTORIA

CAICEDO CARDENAS ROBERT 773727 19/03/2019 SAN MIGUEL

CAJO CESPEDES HILARIO 907901 25/03/2019 SAN MIGUEL

CALDERON CARDENAS REYNALDO LESME 93939 17/03/2019 SAN MIGUEL

CALDERON CARRANZA MARIA ESTELA 1092565 20/03/2019 MIRAFLORES

CALDERON LAURENTE RICARDO BENITO 1279903 22/03/2019 LIMA

CALLAO VEGA JOSE MARCELINO 772607 19/03/2019 SAN MIGUEL

CAMPOBLANCO ALVARADO PAMELA 1082249 16/03/2019 MIRAFLORES

CAMPOS CHAVEZ GINA PAOLA 764426 20/03/2019 SAN MIGUEL

CAR CHECK SAC 22234 22/03/2019 MIRAFLORES

CARHUALLANQUI SUASNABAR GREGORIO 134430 25/03/2019 SAN MIGUEL

CARIDAD ESPERANZA GHIO LUCIANO 583022 24/03/2019 SAN MIGUEL

CARLOS ALBERTO VILLANUEVA MAGALLANE 374040 26/03/2019 SAN MIGUEL

CARLOS MANUEL ALARCON ACEVEDO 545074 22/03/2019 SAN MIGUEL

CARPIO QUINTANA VICTOR HUGO 1089210 25/03/2019 LIMA

CARRANZA PEZO CARLOS FIDEL 979104 22/03/2019 LINCE

CARRANZA VIGO ANGEL ADRIANY 1081662 23/03/2019 SAN BORJA

CARRASCO CARRASCO CIRILO 644196 20/03/2019 SAN MIGUEL

CARRASCO CARRASCO EDINSON ALEXANDER 512885 21/03/2019 SAN MIGUEL

CARRUITERO DOMINGUEZ MARIO ANTONIO 1133187 18/03/2019 LINCE

CASAVERDE CASTILLO KARIN ISABEL 441023 23/03/2019 SAN MIGUEL

CASTAÑEDA HUAMBACHANO VICTOR 1002239 16/03/2019 SAN BORJA

CASTILLA CONTRERAS TOMAS EMILIO 456608 18/03/2019 SAN MIGUEL

CASTILLO ARANDA PEDRO AMERICO 1059387 18/03/2019 LA VICTORIA

CASTILLO MIÑOPE JOSE ANTONIO 239275 21/03/2019 SAN MIGUEL

CASTILLO YAMUNAQUE ALFREDO 1088242 23/03/2019 LINCE

CASTRO HOYLE ERIKA MILAGROS 1210001 24/03/2019 MIRAFLORES

CAVA DIAZ MARLENE HELEA 1000649 16/03/2019 LA VICTORIA

CAVERO JUANA ROSA VELAOCHA 33048 18/03/2019 LA VICTORIA

CERNA CACHIQUE JANET JACKELINE 1164978 17/03/2019 LA VICTORIA

CESPEDES SANTOS MARIA PATRICIA 854735 21/03/2019 SAN MIGUEL

CESPEDES VIRU RAFAEL OMAR 560693 23/03/2019 SAN MIGUEL

CHACON ALMEYDA MILTON CESAR ANTONIO 624845 21/03/2019 SAN MIGUEL

CHACON CERCADO ALDO CESAR 1042079 16/03/2019 CALLAO

CHANAME MARIN JUAN JAVIER 462543 23/03/2019 SAN MIGUEL

CHATI QUISPE HUGO 1086317 18/03/2019 LINCE

CHAVESTA FERNANDEZ CESAR ORLANDO 217328 18/03/2019 SAN MIGUEL

CHAVEZ CARPIO JULIAN BERTTI 118454 21/03/2019 LINCE

CHAVEZ MEDINA HENRY 1121493 22/03/2019 SAN BORJA

CHAVEZ OSORIO MARIA VICTORIA 1080446 19/03/2019 LA VICTORIA

CHAVEZ ROSADO BLANCA EVA 281700 26/03/2019 SAN MIGUEL

CHERO TORRES LUIS GERARDO 697605 21/03/2019 LINCE

CHERRE CORILLOCLLA PEDRO MANUEL 44017 19/03/2019 LIMA

CHERRES DE LA BARRA DALINDA AMADA 942383 23/03/2019 SAN MIGUEL

CHIZAN LARREA NINOSKA ISABEL 176192 23/03/2019 SAN MIGUEL

CHONTA ORTIZ ANTENOR ANGEL 815578 18/03/2019 SAN MIGUEL

CHOQUE CHURA ODILON 1140861 24/03/2019 LINCE

CHOQUE PAUCAR JOSE LUIS 1084092 23/03/2019 LIMA

CHUJUTALLI IPANAMA VICTORIANO 1261318 17/03/2019 LA VICTORIA

CHUMBE ROJAS JUAN MANUEL 1088364 21/03/2019 LA VICTORIA

CHUMBIMUNI CHIRINOS MARIBEL JANET 958425 21/03/2019 SAN MIGUEL

CHUQUIPIONDO ORELLANA JENSYS 898627 19/03/2019 SAN MIGUEL

CHURA PARRILLO LUIS ENRIQUE 1209491 24/03/2019 LA VICTORIA

CIEN POR CIENTO DIES EL SRL 100 DIE 1090797 18/03/2019 SAN BORJA

COLFER BRACAMONTE DESIREE 531737 19/03/2019 SAN MIGUEL

COLLANTES PEÑA JUAN JOSE 1005967 18/03/2019 CALLAO

COLLAZOS VARILLAS ROGELIO 1058772 23/03/2019 SURCO

COLQUE VALENTIN YANINA MARIBEL 1145742 23/03/2019 LIMA

CONSTANTINO JORGE SANCHEZ 136660 25/03/2019 LA VICTORIA

CONTRERAS LUIS ERNESTO BOH 59975 21/03/2019 SURCO

CORDOVA CARVALLO,DAVID ARMANDO 1081499 16/03/2019 LA VICTORIA

CORNEJO DE LA FUENTE CHAVEZ RODRIGO 1297855 20/03/2019 LIMA

CORONEL CAPACYACHI JESUS FRANCISCO 217158 18/03/2019 SAN MIGUEL

CORTEZ ROMERO VICTOR RAUL 448524 22/03/2019 SAN MIGUEL

COTERA TORRES PEDRO GUILLERMO 837938 18/03/2019 SAN MIGUEL

CRUZ CARRASCO SARA JOHAIDY 1100583 22/03/2019 SAN BORJA

CRUZ FLORES BETTY MELISSA 1009826 19/03/2019 SAN MIGUEL

CUELLAR MORALES GAMANIEL 1197824 21/03/2019 LA VICTORIA

CUEVA CRUZATTI MILWUER OSCAR 247332 24/03/2019 LINCE

CUSTODIO CARBAJAL CARLOS 497118 18/03/2019 SAN MIGUEL

CUYA YUYALE TIMOTEO 978140 26/03/2019 LINCE

DAVALOS VERA ANIBAL GUSTAVO 1029350 25/03/2019 SURCO

DAVILA FLORES NAYUD MILAGROS 1059110 25/03/2019 SAN BORJA

DAVILA TULIO PLACIDO MEZA 563975 21/03/2019 LA VICTORIA

DE LA CRUZ CHERRES GREGORIO LORENZO 37198 18/03/2019 LINCE

DE LA CRUZ PAREJA NELSON VICTOR 1251145 20/03/2019 MIRAFLORES

DE LA PEÑA ARMANDO GUALBER 302960 26/03/2019 LA VICTORIA

DE VELASCO SUAREZ ORLANDO ALFONSO 59462 24/03/2019 LIMA

DEL POZO CASAS FERNANDO CESAR 1003319 16/03/2019 SAN ISIDRO

DELGADO SOTOMAYOR DINO ALDO 209910 26/03/2019 SAN MIGUEL

DELGADO TUCTO JAMES 1096991 24/03/2019 LA VICTORIA

DELHONTE MANUEL ANGEL CAGN 78627 19/03/2019 MIRAFLORES

DEMETRIO ANGEL CARBAJAL PACHECO 1125572 23/03/2019 LINCE

DIAZ RAMOS RAMIRO 270768 18/03/2019 SAN MIGUEL

DIAZ RIOS MARLON DEY 1229848 17/03/2019 LA VICTORIA

DIAZ YANTAS VICTOR FRANCISCO 15499 16/03/2019 LA VICTORIA

DOMINGUEZ MARTEL WILDER 1099494 21/03/2019 LA VICTORIA

DOMINGUEZ SALCEDO JAHN HENRY 1074311 24/03/2019 CALLAO

DURAND FLORES JOSE DOMINGO 1140140 25/03/2019 SAN MIGUEL

EGUSQUIZA JUAN RAMON SILUP 25038 18/03/2019 LIMA

ENRIQUEZ ROSSO JOSE FERNANDO 816779 17/03/2019 LINCE

ESCALANTE CHOQUEVILCA CARMEN ANGELA 563900 26/03/2019 SAN MIGUEL

ESCARCENA GUZMAN ROY ARCADIO 214736 20/03/2019 SAN MIGUEL

ESCOBAR BOLTAN TATIANA 1157991 24/03/2019 LA VICTORIA

ESPINOZA BECERRA PATRICIA ESMERALDA 1093315 20/03/2019 SAN BORJA

ESPINOZA ESPINOZA MANUEL TELESFORO 570400 26/03/2019 SAN MIGUEL

ESPINOZA MARIANO JOSE LUIS 1100209 16/03/2019 LIMA

EYZAGUIRRE ALEGRIA MANUEL EDUARDO 1087387 18/03/2019 LIMA

EYZAGUIRRE SANTA ANA GABRIELA MATIL 1144776 19/03/2019 LINCE

FACTORIA ON MOTORS EIRL 11934 21/03/2019 MIRAFLORES

FALEN FERNANDO GONZALEZ GO 11116 19/03/2019 LINCE

FARRO GOMEZ DORA ASUNCION 1005039 16/03/2019 SURCO

FELICES ROY HENRRY CCAICO 55791 25/03/2019 LA VICTORIA

FERNANDEZ LAREDO MIGUEL ANGEL 1158144 21/03/2019 LA VICTORIA

FERNANDEZ LOARTE FERNANDO LINCOLHN 1143100 25/03/2019 LA VICTORIA

FERNANDEZ MELENDEZ ELMO 357227 19/03/2019 SAN MIGUEL

FERNANDO MANUEL LAPIZ YAMUNAQUE 1055256 19/03/2019 SURCO

FERRER MAMANI KARINA VANESSA 764639 17/03/2019 LINCE

FERRETTO CORTEZ SERGIO ISRAEL 920517 19/03/2019 SAN MIGUEL

FERRUZO MARIELLA EULALIA M 104228 17/03/2019 LA VICTORIA

FIGUEROA LOPEZ JORGE 813346 20/03/2019 LINCE

FIGUEROA QUISPE SANDRA ROSALINA 353418 18/03/2019 SAN MIGUEL

FLORES ALTUNA MARIELA MERCEDES 1002461 24/03/2019 MIRAFLORES

FLORES CURISINCHE MARTIN OSWALDO 1145893 22/03/2019 SAN BORJA

FLORES FUENTES GARY BERNARD 1104345 20/03/2019 CALLAO

FOPPIANI VINCES GILDA MARIA 1001882 23/03/2019 MIRAFLORES

GALARRETA VELARDE ANIBAL ANTONIO 1091833 22/03/2019 MIRAFLORES

GALLARDO PEREYRA JOSE LUIS 1099656 19/03/2019 LA VICTORIA

GALVEZ CUBAS CARLOS 1206419 16/03/2019 LA VICTORIA

GAMARRA SILVA JESUS ROBERTO 1059909 16/03/2019 LINCE

GAMEZ MELENDREZ JESUS GILMER 435236 20/03/2019 SAN MIGUEL

GARCIA ADRIANZEN GERARDO MARTIN 413682 24/03/2019 SAN MIGUEL

GARCIA HUERTA WILLIAM WARLEY 1121393 22/03/2019 SURCO

GARCIA LA RIVA VICTORIA ROSA 517402 24/03/2019 SAN MIGUEL

GARCIA MENDOZA MARCIONILA 598550 26/03/2019 SAN MIGUEL

GIL LOPEZ JUAN CARLOS GERARDO 1122038 17/03/2019 MIRAFLORES

GIL VILLANUEVA DIANA CECILIA 1325204 21/03/2019 LIMA

GIRAO MALAGA PATRICIA ANTUANET 1050212 23/03/2019 LINCE

GOMEZ ALCA LINO EZZIO 1027290 25/03/2019 MIRAFLORES

GOMEZ OSCAR ENRIQUE BELTRA 74792 24/03/2019 LINCE

GOMEZ VALENCIA RAFAEL RAMIRO 1063009 16/03/2019 CALLAO

GONZALES INJOQUE MARIA GABRIELA 247456 20/03/2019 LINCE

GONZALES SAAVEDRA JESUS ANTONIO 1032865 20/03/2019 LIMA

GONZALES SALGUERO JESUS ANDRES 639109 17/03/2019 SAN MIGUEL

GONZALEZ MENENDEZ JUAN CARLOS 1062819 16/03/2019 SAN BORJA

GRANADOS CLAROS ANGEL CUSTODIO 61166 20/03/2019 SAN MIGUEL

GUERRA TORO FELICITAS ESTHER 367826 20/03/2019 SAN MIGUEL

GUEVARA ALVAREZ ALEXANDER 1282076 19/03/2019 LINCE

GUEVARA ARANGOITIA CESAR AUGUSTO 1074496 19/03/2019 LIMA

GUEVARA PALOMINO HERMELINDA LUZ 1089174 21/03/2019 SAN BORJA

GUILLEN BUSTIOS CARMEN MARCELA 211249 17/03/2019 SAN MIGUEL

GUTIERREZ CARDENAS LUIS FERNANDO 1060715 20/03/2019 LINCE

HUAMAN ORTEGA OSCAR ALBERTO 184349 16/03/2019 SAN MIGUEL

HUARANCA SEGOVIA CESAR ENRIQUE 339393 23/03/2019 SAN MIGUEL

HUAYNATE BONILLA ARON EFRAIN 1207583 22/03/2019 LA VICTORIA

HUERTA LOPEZ CHRISTIAN 1055351 24/03/2019 SURCO

HURTADO URETA RICARDO 1221652 23/03/2019 LA VICTORIA

HURTADO X JORGE TEODORO 1004719 16/03/2019 SAN MIGUEL

ICAZA DELGADO ARMANDO ABELARDO 1059209 16/03/2019 LIMA

IPANAQUE MENDOZA MIGUEL ANGEL 177288 17/03/2019 LINCE

IPUSHIMA ABNER VASQUEZ CON 91300 26/03/2019 LA VICTORIA

JAIMES EGUIZABAL ELEODORO FRANCISCO 1032553 22/03/2019 LIMA

JAVIER TAFUR SAYDA YENYA 780200 26/03/2019 SAN MIGUEL

JIMENEZ RODRIGUEZ MANUEL HUMBERTO 277630 26/03/2019 SAN MIGUEL

JIMENEZ SANGAMA CARLOS ORLANDO 1148544 21/03/2019 MIRAFLORES

JOAQUIN MORANTE ANA GISELLA 865958 18/03/2019 SAN MIGUEL

JOSE CARLOS JESUS SCHIAFFINO GARCIA 481993 23/03/2019 SAN ISIDRO

JOSE ROBERTO ACEVEDO MARTINEZ 441392 24/03/2019 SAN MIGUEL

JUAN CARLOS BENAVIDES ROJAS 1089915 20/03/2019 SURCO

KAREN YLYANA AGUILAR MOQUILLAZA 676799 17/03/2019 LINCE

KAWAMURA RODRIGUEZ ERIKA PAOLA 37184 22/03/2019 SAN MIGUEL

KOIKE LOAYZA JESUS EUGENIO 524714 22/03/2019 SAN ISIDRO

LEON ALZAMORA JOSE LUIS 1076206 19/03/2019 MIRAFLORES

LEON DE LA ROCA JONATHAN FERNANDO 17154 21/03/2019 SURCO

LERMO GALARZA SERGIO EDMUNDO 1050595 20/03/2019 LA VICTORIA

LEVA AMPUERO RENZO 1209982 23/03/2019 MIRAFLORES

LILIANA ANGELA HUAMANI PUCHURI 495204 22/03/2019 SAN MIGUEL

LINARES PEREZ SEGUNDO RICARDO 1310305 20/03/2019 SAN MIGUEL

LINO MATOS CARMEN ROSA 900109 17/03/2019 SAN MIGUEL

LITANO COBEÑAS JOSE HUGO 938319 17/03/2019 SAN MIGUEL

LLAZA JUANITO ALEJANDRO SERAFIN 529443 23/03/2019 SAN MIGUEL

LLERENA CARLOS AMADOR TELL 549468 18/03/2019 LA VICTORIA

LOAYZA ALCANTARA LUIS ALBERTO 1087696 19/03/2019 MIRAFLORES

LOAYZA DARIO ELISBAN ORTEG 143142 23/03/2019 LINCE

LOAYZA WAIDHOFER GABRIELA MARIE 1308572 23/03/2019 LA VICTORIA

LOPEZ CAYO DIONISIO VILLAN 282471 25/03/2019 LA VICTORIA

LOPEZ CRUZATE GASTON CREIDE 1317342 23/03/2019 SAN MIGUEL

LOPEZ LUIS HUMBERTO OWERLU 567725 21/03/2019 LA VICTORIA

LOPEZ ORDOÑEZ KARIN JANET 22314 22/03/2019 SAN MIGUEL

LOPEZ ROLDAN JUDITH LUZ 1058569 16/03/2019 LINCE

LOPEZ SABOYA MARIA DEL PILAR 74322 24/03/2019 SAN BORJA

LOZANO CANCHO JOSE 1399373 22/03/2019 SAN MIGUEL

LUCAR MACHUCA JOSE CARLOS 703044 22/03/2019 SAN MIGUEL

LUCHO BENAVENTE EIRL 875 21/03/2019 LIMA

LUJAN LUJAN LUIS ULISES 1093687 18/03/2019 LIMA

LUJAN MARIA ROXANA SEPULVE 105958 17/03/2019 SAN ISIDRO

LUNA CRUZ SANTOS REYNALDO 21059 17/03/2019 LINCE

MACEDO MASIAS GIULIANA CECILIA 911399 17/03/2019 LINCE

MACHADO SANDOVAL, VICTORIA ELENA 462565 21/03/2019 SAN ISIDRO

MACIZO GOMEZ GLADIS MARITHZA 1088356 19/03/2019 LINCE

MALATESTA ERNESTO OSWALDO 550172 24/03/2019 LA VICTORIA

MALLQUI MINAYA,GAMANIEL 1211631 24/03/2019 LA VICTORIA

MANRIQUE LEBRUN CARMEN 1083827 18/03/2019 CALLAO

MARAVI CANGALAYA FRENEE MARIA 561541 25/03/2019 LINCE

MARCO ANTONIO FERNANDEZ PALMA 482196 20/03/2019 SAN MIGUEL

MARENGO VELAOCHAGA JORGE EDUARDO 1152700 25/03/2019 MIRAFLORES

MARMANILLO CANO JORGE FIDEL 1139537 18/03/2019 MIRAFLORES

MARQUEZ IBARRA JULIA DONATILDE 1156762 23/03/2019 LIMA

MARREROS VILLANUEVA PAUL RICHARD 651796 20/03/2019 SAN MIGUEL

MARTIN PINEDO JUAN GABRIEL 581394 22/03/2019 SAN ISIDRO

MARTINEZ GONZALES PABLO WILLY 1140554 21/03/2019 LA VICTORIA

MARTINEZ MELGAREJO VICTOR 1059699 16/03/2019 CALLAO

MATTA CAVERO SOFIA REBECA 891568 18/03/2019 SAN MIGUEL

MAYO ORTEGA PEDRO ALFREDO 1199614 21/03/2019 LA VICTORIA

MELISSA SOLEDAD APONTE HUAPAYA 669938 18/03/2019 SAN MIGUEL

MENDIZABAL AMELIA SANDOVAL 87131 25/03/2019 LINCE

MENDOZA LOPEZ DAMASO LEONCIO 1002695 20/03/2019 LIMA

MENDOZA MAGALLANES ITALO 1162590 25/03/2019 SURCO

MENDOZA REVILLA JUAN CARLOS 1284179 16/03/2019 LINCE

MENDOZA RODRIGUEZ ROCIO ELIZABETH 1078326 19/03/2019 LA VICTORIA

MERINO ARCELLES MANUEL 1165821 24/03/2019 LINCE

MERINO CORONADO CARLOS GABRIEL 236578 18/03/2019 LINCE

MEZA JOSE LUIS NAVEDA IO T 95441 25/03/2019 LIMA

MIRANDA TIRAPO JUAN SINECIO 413925 21/03/2019 SAN MIGUEL

MOGROVEJO MEDINA JUAN DAVID 1286587 18/03/2019 SAN MIGUEL

MONASTERIO RUIZ JEAN OLIVER 1247684 21/03/2019 LA VICTORIA

MONTES MONTES CARLOS EDDY 656453 23/03/2019 SAN MIGUEL

MONTES SALAS CECILIA MILAGROS 1020072 23/03/2019 SAN MIGUEL

MONTESINOS NUÑEZ MOISES MIGUEL 1000742 23/03/2019 LIMA

MORALES GALLO JORGE LUIS 1000772 23/03/2019 SAN BORJA

MORALES LLONTOP LORENA JUDITH 572365 21/03/2019 SAN MIGUEL

MORALES PELAEZ CARLOS GUSTAVO 1022459 16/03/2019 LA VICTORIA

MORENO IRENE ROSA LOPEZ Z 26306 20/03/2019 LIMA

MORENO VILLAREYES DEYVER 384550 26/03/2019 SAN MIGUEL

MOULET CHUMACERO DIANA ELIZABETH 452688 18/03/2019 SAN MIGUEL

MUCHA ORLANDO ISAAC LLACZA 23343 23/03/2019 SAN BORJA

MURAYA VILLANUEVA JOSE LUIS 1145394 21/03/2019 SURCO

NAPANGA NEGREIROS EDDY ERNESTO 1120078 17/03/2019 MIRAFLORES

NAVARRO PAREDES TESALIA 1348396 19/03/2019 SAN MIGUEL

NB CORPORATION SAC 1901647 18/03/2019 MIRAFLORES

NEYRA CASTILLO MARIA KATYA 1076517 18/03/2019 SAN BORJA

NUÑEZ RENGIFO NIXON 34932 24/03/2019 LIMA

OCHOA ARAGON HORACIO 1173803 22/03/2019 LINCE

OCHOA LUZMILA LINA ALIAGA 283486 20/03/2019 LA VICTORIA

OLIVARES GUEVARA ARMSTRONG WALTER 1289942 23/03/2019 LA VICTORIA

ONOJIMA CABRERA HELGA CAROL 1211784 21/03/2019 MIRAFLORES

OREJUELA RASMUSSEN MONICA VANESSA 1059591 24/03/2019 SURCO

ORTEGA GAMARRA ALEX HILDEBRANDO 1111540 25/03/2019 MIRAFLORES

PACHAS PATRICIA MILUSKA SA 37088 18/03/2019 LIMA

PADILLA CHAVEZ ALVARO GABRIEL 813435 21/03/2019 SAN MIGUEL

PADILLA PONCE EXEQUIEL PERCY 438367 19/03/2019 SAN MIGUEL

PAICO VEGA JENSON EFRAIN 447676 20/03/2019 SAN MIGUEL

PAIVA FIESTAS MANUEL GREGORIO 374423 23/03/2019 SAN MIGUEL

PALACIOS CALDERON DEYSI MARCELINA 681458 18/03/2019 SAN MIGUEL

PALMIERI TELLO YLLYA VANESSA 285595 21/03/2019 SAN MIGUEL

PALOMINO CHAMORRO AUGUSTO MOISES 1006117 18/03/2019 LIMA

PALOMINO FLORES JOSUE ALEXANDER 658723 23/03/2019 SAN MIGUEL

PALOMINO MENDOZA BENJAMIN ROMULO 621412 24/03/2019 SAN MIGUEL

PANDURO MEDER ROJAS TINO R 553058 18/03/2019 LA VICTORIA

PANDURO SANCHEZ ROCIO DEL PILAR 61395 21/03/2019 SAN MIGUEL

PARIACHI OSORIO JESUS MAXIMILIANO 1203088 17/03/2019 LA VICTORIA

PARODI ARIAS SONIA BEATRIZ 584703 23/03/2019 SAN MIGUEL

PARRAGA BLAS FREDY LUIS 413828 18/03/2019 SAN MIGUEL

PAZ BRAVO JAVIER ALEXANDER 642789 17/03/2019 SAN MIGUEL

PEÑA PETER ELGER RUIZ ESSA 24566 20/03/2019 SAN BORJA

PERALTA MALDONADO FREDY 1069143 22/03/2019 LINCE

PEREZ FIERRO WALTER OSCAR 679704 22/03/2019 LINCE

PEREZ LUIS MIGUEL GRADOS R 180286 19/03/2019 LA VICTORIA

PEREZ OLIVOS LUIS FELIPE 52809 17/03/2019 SAN BORJA

PEREZ REYNAGA MATEO ALEJANDRO 1221379 16/03/2019 SAN BORJA

PEVE ELIAS ABEL GUTIERREZ 106712 23/03/2019 LINCE

PITA RONCAL MERLY NOEMI 1055882 23/03/2019 MIRAFLORES

POLO GARCIA ROSELL HERNAN 1065158 17/03/2019 LINCE

POLO MONTESINOS FRANK ROGGER 377333 23/03/2019 SAN MIGUEL

POLO PAREDES HAYDEE CECILIA 1072833 22/03/2019 MIRAFLORES

POMA FELIX PEDRO YSAURO 1183646 19/03/2019 LA VICTORIA

PONCE SALCEDO MARIANA 1108898 17/03/2019 MIRAFLORES

POZZO OLIVA CARLOS ENRIQUE 158321 24/03/2019 LA VICTORIA

QUEVEDO LEDESMA ALEX ANTONIO 1072465 20/03/2019 LIMA

QUEZADA CORNEJO MILAGROS NATALI 1055791 24/03/2019 LA VICTORIA

QUEZADA PRINCIPE JESUS ALBERTO 900583 23/03/2019 SAN MIGUEL

QUICAÑO DE LA CRUZ TEOFILA CONCEPCI 729566 20/03/2019 LINCE

QUINO ALVARADO ZOILA ISABEL 12621 24/03/2019 MIRAFLORES

QUIROZ GINA JESSICA CUADRO 34655 21/03/2019 CALLAO

QUISPE DE LA CRUZ MARCO ANTONIO 44466 20/03/2019 SAN MIGUEL

QUISPE HIDALGO AURELIO 1040130 25/03/2019 SAN BORJA

QUISPE ORE WALTER RAUL 1121584 21/03/2019 MIRAFLORES

QUISPE VELASQUEZ FELIX 469033 23/03/2019 LINCE

QUISPE ZAVALETA LORENZO 826669 17/03/2019 SAN MIGUEL

RAMIREZ LILIANA RUTH BEATR 31778 18/03/2019 MIRAFLORES

RAMIREZ MARTINEZ TEODORA 1106839 16/03/2019 CALLAO

RAMIREZ REYES FERNANDO ROMAN 1023142 23/03/2019 MIRAFLORES

RAMOS NEYRA JOSE ANTONIO 1083282 23/03/2019 CALLAO

RAMOS NORIEGA ERNESTO MIGUEL 17899 16/03/2019 LINCE

RAMOS PIÑA JOSE ALFONSO 1027215 20/03/2019 CALLAO

RAMOS VILLANUEVA JUAN AUGUSTO 42994 22/03/2019 SAN MIGUEL

REATEGUI YAZAKAMA MANUELA 1061170 25/03/2019 SAN BORJA

REBAZA BEJARANO HUMBERTO FRANCISCO 1059748 17/03/2019 SAN BORJA

RENGIFO RIVERA ELIZABETH 725625 21/03/2019 SAN MIGUEL

RENTERIA AYALA OSWALDO 1141201 24/03/2019 SAN MIGUEL

REYES ZELAYA LEONIDES EVANGELINA 59978 18/03/2019 SAN MIGUEL

RIOS UTIA RUBER 1099486 19/03/2019 LA VICTORIA

RIVERA BALTAZAR WILFREDO ALEX 1146986 19/03/2019 CALLAO

RIVERA COLLANTE MANUEL JESUS 1166717 18/03/2019 LA VICTORIA

RIVERA HEREDIA AMANDA JULIA 1207006 19/03/2019 MIRAFLORES

RIVERO GARCIA,FEDERICO EDUARDO 1005882 23/03/2019 MIRAFLORES

RODAS ESPINOZA SILVIA LILIANA 1079907 18/03/2019 SURCO

RODRIGUEZ CABREJOS ZULEMA LUCITANIA 842869 17/03/2019 SAN MIGUEL

RODRIGUEZ JABA ELIANA 1127704 21/03/2019 SAN BORJA

RODRIGUEZ LLOSA SANDRO IVAN 884278 18/03/2019 SAN MIGUEL

RODRIGUEZ ZAFRA MILTHON JOSUE 1100981 24/03/2019 LA VICTORIA

ROGGERO SOLANO SOFIA 335932 24/03/2019 SAN MIGUEL

ROJAS CORDOVA YENNY MARGOT 1041840 25/03/2019 MIRAFLORES

ROMANI AGUIRRE MIGUEL GUSTAVO 754951 25/03/2019 SAN MIGUEL

ROMERO BETTY MARILU RAMOS 212978 18/03/2019 LA VICTORIA

ROMERO BORDA ANTHONY NICASIO 1105026 19/03/2019 SAN BORJA

ROMERO LEGUA MAXIMO GUILLERMO 1069164 21/03/2019 LA VICTORIA

ROMERO THAIS LEONARDO 1201091 24/03/2019 LIMA

ROSADO D'UGARD RICARDO PABLO 43510 26/03/2019 LIMA

ROSAS ROSAS JUAN CARLOS 38261 25/03/2019 LINCE

RUBIO BRUNO DUNCAN ROGGER 200034 22/03/2019 SAN MIGUEL

RUBIO MANRIQUE SANDRO 1199823 22/03/2019 CALLAO

RUIZ POMACANCHARI MADELEINE 446599 17/03/2019 SAN MIGUEL

SAAVEDRA FLORES JONNY ALEJANDRO 684104 22/03/2019 SAN MIGUEL

SAAVEDRA SALDARRIAGA RAMON 1245944 21/03/2019 LIMA

SALAZAR CAJA GODOFREDO CONSTANTIN 1185347 18/03/2019 LA VICTORIA

SALAZAR MARIA EUGENIA SALV 10323 22/03/2019 SAN BORJA

SALAZAR TERRONES NURIA MORAIMA 1124979 16/03/2019 MIRAFLORES

SALDARRIAGA RIVERA FELIX EDUARDO 874957 19/03/2019 SAN MIGUEL

SALVADOR QUICHIZ LEONCIO 346578 18/03/2019 SAN MIGUEL

SAMAN REYES SILVIA SUSANA 649406 20/03/2019 SAN MIGUEL

SAN MIGUEL ESQUERRA JESUS GERMAN 1053204 21/03/2019 SAN BORJA

SANCHEZ AGREDA DE PEREDA NANCY LUZ 1083928 17/03/2019 CALLAO

SANCHEZ ALBAVERA JOSE FERNANDO 1057982 23/03/2019 SAN ISIDRO

SANGAMA MILTON SHUÑA NICH 565501 25/03/2019 LA VICTORIA

SANTAMARIA COTRINA BENJAMIN 1154870 25/03/2019 LA VICTORIA

SANTAMARIA SUYON JULIO 621870 26/03/2019 SAN MIGUEL

SANTIAGO ALVARADO PEDRO MIGUEL 325309 17/03/2019 SAN MIGUEL

SARMIENTO SALINAS WALTER ALFREDO 1054116 19/03/2019 LA VICTORIA

SERPA ENRIQUEZ NANCY ESMERALDA 466129 17/03/2019 SAN ISIDRO

SIERRA GARATE WALDO SANDRO 1221968 17/03/2019 MIRAFLORES

SILVA VARGAS GLORIA EDITA 1135417 18/03/2019 SAN BORJA

SINTI JARAMILLO MAYLA 1110501 24/03/2019 LIMA

SINUIRI MUDARRA JUAN CARLOS 715182 24/03/2019 SAN MIGUEL

SKRINJARIC YVAN AYUNI RISE 35877 19/03/2019 MIRAFLORES

SOTO LUZ VERONICA GONZALES 99206 20/03/2019 SAN ISIDRO

TAPARA SANCHEZ JESUS 98272 24/03/2019 SAN MIGUEL

TARDILLO LOPEZ GLORIA MONICA FELICI 396125 21/03/2019 SAN MIGUEL

TEJADA GUTIERREZ JOSE ENRIQUE 477117 19/03/2019 SAN MIGUEL

TEOFILO OJEDA GUERRERO 480304 22/03/2019 LINCE

TOLENTINO RIOS JORGE ANTONIO 1044810 25/03/2019 SURCO

TORO YAGUAL RUBEN ORLANDO 1072870 25/03/2019 LINCE

TORREJON RETAMOZO ANTHONY 1107937 18/03/2019 CALLAO

TRIGUEROS ESPEJO CECILIA DEL PILAR 761044 22/03/2019 SAN MIGUEL

TURPO ARCE LUCIO 1105471 24/03/2019 LINCE

URIBE DE LAS CASAS MARIA LUISA 1083314 21/03/2019 LA VICTORIA

URPEQUE CASTRO REBECA 514179 17/03/2019 SAN MIGUEL

USHIÑAHUA PAREDES DE GONZALES YOLA 1203468 17/03/2019 LA VICTORIA

VALCARCEL ALMENARA CLAUDIA MARIA 14752 23/03/2019 SAN BORJA

VALERO GOMEZ BARBARA ANNY 681016 20/03/2019 SAN MIGUEL

VALLEJOS DAVILA MIGUEL 781576 20/03/2019 SAN MIGUEL

VALLEJOS URBANO MARCO ANTONIO 651966 20/03/2019 SAN MIGUEL

VARGAS LUQUE ARQUIMIDES LEON 242500 26/03/2019 LINCE

VASQUEZ CALLUPE YNES MERCEDES 1151841 24/03/2019 LA VICTORIA

VASQUEZ GILBERTO ABELARDO 137608 17/03/2019 LA VICTORIA

VASQUEZ HOYOS LUIS ALONSO 1123688 17/03/2019 LINCE

VEGA LOPEZ HECTOR GUILLERMO 1107393 22/03/2019 SAN BORJA

VEGAS GARRIDO CARLOS 1051183 22/03/2019 CALLAO

VEJARANO AMASIFUEN ERICK 165379 16/03/2019 SAN MIGUEL

VELASQUEZ DIESTRA JIMY RAUL 1067592 23/03/2019 LINCE

VELASQUEZ FIGUEROA MARIA TERESA 1008894 21/03/2019 MIRAFLORES

VELASQUEZ ROJAS MARIO FLORENTINO 1118187 18/03/2019 CALLAO

VELAZCO LOPEZ MARIA ISABEL 1010889 16/03/2019 SAN ISIDRO

VERGARA LOVERA KELLY YOVANA 1079329 16/03/2019 LA VICTORIA

VICTORIA ALVAREZ CARLOS ENRIQUE 1003073 22/03/2019 SAN BORJA

VIGIL LUZ ROXANA GUERRERO 136195 20/03/2019 SAN ISIDRO

VILCAPUMA FLORES LIZ 410578 18/03/2019 SAN MIGUEL

VILLA LUQUE ROSA MARIA 9941 25/03/2019 SAN ISIDRO

VILLACORTA MANSILLA ZUELA ERIKA 1098633 22/03/2019 MIRAFLORES

VILLAGOMEZ DAVALOS JOSE ANTONIO 1047078 17/03/2019 SURCO

VILLALBA IPARRAGUIRRE LUIS ALBERTO 1041662 23/03/2019 SURCO

VILLALOBOS PERCY GUTIERREZ 44811 25/03/2019 LA VICTORIA

VILLANUEVA CERNA JAIME ADRIAN 1082623 22/03/2019 LIMA

VILLANUEVA PEDRAZA SIBEL ORIETTA 1138166 19/03/2019 MIRAFLORES

WILLIAM BELL TAYLOR VERGARA 1098817 18/03/2019 MIRAFLORES

YALAN GUERRERO JAVIER ALEJANDRO 146404 21/03/2019 SAN MIGUEL

YARLEQUE DIAZ MILAGROS 1081555 20/03/2019 MIRAFLORES

YAURI VARGAS PEDRO 851027 19/03/2019 SAN MIGUEL

YUPANQUI COLUMBUS ROXANA KATHERINE 778281 25/03/2019 SAN MIGUEL

ZAPANA QUISPE SATURNINO 1295837 18/03/2019 SAN MIGUEL

ZAPATA CASTILLO MARTIN EDUARDO 1253814 21/03/2019 MIRAFLORES

ZAPATA DEGREGORI NANCY CECILIA 1069855 20/03/2019 SAN BORJA

ZAPATA ORTIZ DIONICIO TEODORO 1036314 21/03/2019 LIMA

ZAPATA SARZO LUIS WALTER 1124703 22/03/2019 LA VICTORIA

ZEGARRA ROCHA JOSE 5444 22/03/2019 SAN MIGUEL

ZELADA HUARACA DE YHA NORMA BEATRIZ 1150899 16/03/2019 LINCE

ZEVALLOS GUERRERO JEFF SANDRO 1162835 20/03/2019 LIMA

ZEVALLOS LORENZO ANDERSON RAFAEL 205605 21/03/2019 SAN MIGUEL

ZUÑIGA ACUÑA NESTOR 893528 18/03/2019 SAN MIGUEL

 Porcentajes de
Interes y Mora
Total_Soles =Soles + Dólares x Tcambio
Monto Tasa %Mora

0 13.50% 0.15%
Interés: =Monto x Tasa
1000 11.40% 0.13%
5000 9.90% 0.11%
10000 7.80% 0.09%
Mora: =Monto(1+i)t-Monto

50000 6.30% 0.07%

Donde: Monto = Total en Soles

i = %Mora

t = días de atraso

^ Alt+94

%Mora es diario

DO DE CUENTAS VENCIDAS
MONTO
Agencia Soles Dólares TotalSoles Interés Mora Pago

13 3,240 6,293 20,646 1,610 72 12,712

25 5,244 9,487 31,760 2,477 55 14,731

17 1,403 1,383 5,268 522 12 2,786

40 3,575 144 3,967 452 25 464

38 8,794 4,351 21,412 1,670 19 13,145

21 2,167 6,558 20,306 1,584 70 8,725

40 168 4,430 12,399 967 65 4,598

21 8,572 3,918 19,233 1,500 83 12,490

21 8,869 7,384 29,544 2,304 205 16,253

40 8,518 4,323 20,566 1,604 54 12,841

38 7,386 2,614 15,032 1,172 131 5,000

17 1,432 3,928 12,297 959 43 8,697

39 9,327 4,232 21,663 1,690 132 13,559

19 9,718 309 10,583 825 74 950

38 9,057 3,883 20,318 1,585 18 6,470

38 7,115 1,688 11,841 924 82 4,401

25 6,790 5,749 23,548 1,837 143 12,539

12 8,477 4,277 20,397 1,591 53 12,754

28 1,989 4,714 15,730 1,227 96 6,703

38 908 8,533 26,456 2,064 207 9,441

40 7,300 7,239 26,997 2,106 117 14,539

21 6,882 9,297 32,793 2,558 85 16,179

38 6,129 8,309 30,433 2,374 265 14,438

28 6,184 4,691 19,319 1,507 134 10,875

25 2,730 1,802 8,125 804 81 4,532

21 3,324 2,678 10,822 844 75 6,002

33 375 8,890 26,378 2,058 230 9,265

9 205 5,544 15,700 1,225 27 5,749

18 8,702 6,454 28,025 2,186 219 15,156

10 6,746 9,898 34,460 2,688 240 16,644

39 9,847 6,621 28,128 2,194 147 16,468

10 9,509 808 11,708 913 51 1,289

37 3,568 2,955 11,827 923 21 6,523

38 3,062 8,367 27,326 2,131 24 11,429

12 2,992 593 4,649 530 12 1,792

9 1,711 3,779 12,292 959 85 5,490

9 8,152 4,811 21,435 1,672 112 12,963

38 3,505 2,050 9,481 939 73 5,555

9 9,374 4,382 22,191 1,731 193 13,756

18 9,618 2,706 17,720 1,382 139 6,162

14 4,076 311 4,983 568 44 548

28 5,168 3,951 16,211 1,264 28 9,119

33 4,841 8,127 28,409 2,216 25 12,968

33 2,903 2,701 10,360 808 54 5,604

40 4,415 5,480 19,545 1,525 102 9,895

18 6,775 564 8,419 833 65 917

10 7,401 9,264 35,137 2,741 275 16,665

25 1,854 4,906 16,543 1,290 129 6,760

38 3,031 1,189 6,360 630 56 4,220

40 6,060 4,610 19,498 1,521 119 10,670

33 5,469 7,900 28,379 2,214 25 13,369

33 5,553 8,843 32,029 2,498 251 14,396

28 742 6,028 17,385 1,356 91 6,770

19 5,128 7,360 25,486 1,988 88 12,488

33 5,130 5,380 20,813 1,623 127 10,510

28 3,277 6,233 21,509 1,678 187 9,510

33 2,122 8,099 24,483 1,910 128 10,221

28 803 2,824 8,614 853 38 3,627

40 8,383 3,938 19,803 1,545 17 12,321

33 6,465 6,624 24,979 1,948 43 13,089

18 4,762 5,330 20,560 1,604 0 10,092

33 4,588 2,387 11,190 873 39 6,975

19 5,280 2,623 12,887 1,005 11 7,903

14 6,738 7,729 28,116 2,193 98 14,467

9 8,980 3,437 18,559 1,448 48 6,208

33 6,768 7,135 26,468 2,064 138 13,903

40 5,601 638 7,337 726 40 779

13 9,881 8,938 34,907 2,723 243 18,819

33 8,145 7,017 27,701 2,161 72 15,162

9 5,058 5,234 20,367 1,589 177 10,292

21 2,711 8,726 27,144 2,117 189 11,437

25 4,626 7,555 25,780 2,011 179 12,181

40 6,862 4,334 18,655 1,455 81 11,196

13 9,326 3,897 20,187 1,575 53 6,611

28 8,399 5,418 23,542 1,836 41 13,817

25 2,011 5,054 16,794 1,310 146 7,065

25 5,829 498 7,223 715 64 790

25 7,362 9,192 34,883 2,721 273 16,554

40 5,353 6,215 22,264 1,737 97 11,568

18 7,162 6,613 25,592 1,996 67 13,775

40 1,807 8,486 24,897 1,942 108 10,293

39 7,743 8,524 32,676 2,549 284 16,267

40 7,838 8,557 31,686 2,472 82 16,395

37 8,872 3,639 19,061 1,487 133 6,255

18 478 6,005 17,292 1,349 120 6,483

17 7,756 2,385 14,246 1,111 62 5,070

9 3,852 2,075 9,591 950 42 5,927

38 4,369 3,595 14,848 1,158 90 7,964

18 2,456 3,922 14,081 1,098 0 6,378

14 5,574 821 7,808 773 43 799

19 4,670 2,306 11,392 889 69 6,976

33 1,962 9,316 27,926 2,178 73 11,278

40 8,557 7,282 28,852 2,250 75 15,839

33 9,857 8,127 32,613 2,544 227 17,984

37 969 5,079 15,165 1,183 26 6,048

19 8,786 8,786 33,273 2,595 87 17,572

38 2,596 7,232 24,249 1,891 190 9,828

38 3,310 1,087 6,268 621 35 2,198

18 1,903 9,058 26,550 2,071 115 10,961

40 4,524 3,810 15,630 1,219 95 8,334

25 1,660 4,564 14,416 1,124 25 6,224

9 5,192 8,830 29,916 2,333 208 14,022

21 6,126 9,679 34,340 2,679 209 15,805

39 8,929 6,627 27,485 2,144 191 15,556

12 3,540 1,380 7,386 731 24 2,460

19 93 2,061 5,837 578 19 2,154

38 3,372 2,942 11,904 928 10 6,314

12 3,231 3,952 13,984 1,091 61 7,183

25 741 8,791 26,455 2,063 230 9,532

19 5,086 8,641 28,944 2,258 151 13,727

40 5,257 9,429 31,658 2,469 220 14,686

40 3,910 5,460 19,012 1,483 66 9,370

40 5,205 915 7,767 769 69 3,060

9 1,063 6,703 19,603 1,529 68 7,766

18 7,270 3,805 18,362 1,432 112 11,075

38 6,461 6,135 23,154 1,806 101 12,596

14 7,707 354 8,696 861 19 1,007

40 8,144 4,453 20,612 1,608 143 12,597

14 5,062 8,622 30,618 2,388 0 13,684

12 9,242 9,863 37,845 2,952 33 19,105

9 8,825 5,899 25,932 2,023 22 14,724

38 2,287 1,527 6,442 638 36 3,814

13 7,824 7,028 27,502 2,145 191 14,852

28 204 9,586 26,671 2,080 139 9,790

38 636 9,614 29,132 2,272 0 10,250

19 9,075 8,588 33,078 2,580 57 17,663

10 4,335 9,216 31,292 2,441 272 13,551

18 5,453 6,068 23,439 1,828 0 11,521

38 9,399 4,195 21,124 1,648 37 6,797

28 8,510 9,228 35,410 2,762 215 17,738

17 4,493 4,238 16,304 1,272 42 8,731

18 9,349 9,738 36,615 2,856 255 19,087

38 2,464 9,467 30,808 2,403 241 11,931

25 5,143 7,107 25,931 2,023 226 12,250

38 7,132 8,866 31,256 2,438 136 15,998

39 4,138 9,741 31,364 2,446 54 13,879

40 7,409 8,503 32,068 2,501 28 15,912

19 7,420 2,349 13,997 1,092 97 4,884

14 8,431 3,464 18,802 1,467 147 5,947

40 3,162 1,304 7,027 696 0 4,466

40 6,043 4,466 18,374 1,433 96 10,509

25 8,684 7,439 29,476 2,299 51 16,123

9 2,979 9,086 28,065 2,189 146 12,065

33 968 2,497 8,369 829 0 3,465

19 2,855 8,564 27,905 2,177 243 11,419

19 8,735 4,348 20,909 1,631 145 13,083

37 7,591 6,826 27,489 2,144 167 14,417

28 3,212 5,555 18,327 1,430 80 8,767

13 9,098 7,920 32,185 2,510 196 17,018

12 6,029 8,615 31,228 2,436 272 14,644

25 2,571 1,943 8,206 812 9 4,514

25 2,664 6,309 19,831 1,547 86 8,973

38 13 1,468 4,270 487 5 1,481

33 1,848 5,173 16,927 1,320 103 7,021

12 7,233 427 8,478 839 65 957

14 5,449 5,650 22,365 1,744 175 11,099

40 86 8,071 23,613 1,842 144 8,157

25 6,441 1,542 11,058 863 87 3,991

14 4,229 706 6,178 612 41 1,850

33 8,212 4,854 21,803 1,701 152 13,066

28 1,160 6,227 18,564 1,448 32 7,387

9 7,250 3,906 18,054 1,408 63 11,156

39 7,600 8,707 31,640 2,468 165 16,307

28 5,906 7,066 25,599 1,997 67 12,972

28 2,051 9,540 28,439 2,218 99 11,591

38 1,512 4,765 15,402 1,201 94 6,277

38 4,599 6,007 22,169 1,729 193 10,606

17 3,168 4,128 15,242 1,189 133 7,296

40 7,776 8,106 30,157 2,352 157 15,882

40 6,572 5,358 21,548 1,681 37 11,930

12 1,209 2,699 8,674 859 38 3,908

18 9,337 6,241 26,781 2,089 46 15,578

33 5,125 3,203 14,619 1,140 0 8,328

28 4,341 8,208 28,916 2,255 226 12,549

19 961 8,743 24,751 1,931 107 9,704

37 1,333 1,447 5,366 531 18 2,780

28 1,313 3,423 11,240 877 10 4,736

37 2,534 9,790 29,897 2,332 52 12,324

39 9,479 9,497 37,258 2,906 324 18,976

14 4,518 8,520 28,042 2,187 146 13,038

19 3,148 7,073 22,677 1,769 118 10,221

33 2,042 8,017 26,045 2,032 204 10,059

9 4,018 9,753 32,546 2,539 283 13,771

40 7,505 1,268 11,006 858 57 4,386

33 590 9,221 26,049 2,032 136 9,811

17 6,874 8,102 30,491 2,378 185 14,976

19 2,611 9,997 31,752 2,477 193 12,608

9 3,594 9,188 28,595 2,230 124 12,782

40 9,392 6,517 28,904 2,255 226 15,909

17 7,431 6,344 24,947 1,946 130 13,775

33 2,748 6,975 23,150 1,806 201 9,723

21 656 378 1,709 195 7 1,034

38 1,328 2,815 9,114 902 40 4,143

12 9,565 3,484 19,303 1,506 33 6,524

38 3,991 9,314 29,949 2,336 78 13,305

40 4,570 5,580 20,892 1,630 182 10,150

19 4,188 719 6,291 623 70 613

14 8,988 7,256 30,712 2,396 240 16,244

38 1,755 5,021 16,637 1,298 0 6,776

19 558 6,922 19,704 1,537 68 7,480

40 835 5,410 16,870 1,316 0 6,245

21 6,103 8,898 32,477 2,533 0 15,001

28 949 5,432 15,729 1,227 68 6,381

40 490 5,179 14,991 1,169 104 5,669

10 1,585 5,215 16,119 1,257 42 6,800

21 2,348 27 2,423 276 6 85

12 6,675 4,791 19,903 1,552 104 11,466

14 8,329 9,910 38,000 2,964 297 18,239

33 6,617 1,662 11,214 875 39 555

10 7,058 4,407 19,248 1,501 67 11,465

28 6,062 3,433 16,069 1,253 98 9,495

12 2,225 2,348 8,614 853 47 4,573

25 3,611 5,821 19,683 1,535 103 9,432

28 3,255 874 5,691 563 19 2,064

21 8,064 3,056 16,517 1,288 57 5,560

40 9,240 5,931 25,615 1,998 133 15,171

40 1,405 5,757 18,641 1,454 146 7,162

40 5,548 4,418 18,775 1,464 147 9,966

40 456 3,972 11,526 899 30 4,428

38 8,519 9,812 35,993 2,807 250 18,331

28 3,724 7,208 24,735 1,929 150 10,932

17 8,998 6,110 26,027 2,030 68 15,108

38 6,405 9,818 33,768 2,634 88 16,223

38 1,363 6,830 21,170 1,651 18 8,193

21 5,845 767 7,983 790 26 826

38 4,243 133 4,605 525 29 422

40 1,315 5,930 17,717 1,382 62 7,245

37 3,320 887 5,914 586 65 2,103

9 7,756 4,595 20,599 1,607 36 12,351

40 6,014 2,956 14,190 1,107 49 8,970

18 6,361 2,203 12,454 971 43 4,282

19 4,094 4,778 17,095 1,333 74 8,872

19 6,522 7,530 27,606 2,153 192 14,052

10 6,199 2,926 14,959 1,167 117 9,125

14 882 8,894 27,511 2,146 215 9,776

14 2,889 7,394 25,027 1,952 196 10,283

10 2,228 3,867 12,750 995 55 6,095

37 2,284 1,986 8,073 799 62 4,270

38 8,377 8,148 31,151 2,430 54 16,525

38 3,114 6,206 20,460 1,596 35 9,320

39 9,746 4,287 21,750 1,696 151 7,016

14 662 8,441 25,141 1,961 22 9,103

40 7,472 9,829 34,610 2,700 180 17,301

28 7,075 285 7,902 782 9 920

28 2,369 2,781 10,156 792 71 5,150

19 2,357 6,388 20,160 1,573 52 8,745

33 1,054 7,303 21,218 1,655 111 8,357

10 3,687 9,958 31,231 2,436 108 13,645

38 3,674 4,901 17,010 1,327 74 8,575

39 7,147 8,802 32,893 2,566 286 15,949

40 94 9,414 26,453 2,063 184 9,508

38 2,589 4,938 16,025 1,250 70 7,527

40 632 9,268 26,582 2,073 185 9,900

17 4,806 2,387 11,728 915 10 7,193

19 9,874 8,309 32,815 2,560 171 18,183

12 81 8,510 24,760 1,931 21 8,591

37 6,741 2,672 14,557 1,135 127 4,706

38 1,049 8,729 26,494 2,067 161 9,778

17 5,655 2,684 13,157 1,026 23 8,339

14 7,742 6,832 26,872 2,096 187 14,574

19 3,391 7,270 24,474 1,909 21 10,661

33 2,468 4,941 15,912 1,241 69 7,409

21 1,166 9,115 26,688 2,082 186 10,281

38 4,510 8,715 28,224 2,201 123 13,225

18 2,704 2,411 9,423 933 31 5,115

33 3,014 2,221 9,204 911 30 5,235

19 5,941 383 7,008 694 23 790

9 8,213 7,495 29,102 2,270 76 15,708

18 6,910 9,752 33,445 2,609 145 16,662

25 7,426 2,186 13,820 1,078 120 4,806

19 2,440 7,474 23,076 1,800 120 9,914

18 5,446 5,472 21,665 1,690 0 10,918

40 7,846 8,573 31,850 2,484 222 16,419

9 9,857 2,957 18,098 1,412 47 6,407

12 6,603 6,389 23,987 1,871 104 12,992

28 1,231 9,151 28,629 2,233 224 10,382

40 6,391 5,232 21,642 1,688 132 11,623

28 156 8,913 25,112 1,959 175 9,069

9 4,496 8,993 29,676 2,315 206 13,489

19 2,970 4,212 14,743 1,150 26 7,182

17 4,231 6,048 20,960 1,635 73 10,279

38 1,565 8,526 25,105 1,958 131 10,091

38 705 5,696 16,580 1,293 43 6,401

28 7,561 3,420 16,867 1,316 73 5,490

12 7,700 8,921 32,634 2,545 57 16,621

28 4,575 8,150 28,210 2,200 24 12,725

19 7,143 2,713 14,739 1,150 103 4,928

40 1,769 8,318 24,402 1,903 106 10,087

40 7,589 2,877 15,975 1,246 97 5,233

33 4,837 9,467 30,975 2,416 161 14,304

40 9,706 6,535 27,919 2,178 73 16,241

33 4,464 9,688 31,590 2,464 220 14,152

40 5,949 1,306 9,503 941 52 3,627

19 2,401 9,727 29,637 2,312 206 12,128

40 2,773 2,398 9,456 936 31 5,171

18 3,818 8,596 27,844 2,172 48 12,414

38 6,512 8,631 30,679 2,393 213 15,143

18 1,791 545 3,274 373 21 1,168

38 2,424 9,215 30,014 2,341 235 11,639

33 9,547 2,371 16,155 1,260 42 5,959

18 1,312 2,030 6,996 693 62 3,342

40 7,531 3,856 19,076 1,488 149 11,387

9 6,808 2,210 12,910 1,007 67 4,509

17 2,856 1,497 6,997 693 31 4,353

14 2,931 8,576 26,652 2,079 93 11,507

38 6,093 9,807 34,680 2,705 211 15,900

9 993 7,122 22,316 1,741 175 8,115

9 9,175 5,999 26,722 2,084 232 15,174

17 9,943 965 12,632 985 33 1,363

28 1,961 7,414 22,624 1,765 59 9,375

37 1,381 7,296 23,225 1,812 182 8,677

40 9,948 4,642 22,885 1,785 60 14,590

28 1,422 2,192 7,485 741 33 3,614

25 8,877 4,197 21,111 1,647 128 13,074

28 5,895 779 8,227 815 82 834

38 3,694 9,202 29,414 2,294 51 12,896

19 9,948 3,840 20,550 1,603 107 6,894

25 9,688 747 11,776 919 20 1,304

40 5,673 7,882 27,640 2,156 72 13,555

14 4,377 4,538 16,906 1,319 88 8,915

28 8,723 1,194 12,060 941 21 1,239

39 4,953 6,722 23,244 1,813 101 11,675

33 8,059 7,694 29,302 2,286 153 15,753

9 1,373 9,825 29,866 2,330 26 11,198

28 2,717 9,479 28,509 2,224 124 12,196

14 6,537 8,556 30,383 2,370 79 15,093

18 3,152 5,671 20,131 1,570 158 8,823

28 1,255 3,736 11,716 914 81 4,991

39 3,585 690 5,603 555 62 2,137

28 7,463 2,774 15,194 1,185 40 5,118

39 7,750 4,444 20,135 1,571 52 12,194

37 2,094 5,170 17,216 1,343 150 7,264

39 5,873 6,731 24,457 1,908 127 12,604

40 3,445 9,728 30,353 2,368 105 13,173

9 976 9,168 27,563 2,150 24 10,144

9 4,283 448 5,624 557 56 591

40 1,171 3,556 10,847 846 47 4,727

18 7,162 9,456 33,592 2,620 58 16,618

18 1,733 9,188 27,459 2,142 191 10,921

38 6,973 6,153 24,909 1,943 152 13,126

39 8,966 8,251 33,018 2,575 201 17,217

38 9,166 3,240 18,238 1,423 127 6,203

28 5,169 2,879 13,561 1,058 82 8,048

28 2,700 734 4,746 541 18 1,717

12 5,679 1,233 9,131 904 81 3,456

33 3,782 2,854 12,327 961 96 6,636

9 276 8,241 22,700 1,771 99 8,517

33 1,665 4,289 13,674 1,067 95 5,954

25 1,518 7,825 23,389 1,824 41 9,343

40 1,194 9,718 28,356 2,212 49 10,912

28 5,564 8,798 31,078 2,424 27 14,362

40 3,415 4,283 15,836 1,235 14 7,698

38 8,415 7,178 28,513 2,224 198 15,593

9 5,131 2,458 12,296 959 75 7,589

25 6,387 7,751 27,477 2,143 119 14,138

19 7,882 5,669 23,727 1,851 41 13,551

19 7,160 1,833 12,593 982 0 4,496

14 876 3,201 10,159 792 9 4,077

33 8,458 2,259 14,706 1,147 51 5,358

39 5,594 3,774 16,033 1,251 56 9,368

40 6,025 8,224 30,648 2,391 240 14,249

40 1,817 2,023 7,413 734 33 3,840

19 5,932 5,573 21,096 1,645 92 11,505

25 1,780 8,363 25,196 1,965 175 10,143

9 4,511 8,599 28,296 2,207 98 13,110

28 5,694 2,267 12,325 961 107 3,980

18 5,434 9,013 31,707 2,473 193 14,447

40 4,215 8,823 28,919 2,256 201 13,038

18 7,468 7,421 27,957 2,181 146 14,889

9 7,352 5,874 23,335 1,820 101 13,226

39 7,051 3,215 16,677 1,301 131 10,266

10 1,063 8,526 24,825 1,936 65 9,589

38 7,279 1,473 11,551 901 10 4,376

38 7,999 9,816 36,465 2,844 32 17,815

33 4,469 627 6,327 626 0 637

18 677 8,714 26,767 2,088 210 9,391

25 7,585 6,294 25,932 2,023 158 13,879

10 5,100 7,024 26,130 2,038 205 12,124

28 7,931 7,770 31,194 2,433 244 15,701

9 4,168 2,555 11,322 883 79 6,723

19 9,060 2,559 16,212 1,265 28 5,809

18 9,888 3,845 20,635 1,610 36 6,866

28 3,629 6,115 21,454 1,673 130 9,744

10 792 5,437 15,804 1,233 82 6,229

40 6,478 2,533 13,558 1,058 24 4,505

40 2,173 5,912 18,260 1,424 79 8,085

40 5,597 3,179 14,864 1,159 90 8,776

14 3,421 160 3,864 440 20 447

12 3,566 3,768 14,493 1,130 13 7,334

37 380 7,523 22,197 1,731 19 7,903

39 9,987 63 10,163 793 71 198

33 4,338 971 7,024 695 31 2,654

37 8,442 9,618 35,324 2,755 61 18,060

38 4,701 8,959 29,078 2,268 126 13,660

33 1,567 7,709 24,648 1,923 193 9,276

38 8,741 9,244 36,418 2,841 285 17,985

9 4,566 4,298 16,545 1,290 43 8,864

40 2,404 1,025 5,234 518 35 3,429

18 2,475 6,192 19,571 1,527 102 8,667

21 1,177 9,732 28,047 2,188 146 10,909

14 7,011 8,654 32,661 2,548 0 15,665

38 2,829 4,434 15,222 1,187 26 7,263

38 7,447 6,962 28,291 2,207 221 14,409

13 1,945 9,411 30,122 2,349 236 11,356

9 3,170 4,393 15,321 1,195 53 7,563

39 6,567 5,877 22,823 1,780 79 12,444

40 662 2,603 8,276 819 91 3,265

37 838 6,582 19,182 1,496 50 7,420

28 7,435 829 9,691 959 53 1,033

39 1,201 2,738 8,867 878 78 3,939

10 2,046 4,534 15,308 1,194 133 6,580

25 9,272 4,990 23,868 1,862 208 14,262

9 1,276 3,188 10,094 787 35 4,464

10 7,055 3,484 16,674 1,301 87 5,269

33 370 7,647 21,782 1,699 151 8,017

10 1,394 8,417 25,803 2,013 22 9,811

28 2,251 7,511 23,026 1,796 80 9,762

12 9,915 6,289 28,744 2,242 225 16,204

12 5,882 9,147 31,375 2,447 82 15,029

25 5,606 4,464 18,552 1,447 16 10,070

19 8,393 7,395 28,848 2,250 100 15,788

28 6,299 9,040 32,651 2,547 199 15,339

28 8,458 7,308 28,920 2,256 201 15,766

40 4,516 1,441 8,437 835 47 2,978

28 8,855 2,325 15,274 1,191 80 5,590

40 1,778 4,661 15,365 1,198 93 6,439

40 4,480 4,847 18,536 1,446 16 9,327

40 207 984 2,962 338 30 1,191

28 4,406 9,186 29,401 2,293 128 13,592

9 4,394 397 5,490 544 36 598

19 8,759 4,009 19,667 1,534 85 12,768

38 3,430 7,937 25,384 1,980 88 11,367

40 2,906 4,213 14,559 1,136 51 7,119

17 181 4,817 14,271 1,113 124 4,998

19 6,942 4,184 18,494 1,443 96 11,126

21 9,287 4,544 21,651 1,689 94 13,831

33 8,676 2,801 16,519 1,288 115 5,738

 CUADRO RESUMEN POR DIAS DE ATRASO
ares x Tcambio
Días de Atraso # Clientes

0 15
x Tasa
1 33
2 40
)t-Monto 3 46
4 40
5 49
6 43
7 40
8 57
9 42
10 32
Total 0
dias de
Saldo dolares en soles Crear la siguiente Tabla dinánica:
atraso

9,617 4 17406.438
19,562 2 26516.165
3,016 2 3865.485
3,980 5 391.824
9,956 1 12617.9
13,236 4 18139.428
8,833 6 12231.23
8,327 5 10660.878
15,801 8 20675.2
9,383 3 12048.201
11,335 10 7645.95
 4,602 4 10864.848
9,926 7 12336.28
10,532 8 865.2
15,450 1 11260.7
8,446 8 4726.4
12,989 7 16758.335
9,287 3 11919.999 Preguntas:
10,350 7 13741.31
19,285 9 25547.802 a) Suma del Monto en Soles del distrito de Surco, con más de 3 di
14,681 5 19697.319
19,257 3 25910.739 Rpta:

18,633 10 24303.825
10,085 8 13134.8 b) Suma del Monto Total en el distrito de La Victoria, superiores a
4,478 9 5395.188
5,740 8 7498.4 Rpta:

19,400 10 26003.25
11,203 2 15495.48 c) Cuantos clientes cancelaron mas de la mitad de su deuda.

15,275 9 19323.276
20,744 8 27714.4 Rpta:

14,000 6 18280.581
11,383 5 2198.568 d) Cuantos clientes tienen su deuda en soles mayor que la de dola

6,247 2 8259.225
18,052 1 24264.3 Rpta:
 3,399 2 1657.435
7,846 8 10581.2
10,256 6 13283.171
4,938 7 5975.75
10,359 10 12817.35
13,079 9 8101.764
5,047 7 906.565
8,385 2 11043.045
17,682 1 23568.3
5,619 6 7457.461
11,277 6 15130.28
8,401 7 1644.06
21,488 9 27736.416
11,202 9 14688.564
2,826 8 3329.2
10,468 7 13438.15
17,248 1 22910
20,382 9 26475.942
12,062 6 16643.308
15,074 4 20357.76
12,053 7 15682.7
13,863 10 18231.525
16,300 6 22361.339
5,878 4 7811.184
 9,044 1 11420.2
13,882 2 18514.08
12,072 0 15798.12
5,127 4 6602.442
6,000 1 7606.7
15,940 4 21378.414
13,847 3 9578.919
14,767 6 19699.735
7,325 5 1735.998
19,054 8 25026.4
14,772 3 19556.379
11,841 10 15309.45
18,013 8 24432.8
15,789 8 21154
8,995 5 11792.814
15,203 3 10860.939
11,602 2 15143.31
11,185 10 14782.95
7,212 8 1394.4
21,323 9 27520.848
12,529 5 16911.015
13,880 3 18430.431
16,654 5 23090.406
19,242 10 24932.7
17,845 3 23848.359
14,426 8 10189.2
12,278 8 16814
10,349 5 6489.585
4,656 4 5739.45
8,133 7 10479.425
8,801 0 11624.808
7,825 5 2233.941
5,374 7 6721.99
18,899 3 25963.692
15,338 3 20294.934
17,399 8 22755.6
10,326 2 14195.805
18,382 3 24486.582
16,502 9 21652.608
4,725 5 2957.727
17,775 5 24646.818
8,610 7 11106.15
9,342 2 12756.38
18,435 8 24724
21,423 7 28214.285
14,264 8 18555.6
5,682 3 3846.06
4,280 3 5744.007
 6,529 1 8531.8
7,953 5 10753.392
19,216 10 25713.675
17,625 6 23857.801
19,662 8 26401.2
11,191 4 15102.36
5,545 8 2562
13,435 4 18540.498
8,830 7 11091.575
12,465 5 16693.335
8,570 2 989.43
9,767 8 12468.4
19,322 0 25555.608
21,724 1 28602.7
13,253 1 17107.1
3,301 5 4154.967
14,987 8 19678.4
19,100 6 26466.946
21,154 0 28495.896
18,053 2 24003.46
20,454 10 26956.8
13,746 0 17985.552
16,011 2 11725.025
20,649 7 26899.62
 8,887 3 11811.306
20,639 8 27266.4
21,521 9 28344.198
15,929 10 20787.975
17,832 5 24124.386
19,986 2 27226.095
18,685 1 24658.7
10,302 8 6577.2
14,469 9 10371.216
3,257 0 3865.056
9,394 6 12330.626
15,703 2 20792.005
18,336 6 25086.446
5,733 0 7401.108
18,905 10 25049.7
9,603 8 12174.4
15,383 7 19897.79
11,069 5 15115.155
17,873 7 23086.8
19,291 10 25198.875
4,513 1 5634.7
12,491 5 17166.789
3,281 1 4257.2
11,330 7 15079.295
 8,425 7 1244.705
13,186 9 16916.1
17,441 7 23526.965
8,016 9 4616.748
4,981 6 1949.266
10,589 8 13591.2
12,658 2 17404.465
8,369 4 10803.996
17,966 6 24040.027
14,690 3 19692.942
19,165 4 26387.64
10,420 7 13889.975
13,486 10 17570.475
9,268 10 12074.4
16,784 6 22380.666
11,336 2 14975.61
5,663 4 7465.434
13,338 2 17443.595
7,431 0 9493.692
18,849 9 24574.752
17,085 5 23789.703
3,135 3 4032.789
7,390 1 9926.7
19,957 2 27363.05
21,512 10 27778.725
17,337 6 23523.72
14,342 6 19528.553
18,221 9 24002.898
21,596 10 28527.525
7,536 6 3500.948
18,406 6 25459.181
18,079 7 23617.33
21,814 7 29141.255
18,167 5 25000.548
15,476 9 19511.898
13,248 6 17515.784
15,434 10 20401.875
877 3 1053.486
5,914 4 7786.29
14,318 2 9737.78
19,058 3 25958.118
12,553 10 16321.5
6,370 10 2103.075
17,104 9 21724.464
11,159 0 14882.244
13,830 4 19146.252
11,941 0 16035.24
20,009 0 26373.672
10,644 5 14780.472
10,596 8 14501.2
10,618 3 14534.205
2,621 2 75.465
10,093 6 13227.951
23,022 9 29670.54
11,573 4 4597.092
9,351 4 12189.762
7,925 7 10007.195
4,941 5 6388.908
11,889 6 16071.781
4,209 3 2435.838
12,303 4 8452.896
12,576 6 16375.491
13,079 9 17236.458
10,421 9 13227.492
8,027 3 11069.964
20,719 8 27473.6
15,883 7 21011.32
13,016 3 17028.57
20,267 3 27362.766
14,647 1 19807
7,973 3 2137.629
4,737 5 361.893
11,916 4 16402.38
4,462 10 2594.475
9,890 2 12843.025
6,376 4 8176.296
9,187 4 6093.498
9,631 5 13000.938
15,899 8 21084
7,118 9 8760.444
20,096 9 26628.636
16,892 9 22137.636
7,705 5 10522.107
4,665 7 5789.19
17,109 2 22773.66
12,771 2 17345.77
16,581 8 12003.6
18,021 1 24478.9
20,189 6 27137.869
7,772 1 826.5
5,869 8 7786.8
13,040 3 17803.356
14,626 6 20163.583
20,130 4 27543.828
9,835 5 13335.621
19,796 10 25745.85
19,193 8 26359.2
9,818 5 13436.298
18,941 8 25950.4
5,460 1 6922.3
17,363 6 22941.149
18,122 1 24679
11,113 10 7815.6
18,944 7 25445.035
5,867 2 7501.78
14,580 8 19129.6
15,743 1 21083
9,814 5 13444.461
18,674 8 25522
17,322 5 23713.515
5,273 3 6719.457
4,911 3 6189.927
6,935 3 1067.421
15,739 3 20888.565
19,537 5 26535.192
10,212 10 6394.05
15,082 6 20635.714
12,437 0 16219.008
18,137 8 24004.4
13,150 3 8241.159
12,971 5 17384.469
20,704 9 27398.094
11,839 7 15251.28
18,177 8 24956.4
18,709 8 25180.4
8,736 2 11772.54
12,388 4 16728.768
17,103 6 23540.286
11,515 3 15874.752
12,766 5 9305.82
18,615 2 24934.195
17,710 1 23635
11,064 8 7596.4
16,325 5 22633.278
12,086 7 8386.455
19,249 6 26138.387
13,928 3 18213.045
20,122 8 27126.4
6,869 5 3553.626
20,026 8 27235.6
5,253 3 6683.226
17,650 2 24025.82
18,142 8 24166.8
2,500 5 1482.945
20,951 9 27589.71
11,498 3 6607.977
4,408 8 5684
9,326 9 11544.864
9,475 6 6101.81
3,367 4 4140.702
17,317 4 23721.216
21,696 7 28587.405
16,117 9 21323.268
13,865 10 17547.075
12,288 3 2689.455
15,072 3 20662.818
16,542 9 21844.224
10,140 3 12937.254
4,645 4 6063.072
9,812 7 12234.255
8,290 9 2332.326
18,863 2 25719.59
15,366 6 10602.24
11,411 2 2087.865
16,313 3 21967.134
9,398 6 12529.418
11,783 2 3337.23
13,482 5 18290.562
15,987 6 21243.134
21,023 1 28492.5
18,661 5 25792.359
17,738 3 23845.572
13,036 9 16978.974
7,720 8 10460.8
4,083 10 2018.25
11,301 3 7731.138
9,564 3 12385.428
11,445 10 15122.25
13,888 6 18584.291
19,653 4 26907.648
19,593 1 26587.2
5,646 9 1341.312
7,013 5 9675.876
19,652 2 26429.52
18,871 8 25726.4
13,877 7 17935.995
18,577 7 24051.665
13,584 8 9072
6,654 7 8392.285
3,588 3 2045.658
6,660 8 3452.4
6,749 9 8544.876
16,052 5 22423.761
8,882 8 12009.2
15,911 2 21870.875
19,705 2 27161.81
19,167 1 25514.2
9,387 1 12420.7
15,343 8 20098.4
5,741 7 7165.07
15,602 5 21090.471
12,068 2 15844.855
9,079 0 5433.012
6,883 1 9282.9
10,547 4 6248.394
7,971 4 10438.884
19,029 9 24622.656
4,339 4 5595.618
11,328 5 15164.133
17,194 8 23416.4
17,491 4 23784.834
9,414 10 6630.975
19,926 7 26272.895
18,338 8 24704.4
15,395 6 20489.381
12,031 5 15983.154
 7,842 9 9625.71
17,237 3 23761.962
8,086 1 4271.7
21,526 1 28466.4
6,317 0 1858.428
19,673 9 26089.716
14,233 7 18347.01
16,249 9 21029.856
18,171 9 23263.38
5,561 8 7154
11,696 2 7152.405
15,414 2 10746.775
13,514 7 17825.225
10,890 6 15011.557
10,134 2 7079.735
11,678 5 16086.552
7,338 7 9266.785
3,877 4 442.56
8,302 1 10927.2
16,044 1 21816.7
10,829 8 176.4
5,096 4 2685.786
20,081 2 26882.31
17,813 5 24377.439
17,487 9 23080.746
21,558 9 27676.536
9,014 3 11978.526
2,358 6 2830.025
12,533 6 17096.112
19,472 6 26870.052
19,544 0 25650.456
9,173 2 12393.03
16,310 9 20844.228
21,351 9 28176.534
9,006 4 12151.038
12,238 4 16255.782
5,922 10 7613.775
13,308 3 18344.034
9,671 5 2255.709
5,885 8 7666.4
10,055 10 13261.95
11,675 10 14595.75
6,452 4 8818.008
12,793 6 9619.324
15,615 8 21411.6
18,027 1 24409.3
15,140 4 20775.426
15,007 9 18829.266
18,875 3 25492.689
9,945 1 12945.6
15,410 4 20454.57
20,057 7 26351.6
15,611 8 20462.4
6,341 5 3920.961
10,955 6 6419.325
10,218 7 13586.815
10,671 1 14056.3
2,139 8 2755.2
18,230 5 24995.106
5,472 6 1096.117
8,519 5 10908.489
16,085 4 21953.742
8,626 4 11653.158
10,510 10 14089.725
8,907 6 11552.024
9,603 5 12364.224
12,184 8 7842.8
UADRO RESUMEN POR DIAS DE ATRASO CUADRO RESUMEN POR DIAS DE ATRASO
En este caso esto puede
cambiar (hay una lista de
Total Soles Días de Atraso # ClientesPodemos usar
validacion)
INDIRECTO
287074.9 0 15
695481.4 1 33
829625.18 2 40
892067.407 3 46
691257.392 4 40
897105.507 5 49
932625.09 6 43
834991.79 7 40
1218263.6 8 57
1012897.164 9 42
676510.325 10 32
0 Total 437
te Tabla dinánica:
Monto en Soles del distrito de Surco, con más de 3 dias de atraso.

48,799.00

Monto Total en el distrito de La Victoria, superiores a 15,000.

1,460,349.76

entes cancelaron mas de la mitad de su deuda.

88

entes tienen su deuda en soles mayor que la de dolares.

58
UMEN POR DIAS DE ATRASO
n este caso esto puede
mbiar (hay una lista de
lidacion) Podemos usar Soles
DIRECTO
60,403.00
142,492.00
222,540.00
250,330.00
155,450.00
224,292.00
215,621.00
214,604.00
301,804.00
206,595.00
150,569.00 Agencia - all -
2,144,700.00
Cliente - all -

Data

Distrito Sum - Soles Sum - Dólares

CALLAO 135,483 109,543

LA VICTORIA 362,127 444,313

LIMA 189,521 183,235

LINCE 267,317 288,562

MIRAFLORES 188,043 234,669

SAN BORJA 159,027 181,442

SAN ISIDRO 66,198 92,981

SAN MIGUEL 677,140 783,112

SURCO 99,844 86,686

Total Result 2,144,700 2,404,543

Sum - TotalSoles Sum - Interés Sum - Mora Sum - Saldo

445,876 35,082 2,693 257,632

1,631,658 128,874 8,083 1,025,043

702,006 55,158 3,137 433,465

1,094,105 86,799 5,249 686,710

853,714 67,760 4,182 555,097

670,723 52,751 3,164 411,627

331,448 25,853 1,821 214,242

2,892,782 228,971 13,764 1,778,205

345,586 28,011 1,325 209,329

8,967,900 709,261 43,419 5,571,350

Ejercicio de Repaso:
Se tiene un estado de cuentas de varios clientes a los cuales se les ha brindado un determinado servicio por lo cual
deben pagar una parte del monto en soles y otra en dolares. Se desea calcular las columnas faltantes en dicho cuadro,
para lo cual se cuenta con 2 Tablas, una de los tipos de cambio del dolar, y otra con los porcentajes de interés y de mora.

1.- En la hoja Tablas definir los siguientes nombres de rango:

B3:C13 ====> TCAMBIO
E4:G8 ====> TABLA

2.- en la hoja Contratos escribir las siguientes formulas:

a) Para el calculo del Total que es la suma de los montos en soles y dolares, todo convertido a soles:
=F18+G18*BUSCARV(C18,TCambio,2,0)
b) Para el calculo del Interes:
=H18*BUSCARV(H18,Tabla,2)
c) Para el calculo de la Mora:
=H18*(1+BUSCARV(H18,Tabla,3))^(HOY()-C18)-H18
d) Para el calculo del Saldo, que es la suma del Total+ Interes + Mora - ACuenta:
=SUMA(H18:J18)-K18