consesionaria de automóviles

12
 1 23 FORD 2 Modelo Cilindraje 3 1 4 2 Kia Base  1 5 3 Kia Plus  1 6 4 Kia Plus  1.6 7 5 Kia Plus  1.6 8 6 Kia XR Sport  1.6 9 7 Kia Black  1.6 10 8 Fiesta LX 3p  1.6 11 9 Fiesta LX 5p  1.6 12 10 Fiesta LX D 5p  1.8 13 11 Fiesta CLX Motor 1! L  1.6 14 12 Fiesta CLX Motor 1! L Sport  1.6 15 13 Fiesta CLX D  1.8 16 14 Ford "a#i $a%ta &p  1.6 17 15 Ford "a#i Diesel &p  1.8 18 16 'scort Cross $a%ta 5p  1.6 19 17 'scort Cross "D( 5p  1.8 20 18 'scort LX $a%ta 5p Plus  1.6 21 19 'scort LX "D( 5p Plus  1.8 22 20 'scort CLX $a%ta 1!) 5p  1.8 23 21 'scort CLX "D( 1!) 5p  1.8 24 22 'scort Station *a+on  1.6 25 23 Focus LX $a%ta 1!) 5p  1.8 26 24 Focus CLX $a%ta 1!) 5p  1.8 27 25 Focus LX "D( 5p  1.8 28 26 Focus ,-ia $a%ta 1!) 5p  2 29 27 Focus ,-ia $a%ta 1!) &p  2 30 28 Focus ,-ia "D( 5p  1.8 31 29 Focus ,-ia "D( &p  1.8 32 30 Mondeo ,-ia $a%ta 1!) &p  2 33 31 Mondeo ,-ia $a%ta .!  2.5 34 32 Mondeo ,-ia "D( 1!) &p  2 35 33 '#plorer &#& Li/ited  4 36 34 '#plorer &#& Sport  4 37 35 '#plorer XL " &#0  4 38 36 'scape &#0 XLS  2 39 37 'scape &#& XLS  2 40 38 'scape &#& XL"  2 41 39 Courier .an  1.8 42 40 Courier Pickup Diesel  1.8 43 41 Courier Pickup Diesel 22  1.8 44 42 "ransit 33 "D( 10 C. 1!)  2.4 45 43 "ransit 33 "D( 10 C.  2.4

Upload: sara-maria-lemus-b

Post on 07-Oct-2015

212 views

Category:

Documents


0 download

DESCRIPTION

ejercicio con formulas de excel

TRANSCRIPT

Base de Datos123FORDTRUE602ModeloCilindrajePrecio531242Kia Base110490853Kia Plus11219064Kia Plus1.61199075Kia Plus1.61369086Kia XR Sport1.61484097Kia Black1.615490108Fiesta LX 3p1.611990119Fiesta LX 5p1.6121901210Fiesta LX D 5p1.8135901311Fiesta CLX Motor 1,6 L1.6142801412Fiesta CLX Motor 1,6 L Sport1.6162301513Fiesta CLX D1.8159701614Ford Taxi Nafta 4p1.6129901715Ford Taxi Diesel 4p1.8147001816Escort Cross Nafta 5p1.6129901917Escort Cross TDI 5p1.8147902018Escort LX Nafta 5p Plus1.6146902119Escort LX TDI 5p Plus1.8164002220Escort CLX Nafta 16v 5p1.8163002321Escort CLX TDI 16v 5p1.8186002422Escort Station Wagon1.6153002523Focus LX Nafta 16v 5p1.8177902624Focus CLX Nafta 16v 5p1.8202002725Focus LX TDI 5p1.8209902826Focus Ghia Nafta 16v 5p2222002927Focus Ghia Nafta 16v 4p2234003028Focus Ghia TDI 5p1.8225003129Focus Ghia TDI 4p1.8237003230Mondeo Ghia Nafta 16v 4p2307003331Mondeo Ghia Nafta V62.5379003432Mondeo Ghia TDI 16v 4p2326003533Explorer 4x4 Limited4445173634Explorer 4x4 Sport4392133735Explorer XLT 4x24313103836Escape 4x2 XLS2296903937Escape 4x4 XLS2319704038Escape 4x4 XLT2359204139Courier Van1.8142004240Courier Pick-up Diesel1.8132504341Courier Pick-up Diesel AA1.8144904442Transit 330 TDI 120 CV 16v2.4231004543Transit 330 TDI 120 CV2.4247504644Transit 350 TDI 120 CV 16v2.4263004745Transit 350 TDI 1202.4279504846F-100 XL TDI3.9257504947F-100 XL TDI AAA3.9277505048F-100 XLT TDI AA (MWM)4.2318505149Ranger XL 4x2 TDI Plus2.8212005250Ranger XL 4x2 "F-Truck"2.8189005351Ranger XL 4x4 TDI2.8233005452Ranger d/cab XL 4x2 TDI2.8217005553Ranger d/cab XL 4x2 TDI p2.8324005654Ranger d/cab XLT 4x2 TDI2.8265005755Ranger d/cab XLT 4x4 TDI2.8300005856Ranger d/cab Limited TDI2.8329005957

