ALTERNATIVA 1

Prestamo (VA)= $10,000,000.00

Tiempo (n)= 12 mensual
Tasa de interes (I)= 0.4% 5.20% anual
PAGOS (A)= $856,991.62

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $10,000,000.00
1 $856,991.62 $43,333.33 $813,658.28 $9,186,341.72
2 $856,991.62 $39,807.48 $817,184.14 $8,369,157.58
3 $856,991.62 $36,266.35 $820,725.27 $7,548,432.31
4 $856,991.62 $32,709.87 $824,281.74 $6,724,150.56
5 $856,991.62 $29,137.99 $827,853.63 $5,896,296.93
6 $856,991.62 $25,550.62 $831,441.00 $5,064,855.93
7 $856,991.62 $21,947.71 $835,043.91 $4,229,812.03
8 $856,991.62 $18,329.19 $838,662.43 $3,391,149.59
9 $856,991.62 $14,694.98 $842,296.64 $2,548,852.96
10 $856,991.62 $11,045.03 $845,946.59 $1,702,906.37
11 $856,991.62 $7,379.26 $849,612.36 $853,294.01
12 $856,991.62 $3,697.61 $853,294.01 $0.00

ALTERNATIVA 2
Prestamo (VA)= $10,000,000.00
Tiempo (n)= 12
Tasa de interes (I)= 1.56% 18.67% anual
PAGOS (A)= $920,000.00

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $10,000,000.00
1 $920,000.00 $155,598.07 $764,401.93 $9,235,598.07
2 $920,000.00 $143,704.13 $776,295.87 $8,459,302.20
3 $920,000.00 $131,625.11 $788,374.89 $7,670,927.31
4 $920,000.00 $119,358.15 $800,641.85 $6,870,285.47
5 $920,000.00 $106,900.32 $813,099.68 $6,057,185.78
6 $920,000.00 $94,248.64 $825,751.36 $5,231,434.43
7 $920,000.00 $81,400.11 $838,599.89 $4,392,834.54
8 $920,000.00 $68,351.66 $851,648.34 $3,541,186.20
9 $920,000.00 $55,100.18 $864,899.82 $2,676,286.38
10 $920,000.00 $41,642.50 $878,357.50 $1,797,928.88
11 $920,000.00 $27,975.43 $892,024.57 $905,904.30
12 $920,000.00 $14,095.70 $905,904.30 $0.00
ALMACEN A
Prestamo (VA)= $720,000.00 $1,200,000.00 40%
Tiempo (n)= 24 mensual
Tasa de interes (I)= 21.6% mensual
PAGOS (A)= $156,956.73

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $720,000.00
1 $156,956.73 $155,520.00 $1,436.73 $718,563.27
2 $156,956.73 $155,209.67 $1,747.06 $716,816.21
3 $156,956.73 $154,832.30 $2,124.42 $714,691.79
4 $156,956.73 $154,373.43 $2,583.30 $712,108.49
5 $156,956.73 $153,815.43 $3,141.29 $708,967.20
6 $156,956.73 $153,136.91 $3,819.81 $705,147.38
7 $156,956.73 $152,311.83 $4,644.89 $700,502.49
8 $156,956.73 $151,308.54 $5,648.19 $694,854.30
9 $156,956.73 $150,088.53 $6,868.20 $687,986.11
10 $156,956.73 $148,605.00 $8,351.73 $679,634.38
11 $156,956.73 $146,801.03 $10,155.70 $669,478.68
12 $156,956.73 $144,607.39 $12,349.33 $657,129.35
13 $156,956.73 $141,939.94 $15,016.79 $642,112.56
14 $156,956.73 $138,696.31 $18,260.41 $623,852.15
15 $156,956.73 $134,752.06 $22,204.66 $601,647.48
16 $156,956.73 $129,955.86 $27,000.87 $574,646.61
17 $156,956.73 $124,123.67 $32,833.06 $541,813.56
18 $156,956.73 $117,031.73 $39,925.00 $501,888.56
19 $156,956.73 $108,407.93 $48,548.80 $453,339.76
20 $156,956.73 $97,921.39 $59,035.34 $394,304.42
21 $156,956.73 $85,169.75 $71,786.97 $322,517.45
22 $156,956.73 $69,663.77 $87,292.96 $235,224.49
23 $156,956.73 $50,808.49 $106,148.24 $129,076.26
24 $156,956.73 $27,880.47 $129,076.26 $0.00

