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

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

Embed Size (px)

DESCRIPTION

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

Citation preview

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