15 Cuentas Vencidas Por Resolver Prof Freyre

Tipo de CambioFecha Tipo cambio

1. Calcular las columnas faltantes en cada cuadro. 07/04/2023 2.925 2. Crear la tabla dinámica de la muestra. 08/04/2023 2.994 3. Responder las preguntas restantes. 09/04/2023 2.800

10/04/2023 2.915 11/04/2023 2.761 12/04/2023 2.721 13/04/2023 2.766 14/04/2023 2.787 15/04/2023 2.795 16/04/2023 2.900 17/04/2023 2.964

ESTADO DE CUENTAS VENCIDAS

Cliente Contrato Distrito

ABANTO CHAVEZ JAVIER LUIS 1091263 13/04/2023 LINCE

ABANTO MENDO MARIA ESTHER 1071851 15/04/2023 LA VICTORIA

ACARAPI CASTILLO SIXTO ALBERTO 1126611 15/04/2023 LINCE

ACEVEDO JAEN HUMBERTO RICARDO 968765 12/04/2023 SAN MIGUEL

ACOSTA ATILIO GARCIA OYA A 553651 16/04/2023 LA VICTORIA

ACOSTA GUEVARA YESSICA MARIA 1456423 13/04/2023 SAN MIGUEL

ADANAQUE RISCO BEATRIZ 1201525 11/04/2023 SAN MIGUEL

AGUIRRE BRAVO EDGAR DAVID 461385 12/04/2023 SAN MIGUEL

ALARCON MENDOZA CONSUELO 889938 09/04/2023 SAN MIGUEL

ALBUJAR CHAVEZ JONATHAN JOAO 243493 14/04/2023 SAN MIGUEL

ALIAGA PICHILINGUE ULISES 1112439 07/04/2023 LA VICTORIA

ALMORA CASTILLO ROBERTO ANTONIO 1134083 13/04/2023 LINCE

ALTAMIRANO DIAZ JESSICA LIZET 1069836 10/04/2023 CALLAO

ALVAREZ CAMPOS JOSE LUIS 1099367 09/04/2023 LIMA

ANDRADE VICTOR ZENON ESPIN 194600 16/04/2023 LA VICTORIA

ANTONIO CCENTE CRESCENCIO 1197557 09/04/2023 LA VICTORIA

APOLAYA PILLACA LUZ ANGELICA 1167306 10/04/2023 LA VICTORIA

APONTE OSCAR LUIS ACUÑA DE 42213 14/04/2023 SURCO

AQUINO EVELYN TERESA OJEDA 34487 10/04/2023 MIRAFLORES

ARANDA ANTONIO ABDON COTER 271119 08/04/2023 LA VICTORIA

ARAPA ZAPATA RODOLFO 143464 12/04/2023 SAN MIGUEL

ARESTEGUI PAYE VICTOR HUGO 871443 14/04/2023 SAN MIGUEL

ARIVILCA QUISPE ABRAHAM 1173109 07/04/2023 LA VICTORIA

ARRIOLA CAQUE MIGUEL ANGEL 1087267 09/04/2023 MIRAFLORES

ARRIOLA TUEROS JOSE ALBERTO 1074788 08/04/2023 LA VICTORIA

FechaVencimiento

ARTEAGA MORON JENNY SANDRA 958468 09/04/2023 SAN MIGUEL

ARTOLA ROJAS HILDA ROSA 1606549 07/04/2023 SAN MIGUEL

ATAUYUCO LUNA VERONICA 1092051 15/04/2023 SAN BORJA

BACA LLERENA JORGE LUIS 34789 08/04/2023 SAN MIGUEL

BALAREZO MINAYA ARNALDO JULIAN 343418 09/04/2023 SAN ISIDRO

BARRENECHEA PASTOR ANTONIO 1154285 11/04/2023 CALLAO

BARRETO ALVARADO EDWARD CLEMENT 1038694 12/04/2023 SAN ISIDRO

BARRETO BARDALES IVAN RICARDO 1099331 15/04/2023 LINCE

BARRIOS IPENZA HUGO AUGUSTO 1160230 16/04/2023 LA VICTORIA

BEGAZO RAMIREZ ORLANDO JOSE 1063021 15/04/2023 SURCO

BELLIDO ANGULO GERALD MARLON 1064377 09/04/2023 SAN BORJA

BELTRAN BARDALES FRANCISCO 1089555 11/04/2023 SAN BORJA

BENAVIDES CABRERA ELI 1046416 10/04/2023 LA VICTORIA

BENITES PEREZ GRACIELA ROSALINDA 1036199 07/04/2023 SAN BORJA

BENITO GONZALES NERIO FIDEL 250139 08/04/2023 SAN MIGUEL

BERRIOS AQUIJE CARMEN BEATRIZ 969877 10/04/2023 LINCE

BOCANEGRA VELASQUEZ SANTIAGO FERNAN 1212551 15/04/2023 MIRAFLORES

BOLIVAR NAVARRO ROMULO MARTIN 524751 16/04/2023 SAN MIGUEL

BOSSIO ERCILLA JUAN MANUEL 939056 11/04/2023 SAN MIGUEL

BOZA SEAS JORGE LUIS 455776 11/04/2023 SAN MIGUEL

BRICEÑO IMAN VICTOR 936367 10/04/2023 SAN MIGUEL

BRINTHON KERR ERICH 1012008 08/04/2023 SAN ISIDRO

BUSTAMANTE SOLARI MARIO LUIS 1010898 08/04/2023 LA VICTORIA

CABRERA RAMON VASQUEZ REY 156327 09/04/2023 LA VICTORIA

CAICEDO CARDENAS ROBERT 773727 10/04/2023 SAN MIGUEL

CAJO CESPEDES HILARIO 907901 16/04/2023 SAN MIGUEL

CALDERON CARDENAS REYNALDO LESME 93939 08/04/2023 SAN MIGUEL

CALDERON CARRANZA MARIA ESTELA 1092565 11/04/2023 MIRAFLORES

CALDERON LAURENTE RICARDO BENITO 1279903 13/04/2023 LIMA

CALLAO VEGA JOSE MARCELINO 772607 10/04/2023 SAN MIGUEL

CAMPOBLANCO ALVARADO PAMELA 1082249 07/04/2023 MIRAFLORES

CAMPOS CHAVEZ GINA PAOLA 764426 11/04/2023 SAN MIGUEL

CAR CHECK SAC 22234 13/04/2023 MIRAFLORES

CARHUALLANQUI SUASNABAR GREGORIO 134430 16/04/2023 SAN MIGUEL

CARIDAD ESPERANZA GHIO LUCIANO 583022 15/04/2023 SAN MIGUEL

CARLOS ALBERTO VILLANUEVA MAGALLANE 374040 17/04/2023 SAN MIGUEL

CARLOS MANUEL ALARCON ACEVEDO 545074 13/04/2023 SAN MIGUEL

CARPIO QUINTANA VICTOR HUGO 1089210 16/04/2023 LIMA

CARRANZA PEZO CARLOS FIDEL 979104 13/04/2023 LINCE

CARRANZA VIGO ANGEL ADRIANY 1081662 14/04/2023 SAN BORJA

CARRASCO CARRASCO CIRILO 644196 11/04/2023 SAN MIGUEL

CARRASCO CARRASCO EDINSON ALEXANDER 512885 12/04/2023 SAN MIGUEL

CARRUITERO DOMINGUEZ MARIO ANTONIO 1133187 09/04/2023 LINCE

CASAVERDE CASTILLO KARIN ISABEL 441023 14/04/2023 SAN MIGUEL

CASTAÑEDA HUAMBACHANO VICTOR 1002239 07/04/2023 SAN BORJA

CASTILLA CONTRERAS TOMAS EMILIO 456608 09/04/2023 SAN MIGUEL

CASTILLO ARANDA PEDRO AMERICO 1059387 09/04/2023 LA VICTORIA

CASTILLO MIÑOPE JOSE ANTONIO 239275 12/04/2023 SAN MIGUEL

CASTILLO YAMUNAQUE ALFREDO 1088242 14/04/2023 LINCE

CASTRO HOYLE ERIKA MILAGROS 1210001 15/04/2023 MIRAFLORES

CAVA DIAZ MARLENE HELEA 1000649 07/04/2023 LA VICTORIA

CAVERO JUANA ROSA VELAOCHA 33048 09/04/2023 LA VICTORIA

CERNA CACHIQUE JANET JACKELINE 1164978 08/04/2023 LA VICTORIA

CESPEDES SANTOS MARIA PATRICIA 854735 12/04/2023 SAN MIGUEL

CESPEDES VIRU RAFAEL OMAR 560693 14/04/2023 SAN MIGUEL

CHACON ALMEYDA MILTON CESAR ANTONIO 624845 12/04/2023 SAN MIGUEL

CHACON CERCADO ALDO CESAR 1042079 07/04/2023 CALLAO

CHANAME MARIN JUAN JAVIER 462543 14/04/2023 SAN MIGUEL

CHATI QUISPE HUGO 1086317 09/04/2023 LINCE

CHAVESTA FERNANDEZ CESAR ORLANDO 217328 09/04/2023 SAN MIGUEL

CHAVEZ CARPIO JULIAN BERTTI 118454 12/04/2023 LINCE

CHAVEZ MEDINA HENRY 1121493 13/04/2023 SAN BORJA

CHAVEZ OSORIO MARIA VICTORIA 1080446 10/04/2023 LA VICTORIA

CHAVEZ ROSADO BLANCA EVA 281700 17/04/2023 SAN MIGUEL

CHERO TORRES LUIS GERARDO 697605 12/04/2023 LINCE

CHERRE CORILLOCLLA PEDRO MANUEL 44017 10/04/2023 LIMA

CHERRES DE LA BARRA DALINDA AMADA 942383 14/04/2023 SAN MIGUEL

CHIZAN LARREA NINOSKA ISABEL 176192 14/04/2023 SAN MIGUEL

CHONTA ORTIZ ANTENOR ANGEL 815578 09/04/2023 SAN MIGUEL

CHOQUE CHURA ODILON 1140861 15/04/2023 LINCE

CHOQUE PAUCAR JOSE LUIS 1084092 14/04/2023 LIMA

CHUJUTALLI IPANAMA VICTORIANO 1261318 08/04/2023 LA VICTORIA

CHUMBE ROJAS JUAN MANUEL 1088364 12/04/2023 LA VICTORIA

CHUMBIMUNI CHIRINOS MARIBEL JANET 958425 12/04/2023 SAN MIGUEL

CHUQUIPIONDO ORELLANA JENSYS 898627 10/04/2023 SAN MIGUEL

CHURA PARRILLO LUIS ENRIQUE 1209491 15/04/2023 LA VICTORIA

CIEN POR CIENTO DIES EL SRL 100 DIE 1090797 09/04/2023 SAN BORJA