ALMACEN B
Prestamo (VA)= $840,000.00 $1,200,000.00 30% $360,000.00
Tiempo (n)= 24 mensual
 Tasa de interes (I)= 0.64% mensual 15.36% EA(efectiva anual)
PAGOS (A)= $37,868.45

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $840,000.00
1 $37,868.45 $5,376.00 $32,492.45 $807,507.55
2 $37,868.45 $5,168.05 $32,700.40 $774,807.15
3 $37,868.45 $4,958.77 $32,909.68 $741,897.47
4 $37,868.45 $4,748.14 $33,120.30 $708,777.17
5 $37,868.45 $4,536.17 $33,332.27 $675,444.89
6 $37,868.45 $4,322.85 $33,545.60 $641,899.29
7 $37,868.45 $4,108.16 $33,760.29 $608,139.00
8 $37,868.45 $3,892.09 $33,976.36 $574,162.64
9 $37,868.45 $3,674.64 $34,193.81 $539,968.84
10 $37,868.45 $3,455.80 $34,412.65 $505,556.19
11 $37,868.45 $3,235.56 $34,632.89 $470,923.30
12 $37,868.45 $3,013.91 $34,854.54 $436,068.76
13 $37,868.45 $2,790.84 $35,077.61 $400,991.15
14 $37,868.45 $2,566.34 $35,302.10 $365,689.05
15 $37,868.45 $2,340.41 $35,528.04 $330,161.01
16 $37,868.45 $2,113.03 $35,755.42 $294,405.60
17 $37,868.45 $1,884.20 $35,984.25 $258,421.34
18 $37,868.45 $1,653.90 $36,214.55 $222,206.79
19 $37,868.45 $1,422.12 $36,446.32 $185,760.47
20 $37,868.45 $1,188.87 $36,679.58 $149,080.89
21 $37,868.45 $954.12 $36,914.33 $112,166.56
22 $37,868.45 $717.87 $37,150.58 $75,015.98
23 $37,868.45 $480.10 $37,388.35 $37,627.63
24 $37,868.45 $240.82 $37,627.63 $0.00
 $480,000.00 cuota inicial

al contado
 Prestamo (VA)= $45,000,000.00
Tiempo (n)= 34
Tasa de interes (I)= 24%
PAGOS (A)= $12,094,558.00

PERIODO PAGOS INTERES

0
1 $12,094,558.00 $10,800,000.00
2 $11,783,864.08 $10,489,306.08
3 $11,473,170.16 $10,178,612.16
4 $11,162,476.24 $9,867,918.24
5 $10,851,782.32 $9,557,224.32
6 $10,541,088.40 $9,246,530.40
7 $10,230,394.48 $8,935,836.48
8 $9,919,700.56 $8,625,142.56
9 $9,609,006.64 $8,314,448.64
10 $9,298,312.72 $8,003,754.72
11 $8,987,618.80 $7,693,060.80
12 $8,676,924.88 $7,382,366.88
13 $8,366,230.96 $7,071,672.96
14 $8,055,537.04 $6,760,979.04
15 $7,744,843.12 $6,450,285.12
16 $7,434,149.20 $6,139,591.20
17 $7,123,455.28 $5,828,897.28
18 $6,812,761.36 $5,518,203.36
19 $6,502,067.44 $5,207,509.44
20 $6,191,373.52 $4,896,815.52
21 $5,880,679.60 $4,586,121.60
22 $5,569,985.68 $4,275,427.68
23 $5,259,291.76 $3,964,733.76
24 $4,948,597.84 $3,654,039.84
25 $4,637,903.92 $3,343,345.92
26 $4,327,210.00 $3,032,652.00
27 $4,016,516.08 $2,721,958.08
28 $3,705,822.16 $2,411,264.16
29 $3,395,128.24 $2,100,570.24
30 $3,084,434.32 $1,789,876.32
31 $2,773,740.40 $1,479,182.40
32 $2,463,046.48 $1,168,488.48
33 $2,152,352.56 $857,794.56
34 $1,841,658.64 $547,100.64
$236,915,682.88 $192,900,710.88
$44,014,972.00
$45,000,000.00
mensual
mensual

