maria alejandra perez - taller 10 8c.xlsx

3
# MARCA PRECIO IVA 26% chevrolet corsa ci $ 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 XLT4x4 $ 66,600,000 $ 13,986,000 7 Peugeot306 $ 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 Mitsubushu Lancer $ 39,800,000 $ 8,358,000 11 volkswagen suran $ 29,500,000 $ 6,195,000 TOTALES $ 509,940,000 $ 107,087,400 $ 88,644,600 $ 39,264,500 $ 2,570,948 $ 1,739,506 Mayor precio con interés Menor precio con interés Promedio valor en 24 cuotas Promedio valor en 36 cuotas

Upload: jorge-loaiza

Post on 12-Feb-2016

7 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: maria alejandra perez - taller 10 8c.xlsx

Compra venta de automoviles # MARCA PRECIO IVA 26% PRECIO CONTADO

chevrolet corsa city $ 39,450,000 $ 8,284,500 $ 47,734,500 2 citroen c4 $ 63,000,000 $ 13,230,000 $ 76,230,000 3 fiat palio weekend $ 54,400,000 $ 11,424,000 $ 65,824,000 4 honda accord $ 37,200,000 $ 7,812,000 $ 45,012,000 5 toyota celica $ 62,900,000 $ 13,209,000 $ 76,109,000 6 Ford Ranger XLT4x4 $ 66,600,000 $ 13,986,000 $ 80,586,000 7 Peugeot306 $ 45,000,000 $ 9,450,000 $ 54,450,000 8 Renault Laguna $ 39,500,000 $ 8,295,000 $ 47,795,000 9 Susuki fun $ 32,590,000 $ 6,843,900 $ 39,433,900

10 Mitsubushu Lancer $ 39,800,000 $ 8,358,000 $ 48,158,000 11 volkswagen suran $ 29,500,000 $ 6,195,000 $ 35,695,000

TOTALES $ 509,940,000 $ 107,087,400 $ 617,027,400

$ 88,644,600

$ 39,264,500

$ 2,570,948

$ 1,739,506

Mayor precio con interés

Menor precio con interés

Promedio valor en 24 cuotas

Promedio valor en 36 cuotas

Page 2: maria alejandra perez - taller 10 8c.xlsx

Compra venta de automoviles INTERÉS 10%

$ 4,773,450 $ 52,507,950 $ 2,187,831 $ 1,458,554 $ 7,623,000 $ 83,853,000 $ 3,493,875 $ 2,329,250 $ 6,582,400 $ 72,406,400 $ 3,016,933 $ 2,011,289 $ 4,501,200 $ 49,513,200 $ 2,063,050 $ 1,375,367 $ 7,610,900 $ 83,719,900 $ 3,488,329 $ 2,325,553 $ 8,058,600 $ 88,644,600 $ 3,693,525 $ 2,462,350 $ 5,445,000 $ 59,895,000 $ 2,495,625 $ 1,663,750 $ 4,779,500 $ 52,574,500 $ 2,190,604 $ 1,460,403 $ 3,943,390 $ 43,377,290 $ 1,807,387 $ 1,204,925 $ 4,815,800 $ 52,973,800 $ 2,207,242 $ 1,471,494 $ 3,569,500 $ 39,264,500 $ 1,636,021 $ 1,090,681

$ 61,702,740 $ 678,730,140 $ 28,280,423 $ 18,853,615

PRECIO CON INTERÉS

VALOR A 24 CUOTAS

VALOR A 36 CUOTAS

Page 3: maria alejandra perez - taller 10 8c.xlsx

10%

21%