COLFER BRACAMONTE DESIREE 531737 10/04/2023 SAN MIGUEL

COLLANTES PEÑA JUAN JOSE 1005967 09/04/2023 CALLAO

COLLAZOS VARILLAS ROGELIO 1058772 14/04/2023 SURCO

COLQUE VALENTIN YANINA MARIBEL 1145742 14/04/2023 LIMA

CONSTANTINO JORGE SANCHEZ 136660 16/04/2023 LA VICTORIA

CONTRERAS LUIS ERNESTO BOH 59975 12/04/2023 SURCO

CORDOVA CARVALLO,DAVID ARMANDO 1081499 07/04/2023 LA VICTORIA

CORNEJO DE LA FUENTE CHAVEZ RODRIGO 1297855 11/04/2023 LIMA

CORONEL CAPACYACHI JESUS FRANCISCO 217158 09/04/2023 SAN MIGUEL

CORTEZ ROMERO VICTOR RAUL 448524 13/04/2023 SAN MIGUEL

COTERA TORRES PEDRO GUILLERMO 837938 09/04/2023 SAN MIGUEL

CRUZ CARRASCO SARA JOHAIDY 1100583 13/04/2023 SAN BORJA

CRUZ FLORES BETTY MELISSA 1009826 10/04/2023 SAN MIGUEL

CUELLAR MORALES GAMANIEL 1197824 12/04/2023 LA VICTORIA

CUEVA CRUZATTI MILWUER OSCAR 247332 15/04/2023 LINCE

CUSTODIO CARBAJAL CARLOS 497118 09/04/2023 SAN MIGUEL

CUYA YUYALE TIMOTEO 978140 17/04/2023 LINCE

DAVALOS VERA ANIBAL GUSTAVO 1029350 16/04/2023 SURCO

DAVILA FLORES NAYUD MILAGROS 1059110 16/04/2023 SAN BORJA

DAVILA TULIO PLACIDO MEZA 563975 12/04/2023 LA VICTORIA

DE LA CRUZ CHERRES GREGORIO LORENZO 37198 09/04/2023 LINCE

DE LA CRUZ PAREJA NELSON VICTOR 1251145 11/04/2023 MIRAFLORES

DE LA PEÑA ARMANDO GUALBER 302960 17/04/2023 LA VICTORIA

DE VELASCO SUAREZ ORLANDO ALFONSO 59462 15/04/2023 LIMA

DEL POZO CASAS FERNANDO CESAR 1003319 07/04/2023 SAN ISIDRO

DELGADO SOTOMAYOR DINO ALDO 209910 17/04/2023 SAN MIGUEL

DELGADO TUCTO JAMES 1096991 15/04/2023 LA VICTORIA

DELHONTE MANUEL ANGEL CAGN 78627 10/04/2023 MIRAFLORES

DEMETRIO ANGEL CARBAJAL PACHECO 1125572 14/04/2023 LINCE

DIAZ RAMOS RAMIRO 270768 09/04/2023 SAN MIGUEL

DIAZ RIOS MARLON DEY 1229848 08/04/2023 LA VICTORIA

DIAZ YANTAS VICTOR FRANCISCO 15499 07/04/2023 LA VICTORIA

DOMINGUEZ MARTEL WILDER 1099494 12/04/2023 LA VICTORIA

DOMINGUEZ SALCEDO JAHN HENRY 1074311 15/04/2023 CALLAO

DURAND FLORES JOSE DOMINGO 1140140 16/04/2023 SAN MIGUEL

EGUSQUIZA JUAN RAMON SILUP 25038 09/04/2023 LIMA

ENRIQUEZ ROSSO JOSE FERNANDO 816779 08/04/2023 LINCE

ESCALANTE CHOQUEVILCA CARMEN ANGELA 563900 17/04/2023 SAN MIGUEL

ESCARCENA GUZMAN ROY ARCADIO 214736 11/04/2023 SAN MIGUEL

ESCOBAR BOLTAN TATIANA 1157991 15/04/2023 LA VICTORIA

ESPINOZA BECERRA PATRICIA ESMERALDA 1093315 11/04/2023 SAN BORJA

ESPINOZA ESPINOZA MANUEL TELESFORO 570400 17/04/2023 SAN MIGUEL

ESPINOZA MARIANO JOSE LUIS 1100209 07/04/2023 LIMA

EYZAGUIRRE ALEGRIA MANUEL EDUARDO 1087387 09/04/2023 LIMA

EYZAGUIRRE SANTA ANA GABRIELA MATIL 1144776 10/04/2023 LINCE

FACTORIA ON MOTORS EIRL 11934 12/04/2023 MIRAFLORES

FALEN FERNANDO GONZALEZ GO 11116 10/04/2023 LINCE

FARRO GOMEZ DORA ASUNCION 1005039 07/04/2023 SURCO

FELICES ROY HENRRY CCAICO 55791 16/04/2023 LA VICTORIA

FERNANDEZ LAREDO MIGUEL ANGEL 1158144 12/04/2023 LA VICTORIA

FERNANDEZ LOARTE FERNANDO LINCOLHN 1143100 16/04/2023 LA VICTORIA

FERNANDEZ MELENDEZ ELMO 357227 10/04/2023 SAN MIGUEL

FERNANDO MANUEL LAPIZ YAMUNAQUE 1055256 10/04/2023 SURCO

FERRER MAMANI KARINA VANESSA 764639 08/04/2023 LINCE

FERRETTO CORTEZ SERGIO ISRAEL 920517 10/04/2023 SAN MIGUEL

FERRUZO MARIELLA EULALIA M 104228 08/04/2023 LA VICTORIA

FIGUEROA LOPEZ JORGE 813346 11/04/2023 LINCE

FIGUEROA QUISPE SANDRA ROSALINA 353418 09/04/2023 SAN MIGUEL

FLORES ALTUNA MARIELA MERCEDES 1002461 15/04/2023 MIRAFLORES

FLORES CURISINCHE MARTIN OSWALDO 1145893 13/04/2023 SAN BORJA

FLORES FUENTES GARY BERNARD 1104345 11/04/2023 CALLAO

FOPPIANI VINCES GILDA MARIA 1001882 14/04/2023 MIRAFLORES

GALARRETA VELARDE ANIBAL ANTONIO 1091833 13/04/2023 MIRAFLORES

GALLARDO PEREYRA JOSE LUIS 1099656 10/04/2023 LA VICTORIA

GALVEZ CUBAS CARLOS 1206419 07/04/2023 LA VICTORIA

GAMARRA SILVA JESUS ROBERTO 1059909 07/04/2023 LINCE

GAMEZ MELENDREZ JESUS GILMER 435236 11/04/2023 SAN MIGUEL

GARCIA ADRIANZEN GERARDO MARTIN 413682 15/04/2023 SAN MIGUEL

GARCIA HUERTA WILLIAM WARLEY 1121393 13/04/2023 SURCO

GARCIA LA RIVA VICTORIA ROSA 517402 15/04/2023 SAN MIGUEL

GARCIA MENDOZA MARCIONILA 598550 17/04/2023 SAN MIGUEL

GIL LOPEZ JUAN CARLOS GERARDO 1122038 08/04/2023 MIRAFLORES

GIL VILLANUEVA DIANA CECILIA 1325204 12/04/2023 LIMA

GIRAO MALAGA PATRICIA ANTUANET 1050212 14/04/2023 LINCE

GOMEZ ALCA LINO EZZIO 1027290 16/04/2023 MIRAFLORES

GOMEZ OSCAR ENRIQUE BELTRA 74792 15/04/2023 LINCE

GOMEZ VALENCIA RAFAEL RAMIRO 1063009 07/04/2023 CALLAO

GONZALES INJOQUE MARIA GABRIELA 247456 11/04/2023 LINCE

GONZALES SAAVEDRA JESUS ANTONIO 1032865 11/04/2023 LIMA

GONZALES SALGUERO JESUS ANDRES 639109 08/04/2023 SAN MIGUEL

GONZALEZ MENENDEZ JUAN CARLOS 1062819 07/04/2023 SAN BORJA

GRANADOS CLAROS ANGEL CUSTODIO 61166 11/04/2023 SAN MIGUEL

GUERRA TORO FELICITAS ESTHER 367826 11/04/2023 SAN MIGUEL

GUEVARA ALVAREZ ALEXANDER 1282076 10/04/2023 LINCE

GUEVARA ARANGOITIA CESAR AUGUSTO 1074496 10/04/2023 LIMA

GUEVARA PALOMINO HERMELINDA LUZ 1089174 12/04/2023 SAN BORJA

GUILLEN BUSTIOS CARMEN MARCELA 211249 08/04/2023 SAN MIGUEL

GUTIERREZ CARDENAS LUIS FERNANDO 1060715 11/04/2023 LINCE

HUAMAN ORTEGA OSCAR ALBERTO 184349 07/04/2023 SAN MIGUEL

HUARANCA SEGOVIA CESAR ENRIQUE 339393 14/04/2023 SAN MIGUEL

HUAYNATE BONILLA ARON EFRAIN 1207583 13/04/2023 LA VICTORIA

HUERTA LOPEZ CHRISTIAN 1055351 15/04/2023 SURCO

HURTADO URETA RICARDO 1221652 14/04/2023 LA VICTORIA

HURTADO X JORGE TEODORO 1004719 07/04/2023 SAN MIGUEL

ICAZA DELGADO ARMANDO ABELARDO 1059209 07/04/2023 LIMA

IPANAQUE MENDOZA MIGUEL ANGEL 177288 08/04/2023 LINCE

IPUSHIMA ABNER VASQUEZ CON 91300 17/04/2023 LA VICTORIA

JAIMES EGUIZABAL ELEODORO FRANCISCO 1032553 13/04/2023 LIMA

JAVIER TAFUR SAYDA YENYA 780200 17/04/2023 SAN MIGUEL

JIMENEZ RODRIGUEZ MANUEL HUMBERTO 277630 17/04/2023 SAN MIGUEL

JIMENEZ SANGAMA CARLOS ORLANDO 1148544 12/04/2023 MIRAFLORES

JOAQUIN MORANTE ANA GISELLA 865958 09/04/2023 SAN MIGUEL

JOSE CARLOS JESUS SCHIAFFINO GARCIA 481993 14/04/2023 SAN ISIDRO

JOSE ROBERTO ACEVEDO MARTINEZ 441392 15/04/2023 SAN MIGUEL

JUAN CARLOS BENAVIDES ROJAS 1089915 11/04/2023 SURCO

KAREN YLYANA AGUILAR MOQUILLAZA 676799 08/04/2023 LINCE

KAWAMURA RODRIGUEZ ERIKA PAOLA 37184 13/04/2023 SAN MIGUEL

KOIKE LOAYZA JESUS EUGENIO 524714 13/04/2023 SAN ISIDRO