AMORTIZACION SALDO
$45,000,000.00
$1,294,558.00 $43,705,442.00
$1,294,558.00 $42,410,884.00
$1,294,558.00 $41,116,326.00
$1,294,558.00 $39,821,768.00
$1,294,558.00 $38,527,210.00
$1,294,558.00 $37,232,652.00
$1,294,558.00 $35,938,094.00
$1,294,558.00 $34,643,536.00
$1,294,558.00 $33,348,978.00
$1,294,558.00 $32,054,420.00
$1,294,558.00 $30,759,862.00
$1,294,558.00 $29,465,304.00
$1,294,558.00 $28,170,746.00
$1,294,558.00 $26,876,188.00
$1,294,558.00 $25,581,630.00
$1,294,558.00 $24,287,072.00
$1,294,558.00 $22,992,514.00
$1,294,558.00 $21,697,956.00
$1,294,558.00 $20,403,398.00
$1,294,558.00 $19,108,840.00
$1,294,558.00 $17,814,282.00
$1,294,558.00 $16,519,724.00
$1,294,558.00 $15,225,166.00
$1,294,558.00 $13,930,608.00
$1,294,558.00 $12,636,050.00
$1,294,558.00 $11,341,492.00
$1,294,558.00 $10,046,934.00
$1,294,558.00 $8,752,376.00
$1,294,558.00 $7,457,818.00
$1,294,558.00 $6,163,260.00
$1,294,558.00 $4,868,702.00
$1,294,558.00 $3,574,144.00
$1,294,558.00 $2,279,586.00
$1,294,558.00 $985,028.00
primer año
Prestamo (VA)= $7,000,000.00 $10,000,000.00 30%
Tiempo (n)= 12 meses
Tasa de interes (I)= 2.0%
PAGOS (A)= $661,917.18

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $7,000,000.00
1 $661,917.18 $140,000.00 $521,917.18 $6,478,082.82
2 $661,917.18 $129,561.66 $532,355.52 $5,945,727.30
3 $661,917.18 $118,914.55 $543,002.63 $5,402,724.67
4 $661,917.18 $108,054.49 $553,862.68 $4,848,861.99
5 $661,917.18 $96,977.24 $564,939.94 $4,283,922.05
6 $661,917.18 $85,678.44 $576,238.74 $3,707,683.32
7 $661,917.18 $74,153.67 $587,763.51 $3,119,919.81
8 $661,917.18 $62,398.40 $599,518.78 $2,520,401.03
9 $661,917.18 $50,408.02 $611,509.16 $1,908,891.87
10 $661,917.18 $38,177.84 $623,739.34 $1,285,152.53
11 $661,917.18 $25,703.05 $636,214.13 $648,938.41
12 $661,917.18 $12,978.77 $648,938.41 $0.00

