practicas de excel

4
Datos Financieros Cliente Importe Tipo de crédito Fecha Compra a sola firma con garantia Juan Lopez 3400 x 6/25/2006 Maria Sosa 2500 x 8/5/2006 Jose Rosas 750 x 7/8/2006 Mario Garcia 1200 x 6/21/2006 Cecilia Perez 4500 x 7/9/2006 Laura Soria 3850 x 7/19/2006 Juana Alvez 2600 x 7/12/2006 Walter Miranda 1750 x 7/24/2006 Mariana Estevez 1400 x 7/29/2006 Pablo Quintana 800 x 6/21/2006 Diana Saravia 1200 x 7/9/2006 Fernanda Castro 3600 x 7/19/2006 Monica Peña 2100 x 7/12/2006 Mauricio Gestido 6100 x 7/24/2006 Marco Perea 5050 x 7/24/2006 Leticia Costa 4750 x 8/8/2006 Esteban Da Silva 5700 x 7/21/2006

Upload: samalonar

Post on 17-Dec-2015

3 views

Category:

Documents


0 download

DESCRIPTION

tablas

TRANSCRIPT

Control financieroDatos Financieros

ClienteImporteTipo de crditoFecha CompraNro. CuotasImporte CuotaI.V.A.Total CuotaRecargoIVAa sola firma con garantia5%14%Juan Lopez3400x6/25/062851297Maria Sosa2500x8/5/06342648Jose Rosas750x7/8/065819Mario Garcia1200x6/21/06512214Cecilia Perez4500x7/9/063751186Laura Soria3850x7/19/06448755Juana Alvez2600x7/12/06265974Walter Miranda1750x7/24/06422325Mariana Estevez1400x7/29/06514216Pablo Quintana800x6/21/06313215Diana Saravia1200x7/9/06320323Fernanda Castro3600x7/19/06445651Monica Pea2100x7/12/06521324Mauricio Gestido6100x7/24/06310214116Marco Perea5050x7/24/06551758Leticia Costa4750x8/8/06459868Esteban Da Silva5700x7/21/0639513108

EstadisticaClienteNro. CuotasTotal CuotaTotal a PagarImporte U$SDlar U$S

Juan Lopez297193.8$12.78$15.16Maria Sosa348142.5$9.40Jose Rosas5942.75$2.82Mario Garcia51468.4$4.51Cecilia Perez386256.5$16.92Laura Soria455219.45$14.48Juana Alvez274148.2$9.78Walter Miranda42599.75$6.58Mariana Estevez51679.8$5.26Pablo Quintana31545.6$3.01Diana Saravia32368.4$4.51Fernanda Castro451205.2$13.54Monica Pea524119.7$7.90Mauricio Gestido3116347.7$22.94Marco Perea558287.85$18.99Leticia Costa468270.75$17.86Esteban Da Silva3108324.9$21.43Totales638852921.25$192.69

Hoja3