LEON ALZAMORA JOSE LUIS 1076206 10/04/2023 MIRAFLORES

LEON DE LA ROCA JONATHAN FERNANDO 17154 12/04/2023 SURCO

LERMO GALARZA SERGIO EDMUNDO 1050595 11/04/2023 LA VICTORIA

LEVA AMPUERO RENZO 1209982 14/04/2023 MIRAFLORES

LILIANA ANGELA HUAMANI PUCHURI 495204 13/04/2023 SAN MIGUEL

LINARES PEREZ SEGUNDO RICARDO 1310305 11/04/2023 SAN MIGUEL

LINO MATOS CARMEN ROSA 900109 08/04/2023 SAN MIGUEL

LITANO COBEÑAS JOSE HUGO 938319 08/04/2023 SAN MIGUEL

LLAZA JUANITO ALEJANDRO SERAFIN 529443 14/04/2023 SAN MIGUEL

LLERENA CARLOS AMADOR TELL 549468 09/04/2023 LA VICTORIA

LOAYZA ALCANTARA LUIS ALBERTO 1087696 10/04/2023 MIRAFLORES

LOAYZA DARIO ELISBAN ORTEG 143142 14/04/2023 LINCE

LOAYZA WAIDHOFER GABRIELA MARIE 1308572 14/04/2023 LA VICTORIA

LOPEZ CAYO DIONISIO VILLAN 282471 16/04/2023 LA VICTORIA

LOPEZ CRUZATE GASTON CREIDE 1317342 14/04/2023 SAN MIGUEL

LOPEZ LUIS HUMBERTO OWERLU 567725 12/04/2023 LA VICTORIA

LOPEZ ORDOÑEZ KARIN JANET 22314 13/04/2023 SAN MIGUEL

LOPEZ ROLDAN JUDITH LUZ 1058569 07/04/2023 LINCE

LOPEZ SABOYA MARIA DEL PILAR 74322 15/04/2023 SAN BORJA

LOZANO CANCHO JOSE 1399373 13/04/2023 SAN MIGUEL

LUCAR MACHUCA JOSE CARLOS 703044 13/04/2023 SAN MIGUEL

LUCHO BENAVENTE EIRL 875 12/04/2023 LIMA

LUJAN LUJAN LUIS ULISES 1093687 09/04/2023 LIMA

LUJAN MARIA ROXANA SEPULVE 105958 08/04/2023 SAN ISIDRO

LUNA CRUZ SANTOS REYNALDO 21059 08/04/2023 LINCE

MACEDO MASIAS GIULIANA CECILIA 911399 08/04/2023 LINCE

MACHADO SANDOVAL, VICTORIA ELENA 462565 12/04/2023 SAN ISIDRO

MACIZO GOMEZ GLADIS MARITHZA 1088356 10/04/2023 LINCE

MALATESTA ERNESTO OSWALDO 550172 15/04/2023 LA VICTORIA

MALLQUI MINAYA,GAMANIEL 1211631 15/04/2023 LA VICTORIA

MANRIQUE LEBRUN CARMEN 1083827 09/04/2023 CALLAO

MARAVI CANGALAYA FRENEE MARIA 561541 16/04/2023 LINCE

MARCO ANTONIO FERNANDEZ PALMA 482196 11/04/2023 SAN MIGUEL

MARENGO VELAOCHAGA JORGE EDUARDO 1152700 16/04/2023 MIRAFLORES

MARMANILLO CANO JORGE FIDEL 1139537 09/04/2023 MIRAFLORES

MARQUEZ IBARRA JULIA DONATILDE 1156762 14/04/2023 LIMA

MARREROS VILLANUEVA PAUL RICHARD 651796 11/04/2023 SAN MIGUEL

MARTIN PINEDO JUAN GABRIEL 581394 13/04/2023 SAN ISIDRO

MARTINEZ GONZALES PABLO WILLY 1140554 12/04/2023 LA VICTORIA

MARTINEZ MELGAREJO VICTOR 1059699 07/04/2023 CALLAO

MATTA CAVERO SOFIA REBECA 891568 09/04/2023 SAN MIGUEL

MAYO ORTEGA PEDRO ALFREDO 1199614 12/04/2023 LA VICTORIA

MELISSA SOLEDAD APONTE HUAPAYA 669938 09/04/2023 SAN MIGUEL

MENDIZABAL AMELIA SANDOVAL 87131 16/04/2023 LINCE

MENDOZA LOPEZ DAMASO LEONCIO 1002695 11/04/2023 LIMA

MENDOZA MAGALLANES ITALO 1162590 16/04/2023 SURCO

MENDOZA REVILLA JUAN CARLOS 1284179 07/04/2023 LINCE

MENDOZA RODRIGUEZ ROCIO ELIZABETH 1078326 10/04/2023 LA VICTORIA

MERINO ARCELLES MANUEL 1165821 15/04/2023 LINCE

MERINO CORONADO CARLOS GABRIEL 236578 09/04/2023 LINCE

MEZA JOSE LUIS NAVEDA IO T 95441 16/04/2023 LIMA

MIRANDA TIRAPO JUAN SINECIO 413925 12/04/2023 SAN MIGUEL

MOGROVEJO MEDINA JUAN DAVID 1286587 09/04/2023 SAN MIGUEL

MONASTERIO RUIZ JEAN OLIVER 1247684 12/04/2023 LA VICTORIA

MONTES MONTES CARLOS EDDY 656453 14/04/2023 SAN MIGUEL

MONTES SALAS CECILIA MILAGROS 1020072 14/04/2023 SAN MIGUEL

MONTESINOS NUÑEZ MOISES MIGUEL 1000742 14/04/2023 LIMA

MORALES GALLO JORGE LUIS 1000772 14/04/2023 SAN BORJA

MORALES LLONTOP LORENA JUDITH 572365 12/04/2023 SAN MIGUEL

MORALES PELAEZ CARLOS GUSTAVO 1022459 07/04/2023 LA VICTORIA

MORENO IRENE ROSA LOPEZ Z 26306 11/04/2023 LIMA

MORENO VILLAREYES DEYVER 384550 17/04/2023 SAN MIGUEL

MOULET CHUMACERO DIANA ELIZABETH 452688 09/04/2023 SAN MIGUEL

MUCHA ORLANDO ISAAC LLACZA 23343 14/04/2023 SAN BORJA

MURAYA VILLANUEVA JOSE LUIS 1145394 12/04/2023 SURCO

NAPANGA NEGREIROS EDDY ERNESTO 1120078 08/04/2023 MIRAFLORES

NAVARRO PAREDES TESALIA 1348396 10/04/2023 SAN MIGUEL

NB CORPORATION SAC 1901647 09/04/2023 MIRAFLORES

NEYRA CASTILLO MARIA KATYA 1076517 09/04/2023 SAN BORJA

NUÑEZ RENGIFO NIXON 34932 15/04/2023 LIMA

OCHOA ARAGON HORACIO 1173803 13/04/2023 LINCE

OCHOA LUZMILA LINA ALIAGA 283486 11/04/2023 LA VICTORIA

OLIVARES GUEVARA ARMSTRONG WALTER 1289942 14/04/2023 LA VICTORIA

ONOJIMA CABRERA HELGA CAROL 1211784 12/04/2023 MIRAFLORES

OREJUELA RASMUSSEN MONICA VANESSA 1059591 15/04/2023 SURCO

ORTEGA GAMARRA ALEX HILDEBRANDO 1111540 16/04/2023 MIRAFLORES

PACHAS PATRICIA MILUSKA SA 37088 09/04/2023 LIMA

PADILLA CHAVEZ ALVARO GABRIEL 813435 12/04/2023 SAN MIGUEL

PADILLA PONCE EXEQUIEL PERCY 438367 10/04/2023 SAN MIGUEL

PAICO VEGA JENSON EFRAIN 447676 11/04/2023 SAN MIGUEL

PAIVA FIESTAS MANUEL GREGORIO 374423 14/04/2023 SAN MIGUEL

PALACIOS CALDERON DEYSI MARCELINA 681458 09/04/2023 SAN MIGUEL

PALMIERI TELLO YLLYA VANESSA 285595 12/04/2023 SAN MIGUEL

PALOMINO CHAMORRO AUGUSTO MOISES 1006117 09/04/2023 LIMA

PALOMINO FLORES JOSUE ALEXANDER 658723 14/04/2023 SAN MIGUEL

PALOMINO MENDOZA BENJAMIN ROMULO 621412 15/04/2023 SAN MIGUEL

PANDURO MEDER ROJAS TINO R 553058 09/04/2023 LA VICTORIA

PANDURO SANCHEZ ROCIO DEL PILAR 61395 12/04/2023 SAN MIGUEL

PARIACHI OSORIO JESUS MAXIMILIANO 1203088 08/04/2023 LA VICTORIA

PARODI ARIAS SONIA BEATRIZ 584703 14/04/2023 SAN MIGUEL

PARRAGA BLAS FREDY LUIS 413828 09/04/2023 SAN MIGUEL

PAZ BRAVO JAVIER ALEXANDER 642789 08/04/2023 SAN MIGUEL

PEÑA PETER ELGER RUIZ ESSA 24566 11/04/2023 SAN BORJA

PERALTA MALDONADO FREDY 1069143 13/04/2023 LINCE

PEREZ FIERRO WALTER OSCAR 679704 13/04/2023 LINCE

PEREZ LUIS MIGUEL GRADOS R 180286 10/04/2023 LA VICTORIA

PEREZ OLIVOS LUIS FELIPE 52809 08/04/2023 SAN BORJA

PEREZ REYNAGA MATEO ALEJANDRO 1221379 07/04/2023 SAN BORJA

PEVE ELIAS ABEL GUTIERREZ 106712 14/04/2023 LINCE

PITA RONCAL MERLY NOEMI 1055882 14/04/2023 MIRAFLORES

POLO GARCIA ROSELL HERNAN 1065158 08/04/2023 LINCE

POLO MONTESINOS FRANK ROGGER 377333 14/04/2023 SAN MIGUEL

POLO PAREDES HAYDEE CECILIA 1072833 13/04/2023 MIRAFLORES

POMA FELIX PEDRO YSAURO 1183646 10/04/2023 LA VICTORIA

PONCE SALCEDO MARIANA 1108898 08/04/2023 MIRAFLORES

POZZO OLIVA CARLOS ENRIQUE 158321 15/04/2023 LA VICTORIA

QUEVEDO LEDESMA ALEX ANTONIO 1072465 11/04/2023 LIMA

QUEZADA CORNEJO MILAGROS NATALI 1055791 15/04/2023 LA VICTORIA

QUEZADA PRINCIPE JESUS ALBERTO 900583 14/04/2023 SAN MIGUEL

QUICAÑO DE LA CRUZ TEOFILA CONCEPCI 729566 11/04/2023 LINCE