segundo año
Prestamo (VA)= $7,000,000.00 $10,000,000.00 30%
Tiempo (n)= 12 meses
Tasa de interes (I)= 2.25% 2.00% 0.25%
PAGOS (A)= $672,121.81

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $7,000,000.00
1 $672,121.81 $157,500.00 $514,621.81 $6,485,378.19
2 $672,121.81 $145,921.01 $526,200.80 $5,959,177.39
3 $672,121.81 $134,081.49 $538,040.32 $5,421,137.07
4 $672,121.81 $121,975.58 $550,146.23 $4,870,990.84
5 $672,121.81 $109,597.29 $562,524.52 $4,308,466.32
6 $672,121.81 $96,940.49 $575,181.32 $3,733,285.01
7 $672,121.81 $83,998.91 $588,122.90 $3,145,162.11
8 $672,121.81 $70,766.15 $601,355.66 $2,543,806.44
9 $672,121.81 $57,235.64 $614,886.17 $1,928,920.28
 10 $672,121.81 $43,400.71 $628,721.10 $1,300,199.17
11 $672,121.81 $29,254.48 $642,867.33 $657,331.84
12 $672,121.81 $14,789.97 $657,331.84 $0.00

tercer año
Prestamo (VA)= $7,000,000.00 $10,000,000.00 30%
Tiempo (n)= 12 meses
Tasa de interes (I)= 2.50% 2.25% 0.25%
PAGOS (A)= $682,409.89

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $7,000,000.00
1 $682,409.89 $175,000.00 $507,409.89 $6,492,590.11
2 $682,409.89 $162,314.75 $520,095.14 $5,972,494.97
3 $682,409.89 $149,312.37 $533,097.51 $5,439,397.46
4 $682,409.89 $135,984.94 $546,424.95 $4,892,972.51
5 $682,409.89 $122,324.31 $560,085.58 $4,332,886.93
6 $682,409.89 $108,322.17 $574,087.72 $3,758,799.22
7 $682,409.89 $93,969.98 $588,439.91 $3,170,359.31
8 $682,409.89 $79,258.98 $603,150.91 $2,567,208.40
9 $682,409.89 $64,180.21 $618,229.68 $1,948,978.72
10 $682,409.89 $48,724.47 $633,685.42 $1,315,293.30
11 $682,409.89 $32,882.33 $649,527.56 $665,765.75
12 $682,409.89 $16,644.14 $665,765.75 $0.00

cuarto año
Prestamo (VA)= $7,000,000.00 $10,000,000.00 30%
Tiempo (n)= 12 meses
Tasa de interes (I)= 2.75% 2.50% 0.25%
PAGOS (A)= $692,780.97

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $7,000,000.00
1 $692,780.97 $192,500.00 $500,280.97 $6,499,719.03
2 $692,780.97 $178,742.27 $514,038.70 $5,985,680.34
3 $692,780.97 $164,606.21 $528,174.76 $5,457,505.58
4 $692,780.97 $150,081.40 $542,699.57 $4,914,806.01
5 $692,780.97 $135,157.17 $557,623.80 $4,357,182.21
6 $692,780.97 $119,822.51 $572,958.46 $3,784,223.75
7 $692,780.97 $104,066.15 $588,714.82 $3,195,508.93
8 $692,780.97 $87,876.50 $604,904.47 $2,590,604.46
9 $692,780.97 $71,241.62 $621,539.35 $1,969,065.11
10 $692,780.97 $54,149.29 $638,631.68 $1,330,433.44
11 $692,780.97 $36,586.92 $656,194.05 $674,239.39
12 $692,780.97 $18,541.58 $674,239.39 $0.00
quinto año
Prestamo (VA)= $7,000,000.00 $10,000,000.00 30%
Tiempo (n)= 12 meses
Tasa de interes (I)= 3.00% 2.75% 0.25%
PAGOS (A)= $703,234.60

PERIODO PAGOS INTERES AMORTIZACION SALDO

