taller 10 aplicacion de formulas michael stiven marin quintero 8c (1)

5
MARCA PRECIO IVA 21 % 1 cheverolet corsa city $ 39,450,000 $ 8,284,500 2 citroen C4 $ 63,000,000 $ 13,230,000 3 fiat palio weekend $ 54,400,000 $ 11,424,000 4 honda accord $ 37,200,000 $ 7,812,000 5 toyota celica $ 62,900,000 $ 13,209,000 6 ford ranger xlt 4x4 $ 66,600,000 $ 13,986,000 7 peugeot 306 $ 45,000,000 $ 9,450,000 8 renault laguna $ 39,500,000 $ 8,295,000 9 susuki fun $ 32,590,000 $ 6,843,900 10 mitsubishi lancer $ 39,800,000 $ 8,358,000 11 volkswagen suran $ 29,500,000 $ 6,195,000 TOTALES $ 407,590,000 $ 98,802,900 $ 88,644,600 $ 39,264,500 $ 2,570,948 $ 1,713,965 MAYOR PRECIO CON INTERES MENOR PRECIO CON INTERES PROMEDIO VALOR A 24 CUOTAS PROMEDIO VALOR A 36 CUOTAS

Upload: maicolmarin

Post on 18-Aug-2015

5 views

Category:

Documents


2 download

DESCRIPTION

Taller 10 Aplicacion de Formulas Michael Stiven Marin Quintero 8C (1)

TRANSCRIPT

MARCA PRECIO IVA 21 %1cheverolet corsa city $ 39,450,000 $ 8,284,5002citroenC4 $ 63,000,000 $ 13,230,0003fat palio weekend $ 54,400,000 $ 11,424,0004honda accord $ 3,200,000 $ ,812,0005toyota celica $ 62,900,000 $ 13,209,0006!ord ran"er #lt 4#4 $ 66,600,000 $ 13,986,000pe$"eot 306 $ 45,000,000 $ 9,450,0008rena$lt la"$na$ 39,500,000 $ 8,295,0009s$s$ki !$n $ 32,590,000 $ 6,843,90010%its$&ishi lancer $ 39,800,000 $ 8,358,00011volkswa"en s$ran $ 29,500,000 $ 6,195,000'(')*+, $ 40,590,000 $ 98,802,900$ 88,644,600$ 39,264,500$ 2,50,948$ 1,13,965-).(/ 0/+C1( C(2 12'+/+,-+2(/ 0/+C1( C(2 12'+/+,0/(-+31( 4)*(/ ) 24 C5('),0/(-+31( 4)*(/ ) 36 C5('),INTERES 10 %$ 4,34,500 $ 4,3,450 $ 52,50,950 $ 2,18,831$ 6,230,000 $ ,623,000 $ 83,853,000 $ 3,493,85$ 65,824,000 $ 6,582,400 $ 2,406,400 $ 3,016,933$ 45,012,000 $ 4,501,200 $ 49,513,200 $ 2,063,050$ 6,109,000 $ ,610,900 $ 83,19,900 $ 3,488,329$ 80,586,000 $ 8,058,600 $ 88,644,600 $ 3,693,525$ 54,450,000 $ 5,445,000 $ 59,895,000 $ 2,495,625$ 4,95,000 $ 4,9,500 $ 52,54,500 $ 2,190,604$ 39,433,900 $ 3,943,390 $ 43,3,290 $ 1,80,38$ 48,158,000 $ 4,815,800 $ 52,93,800 $ 2,20,242$ 35,695,000 $ 3,569,500 $ 39,264,500 $ 1,636,021$ 569,292,900 $ 56,929,290 $ 626,222,190 $ 26,092,591216 106 24PRECIO CONTADOPRECIO CON INTERESVFALOR 24 CUOTAS$ 1,458,554$ 2,329,250$ 2,011,289$ 1,35,36$ 2,325,553$ 2,462,350$ 1,663,50$ 1,460,403$ 1,204,925$ 1,41,494$ 1,090,681$ 1,395,06136VALOR A 36 CUOTASPROYECCIN DE AUMENTO DE PRECIOS 2010 2011 2012$ 15,000 $ 450 $ 15,450 $ 3 $ 16,223 $ 324$ 16,550 $ 49 $ 1,04 $ 852 $ 1,899 $ 358$ 1,000 $ 510 $ 1,510 $ 86 $ 18,386 $ 368$ 19,900 $ 59 $ 20,49 $ 1,025 $ 21,522 $ 430$ 23,25 $ 698 $ 23,93 $ 1,199 $ 25,12 $ 503$ 23,00 $ 11 $ 24,411 $ 1,221 $ 25,632 $ 513$ 25,050 $ 52 $ 25,802 $ 1,290 $ 2,092 $ 542$ 26,950 $ 809 $ 2,59 $ 1,388 $ 29,146 $ 583$ 31,50 $ 953 $ 32,03 $ 1,635 $ 34,338 $ 68$ 39,800 $ 1,194 $ 40,994 $ 2,050 $ 43,044 $ 861$ 43,600 $ 1,308 $ 44,908 $ 2,245 $ 4,153 $ 943$ 45,200 $ 1,356 $ 46,556 $ 2,328 $ 48,884 $ 98$ 51,100 $ 1,533 $ 52,633 $ 2,632 $ 55,265 $ 1,105$ 62,300 $ 1,869 $ 64,169 $ 3,208 $ 6,3 $ 1,348$ 62,400 $ 1,82 $ 64,22 $ 3,214 $ 6,486 $ 1,35036 56 26DIFERENCIA EN PESOSDIFERENCIA EN PESOSDIFERENCIA EN PESOSPROYECCIN DE AUMENTO DE PRECIOS 2013$ 16,54$ 18,25$ 18,53$ 21,952$ 25,65$ 26,144$ 2,633$ 29,29$ 35,024$ 43,905$ 48,096$ 49,861$ 56,30$ 68,25$ 68,835