QUINO ALVARADO ZOILA ISABEL 12621 15/04/2023 MIRAFLORES

QUIROZ GINA JESSICA CUADRO 34655 12/04/2023 CALLAO

QUISPE DE LA CRUZ MARCO ANTONIO 44466 11/04/2023 SAN MIGUEL

QUISPE HIDALGO AURELIO 1040130 16/04/2023 SAN BORJA

QUISPE ORE WALTER RAUL 1121584 12/04/2023 MIRAFLORES

QUISPE VELASQUEZ FELIX 469033 14/04/2023 LINCE

QUISPE ZAVALETA LORENZO 826669 08/04/2023 SAN MIGUEL

RAMIREZ LILIANA RUTH BEATR 31778 09/04/2023 MIRAFLORES

RAMIREZ MARTINEZ TEODORA 1106839 07/04/2023 CALLAO

RAMIREZ REYES FERNANDO ROMAN 1023142 14/04/2023 MIRAFLORES

RAMOS NEYRA JOSE ANTONIO 1083282 14/04/2023 CALLAO

RAMOS NORIEGA ERNESTO MIGUEL 17899 07/04/2023 LINCE

RAMOS PIÑA JOSE ALFONSO 1027215 11/04/2023 CALLAO

RAMOS VILLANUEVA JUAN AUGUSTO 42994 13/04/2023 SAN MIGUEL

REATEGUI YAZAKAMA MANUELA 1061170 16/04/2023 SAN BORJA

REBAZA BEJARANO HUMBERTO FRANCISCO 1059748 08/04/2023 SAN BORJA

RENGIFO RIVERA ELIZABETH 725625 12/04/2023 SAN MIGUEL

RENTERIA AYALA OSWALDO 1141201 15/04/2023 SAN MIGUEL

REYES ZELAYA LEONIDES EVANGELINA 59978 09/04/2023 SAN MIGUEL

RIOS UTIA RUBER 1099486 10/04/2023 LA VICTORIA

RIVERA BALTAZAR WILFREDO ALEX 1146986 10/04/2023 CALLAO

RIVERA COLLANTE MANUEL JESUS 1166717 09/04/2023 LA VICTORIA

RIVERA HEREDIA AMANDA JULIA 1207006 10/04/2023 MIRAFLORES

RIVERO GARCIA,FEDERICO EDUARDO 1005882 14/04/2023 MIRAFLORES

RODAS ESPINOZA SILVIA LILIANA 1079907 09/04/2023 SURCO

RODRIGUEZ CABREJOS ZULEMA LUCITANIA 842869 08/04/2023 SAN MIGUEL

RODRIGUEZ JABA ELIANA 1127704 12/04/2023 SAN BORJA

RODRIGUEZ LLOSA SANDRO IVAN 884278 09/04/2023 SAN MIGUEL

RODRIGUEZ ZAFRA MILTHON JOSUE 1100981 15/04/2023 LA VICTORIA

ROGGERO SOLANO SOFIA 335932 15/04/2023 SAN MIGUEL

ROJAS CORDOVA YENNY MARGOT 1041840 16/04/2023 MIRAFLORES

ROMANI AGUIRRE MIGUEL GUSTAVO 754951 16/04/2023 SAN MIGUEL

ROMERO BETTY MARILU RAMOS 212978 09/04/2023 LA VICTORIA

ROMERO BORDA ANTHONY NICASIO 1105026 10/04/2023 SAN BORJA

ROMERO LEGUA MAXIMO GUILLERMO 1069164 12/04/2023 LA VICTORIA

ROMERO THAIS LEONARDO 1201091 15/04/2023 LIMA

ROSADO D'UGARD RICARDO PABLO 43510 17/04/2023 LIMA

ROSAS ROSAS JUAN CARLOS 38261 16/04/2023 LINCE

RUBIO BRUNO DUNCAN ROGGER 200034 13/04/2023 SAN MIGUEL

RUBIO MANRIQUE SANDRO 1199823 13/04/2023 CALLAO

RUIZ POMACANCHARI MADELEINE 446599 08/04/2023 SAN MIGUEL

SAAVEDRA FLORES JONNY ALEJANDRO 684104 13/04/2023 SAN MIGUEL

SAAVEDRA SALDARRIAGA RAMON 1245944 12/04/2023 LIMA

SALAZAR CAJA GODOFREDO CONSTANTIN 1185347 09/04/2023 LA VICTORIA

SALAZAR MARIA EUGENIA SALV 10323 13/04/2023 SAN BORJA

SALAZAR TERRONES NURIA MORAIMA 1124979 07/04/2023 MIRAFLORES

SALDARRIAGA RIVERA FELIX EDUARDO 874957 10/04/2023 SAN MIGUEL

SALVADOR QUICHIZ LEONCIO 346578 09/04/2023 SAN MIGUEL

SAMAN REYES SILVIA SUSANA 649406 11/04/2023 SAN MIGUEL

SAN MIGUEL ESQUERRA JESUS GERMAN 1053204 12/04/2023 SAN BORJA

SANCHEZ AGREDA DE PEREDA NANCY LUZ 1083928 08/04/2023 CALLAO

SANCHEZ ALBAVERA JOSE FERNANDO 1057982 14/04/2023 SAN ISIDRO

SANGAMA MILTON SHUÑA NICH 565501 16/04/2023 LA VICTORIA

SANTAMARIA COTRINA BENJAMIN 1154870 16/04/2023 LA VICTORIA

SANTAMARIA SUYON JULIO 621870 17/04/2023 SAN MIGUEL

SANTIAGO ALVARADO PEDRO MIGUEL 325309 08/04/2023 SAN MIGUEL

SARMIENTO SALINAS WALTER ALFREDO 1054116 10/04/2023 LA VICTORIA

SERPA ENRIQUEZ NANCY ESMERALDA 466129 08/04/2023 SAN ISIDRO

SIERRA GARATE WALDO SANDRO 1221968 08/04/2023 MIRAFLORES

SILVA VARGAS GLORIA EDITA 1135417 09/04/2023 SAN BORJA

SINTI JARAMILLO MAYLA 1110501 15/04/2023 LIMA

SINUIRI MUDARRA JUAN CARLOS 715182 15/04/2023 SAN MIGUEL

SKRINJARIC YVAN AYUNI RISE 35877 10/04/2023 MIRAFLORES

SOTO LUZ VERONICA GONZALES 99206 11/04/2023 SAN ISIDRO

TAPARA SANCHEZ JESUS 98272 15/04/2023 SAN MIGUEL

TARDILLO LOPEZ GLORIA MONICA FELICI 396125 12/04/2023 SAN MIGUEL

TEJADA GUTIERREZ JOSE ENRIQUE 477117 10/04/2023 SAN MIGUEL

TEOFILO OJEDA GUERRERO 480304 13/04/2023 LINCE

TOLENTINO RIOS JORGE ANTONIO 1044810 16/04/2023 SURCO

TORO YAGUAL RUBEN ORLANDO 1072870 16/04/2023 LINCE

TORREJON RETAMOZO ANTHONY 1107937 09/04/2023 CALLAO

TRIGUEROS ESPEJO CECILIA DEL PILAR 761044 13/04/2023 SAN MIGUEL

TURPO ARCE LUCIO 1105471 15/04/2023 LINCE

URIBE DE LAS CASAS MARIA LUISA 1083314 12/04/2023 LA VICTORIA

URPEQUE CASTRO REBECA 514179 08/04/2023 SAN MIGUEL

USHIÑAHUA PAREDES DE GONZALES YOLA 1203468 08/04/2023 LA VICTORIA

VALCARCEL ALMENARA CLAUDIA MARIA 14752 14/04/2023 SAN BORJA

VALERO GOMEZ BARBARA ANNY 681016 11/04/2023 SAN MIGUEL

VALLEJOS DAVILA MIGUEL 781576 11/04/2023 SAN MIGUEL

VALLEJOS URBANO MARCO ANTONIO 651966 11/04/2023 SAN MIGUEL

VARGAS LUQUE ARQUIMIDES LEON 242500 17/04/2023 LINCE

VASQUEZ CALLUPE YNES MERCEDES 1151841 15/04/2023 LA VICTORIA

VASQUEZ GILBERTO ABELARDO 137608 08/04/2023 LA VICTORIA

VASQUEZ HOYOS LUIS ALONSO 1123688 08/04/2023 LINCE

VEGA LOPEZ HECTOR GUILLERMO 1107393 13/04/2023 SAN BORJA

VEGAS GARRIDO CARLOS 1051183 13/04/2023 CALLAO

VEJARANO AMASIFUEN ERICK 165379 07/04/2023 SAN MIGUEL

VELASQUEZ DIESTRA JIMY RAUL 1067592 14/04/2023 LINCE

VELASQUEZ FIGUEROA MARIA TERESA 1008894 12/04/2023 MIRAFLORES

VELASQUEZ ROJAS MARIO FLORENTINO 1118187 09/04/2023 CALLAO

VELAZCO LOPEZ MARIA ISABEL 1010889 07/04/2023 SAN ISIDRO

VERGARA LOVERA KELLY YOVANA 1079329 07/04/2023 LA VICTORIA

VICTORIA ALVAREZ CARLOS ENRIQUE 1003073 13/04/2023 SAN BORJA

VIGIL LUZ ROXANA GUERRERO 136195 11/04/2023 SAN ISIDRO

VILCAPUMA FLORES LIZ 410578 09/04/2023 SAN MIGUEL

VILLA LUQUE ROSA MARIA 9941 16/04/2023 SAN ISIDRO

VILLACORTA MANSILLA ZUELA ERIKA 1098633 13/04/2023 MIRAFLORES

VILLAGOMEZ DAVALOS JOSE ANTONIO 1047078 08/04/2023 SURCO

VILLALBA IPARRAGUIRRE LUIS ALBERTO 1041662 14/04/2023 SURCO

VILLALOBOS PERCY GUTIERREZ 44811 16/04/2023 LA VICTORIA

VILLANUEVA CERNA JAIME ADRIAN 1082623 13/04/2023 LIMA

VILLANUEVA PEDRAZA SIBEL ORIETTA 1138166 10/04/2023 MIRAFLORES

WILLIAM BELL TAYLOR VERGARA 1098817 09/04/2023 MIRAFLORES

YALAN GUERRERO JAVIER ALEJANDRO 146404 12/04/2023 SAN MIGUEL

YARLEQUE DIAZ MILAGROS 1081555 11/04/2023 MIRAFLORES

YAURI VARGAS PEDRO 851027 10/04/2023 SAN MIGUEL

YUPANQUI COLUMBUS ROXANA KATHERINE 778281 16/04/2023 SAN MIGUEL

ZAPANA QUISPE SATURNINO 1295837 09/04/2023 SAN MIGUEL

ZAPATA CASTILLO MARTIN EDUARDO 1253814 12/04/2023 MIRAFLORES

