7
VA= 14750 n= 18 i= 3.85% mensual CUOTA= S/. 1,150.99 PERIODO SALDO INTERÉS AMORTIZACIÓN CUOTA 1 S/. 14,750.00 S/. 567.88 S/. 583.12 ### 2 S/. 14,166.88 S/. 545.43 S/. 605.57 ### 3 S/. 13,561.32 S/. 522.11 S/. 628.88 ### 4 S/. 12,932.44 S/. 497.90 S/. 653.09 ### 5 S/. 12,279.35 S/. 472.75 S/. 678.24 ### 6 S/. 11,601.11 S/. 446.64 S/. 704.35 ### 7 S/. 10,896.76 S/. 419.53 S/. 731.47 ### 8 S/. 10,165.30 S/. 391.36 S/. 759.63 ### 9 S/. 9,405.67 S/. 362.12 S/. 788.87 ### 10 S/. 8,616.80 S/. 331.75 S/. 819.24 ### 11 S/. 7,797.55 S/. 300.21 S/. 850.79 ### 12 S/. 6,946.77 S/. 267.45 S/. 883.54 ### 13 S/. 6,063.23 S/. 233.43 S/. 917.56 ### 14 S/. 5,145.67 S/. 198.11 S/. 952.88 ### 15 S/. 4,192.79 S/. 161.42 S/. 989.57 ### 16 S/. 3,203.22 S/. 123.32 S/. 1,027.67 ### 17 S/. 2,175.55 S/. 83.76 S/. 1,067.23 ### 18 S/. 1,108.32 S/. 42.67 S/. 1,108.32 ### TOTAL ### S/. 14,750.00 ###

PROCESAMIENTO DE DATOS

Embed Size (px)

DESCRIPTION

PROCESAMIENTO DE DATOS

Citation preview

EJERCICIO 1VA=14750n=18i=3.85%mensualCUOTA=1150.9908747114PERIODOSALDOINTERSAMORTIZACINCUOTA114750567.875583.11587471141150.9908747114214167545.4250388236605.56583588781150.9908747114313561522.1107541419628.88012056951150.9908747114412932497.8988695653.09200521141150.9908747114512279472.7548272994678.23604741211150.9908747114611601446.642739474704.34813523741150.9908747114710897419.5253362674731.46553844411150.9908747114810165391.3639130373759.62696167421150.990874711499406362.1182750128788.87259969861150.9908747114108617331.7466799244819.2441947871150.9908747114117798300.2057784251850.78509628631150.9908747114126947267.4505522181883.54032249331150.9908747114136063233.4342498021917.55662490931150.9908747114145146198.1083197431952.88255496831150.9908747114154193161.4223413768989.56853333461150.9908747114163203123.32395284341027.6669218681150.990874711417217683.75877635151067.23209835991150.990874711418110842.67034056471108.32053414681150.9908747114TOTAL5967.83574480551475020717.8357448055

DATOSNNOMBRES Y APELLIDOSDNIFECHA DE INICIOHIJOSAFPCOMISIONREMUNERACIN1CASTRO VASQUEZ VERONICA422435731/14/092PROFUTUROMIXTA7502ALEGRIA FERNANDEZ NESTOR ALFREDO445454491/21/122ONPMIXTA15003ALFARO CACEDA RICARDO439143666/25/111INTEGRAMIXTA1250AFPOBLIGATORIACOMIS. MIXT.COMIS. FLUJOSEGUROPRIMA10.00%1.51%1.60%1.30%INTEGRA10.00%1.55%1.74%1.22%PROFUTURO10.00%1.49%1.84%1.41%HORIZONTE10.00%1.65%1.85%1.38%HABITAD10.00%0.47%1.47%1.16%REMUNERACIN BSICA750ONPESSALUD9%13%MESJUNIO

PLANILLANNOMBRES Y APELLIDOSDNIFECHA DE INICIOHIJOSAFPCOMISIONREMUN. BASICAASIG. FAM.REMUNERAC. BRUTAGRATIFICACINBASE IMPONIBLEESSSALUDTOTAL APORTESAPORTES DEL TRABAJADORTOTAL DESCUENTOSONPAFPAPORT. OBLIGSEGUROCOMISIONOTROS1CASTRO VASQUEZ VERONICA422435731/14/092PROFUTUROMIXTA750758250825747408212122ALEGRIA FERNANDEZ NESTOR ALFREDO445454491/21/122ONP1500751575015751421422050003ALFARO CACEDA RICARDO439143666/25/111INTEGRAMIXTA12507513250132511911901321621