Creacion de Un Modelo Uveg
Creacion de Un Modelo Uveg
Creacion de Un Modelo Uveg
MONTO 500000
INTERES ANUAL 0.35
PERIODO 36
INTERES MENSUAL 0.03
AMORTIZACION 13888.88
IVA 0.16
PERIODO CAPITAL AMORTIZACION INTERES IVA MENSUALIDAD
1 $ 500,000.00 $ 13,888.89 $ 15,000.00 $ 2,400.00 $ 31,288.89
2 $ 486,111.11 $ 13,888.89 $ 14,583.33 $ 2,333.33 $ 30,805.56
3 $ 472,222.22 $ 13,888.89 $ 14,166.67 $ 2,266.67 $ 30,322.22
4 $ 458,333.33 $ 13,888.89 $ 13,750.00 $ 2,200.00 $ 29,838.89
5 $ 444,444.44 $ 13,888.89 $ 13,333.33 $ 2,133.33 $ 29,355.56
6 $ 430,555.56 $ 13,888.89 $ 12,916.67 $ 2,066.67 $ 28,872.22
7 $ 416,666.67 $ 13,888.89 $ 12,500.00 $ 2,000.00 $ 28,388.89
8 $ 402,777.78 $ 13,888.89 $ 12,083.33 $ 1,933.33 $ 27,905.56
9 $ 388,888.89 $ 13,888.89 $ 11,666.67 $ 1,866.67 $ 27,422.22
10 $ 375,000.00 $ 13,888.89 $ 11,250.00 $ 1,800.00 $ 26,938.89
11 $ 361,111.11 $ 13,888.89 $ 10,833.33 $ 1,733.33 $ 26,455.56
12 $ 347,222.22 $ 13,888.89 $ 10,416.67 $ 1,666.67 $ 25,972.22
13 $ 333,333.33 $ 13,888.89 $ 10,000.00 $ 1,600.00 $ 25,488.89
14 $ 319,444.44 $ 13,888.89 $ 9,583.33 $ 1,533.33 $ 25,005.56
15 $ 305,555.56 $ 13,888.89 $ 9,166.67 $ 1,466.67 $ 24,522.22
16 $ 291,666.67 $ 13,888.89 $ 8,750.00 $ 1,400.00 $ 24,038.89
17 $ 277,777.78 $ 13,888.89 $ 8,333.33 $ 1,333.33 $ 23,555.56
18 $ 263,888.89 $ 13,888.89 $ 7,916.67 $ 1,266.67 $ 23,072.22
19 $ 250,000.00 $ 13,888.89 $ 7,500.00 $ 1,200.00 $ 22,588.89
20 $ 236,111.11 $ 13,888.89 $ 7,083.33 $ 1,133.33 $ 22,105.56
21 $ 222,222.22 $ 13,888.89 $ 6,666.67 $ 1,066.67 $ 21,622.22
22 $ 208,333.33 $ 13,888.89 $ 6,250.00 $ 1,000.00 $ 21,138.89
23 $ 194,444.44 $ 13,888.89 $ 5,833.33 $ 933.33 $ 20,655.56
24 $ 180,555.56 $ 13,888.89 $ 5,416.67 $ 866.67 $ 20,172.22
25 $ 166,666.67 $ 13,888.89 $ 5,000.00 $ 800.00 $ 19,688.89
26 $ 152,777.78 $ 13,888.89 $ 4,583.33 $ 733.33 $ 19,205.56
27 $ 138,888.89 $ 13,888.89 $ 4,166.67 $ 666.67 $ 18,722.22
28 $ 125,000.00 $ 13,888.89 $ 3,750.00 $ 600.00 $ 18,238.89
29 $ 111,111.11 $ 13,888.89 $ 3,333.33 $ 533.33 $ 17,755.56
30 $ 97,222.22 $ 13,888.89 $ 2,916.67 $ 466.67 $ 17,272.22
31 $ 83,333.33 $ 13,888.89 $ 2,500.00 $ 400.00 $ 16,788.89
32 $ 69,444.44 $ 13,888.89 $ 2,083.33 $ 333.33 $ 16,305.56
33 $ 55,555.56 $ 13,888.89 $ 1,666.67 $ 266.67 $ 15,822.22
34 $ 41,666.67 $ 13,888.89 $ 1,250.00 $ 200.00 $ 15,338.89
35 $ 27,777.78 $ 13,888.89 $ 833.33 $ 133.33 $ 14,855.56
36 $ 13,888.89 $ 13,888.89 $ 416.67 $ 66.67 $ 14,372.22
$ 277,500.00 $44,400.00
SALDO
$ 486,111.11
$ 472,222.22
$ 458,333.33
$ 444,444.44
$ 430,555.56
$ 416,666.67
$ 402,777.78
$ 388,888.89
$ 375,000.00
$ 361,111.11
$ 347,222.22
$ 333,333.33
$ 319,444.44
$ 305,555.56
$ 291,666.67
$ 277,777.78
$ 263,888.89
$ 250,000.00
$ 236,111.11
$ 222,222.22
$ 208,333.33
$ 194,444.44
$ 180,555.56
$ 166,666.67
$ 152,777.78
$ 138,888.89
$ 125,000.00
$ 111,111.11
$ 97,222.22
$ 83,333.33
$ 69,444.44
$ 55,555.56
$ 41,666.67
$ 27,777.78
$ 13,888.89
$ 0.00
MONTO $500,000.00
INTERES ANUAL 0.35
PERIODO 36
INTERES MENSUAL 0.03
IVA 0.16
MENSUALIDAD $22,901.90 PERIDO CAPITAL AMORTIZACIONES
1 $ 500,000.00 $7,901.90
2 $ 492,098.10 $8,138.95
3 $483,959.15 $8,383.12
4 $ 475,576.03 $8,634.62
5 $466,941.41 $8,893.65
6 $ 458,047.76 $9,160.46
7 $448,887.29 $9,435.28
8 $ 439,452.01 $9,718.34
9 $429,733.68 $10,009.89
10 $ 419,723.79 $10,310.18
11 $409,413.61 $10,619.49
12 $ 398,794.12 $10,938.07
13 $387,856.04 $11,266.22
14 $ 376,589.83 $11,604.20
15 $364,985.62 $11,952.33
16 $ 353,033.30 $12,310.90
17 $340,722.40 $12,680.23
18 $ 328,042.17 $13,060.63
19 $314,981.54 $13,452.45
20 $ 301,529.09 $13,856.02
21 $287,673.07 $14,271.71
22 $273,401.36 $14,699.86
23 $258,701.50 $15,140.85
24 $ 243,560.65 $15,595.08
25 $227,965.58 $16,062.93
26 $ 211,902.65 $16,544.82
27 $195,357.83 $17,041.16
28 $ 178,316.67 $17,552.40
29 $160,764.27 $18,078.97
30 $ 142,685.30 $18,621.34
31 $124,063.96 $19,179.98
32 $ 104,883.98 $19,755.38
33 $85,128.61 $20,348.04
34 $ 64,780.57 $20,958.48
35 $43,822.09 $21,587.23
36 $ 22,234.85 $22,234.85
INTERES IVA MENSUALIDAD FIJA SALDO
$ 15,000.00 $ 2,400.00 $25,301.90 $ 492,098.10
$ 14,762.94 $ 2,362.07 $25,263.97 $ 483,959.15
$ 14,518.77 $ 2,323.00 $25,224.90 $475,576.03
$ 14,267.28 $ 2,282.76 $25,184.66 $ 466,941.41
$ 14,008.24 $ 2,241.32 $25,143.22 $458,047.76
$ 13,741.43 $ 2,198.63 $25,100.53 $ 448,887.29
$ 13,466.62 $ 2,154.66 $25,056.56 $ 439,452.01
$ 13,183.56 $ 2,109.37 $25,011.27 $ 429,733.68
$ 12,892.01 $ 2,062.72 $24,964.62 $ 419,723.79
$ 12,591.71 $ 2,014.67 $24,916.57 $ 409,413.61
$ 12,282.41 $ 1,965.19 $24,867.08 $ 398,794.12
$ 11,963.82 $ 1,914.21 $24,816.11 $ 387,856.04
$ 11,635.68 $ 1,861.71 $24,763.61 $ 376,589.83
$ 11,297.69 $ 1,807.63 $24,709.53 $ 364,985.62
$ 10,949.57 $ 1,751.93 $24,653.83 $ 353,033.30
$ 10,591.00 $ 1,694.56 $24,596.46 $ 340,722.40
$ 10,221.67 $ 1,635.47 $24,537.36 $ 328,042.17
$ 9,841.27 $ 1,574.60 $24,476.50 $ 314,981.54
$ 9,449.45 $ 1,511.91 $24,413.81 $ 301,529.09
$ 9,045.87 $ 1,447.34 $24,349.24 $ 287,673.07
$ 8,630.19 $ 1,380.83 $24,282.73 $273,401.36
$ 8,202.04 $ 1,312.33 $24,214.22 $ 258,701.50
$ 7,761.05 $ 1,241.77 $24,143.66 $243,560.65
$ 7,306.82 $ 1,169.09 $24,070.99 $ 227,965.58
$ 6,838.97 $ 1,094.23 $23,996.13 $ 211,902.65
$ 6,357.08 $ 1,017.13 $23,919.03 $ 195,357.83
$ 5,860.73 $ 937.72 $23,839.61 $ 178,316.67
$ 5,349.50 $ 855.92 $23,757.82 $ 160,764.27
$ 4,822.93 $ 771.67 $23,673.57 $ 142,685.30
$ 4,280.56 $ 684.89 $23,586.79 $ 124,063.96
$ 3,721.92 $ 595.51 $23,497.40 $ 104,883.98
$ 3,146.52 $ 503.44 $23,405.34 $ 85,128.61
$ 2,553.86 $ 408.62 $23,310.51 $ 64,780.57
$ 1,943.42 $ 310.95 $23,212.84 $ 43,822.09
$ 1,314.66 $ 210.35 $23,112.24 $ 22,234.85
$ 667.05 $ 106.73 $23,008.62 $ 0.00
$ 324,468.30 $51,914.93
FINANCIERA MIUR INSOLITOS
CAPITAL 500,000
INTERES ANUAL 23
PERIODO 48
INTERES MENSUAL 0.02
AMORTIZACION
IVA 0.16 PERIODO CAPITAL
1 $ 500,000.00
2 $ 489,583.33
3 $ 479,166.67
4 $ 468,750.00
5 $ 458,333.33
6 $ 447,916.67
7 $ 437,500.00
8 $ 427,083.33
9 $ 416,666.67
10 $ 406,250.00
11 $ 395,833.33
12 $ 385,416.67
13 $ 375,000.00
14 $ 364,583.33
15 $ 354,166.67
16 $ 343,750.00
17 $ 333,333.33
18 $ 322,916.67
19 $ 312,500.00
20 $ 302,083.33
21 $ 291,666.67
22 $ 281,250.00
23 $ 270,833.33
24 $ 260,416.67
25 $ 250,000.00
26 $ 239,583.33
27 $ 229,166.67
28 $ 218,750.00
29 $ 208,333.33
30 $ 197,916.67
31 $ 187,500.00
32 $ 177,083.33
33 $ 166,666.67
34 $ 156,250.00
35 $ 145,833.33
36 $ 135,416.67
37 $ 125,000.00
38 $ 114,583.33
39 $ 104,166.67
40 $ 93,750.00
41 $ 83,333.33
42 $ 72,916.67
43 $ 62,500.00
44 $ 52,083.33
45 $ 41,666.67
46 $ 31,250.00
47 $ 20,833.33
48 $ 10,416.67
AMORTIZACION INTERES IVA MENSUALIDAD SALDO
$ 10,416.67 $ 10,000.00 $ 1,600.00 $ 22,016.67 $ 489,583.33
$ 10,416.67 $ 9,791.67 $ 1,566.67 $ 21,775.00 $ 479,166.67
$ 10,416.67 $ 9,583.33 $ 1,533.33 $ 21,533.33 $ 468,750.00
$ 10,416.67 $ 9,375.00 $ 1,500.00 $ 21,291.67 $ 458,333.33
$ 10,416.67 $ 9,166.67 $ 1,466.67 $ 21,050.00 $ 447,916.67
$ 10,416.67 $ 8,958.33 $ 1,433.33 $ 20,808.33 $ 437,500.00
$ 10,416.67 $ 8,750.00 $ 1,400.00 $ 20,566.67 $ 427,083.33
$ 10,416.67 $ 8,541.67 $ 1,366.67 $ 20,325.00 $ 416,666.67
$ 10,416.67 $ 8,333.33 $ 1,333.33 $ 20,083.33 $ 406,250.00
$ 10,416.67 $ 8,125.00 $ 1,300.00 $ 19,841.67 $ 395,833.33
$ 10,416.67 $ 7,916.67 $ 1,266.67 $ 19,600.00 $ 385,416.67
$ 10,416.67 $ 7,708.33 $ 1,233.33 $ 19,358.33 $ 375,000.00
$ 10,416.67 $ 7,500.00 $ 1,200.00 $ 19,116.67 $ 364,583.33
$ 10,416.67 $ 7,291.67 $ 1,166.67 $ 18,875.00 $ 354,166.67
$ 10,416.67 $ 7,083.33 $ 1,133.33 $ 18,633.33 $ 343,750.00
$ 10,416.67 $ 6,875.00 $ 1,100.00 $ 18,391.67 $ 333,333.33
$ 10,416.67 $ 6,666.67 $ 1,066.67 $ 18,150.00 $ 322,916.67
$ 10,416.67 $ 6,458.33 $ 1,033.33 $ 17,908.33 $ 312,500.00
$ 10,416.67 $ 6,250.00 $ 1,000.00 $ 17,666.67 $ 302,083.33
$ 10,416.67 $ 6,041.67 $ 966.67 $ 17,425.00 $ 291,666.67
$ 10,416.67 $ 5,833.33 $ 933.33 $ 17,183.33 $ 281,250.00
$ 10,416.67 $ 5,625.00 $ 900.00 $ 16,941.67 $ 270,833.33
$ 10,416.67 $ 5,416.67 $ 866.67 $ 16,700.00 $ 260,416.67
$ 10,416.67 $ 5,208.33 $ 833.33 $ 16,458.33 $ 250,000.00
$ 10,416.67 $ 5,000.00 $ 800.00 $ 16,216.67 $ 239,583.33
$ 10,416.67 $ 4,791.67 $ 766.67 $ 15,975.00 $ 229,166.67
$ 10,416.67 $ 4,583.33 $ 733.33 $ 15,733.33 $ 218,750.00
$ 10,416.67 $ 4,375.00 $ 700.00 $ 15,491.67 $ 208,333.33
$ 10,416.67 $ 4,166.67 $ 666.67 $ 15,250.00 $ 197,916.67
$ 10,416.67 $ 3,958.33 $ 633.33 $ 15,008.33 $ 187,500.00
$ 10,416.67 $ 3,750.00 $ 600.00 $ 14,766.67 $ 177,083.33
$ 10,416.67 $ 3,541.67 $ 566.67 $ 14,525.00 $ 166,666.67
$ 10,416.67 $ 3,333.33 $ 533.33 $ 14,283.33 $ 156,250.00
$ 10,416.67 $ 3,125.00 $ 500.00 $ 14,041.67 $ 145,833.33
$ 10,416.67 $ 2,916.67 $ 466.67 $ 13,800.00 $ 135,416.67
$ 10,416.67 $ 2,708.33 $ 433.33 $ 13,558.33 $ 125,000.00
$ 10,416.67 $ 2,500.00 $ 400.00 $ 13,316.67 $ 114,583.33
$ 10,416.67 $ 2,291.67 $ 366.67 $ 13,075.00 $ 104,166.67
$ 10,416.67 $ 2,083.33 $ 333.33 $ 12,833.33 $ 93,750.00
$ 10,416.67 $ 1,875.00 $ 300.00 $ 12,591.67 $ 83,333.33
$ 10,416.67 $ 1,666.67 $ 266.67 $ 12,350.00 $ 72,916.67
$ 10,416.67 $ 1,458.33 $ 233.33 $ 12,108.33 $ 62,500.00
$ 10,416.67 $ 1,250.00 $ 200.00 $ 11,866.67 $ 52,083.33
$ 10,416.67 $ 1,041.67 $ 166.67 $ 11,625.00 $ 41,666.67
$ 10,416.67 $ 833.33 $ 133.33 $ 11,383.33 $ 31,250.00
$ 10,416.67 $ 625.00 $ 100.00 $ 11,141.67 $ 20,833.33
$ 10,416.67 $ 416.67 $ 66.67 $ 10,900.00 $ 10,416.67
$ 10,416.67 $ 208.33 $ 33.33 $ 10,658.33 -$ 0.00
$ 245,000.00 $39,200.00
FINANCIERA MIUR INSOLITOS
CAPITAL 500,000
INTERES ANUAL 23
PERIODO 48
INTERES MENSUAL 0.02
AMORTIZACION
IVA 0.16