ZAPATA DEGREGORI NANCY CECILIA 1069855 11/04/2023 SAN BORJA

ZAPATA ORTIZ DIONICIO TEODORO 1036314 12/04/2023 LIMA

ZAPATA SARZO LUIS WALTER 1124703 13/04/2023 LA VICTORIA

ZEGARRA ROCHA JOSE 5444 13/04/2023 SAN MIGUEL

ZELADA HUARACA DE YHA NORMA BEATRIZ 1150899 07/04/2023 LINCE

ZEVALLOS GUERRERO JEFF SANDRO 1162835 11/04/2023 LIMA

ZEVALLOS LORENZO ANDERSON RAFAEL 205605 12/04/2023 SAN MIGUEL

ZUÑIGA ACUÑA NESTOR 893528 09/04/2023 SAN MIGUEL

Total =Soles + Dólares x TcambioMonto Tasa %Mora

0 13.50% 0.15%Interés: =Monto x Tasa

1000 11.40% 0.13%5000 9.90% 0.11%

Mora:10000 7.80% 0.09%50000 6.30% 0.07%

Donde: Monto = Total en Solesi = %Morat = días de atraso

ESTADO DE CUENTAS VENCIDAS

Agencia Soles Dólares Total Interés Mora Pago

13 3,240 6,293 20646.44 1610.422 72 12,712

25 5,244 9,487 31760.17 2477.293 55 14,731

17 1,403 1,383 5268.49 521.58 12 2,786

40 3,575 144 3966.82 452.2179 25 464

38 8,794 4,351 21411.90 1670.128 19 13,145

21 2,167 6,558 20306.43 1583.901 70 8,725

40 168 4,430 12399.23 967.1399 65 4,598

21 8,572 3,918 19232.88 1500.164 83 12,490

21 8,869 7,384 29544.20 2304.448 205 16,253

40 8,518 4,323 20566.20 1604.164 54 12,841

38 7,386 2,614 15031.95 1172.492 131 5,000

17 1,432 3,928 12296.85 959.1541 43 8,697

39 9,327 4,232 21663.28 1689.736 132 13,559

19 9,718 309 10583.20 825.4896 74 950

38 9,057 3,883 20317.70 1584.781 18 6,470

38 7,115 1,688 11841.40 923.6292 82 4,401

25 6,790 5,749 23548.34 1836.77 143 12,539

12 8,477 4,277 20397.00 1590.966 53 12,754

28 1,989 4,714 15730.31 1226.964 96 6,703

38 908 8,533 26455.80 2063.553 207 9,441

40 7,300 7,239 26997.32 2105.791 117 14,539

21 6,882 9,297 32792.74 2557.834 85 16,179

38 6,129 8,309 30432.82 2373.76 265 14,438

28 6,184 4,691 19318.80 1506.866 134 10,875

25 2,730 1,802 8125.19 804.3936 81 4,532

Porcentajes de Interes y Mora

=Monto(1+i)t-Monto

21 3,324 2,678 10822.40 844.1472 75 6,002

33 375 8,890 26378.25 2057.504 230 9,265

9 205 5,544 15700.48 1224.637 27 5,749

18 8,702 6,454 28025.28 2185.972 219 15,156

10 6,746 9,898 34460.40 2687.911 240 16,644

39 9,847 6,621 28127.58 2193.951 147 16,468

10 9,509 808 11707.57 913.1903 51 1,289

37 3,568 2,955 11827.23 922.5236 21 6,523

38 3,062 8,367 27326.30 2131.451 24 11,429

12 2,992 593 4649.43 530.0356 12 1,792

9 1,711 3,779 12292.20 958.7916 85 5,490

9 8,152 4,811 21435.17 1671.943 112 12,963

38 3,505 2,050 9480.75 938.5943 73 5,555

9 9,374 4,382 22191.35 1730.925 193 13,756

18 9,618 2,706 17719.76 1382.142 139 6,162

14 4,076 311 4982.57 568.0124 44 548

28 5,168 3,951 16211.05 1264.462 28 9,119

33 4,841 8,127 28409.30 2215.925 25 12,968

33 2,903 2,701 10360.46 808.116 54 5,604

40 4,415 5,480 19545.28 1524.532 102 9,895

18 6,775 564 8419.06 833.4869 65 917

10 7,401 9,264 35137.42 2740.718 275 16,665

25 1,854 4,906 16542.56 1290.32 129 6,760

38 3,031 1,189 6360.20 629.6598 56 4,220

40 6,060 4,610 19498.15 1520.856 119 10,670

33 5,469 7,900 28379.00 2213.562 25 13,369

33 5,553 8,843 32028.94 2498.257 251 14,396

28 742 6,028 17385.31 1356.054 91 6,770

19 5,128 7,360 25485.76 1987.889 88 12,488

33 5,130 5,380 20812.70 1623.391 127 10,510

28 3,277 6,233 21508.52 1677.665 187 9,510

33 2,122 8,099 24483.34 1909.7 128 10,221

28 803 2,824 8614.18 852.8042 38 3,627

40 8,383 3,938 19803.20 1544.65 17 12,321

33 6,465 6,624 24979.08 1948.368 43 13,089

18 4,762 5,330 20560.12 1603.689 0 10,092

33 4,588 2,387 11190.44 872.8545 39 6,975

19 5,280 2,623 12886.70 1005.163 11 7,903

14 6,738 7,729 28116.41 2193.08 98 14,467

9 8,980 3,437 18558.92 1447.596 48 6,208

33 6,768 7,135 26467.73 2064.483 138 13,903

40 5,601 638 7337.00 726.3628 40 779

13 9,881 8,938 34907.40 2722.777 243 18,819

33 8,145 7,017 27701.38 2160.708 72 15,162

9 5,058 5,234 20367.45 1588.661 177 10,292

21 2,711 8,726 27143.80 2117.216 189 11,437

25 4,626 7,555 25780.00 2010.84 179 12,181

40 6,862 4,334 18654.81 1455.075 81 11,196

13 9,326 3,897 20186.94 1574.581 53 6,611

28 8,399 5,418 23542.31 1836.3 41 13,817

25 2,011 5,054 16793.95 1309.928 146 7,065

25 5,829 498 7223.40 715.1166 64 790

25 7,362 9,192 34882.85 2720.862 273 16,554

40 5,353 6,215 22264.02 1736.593 97 11,568

18 7,162 6,613 25592.43 1996.21 67 13,775

40 1,807 8,486 24897.41 1942 108 10,293

39 7,743 8,524 32675.70 2548.705 284 16,267

40 7,838 8,557 31686.36 2471.536 82 16,395

37 8,872 3,639 19061.20 1486.774 133 6,255

18 478 6,005 17292.00 1348.776 120 6,483

17 7,756 2,385 14245.59 1111.156 62 5,070

9 3,852 2,075 9591.45 949.5536 42 5,927

38 4,369 3,595 14848.43 1158.177 90 7,964

18 2,456 3,922 14080.81 1098.303 0 6,378

14 5,574 821 7807.94 772.9862 43 799

19 4,670 2,306 11391.99 888.5752 69 6,976

33 1,962 9,316 27925.69 2178.204 73 11,278

40 8,557 7,282 28851.93 2250.451 75 15,839

33 9,857 8,127 32612.60 2543.783 227 17,984

37 969 5,079 15164.81 1182.855 26 6,048

19 8,786 8,786 33272.58 2595.261 87 17,572

38 2,596 7,232 24248.61 1891.391 190 9,828

38 3,310 1,087 6267.73 620.505 35 2,198

18 1,903 9,058 26549.82 2070.886 115 10,961

40 4,524 3,810 15630.15 1219.152 95 8,334

25 1,660 4,564 14416.38 1124.478 25 6,224

9 5,192 8,830 29916.00 2333.448 208 14,022

21 6,126 9,679 34340.29 2678.542 209 15,805

39 8,929 6,627 27484.60 2143.799 191 15,556

12 3,540 1,380 7386.06 731.2199 24 2,460

19 93 2,061 5837.01 577.8637 19 2,154

38 3,372 2,942 11903.80 928.4964 10 6,314

12 3,231 3,952 13984.39 1090.783 61 7,183

25 741 8,791 26454.68 2063.465 230 9,532

19 5,086 8,641 28943.80 2257.616 151 13,727

40 5,257 9,429 31658.20 2469.34 220 14,686

40 3,910 5,460 19012.36 1482.964 66 9,370

40 5,205 915 7767.00 768.933 69 3,060

9 1,063 6,703 19603.50 1529.073 68 7,766

18 7,270 3,805 18361.58 1432.203 112 11,075

38 6,461 6,135 23154.34 1806.038 101 12,596

14 7,707 354 8696.43 860.9466 19 1,007

40 8,144 4,453 20612.40 1607.767 143 12,597

14 5,062 8,622 30617.61 2388.173 0 13,684

12 9,242 9,863 37844.70 2951.887 33 19,105

9 8,825 5,899 25932.10 2022.704 22 14,724

38 2,287 1,527 6441.97 637.7547 36 3,814

13 7,824 7,028 27502.40 2145.187 191 14,852

28 204 9,586 26670.95 2080.334 139 9,790

38 636 9,614 29131.90 2272.288 0 10,250

19 9,075 8,588 33078.46 2580.12 57 17,663

10 4,335 9,216 31291.80 2440.76 272 13,551

18 5,453 6,068 23438.55 1828.207 0 11,521

38 9,399 4,195 21124.03 1647.674 37 6,797

28 8,510 9,228 35409.62 2761.95 215 17,738

17 4,493 4,238 16304.31 1271.736 42 8,731

18 9,349 9,738 36615.40 2856 255 19,087

38 2,464 9,467 30808.20 2403.039 241 11,931

25 5,143 7,107 25930.98 2022.616 226 12,250

38 7,132 8,866 31256.39 2438 136 15,998

39 4,138 9,741 31364.09 2446.399 54 13,879

40 7,409 8,503 32067.70 2501.281 28 15,912

19 7,420 2,349 13997.20 1091.782 97 4,884

14 8,431 3,464 18802.22 1466.573 147 5,947

40 3,162 1,304 7027.06 695.6785 0 4,466

40 6,043 4,466 18373.63 1433.143 96 10,509

25 8,684 7,439 29476.01 2299.128 51 16,123

9 2,979 9,086 28065.45 2189.105 146 12,065

33 968 2,497 8369.11 828.5417 0 3,465

19 2,855 8,564 27904.70 2176.567 243 11,419

19 8,735 4,348 20909.40 1630.933 145 13,083

37 7,591 6,826 27488.79 2144.126 167 14,417

28 3,212 5,555 18327.16 1429.518 80 8,767

13 9,098 7,920 32184.80 2510.414 196 17,018

12 6,029 8,615 31227.88 2435.774 272 14,644

