TABLAS DE AMORTIZACION

De Cuota Constante

TASA DE INTERES MENSUAL: 5.00%CAPITAL: $ 10,000,000

NUMERO DE PERIODOS: 24

PAGO: $ 724,709.01

MES SALDO INICIAL CUOTA INTERES

0 - (10,000,000) -

1 10,000,000 724,709 500,000

2 9,775,291 724,709 488,765

3 9,539,347 724,709 476,967

4 9,291,605 724,709 464,580

5 9,031,476 724,709 451,574

6 8,758,341 724,709 437,917

7 8,471,549 724,709 423,577

8 8,170,417 724,709 408,521

9 7,854,229 724,709 392,711

10 7,522,232 724,709 376,112

11 7,173,634 724,709 358,682

12 6,807,607 724,709 340,380

13 6,423,278 724,709 321,164

14 6,019,733 724,709 300,987

15 5,596,011 724,709 279,801

16 5,151,102 724,709 257,555

17 4,683,949 724,709 234,197

18 4,193,437 724,709 209,672

19 3,678,400 724,709 183,920

20 3,137,611 724,709 156,881

21 2,569,782 724,709 128,489

22 1,973,562 724,709 98,678

23 1,347,531 724,709 67,377

24 690,199 724,709 34,510

,=SI(B15<>"";C15*$E$6;"")

,=SI(B14<>"";C14*$E$6)

ABONO A CAPITAL SALDO FINAL

- 10,000,000

224,709 9,775,291 ,=SI(B14="";"";C14-F14) 235,944 9,539,347

247,742 9,291,605

260,129 9,031,476

273,135 8,758,341

286,792 8,471,549

301,132 8,170,417

316,188 7,854,229

331,998 7,522,232

348,597 7,173,634

366,027 6,807,607

384,329 6,423,278

403,545 6,019,733

423,722 5,596,011

444,908 5,151,102

467,154 4,683,949

490,512 4,193,437

515,037 3,678,400

540,789 3,137,611

567,828 2,569,782

596,220 1,973,562

626,031 1,347,531

657,332 690,199

690,199 -

TABLA DE AMORTIZACION

De Cuota Constante

TASA DE INTERES MENSUAL:

CAPITAL:

NUMERO DE PERIODOS:

PAGO: $ 456,617.16

MES SALDO INICIAL CUOTA

01 25,000,000.00 456,617.16 2 24,740,882.84 456,617.16 3 24,479,718.66 456,617.16 4 24,216,491.28 456,617.16 5 23,951,184.40 456,617.16 6 23,683,781.60 456,617.16 7 23,414,266.31 456,617.16 8 23,142,621.86 456,617.16 9 22,868,831.41 456,617.16

10 22,592,878.02 456,617.16 11 22,314,744.60 456,617.16 12 22,034,413.92 456,617.16 13 21,751,868.63 456,617.16 14 21,467,091.24 456,617.16 15 21,180,064.10 456,617.16 16 20,890,769.45 456,617.16 17 20,599,189.37 456,617.16 18 20,305,305.81 456,617.16 19 20,009,100.56 456,617.16 20 19,710,555.30 456,617.16 21 19,409,651.53 456,617.16 22 19,106,370.62 456,617.16 23 18,800,693.79 456,617.16 24 18,492,602.11 456,617.16 25 18,182,076.51 456,617.16 26 17,869,097.75 456,617.16 27 17,553,646.47 456,617.16 28 17,235,703.11 456,617.16 29 16,915,248.01 456,617.16 30 16,592,261.31 456,617.16 31 16,266,723.02 456,617.16 32 15,938,612.97 456,617.16 33 15,607,910.85 456,617.16 34 15,274,596.19 456,617.16

,=SI(B13<$E$8;B13+1;"") ,=SI(B14<>"";G13;"") ,=SI(B14<>"";$D$10;"")

35 14,938,648.34 456,617.16 36 14,600,046.51 456,617.16 37 14,258,769.71 456,617.16 38 13,914,796.84 456,617.16 39 13,568,106.57 456,617.16 40 13,218,677.46 456,617.16 41 12,866,487.85 456,617.16 42 12,511,515.94 456,617.16 43 12,153,739.76 456,617.16 44 11,793,137.15 456,617.16 45 11,429,685.77 456,617.16 46 11,063,363.13 456,617.16 47 10,694,146.54 456,617.16 48 10,322,013.14 456,617.16 49 9,946,939.89 456,617.16 50 9,568,903.55 456,617.16 51 9,187,880.73 456,617.16 52 8,803,847.83 456,617.16 53 8,416,781.07 456,617.16 54 8,026,656.48 456,617.16 55 7,633,449.91 456,617.16 56 7,237,137.01 456,617.16 57 6,837,693.23 456,617.16 58 6,435,093.85 456,617.16 59 6,029,313.93 456,617.16 60 5,620,328.35 456,617.16 61 5,208,111.79 456,617.16 62 4,792,638.71 456,617.16 63 4,373,883.40 456,617.16 64 3,951,819.92 456,617.16 65 3,526,422.14 456,617.16 66 3,097,663.71 456,617.16 67 2,665,518.10 456,617.16 68 2,229,958.53 456,617.16 69 1,790,958.05 456,617.16 70 1,348,489.46 456,617.16 71 902,525.37 456,617.16 72 453,038.16 456,617.16

