charts 3

5
Préstamo Bancario de Largo Plazo Monto 6,000,000 $ Tasa 20% Plazo 24 meses Pago Pago no. Saldo Inicial Capital Intereses Total Saldo Final 1 6,000,000 250,000 100,000.00 350,000.00 5,750,000 2 5,750,000 250,000 95,833.33 345,833.33 5,500,000 3 5,500,000 250,000 91,666.67 341,666.67 5,250,000 4 5,250,000 250,000 87,500.00 337,500.00 5,000,000 5 5,000,000 250,000 83,333.33 333,333.33 4,750,000 6 4,750,000 250,000 79,166.67 329,166.67 4,500,000 7 4,500,000 250,000 75,000.00 325,000.00 4,250,000 8 4,250,000 250,000 70,833.33 320,833.33 4,000,000 9 4,000,000 250,000 66,666.67 316,666.67 3,750,000 10 3,750,000 250,000 62,500.00 312,500.00 3,500,000 11 3,500,000 250,000 58,333.33 308,333.33 3,250,000 12 3,250,000 250,000 54,166.67 304,166.67 3,000,000 13 3,000,000 250,000 50,000.00 300,000.00 2,750,000 14 2,750,000 250,000 45,833.33 295,833.33 2,500,000 15 2,500,000 250,000 41,666.67 291,666.67 2,250,000 16 2,250,000 250,000 37,500.00 287,500.00 2,000,000 17 2,000,000 250,000 33,333.33 283,333.33 1,750,000 18 1,750,000 250,000 29,166.67 279,166.67 1,500,000 19 1,500,000 250,000 25,000.00 275,000.00 1,250,000 20 1,250,000 250,000 20,833.33 270,833.33 1,000,000 21 1,000,000 250,000 16,666.67 266,666.67 750,000 22 750,000 250,000 12,500.00 262,500.00 500,000 23 500,000 250,000 8,333.33 258,333.33 250,000 24 250,000 250,000 4,166.67 254,166.67 -

Upload: eo

Post on 10-Apr-2016

232 views

Category:

Documents


0 download

DESCRIPTION

Prestamo Largo Plazo

TRANSCRIPT

Page 1: Charts 3

Préstamo Bancario de Largo Plazo

Monto 6,000,000$

Tasa 20%

Plazo 24 meses

Pago

Pago no. Saldo Inicial Capital Intereses Total Saldo Final

1 6,000,000 250,000 100,000.00 350,000.00 5,750,000

2 5,750,000 250,000 95,833.33 345,833.33 5,500,000

3 5,500,000 250,000 91,666.67 341,666.67 5,250,000

4 5,250,000 250,000 87,500.00 337,500.00 5,000,000

5 5,000,000 250,000 83,333.33 333,333.33 4,750,000

6 4,750,000 250,000 79,166.67 329,166.67 4,500,000

7 4,500,000 250,000 75,000.00 325,000.00 4,250,000

8 4,250,000 250,000 70,833.33 320,833.33 4,000,000

9 4,000,000 250,000 66,666.67 316,666.67 3,750,000

10 3,750,000 250,000 62,500.00 312,500.00 3,500,000

11 3,500,000 250,000 58,333.33 308,333.33 3,250,000

12 3,250,000 250,000 54,166.67 304,166.67 3,000,000

13 3,000,000 250,000 50,000.00 300,000.00 2,750,000

14 2,750,000 250,000 45,833.33 295,833.33 2,500,000

15 2,500,000 250,000 41,666.67 291,666.67 2,250,000

16 2,250,000 250,000 37,500.00 287,500.00 2,000,000

17 2,000,000 250,000 33,333.33 283,333.33 1,750,000

18 1,750,000 250,000 29,166.67 279,166.67 1,500,000

19 1,500,000 250,000 25,000.00 275,000.00 1,250,000

20 1,250,000 250,000 20,833.33 270,833.33 1,000,000

21 1,000,000 250,000 16,666.67 266,666.67 750,000

22 750,000 250,000 12,500.00 262,500.00 500,000

23 500,000 250,000 8,333.33 258,333.33 250,000

24 250,000 250,000 4,166.67 254,166.67 -

Page 2: Charts 3

Préstamo Bancario de Largo Plazo

Monto 6,000,000$

Tasa 20%

Plazo 24 meses

Pago

Pago no. Saldo Inicial Capital Intereses Total Saldo Final

1 6,000,000 205,375 100,000.00 305,374.82 5,794,625

2 5,794,625 208,798 96,577.09 305,374.82 5,585,827

3 5,585,827 212,278 93,097.12 305,374.82 5,373,550

4 5,373,550 215,816 89,559.16 305,374.82 5,157,734

5 5,157,734 219,413 85,962.24 305,374.82 4,938,322

6 4,938,322 223,069 82,305.36 305,374.82 4,715,252

7 4,715,252 226,787 78,587.53 305,374.82 4,488,465

8 4,488,465 230,567 74,807.75 305,374.82 4,257,898

9 4,257,898 234,410 70,964.96 305,374.82 4,023,488

10 4,023,488 238,317 67,058.13 305,374.82 3,785,171

11 3,785,171 242,289 63,086.19 305,374.82 3,542,883

12 3,542,883 246,327 59,048.04 305,374.82 3,296,556

13 3,296,556 250,432 54,942.60 305,374.82 3,046,124

14 3,046,124 254,606 50,768.73 305,374.82 2,791,517

15 2,791,517 258,850 46,525.29 305,374.82 2,532,668

16 2,532,668 263,164 42,211.13 305,374.82 2,269,504

17 2,269,504 267,550 37,825.07 305,374.82 2,001,955

18 2,001,955 272,009 33,365.91 305,374.82 1,729,946

19 1,729,946 276,542 28,832.43 305,374.82 1,453,403

20 1,453,403 281,151 24,223.39 305,374.82 1,172,252

21 1,172,252 285,837 19,537.53 305,374.82 886,415

22 886,415 290,601 14,773.58 305,374.82 595,813

23 595,813 295,445 9,930.22 305,374.82 300,369

24 300,369 300,369 5,006.14 305,374.82 0

Page 3: Charts 3

Préstamo Bancario de Largo Plazo

-

50,000

100,000

150,000

200,000

250,000

300,000

350,000

400,000

1 3 5 7 9 11 13 15 17 19 21 23

Capital

Intereses

Total

-

50,000

100,000

150,000

200,000

250,000

300,000

350,000

1 3 5 7 9 11 13 15 17 19 21 23

Capital

Intereses

Total

Pagos constantes a capital Pagos totales constantes

Page 4: Charts 3

Arrendamiento Financiero

Valor del auto 650,000.00$

Plazo 36 meses

Pagos 22,551.39$

Con préstamo bancario:

Costo del periodo 1.25%

Costo anual 15.06%

Con arrandamiento financiero:

Costo del periodo 1.33%

Costo anual 16.00%

Page 5: Charts 3

Arrendamiento Financiero

Valor del auto 650,000.00$

Plazo 36 meses

Tasa 20%

Pagos:

0% enganche $23,760.32

20% enganche $19,008.26

0% enganche

20% valor final $21,139.41

20% enganche20% valor final $16,387.34