FormularioFinanciamiento MximoNmero de cuotaFechaAmortizacinIntersCuota11Martes, 28 de febrero de 2012223.9071186574.4422589061228.3493775631Ford22223.9071186574.4422589061228.349377563133223.9071186574.4422589061228.349377563144223.9071186574.4422589061228.349377563155223.9071186574.4422589061228.3493775631ModeloCilindrajePrecio66223.9071186574.4422589061228.3493775631Focus LX Nafta 16v 5p1.81779077223.9071186574.4422589061228.349377563188223.9071186574.4422589061228.349377563199223.9071186574.4422589061228.3493775631 Ejecucion de la Operacin1010223.9071186574.4422589061228.3493775631Contado1111223.9071186574.4422589061228.3493775631Financiado1212223.9071186574.4422589061228.34937756311313223.9071186574.4422589061228.3493775631Financiamiento1414223.9071186574.4422589061228.34937756311515223.9071186574.4422589061228.3493775631Q223.911616223.9071186574.4422589061228.34937756311717223.9071186574.4422589061228.34937756311818223.9071186574.4422589061228.3493775631ImporteQ17,790.001919223.9071186574.4422589061228.3493775631Anticipo60%Q10,674.002020223.9071186574.4422589061228.3493775631Saldo a FinanciarQ7,116.002121223.9071186574.4422589061228.3493775631Tasa0.0052222223.9071186574.4422589061228.3493775631Plazo en aos22323223.9071186574.4422589061228.34937756312424223.9071186574.4422589061228.3493775631Fraccin meses82525223.9071186574.4422589061228.3493775631Periodicidad122626223.9071186574.4422589061228.34937756312727223.9071186574.4422589061228.3493775631Fecha de cuota No. 1Martes, 28 de febrero de 20122828223.9071186574.4422589061228.34937756312929223.9071186574.4422589061228.34937756313030223.9071186574.4422589061228.34937756313131223.9071186574.4422589061228.34937756313232223.9071186574.4422589061228.34937756313333223.9071186574.4422589061228.34937756313434223.9071186574.4422589061228.34937756313535223.9071186574.4422589061228.34937756313636223.9071186574.4422589061228.34937756313737223.9071186574.4422589061228.34937756313838223.9071186574.4422589061228.34937756313939223.9071186574.4422589061228.34937756314040223.9071186574.4422589061228.34937756314141223.9071186574.4422589061228.34937756314242223.9071186574.4422589061228.34937756314343223.9071186574.4422589061228.34937756314444223.9071186574.4422589061228.34937756314545223.9071186574.4422589061228.34937756314646223.9071186574.4422589061228.34937756314747223.9071186574.4422589061228.34937756314848223.9071186574.4422589061228.34937756314949223.9071186574.4422589061228.34937756315050223.9071186574.4422589061228.34937756315151223.9071186574.4422589061228.34937756315252223.9071186574.4422589061228.34937756315353223.9071186574.4422589061228.34937756315454223.9071186574.4422589061228.34937756315555223.9071186574.4422589061228.34937756315656223.9071186574.4422589061228.34937756315757223.9071186574.4422589061228.34937756315858223.9071186574.4422589061228.34937756315959223.9071186574.4422589061228.34937756316060223.9071186574.4422589061228.3493775631

Hoja3