25 2,571 1,943 8205.70 812.3643 9 4,514

25 2,664 6,309 19830.79 1546.802 86 8,973

38 13 1,468 4270.20 486.8028 5 1,481

33 1,848 5,173 16927.30 1320.329 103 7,021

12 7,233 427 8477.71 839.2928 65 957

14 5,449 5,650 22365.10 1744.478 175 11,099

40 86 8,071 23612.97 1841.811 144 8,157

25 6,441 1,542 11057.75 862.5043 87 3,991

14 4,229 706 6178.27 611.6483 41 1,850

33 8,212 4,854 21803.20 1700.65 152 13,066

28 1,160 6,227 18564.47 1448.028 32 7,387

9 7,250 3,906 18054.00 1408.212 63 11,156

39 7,600 8,707 31640.03 2467.922 165 16,307

28 5,906 7,066 25598.94 1996.717 67 12,972

28 2,051 9,540 28438.64 2218.214 99 11,591

38 1,512 4,765 15401.98 1201.354 94 6,277

38 4,599 6,007 22169.48 1729.219 193 10,606

17 3,168 4,128 15242.40 1188.907 133 7,296

40 7,776 8,106 30156.67 2352.22 157 15,882

40 6,572 5,358 21547.61 1680.714 37 11,930

12 1,209 2,699 8674.43 858.769 38 3,908

18 9,337 6,241 26780.60 2088.886 46 15,578

33 5,125 3,203 14618.69 1140.258 0 8,328

28 4,341 8,208 28915.75 2255.429 226 12,549

19 961 8,743 24750.70 1930.555 107 9,704

37 1,333 1,447 5365.79 531.2131 18 2,780

28 1,313 3,423 11239.70 876.6966 10 4,736

37 2,534 9,790 29897.05 2331.97 52 12,324

39 9,479 9,497 37257.73 2906.103 324 18,976

14 4,518 8,520 28041.72 2187.254 146 13,038

19 3,148 7,073 22676.55 1768.771 118 10,221

33 2,042 8,017 26044.90 2031.502 204 10,059

9 4,018 9,753 32545.52 2538.551 283 13,771

40 7,505 1,268 11005.95 858.4639 57 4,386

33 590 9,221 26049.18 2031.836 136 9,811

17 6,874 8,102 30491.33 2378.324 185 14,976

19 2,611 9,997 31752.26 2476.676 193 12,608

9 3,594 9,188 28594.55 2230.375 124 12,782

40 9,392 6,517 28903.90 2254.504 226 15,909

17 7,431 6,344 24946.78 1945.849 130 13,775

33 2,748 6,975 23149.88 1805.69 201 9,723

21 656 378 1709.49 194.8814 7 1,034

38 1,328 2,815 9114.29 902.3147 40 4,143

12 9,565 3,484 19302.78 1505.617 33 6,524

38 3,991 9,314 29949.12 2336.031 78 13,305

40 4,570 5,580 20891.50 1629.537 182 10,150

19 4,188 719 6291.08 622.8164 70 613

14 8,988 7,256 30712.46 2395.572 240 16,244

38 1,755 5,021 16637.24 1297.705 0 6,776

19 558 6,922 19704.25 1536.932 68 7,480

40 835 5,410 16870.24 1315.879 0 6,245

21 6,103 8,898 32476.67 2533.18 0 15,001

28 949 5,432 15729.47 1226.899 68 6,381

40 490 5,179 14991.20 1169.314 104 5,669

10 1,585 5,215 16119.21 1257.298 42 6,800

21 2,348 27 2423.47 276.275 6 85

12 6,675 4,791 19902.95 1552.43 104 11,466

14 8,329 9,910 37999.54 2963.964 297 18,239

33 6,617 1,662 11214.09 874.6992 39 555

10 7,058 4,407 19247.76 1501.325 67 11,465

28 6,062 3,433 16069.20 1253.397 98 9,495

12 2,225 2,348 8613.91 852.7769 47 4,573

25 3,611 5,821 19682.78 1535.257 103 9,432

28 3,255 874 5690.84 563.393 19 2,064

21 8,064 3,056 16516.90 1288.318 57 5,560

40 9,240 5,931 25615.49 1998.008 133 15,171

40 1,405 5,757 18641.46 1454.034 146 7,162

40 5,548 4,418 18775.49 1464.488 147 9,966

40 456 3,972 11525.96 899.0252 30 4,428

38 8,519 9,812 35992.60 2807.423 250 18,331

28 3,724 7,208 24735.32 1929.355 150 10,932

17 8,998 6,110 26026.57 2030.072 68 15,108

38 6,405 9,818 33767.77 2633.886 88 16,223

38 1,363 6,830 21170.00 1651.26 18 8,193

21 5,845 767 7982.63 790.2803 26 826

38 4,243 133 4604.89 524.9578 29 422

40 1,315 5,930 17717.38 1381.956 62 7,245

37 3,320 887 5914.48 585.533 65 2,103

9 7,756 4,595 20599.03 1606.724 36 12,351

40 6,014 2,956 14190.30 1106.843 49 8,970

18 6,361 2,203 12454.50 971.4508 43 4,282

19 4,094 4,778 17094.94 1333.405 74 8,872

19 6,522 7,530 27606.00 2153.268 192 14,052

10 6,199 2,926 14959.44 1166.837 117 9,125

14 882 8,894 27510.64 2145.83 215 9,776

14 2,889 7,394 25026.64 1952.078 196 10,283

10 2,228 3,867 12750.11 994.5083 55 6,095

37 2,284 1,986 8073.19 799.2458 62 4,270

38 8,377 8,148 31150.66 2429.751 54 16,525

38 3,114 6,206 20459.77 1595.862 35 9,320

39 9,746 4,287 21749.60 1696.469 151 7,016

14 662 8,441 25140.90 1960.99 22 9,103

40 7,472 9,829 34609.87 2699.57 180 17,301

28 7,075 285 7901.50 782.2485 9 920

28 2,369 2,781 10155.80 792.1524 71 5,150

19 2,357 6,388 20160.36 1572.508 52 8,745

33 1,054 7,303 21217.58 1654.971 111 8,357

10 3,687 9,958 31230.83 2436 108 13,645

38 3,674 4,901 17009.62 1326.75 74 8,575

39 7,147 8,802 32892.85 2565.642 286 15,949

40 94 9,414 26453.20 2063.35 184 9,508

38 2,589 4,938 16025.30 1249.973 70 7,527

40 632 9,268 26582.40 2073.427 185 9,900

17 4,806 2,387 11728.30 914.8074 10 7,193

19 9,874 8,309 32815.15 2559.582 171 18,183

12 81 8,510 24760.00 1931.28 21 8,591

37 6,741 2,672 14556.60 1135.415 127 4,706

38 1,049 8,729 26494.04 2066.535 161 9,778

17 5,655 2,684 13156.78 1026.229 23 8,339

14 7,742 6,832 26871.60 2095.985 187 14,574

19 3,391 7,270 24474.00 1908.972 21 10,661

33 2,468 4,941 15912.46 1241.172 69 7,409

21 1,166 9,115 26688.00 2081.664 186 10,281

38 4,510 8,715 28223.52 2201.434 123 13,225

18 2,704 2,411 9423.46 932.9222 31 5,115

33 3,014 2,221 9203.93 911.1888 30 5,235

19 5,941 383 7008.42 693.8337 23 790

9 8,213 7,495 29101.57 2269.922 76 15,708

18 6,910 9,752 33445.19 2608.725 145 16,662

25 7,426 2,186 13820.05 1077.964 120 4,806

19 2,440 7,474 23075.71 1799.906 120 9,914

18 5,446 5,472 21665.01 1689.871 0 10,918

40 7,846 8,573 31850.40 2484.331 222 16,419

9 9,857 2,957 18098.16 1411.656 47 6,407

12 6,603 6,389 23987.47 1871.023 104 12,992

28 1,231 9,151 28629.09 2233.069 224 10,382

40 6,391 5,232 21642.28 1688.098 132 11,623

28 156 8,913 25112.40 1958.767 175 9,069

9 4,496 8,993 29676.40 2314.759 206 13,489

19 2,970 4,212 14742.54 1149.918 26 7,182

17 4,231 6,048 20959.77 1634.862 73 10,279

38 1,565 8,526 25105.29 1958.212 131 10,091

38 705 5,696 16579.75 1293.221 43 6,401

28 7,561 3,420 16866.82 1315.612 73 5,490

12 7,700 8,921 32634.20 2545.467 57 16,621

28 4,575 8,150 28210.00 2200.38 24 12,725

19 7,143 2,713 14739.40 1149.673 103 4,928

40 1,769 8,318 24402.28 1903.378 106 10,087

40 7,589 2,877 15975.46 1246.085 97 5,233

33 4,837 9,467 30975.39 2416.08 161 14,304

40 9,706 6,535 27919.05 2177.686 73 16,241

33 4,464 9,688 31590.40 2464.051 220 14,152

40 5,949 1,306 9502.63 940.76 52 3,627

19 2,401 9,727 29636.60 2311.655 206 12,128

40 2,773 2,398 9456.23 936.1664 31 5,171

18 3,818 8,596 27843.82 2171.818 48 12,414

38 6,512 8,631 30678.80 2392.946 213 15,143

18 1,791 545 3273.94 373.2297 21 1,168

38 2,424 9,215 30013.71 2341.069 235 11,639

33 9,547 2,371 16154.98 1260.088 42 5,959

18 1,312 2,030 6996.00 692.604 62 3,342

40 7,531 3,856 19075.86 1487.917 149 11,387

9 6,808 2,210 12909.81 1006.965 67 4,509

17 2,856 1,497 6996.70 692.6735 31 4,353

14 2,931 8,576 26652.22 2078.873 93 11,507

38 6,093 9,807 34680.41 2705.072 211 15,900

9 993 7,122 22316.27 1740.669 175 8,115

9 9,175 5,999 26722.08 2084.322 232 15,174

17 9,943 965 12632.46 985.3315 33 1,363

28 1,961 7,414 22623.82 1764.658 59 9,375

37 1,381 7,296 23225.22 1811.567 182 8,677

40 9,948 4,642 22885.25 1785.05 60 14,590

28 1,422 2,192 7485.07 741.0221 33 3,614

25 8,877 4,197 21111.26 1646.678 128 13,074

28 5,895 779 8227.33 814.5053 82 834

38 3,694 9,202 29413.59 2294.26 51 12,896

19 9,948 3,840 20550.24 1602.919 107 6,894

25 9,688 747 11775.87 918.5175 20 1,304

40 5,673 7,882 27640.13 2155.93 72 13,555

14 4,377 4,538 16906.42 1318.701 88 8,915

28 8,723 1,194 12060.23 940.6979 21 1,239

39 4,953 6,722 23243.56 1813 101 11,675

33 8,059 7,694 29302.13 2285.566 153 15,753