TABLA DE AMORTIZACION

De Cuota Constante

0.79%

25,000,000.00 606,617.16 72.00

,=SI(B14<>"";D14-E14;"") ,=SI(B14="";"";C14-F14)

INTERES ABONO A CAPITAL SALDO FINAL

$ 25,000,000 197,500.00 259,117.16 24,740,882.84 195,452.97 261,164.18 24,479,718.66 193,389.78 263,227.38 24,216,491.28 191,310.28 265,306.88 23,951,184.40 189,214.36 267,402.80 23,683,781.60 187,101.87 269,515.28 23,414,266.31 184,972.70 271,644.45 23,142,621.86 182,826.71 273,790.45 22,868,831.41 180,663.77 275,953.39 22,592,878.02 178,483.74 278,133.42 22,314,744.60 176,286.48 280,330.68 22,034,413.92 174,071.87 282,545.29 21,751,868.63 171,839.76 284,777.40 21,467,091.24 169,590.02 287,027.14 21,180,064.10 167,322.51 289,294.65 20,890,769.45 165,037.08 291,580.08 20,599,189.37 162,733.60 293,883.56 20,305,305.81 160,411.92 296,205.24 20,009,100.56 158,071.89 298,545.26 19,710,555.30 155,713.39 300,903.77 19,409,651.53 153,336.25 303,280.91 19,106,370.62 150,940.33 305,676.83 18,800,693.79 148,525.48 308,091.68 18,492,602.11 146,091.56 310,525.60 18,182,076.51 143,638.40 312,978.75 17,869,097.75 141,165.87 315,451.29 17,553,646.47 138,673.81 317,943.35 17,235,703.11 136,162.05 320,455.10 16,915,248.01 133,630.46 322,986.70 16,592,261.31 131,078.86 325,538.29 16,266,723.02 128,507.11 328,110.05 15,938,612.97 125,915.04 330,702.12 15,607,910.85 123,302.50 333,314.66 15,274,596.19 120,669.31 335,947.85 14,938,648.34

,=SI(B15<>"";C15*$E$6;"")

118,015.32 338,601.84 14,600,046.51 115,340.37 341,276.79 14,258,769.71 112,644.28 343,972.88 13,914,796.84 109,926.90 346,690.26 13,568,106.57 107,188.04 349,429.12 13,218,677.46 104,427.55 352,189.61 12,866,487.85 101,645.25 354,971.90 12,511,515.94 98,840.98 357,776.18 12,153,739.76 96,014.54 360,602.61 11,793,137.15 93,165.78 363,451.38 11,429,685.77 90,294.52 366,322.64 11,063,363.13 87,400.57 369,216.59 10,694,146.54 84,483.76 372,133.40 10,322,013.14 81,543.90 375,073.25 9,946,939.89 78,580.83 378,036.33 9,568,903.55 75,594.34 381,022.82 9,187,880.73 72,584.26 384,032.90 8,803,847.83 69,550.40 387,066.76 8,416,781.07 66,492.57 390,124.59 8,026,656.48 63,410.59 393,206.57 7,633,449.91 60,304.25 396,312.90 7,237,137.01 57,173.38 399,443.78 6,837,693.23 54,017.78 402,599.38 6,435,093.85 50,837.24 405,779.92 6,029,313.93 47,631.58 408,985.58 5,620,328.35 44,400.59 412,216.56 5,208,111.79 41,144.08 415,473.08 4,792,638.71 37,861.85 418,755.31 4,373,883.40 34,553.68 422,063.48 3,951,819.92 31,219.38 425,397.78 3,526,422.14 27,858.73 428,758.42 3,097,663.71 24,471.54 432,145.62 2,665,518.10 21,057.59 435,559.57 2,229,958.53 17,616.67 439,000.49 1,790,958.05 14,148.57 442,468.59 1,348,489.46 10,653.07 445,964.09 902,525.37 7,129.95 449,487.21 453,038.16 3,579.00 453,038.16 (0.00)