0 $7,000,000.00
1 $703,234.60 $210,000.00 $493,234.60 $6,506,765.40
2 $703,234.60 $195,202.96 $508,031.64 $5,998,733.77
3 $703,234.60 $179,962.01 $523,272.59 $5,475,461.18
4 $703,234.60 $164,263.84 $538,970.76 $4,936,490.42
5 $703,234.60 $148,094.71 $555,139.89 $4,381,350.53
6 $703,234.60 $131,440.52 $571,794.08 $3,809,556.45
7 $703,234.60 $114,286.69 $588,947.90 $3,220,608.54
8 $703,234.60 $96,618.26 $606,616.34 $2,613,992.20
9 $703,234.60 $78,419.77 $624,814.83 $1,989,177.37
10 $703,234.60 $59,675.32 $643,559.28 $1,345,618.09
11 $703,234.60 $40,368.54 $662,866.06 $682,752.04
12 $703,234.60 $20,482.56 $682,752.04 $0.00
$3,000,000.00

$3,000,000.00
$3,000,000.00

$3,000,000.00
$3,000,000.00
 Prestamo (VF)= $25,000,000.00
Tiempo (n)= 36 meses
Tasa de interes (I)= 1.55% mensual $6,200.00
CUOTAS= $400,000.00 mensual $406,200.00

PERIODO CUOTAS INTERES ABONO

0
1 $400,000.00 $6,200.00 $406,200.00
2 $400,000.00 $6,200.00 $406,200.00
3 $400,000.00 $6,200.00 $406,200.00
4 $400,000.00 $6,200.00 $406,200.00
5 $400,000.00 $6,200.00 $406,200.00
6 $400,000.00 $6,200.00 $406,200.00
7 $400,000.00 $6,200.00 $406,200.00
8 $400,000.00 $6,200.00 $406,200.00
9 $400,000.00 $6,200.00 $406,200.00
10 $400,000.00 $6,200.00 $406,200.00
11 $400,000.00 $6,200.00 $406,200.00
12 $400,000.00 $6,200.00 $406,200.00
13 $400,000.00 $6,200.00 $406,200.00
14 $400,000.00 $6,200.00 $406,200.00
15 $400,000.00 $6,200.00 $406,200.00
16 $400,000.00 $6,200.00 $406,200.00
17 $400,000.00 $6,200.00 $406,200.00
18 $5,588,400.00 $6,200.00 $5,594,600.00
19 $400,000.00 $6,200.00 $406,200.00
20 $400,000.00 $6,200.00 $406,200.00
21 $400,000.00 $6,200.00 $406,200.00
22 $400,000.00 $6,200.00 $406,200.00
23 $400,000.00 $6,200.00 $406,200.00
24 $5,588,400.00 $6,200.00 $5,594,600.00
25 $400,000.00 $6,200.00 $406,200.00
26 $400,000.00 $6,200.00 $406,200.00
27 $400,000.00 $6,200.00 $406,200.00
28 $400,000.00 $6,200.00 $406,200.00
29 $400,000.00 $6,200.00 $406,200.00
30 $400,000.00 $6,200.00 $406,200.00
31 $400,000.00 $6,200.00 $406,200.00
32 $400,000.00 $6,200.00 $406,200.00
33 $400,000.00 $6,200.00 $406,200.00
34 $400,000.00 $6,200.00 $406,200.00
35 $400,000.00 $6,200.00 $406,200.00
36 $400,000.00 $6,200.00 $406,200.00
SALDO
0
$406,200.00
$812,400.00
$1,218,600.00
$1,624,800.00
$2,031,000.00
$2,437,200.00
$2,843,400.00
$3,249,600.00
$3,655,800.00
$4,062,000.00
$4,468,200.00
$4,874,400.00
$5,280,600.00
$5,686,800.00
$6,093,000.00
$6,499,200.00
$6,905,400.00
$12,500,000.00
$12,906,200.00
$13,312,400.00
$13,718,600.00
$14,124,800.00
$14,531,000.00
$20,125,600.00
$20,531,800.00
$20,938,000.00
$21,344,200.00
$21,750,400.00
$22,156,600.00
$22,562,800.00
$22,969,000.00
$23,375,200.00
$23,781,400.00
$24,187,600.00
$24,593,800.00
$25,000,000.00