9 1,373 9,825 29865.50 2329.509 26 11,198

28 2,717 9,479 28509.36 2223.73 124 12,196

14 6,537 8,556 30382.57 2369.841 79 15,093

18 3,152 5,671 20130.97 1570.216 158 8,823

28 1,255 3,736 11715.80 913.8324 81 4,991

39 3,585 690 5603.25 554.7218 62 2,137

28 7,463 2,774 15194.14 1185.143 40 5,118

39 7,750 4,444 20135.43 1570.563 52 12,194

37 2,094 5,170 17216.25 1342.868 150 7,264

39 5,873 6,731 24457.29 1907.669 127 12,604

40 3,445 9,728 30352.65 2367.507 105 13,173

9 976 9,168 27563.20 2149.93 24 10,144

9 4,283 448 5624.31 556.8069 56 591

40 1,171 3,556 10846.88 846.0563 47 4,727

18 7,162 9,456 33591.52 2620.139 58 16,618

18 1,733 9,188 27459.40 2141.833 191 10,921

38 6,973 6,153 24909.00 1942.902 152 13,126

39 8,966 8,251 33017.67 2575.378 201 17,217

38 9,166 3,240 18238.00 1422.564 127 6,203

28 5,169 2,879 13561.29 1057.78 82 8,048

28 2,700 734 4745.66 541.005 18 1,717

12 5,679 1,233 9131.40 904.0086 81 3,456

33 3,782 2,854 12326.88 961.4963 96 6,636

9 276 8,241 22699.76 1770.581 99 8,517

33 1,665 4,289 13674.20 1066.588 95 5,954

25 1,518 7,825 23388.88 1824.332 41 9,343

40 1,194 9,718 28355.81 2211.753 49 10,912

28 5,564 8,798 31078.20 2424.1 27 14,362

40 3,415 4,283 15835.70 1235.185 14 7,698

38 8,415 7,178 28513.40 2224.045 198 15,593

9 5,131 2,458 12296.07 959.0935 75 7,589

25 6,387 7,751 27477.47 2143.243 119 14,138

19 7,882 5,669 23726.86 1850.695 41 13,551

19 7,160 1,833 12593.01 982.2549 0 4,496

14 876 3,201 10158.90 792.3942 9 4,077

33 8,458 2,259 14706.39 1147.099 51 5,358

39 5,594 3,774 16032.88 1250.565 56 9,368

40 6,025 8,224 30647.66 2390.517 240 14,249

40 1,817 2,023 7412.62 733.8492 33 3,840

19 5,932 5,573 21096.13 1645.498 92 11,505

25 1,780 8,363 25196.40 1965.319 175 10,143

9 4,511 8,599 28295.83 2207.075 98 13,110

28 5,694 2,267 12324.97 961.348 107 3,980

18 5,434 9,013 31706.90 2473.138 193 14,447

40 4,215 8,823 28919.40 2255.713 201 13,038

18 7,468 7,421 27957.38 2180.676 146 14,889

9 7,352 5,874 23335.15 1820.142 101 13,226

39 7,051 3,215 16676.71 1300.783 131 10,266

10 1,063 8,526 24824.96 1936.347 65 9,589

38 7,279 1,473 11550.70 900.9546 10 4,376

38 7,999 9,816 36465.40 2844.301 32 17,815

33 4,469 627 6327.43 626.4154 0 637

18 677 8,714 26766.72 2087.804 210 9,391

25 7,585 6,294 25932.01 2022.697 158 13,879

10 5,100 7,024 26129.86 2038.129 205 12,124

28 7,931 7,770 31194.38 2433.162 244 15,701

9 4,168 2,555 11322.00 883.116 79 6,723

19 9,060 2,559 16212.40 1264.568 28 5,809

18 9,888 3,845 20634.78 1609.512 36 6,866

28 3,629 6,115 21454.23 1673.43 130 9,744

10 792 5,437 15803.56 1232.677 82 6,229

40 6,478 2,533 13557.74 1057.503 24 4,505

40 2,173 5,912 18259.55 1424.245 79 8,085

40 5,597 3,179 14863.79 1159.375 90 8,776

14 3,421 160 3863.56 440.4458 20 447

12 3,566 3,768 14493.20 1130.47 13 7,334

37 380 7,523 22196.70 1731.343 19 7,903

39 9,987 63 10163.40 792.7452 71 198

33 4,338 971 7023.79 695.3548 31 2,654

37 8,442 9,618 35324.31 2755.296 61 18,060

38 4,701 8,959 29078.44 2268.118 126 13,660

33 1,567 7,709 24647.75 1922.524 193 9,276

38 8,741 9,244 36417.54 2840.568 285 17,985

9 4,566 4,298 16544.53 1290.473 43 8,864

40 2,404 1,025 5234.03 518.1685 35 3,429

18 2,475 6,192 19571.11 1526.547 102 8,667

21 1,177 9,732 28047.05 2187.67 146 10,909

14 7,011 8,654 32661.46 2547.594 0 15,665

38 2,829 4,434 15222.03 1187.318 26 7,263

38 7,447 6,962 28291.23 2206.716 221 14,409

13 1,945 9,411 30121.53 2349.48 236 11,356

9 3,170 4,393 15321.04 1195.041 53 7,563

39 6,567 5,877 22822.78 1780.177 79 12,444

40 662 2,603 8275.78 819.3017 91 3,265

37 838 6,582 19182.03 1496.199 50 7,420

28 7,435 829 9690.71 959.3802 53 1,033

39 1,201 2,738 8867.40 877.8726 78 3,939

10 2,046 4,534 15307.95 1194.02 133 6,580

25 9,272 4,990 23867.75 1861.685 208 14,262

9 1,276 3,188 10094.01 787.3326 35 4,464

10 7,055 3,484 16674.32 1300.597 87 5,269

33 370 7,647 21781.60 1698.965 151 8,017

10 1,394 8,417 25803.30 2012.657 22 9,811

28 2,251 7,511 23026.43 1796.061 80 9,762

12 9,915 6,289 28744.27 2242.053 225 16,204

12 5,882 9,147 31374.69 2447.226 82 15,029

25 5,606 4,464 18551.60 1447.025 16 10,070

19 8,393 7,395 28847.57 2250.11 100 15,788

28 6,299 9,040 32650.60 2546.747 199 15,339

28 8,458 7,308 28920.40 2255.791 201 15,766

40 4,516 1,441 8436.96 835.2591 47 2,978

28 8,855 2,325 15274.32 1191.397 80 5,590

40 1,778 4,661 15364.82 1198.456 93 6,439

40 4,480 4,847 18536.30 1445.831 16 9,327

40 207 984 2962.20 337.6908 30 1,191

28 4,406 9,186 29401.11 2293.286 128 13,592

9 4,394 397 5490.12 543.5216 36 598

19 8,759 4,009 19667.49 1534.064 85 12,768

38 3,430 7,937 25383.74 1979.932 88 11,367

40 2,906 4,213 14559.16 1135.614 51 7,119

17 181 4,817 14270.72 1113.117 124 4,998

19 6,942 4,184 18494.02 1442.534 96 11,126

21 9,287 4,544 21651.22 1688.795 94 13,831

33 8,676 2,801 16518.80 1288.466 115 5,738

CUADRO RESUMEN POR DIAS DE ATRASO

=Soles + Dólares x TcambioDías de Atraso

=Monto x Tasa0123456789

10

ESTADO DE CUENTAS VENCIDAS Total

Saldo Crear la siguiente Tabla dinánica:

9616.53

19561.53

3015.66

3980.23

9955.59

13235.82

8832.99

8326.53

15801.11

9382.88

11335.23

4601.69

9925.78

10532.29

15450.09

8446.38

12989.34

9287.04 Preguntas:10349.95

19285.43 a) Suma del Monto en Soles del distrito de Surco, con más de 3 dias de atraso.14681.30

19256.91

18633.37

10085.02

4478.38

-Monto

Agencia (Todas)Cliente (Todas)

Distrito Soles Dólares Total Interés Mora Saldo PagoCALLAO 135,483.00 109,543.00 447,708.57 35,230.46 1,778.77 258,698.80 226,019.00 LA VICTORIA 362,127.00 444,313.00 1,632,186.92 128,908.02 8,551.58 1,026,073.51 743,573.00 LIMA 189,521.00 183,235.00 710,927.23 55,851.50 2,676.92 442,618.65 326,837.00 LINCE 267,317.00 288,562.00 1,093,442.46 86,754.81 5,512.96 686,266.23 499,444.00 MIRAFLORES 188,043.00 234,669.00 857,305.94 68,054.24 3,620.17 558,420.35 370,560.00 SAN BORJA 159,027.00 181,442.00 673,867.01 52,995.52 1,985.81 413,837.34 315,011.00 SAN ISIDRO 66,198.00 92,981.00 332,175.80 25,909.71 1,325.01 214,529.53 144,881.00 SAN MIGUEL 677,140.00 783,112.00 2,916,588.13 230,859.30 11,004.96 1,801,140.39 1,357,312.00 SURCO 99,844.00 86,686.00 347,274.60 28,151.62 1,927.39 211,760.62 165,593.00 Total general 2,144,700.00 2,404,543.00 9,011,476.66 712,715.18 38,383.58 5,613,345.41 4,149,230.00

5739.81

19400.26

11203.34

15274.60

20743.96 b) Suma del Monto Total en el distrito de La Victoria, superiores a 15,000.14000.11

11382.58

6247.26

18052.43

3399.26

7846.48

10255.82

4937.59

10359.35 c) Cuantos clientes cancelaron mas de la mitad de su deuda.13078.60

5046.92

8384.62

17681.85

5618.57

11276.67

8400.59

21488.16

11202.36

2826.05

10467.60 d) Cuantos clientes tienen su deuda en soles mayor que la de dolares.17248.16

20381.89

12061.96

15074.11

12052.68

13863.33

16299.63

5877.95

9044.01

13881.76

12071.81

5127.14

6000.03

15940.09 Distrito

13846.81 CALLAO

14767.15 LA VICTORIA

7324.80 LIMA

19053.94 LINCE

14772.17 MIRAFLORES

11841.32 SAN BORJA

18012.79 SAN ISIDRO

15789.12 SAN MIGUEL

8994.87 SURCO

15203.05 Total Result

11602.43

11184.99

7212.33

21322.74

12529.25

13880.24

16654.48

19241.70

17845.35

14425.53

12278.03

10348.58

4656.28

8132.92

8801.11

7824.97

5373.86

18898.57

15338.46

17399.18

10325.96

18382.43

16501.80

4724.78

17774.95

8610.37

9341.86

18435.50

21422.70

14263.54

5681.68

4280.15

6528.61

7952.88

19216.31

17625.25

19661.70

11191.32

5544.55

13434.62

8830.46

12464.88

8569.52

9766.51

19321.78

21724.39

13253.28

3301.23

14986.85

19100.27

21154.18

18052.94

20453.82

13745.76

16011.33

20648.95

8887.47

20639.04

21521.38

15929.20

17832.06

19985.88

18684.77

10302.32

14468.96

3256.73

9393.52

15703.25

18335.81

5732.65

18905.05

9602.75

15383.12

11069.23

17872.98

19291.35

4513.09

12490.67

3281.41

11329.58

8425.49

13185.63

17441.40

8015.80

4980.80

10589.48

12657.69

8368.88

17965.83

14690.27

19164.57

10420.01

13485.58

9267.92

16784.04

11335.69

5663.43

13337.92

7430.95

18848.51

17084.70

3134.73

7390.14

19956.86

21511.99

17337.11

14342.50

18221.26

21596.24

7535.77

18405.77

18079.12

21814.06

18167.05

15475.64

13247.64

15433.98

876.87

5913.77

14317.87

19058.08

12552.80

6370.44

17104.43

11158.95

13829.58

11941.12

20008.85

10643.65

10595.77

10618.45

2620.88

10093.10

23021.93

11572.72

9350.90

7925.33

4941.17

11888.61

4209.03

12302.55

12575.99

13079.40

10420.94

8026.98

20719.33

15883.13

13016.37

20266.52

14646.61

7973.28

4737.09

11915.84

4462.39

9890.47

6376.40

9187.18

9630.55

15899.25

7118.37

20095.79

16891.60

7704.96

4664.80

17109.43

12771.11

16581.32

18020.68

20188.80

7772.44

5868.58

13040.33

14626.13

20130.24

9835.21

19795.68

19192.52

9817.83

18940.69

5460.27

17362.74

18121.74

11112.67

18943.72

5866.82

14580.46

15743.18

9813.71

18674.26

17322.46

5272.51

4910.52

6935.41

15739.22

19537.10

10212.26

15081.87

12436.88

18137.23

13149.91

12970.62

20704.25

11839.02

18176.81

18708.54

8736.02

12388.38

17103.33

11515.12

12765.65

18615.25

17709.83

11063.58

16324.58

12085.71

19248.89

13928.38

20122.14

6868.77

20026.36

5252.63

17649.92

18142.10

2499.96

20950.70

11498.10

4408.41

9326.09

9475.05

3367.21

17316.60

21696.42

16116.61

13864.89

12287.66

15072.35

16541.58

10139.86

4645.08

9812.34

8289.64

18862.86

15366.25

11410.80

16312.99

9398.22

11782.84

13482.46

15987.40

21022.89

18660.84

17738.48

13035.76

7720.11

4082.91

11300.82

9564.39

11444.91

13888.41

19652.51

19593.02

5646.05

7013.02

19651.91

18871.20

13877.40

18576.87

13584.40

6653.55

3587.72

6660.07

6748.86

16051.88

8881.88

15910.77

19704.73

19167.23

9386.61

15342.74

5740.95

15601.99

12067.69

9079.27

6883.10

10546.54

7971.10

19029.06

4339.14

11328.21

17193.95

17491.13

9413.56

19925.89

18338.23

15394.75

12030.59

7842.02

17236.91

8085.67

21526.30

6316.84

19673.03

14233.44

16248.51

18170.70

5560.85

11696.09

15414.07

13514.15

10889.59

10133.75

11678.06

7337.57

3876.62

8302.23

16044.28

10828.83

5096.10

20080.86

17812.78

17487.19

21558.15

9014.05

2357.83

12532.65

19471.88

19544.05

9172.74

16310.38

21350.78

9006.26

12238.18

5921.56

13308.15

9670.51

5884.61

10055.16

11675.10

6452.38

12792.82

15615.04

18027.32

15140.42

15007.30

18874.56

9944.70

15409.82

20056.94

15611.32

6340.73

10955.32

10217.73

10671.20

2139.04

18230.02

5471.97

8518.93

16084.79

8626.31

10510.00

8906.94

9603.00

12184.14

CUADRO RESUMEN POR DIAS DE ATRASO

# Clientes Monto en soles Dolares 0 - - 0 - - 1 1,403.00 1,383.00 0 - - 0 - - 0 - - 1 168.00 4,430.00 0 - - 1 8,869.00 7,384.00 0 - - 1 7,386.00 2,614.00

4 17,826.00 15,811.00

Crear la siguiente Tabla dinánica:

a) Suma del Monto en Soles del distrito de Surco, con más de 3 dias de atraso.

Rpta: {=SUMA(SI((Distrito="surco")*(HOY()-C18> 3),F18))} 48799 RPTA

Agencia (Todas)Cliente (Todas)

Distrito Soles Dólares Total Interés Mora Saldo PagoCALLAO 135,483.00 109,543.00 447,708.57 35,230.46 1,778.77 258,698.80 226,019.00 LA VICTORIA 362,127.00 444,313.00 1,632,186.92 128,908.02 8,551.58 1,026,073.51 743,573.00 LIMA 189,521.00 183,235.00 710,927.23 55,851.50 2,676.92 442,618.65 326,837.00 LINCE 267,317.00 288,562.00 1,093,442.46 86,754.81 5,512.96 686,266.23 499,444.00 MIRAFLORES 188,043.00 234,669.00 857,305.94 68,054.24 3,620.17 558,420.35 370,560.00 SAN BORJA 159,027.00 181,442.00 673,867.01 52,995.52 1,985.81 413,837.34 315,011.00 SAN ISIDRO 66,198.00 92,981.00 332,175.80 25,909.71 1,325.01 214,529.53 144,881.00 SAN MIGUEL 677,140.00 783,112.00 2,916,588.13 230,859.30 11,004.96 1,801,140.39 1,357,312.00 SURCO 99,844.00 86,686.00 347,274.60 28,151.62 1,927.39 211,760.62 165,593.00 Total general 2,144,700.00 2,404,543.00 9,011,476.66 712,715.18 38,383.58 5,613,345.41 4,149,230.00

# Clientes

=CONTAR.SI(Fecha_Vencimiento,HOY()-N4)

Dólares

=SUMAR.SI(Fecha_Vencimiento,HOY()-N4,INDIRECTO(P$3))

Monto en soles

=SUMAR.SI(Fecha_Vencimiento;HOY()-N4;Soles)

FORMULAS PARA EL CUADRO RESUMEN POR DIAS DE ATRASO

b) Suma del Monto Total en el distrito de La Victoria, superiores a 15,000.

Rpta: {=SUMA(SI((Distrito="La Victoria")*(H18>15000),H18))} 1460349.763

c) Cuantos clientes cancelaron mas de la mitad de su deuda.

Rpta: 1 157

d) Cuantos clientes tienen su deuda en soles mayor que la de dolares.

Rpta:

RPTA D : 58

Data

Suma de Soles Suma de Dólares Suma de Total Suma de Interés Suma de Mora

135,483 109,543 445875.83 35082.19839 2,693

362,127 444,313 1631658.45 128874.465798 8,083

189,521 183,235 702006.48 55158.372315 3,137

267,317 288,562 1094105.35 86799.00456 5,249

188,043 234,669 853714.17 67760.351391 4,182

159,027 181,442 670722.96 52751.213949 3,164

66,198 92,981 331448.48 25852.981362 1,821

677,140 783,112 2892781.58 228971.144718 13,764

99,844 86,686 345586.46 28011.077031 1,325

2,144,700 2,404,543 8967899.76 709260.809514 43,419

???

RPTA B

# Clientes

=CONTAR.SI(Fecha_Vencimiento,HOY()-N4)

Dólares

=SUMAR.SI(Fecha_Vencimiento,HOY()-N4,INDIRECTO(P$3))

=F18+G18*CONSULTAV(C18;tcambio;2;0)

FORMULA PARA EL TOTAL

Ejercicio : 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 TABLA ESTADO DE CUENTAS VENCIDAS 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)-H18d) Para el calculo del Saldo, que es la suma del Total+ Interes + Mora - ACuenta:

=SUMA(H18:J18)-K18

Monto en soles

=SUMAR.SI(Fecha_Vencimiento;HOY()-N4;Soles)

FORMULAS PARA EL CUADRO RESUMEN POR DIAS DE ATRASO

=F18+G18*BUSCARV(C18,TCAMBIO,2,0) =F18+G18*CONSULTAV(C18;tcambio;2;0)

FORMULA PARA EL TOTAL










=SUMA(H18:J18)-K18

FORMULA PARA EL INTERES

PRIMERO VAMOS A CALCULAR EL TOTAL, PRIMERO DAR EL NOMBRE DE RANGO A TODA LA TABLA EJEM TCAMBIO , EL RANGO DE LA TABLA DEBE INCLUIR LOS TITULOS, ESTO ME SERVIRA PARA HACER UNA BUSQUEDA EXACTA, EN LA CELDA H18, COLOCAMOS ;B1:C13 .......TCAMBIO PONER COMO NOMBRE AL RANGOEN H18: COLOCAMOS LA FORMULA =F18+G18*BUSCARV(C18,TCAMBIO,2,0)2) CALCULO DEL INTERESDAR NOMBRE AL RANGO DE E4:G8 ............TASASEN I18.................. =H18*BUSCARV(H18,TASAS,2)PARA CALCULAR LA FORMULA DEL INTERES TENDREMOS:

=H18*(1+CONSULTAV(H18,TASAS,3))^(HOY()-C18)-H18

=F18+G18*BUSCARV(C18,TCAMBIO,2,0)










=SUMA(H18:J18)-K18

PRIMERO VAMOS A CALCULAR EL TOTAL, PRIMERO DAR EL NOMBRE DE RANGO A TODA LA TABLA EJEM TCAMBIO , EL RANGO DE LA TABLA DEBE INCLUIR LOS TITULOS, ESTO ME SERVIRA PARA HACER UNA BUSQUEDA EXACTA, EN LA CELDA H18, COLOCAMOS ;B1:C13 .......TCAMBIO PONER COMO NOMBRE AL RANGOEN H18: COLOCAMOS LA FORMULA =F18+G18*BUSCARV(C18,TCAMBIO,2,0)2) CALCULO DEL INTERESDAR NOMBRE AL RANGO DE E4:G8 ............TASASEN I18.................. =H18*BUSCARV(H18,TASAS,2)PARA CALCULAR LA FORMULA DEL INTERES TENDREMOS:

=H18*(1+CONSULTAV(H18,TASAS,3))^(HOY()-C18)-H18

Ejercicio de Repaso:

1.- En la hoja Tablas definir los siguientes nombres de rango:B3:C13 ====> TCAMBIOE4:G8 ====> TABLA

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




=SUMA(H18:J18)-K18

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.


15 Cuentas Vencidas Por Resolver Prof Freyre

Documents

Transcript of 15 Cuentas Vencidas Por Resolver Prof Freyre