Creacion de Un Modelo Uveg

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 13

FINANCIERA GLOX INSOLITOS

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

Mensualidad $16,300.92 PERIODO CAPITAL


1 $ 500,000.00
2 $ 493,699.08
3 $ 487,272.15
4 $ 480,716.67
5 $ 474,030.09
6 $ 467,209.77
7 $ 460,253.05
8 $ 453,157.19
9 $ 445,919.42
10 $ 438,536.89
11 $ 431,006.71
12 $ 423,325.92
13 $ 415,491.53
14 $ 407,500.44
15 $ 399,349.53
16 $ 391,035.60
17 $ 382,555.40
18 $ 373,905.59
19 $ 365,082.78
20 $ 356,083.52
21 $ 346,904.27
22 $ 337,541.44
23 $ 327,991.35
24 $ 318,250.26
25 $ 308,314.35
26 $ 298,179.72
27 $ 287,842.39
28 $ 277,298.32
29 $ 266,543.37
30 $ 255,573.32
31 $ 244,383.87
32 $ 232,970.63
33 $ 221,329.12
34 $ 209,454.79
35 $ 197,342.97
36 $ 184,988.91
37 $ 172,387.77
38 $ 159,534.61
39 $ 146,424.38
40 $ 133,051.95
41 $ 119,412.07
42 $ 105,499.39
43 $ 91,308.46
44 $ 76,833.72
45 $ 62,069.47
46 $ 47,009.94
47 $ 31,649.23
48 $ 15,981.29
AMORTIZACION INTERES IVA MENSUALIDAD FIJA SALDO
$6,300.92 $ 10,000.00 $ 1,600.00 $17,900.92 $ 493,699.08
$6,426.94 $ 9,873.98 $ 1,579.84 $17,880.75 $ 487,272.15
$6,555.47 $ 9,745.44 $ 1,559.27 $17,860.19 $ 480,716.67
$6,686.58 $ 9,614.33 $ 1,538.29 $17,839.21 $ 474,030.09
$6,820.32 $ 9,480.60 $ 1,516.90 $17,817.81 $ 467,209.77
$6,956.72 $ 9,344.20 $ 1,495.07 $17,795.99 $ 460,253.05
$7,095.86 $ 9,205.06 $ 1,472.81 $17,773.73 $ 453,157.19
$7,237.77 $ 9,063.14 $ 1,450.10 $17,751.02 $ 445,919.42
$7,382.53 $ 8,918.39 $ 1,426.94 $17,727.86 $ 438,536.89
$7,530.18 $ 8,770.74 $ 1,403.32 $17,704.24 $ 431,006.71
$7,680.78 $ 8,620.13 $ 1,379.22 $17,680.14 $ 423,325.92
$7,834.40 $ 8,466.52 $ 1,354.64 $17,655.56 $ 415,491.53
$7,991.09 $ 8,309.83 $ 1,329.57 $17,630.49 $ 407,500.44
$8,150.91 $ 8,150.01 $ 1,304.00 $17,604.92 $ 399,349.53
$8,313.93 $ 7,986.99 $ 1,277.92 $17,578.84 $ 391,035.60
$8,480.21 $ 7,820.71 $ 1,251.31 $17,552.23 $ 382,555.40
$8,649.81 $ 7,651.11 $ 1,224.18 $17,525.10 $ 373,905.59
$8,822.81 $ 7,478.11 $ 1,196.50 $17,497.42 $ 365,082.78
$8,999.26 $ 7,301.66 $ 1,168.26 $17,469.18 $ 356,083.52
$9,179.25 $ 7,121.67 $ 1,139.47 $17,440.39 $ 346,904.27
$9,362.83 $ 6,938.09 $ 1,110.09 $17,411.01 $ 337,541.44
$9,550.09 $ 6,750.83 $ 1,080.13 $17,381.05 $ 327,991.35
$9,741.09 $ 6,559.83 $ 1,049.57 $17,350.49 $ 318,250.26
$9,935.91 $ 6,365.01 $ 1,018.40 $17,319.32 $ 308,314.35
$10,134.63 $ 6,166.29 $ 986.61 $17,287.52 $ 298,179.72
$10,337.32 $ 5,963.59 $ 954.18 $17,255.09 $ 287,842.39
$10,544.07 $ 5,756.85 $ 921.10 $17,222.01 $ 277,298.32
$10,754.95 $ 5,545.97 $ 887.35 $17,188.27 $ 266,543.37
$10,970.05 $ 5,330.87 $ 852.94 $17,153.86 $ 255,573.32
$11,189.45 $ 5,111.47 $ 817.83 $17,118.75 $ 244,383.87
$11,413.24 $ 4,887.68 $ 782.03 $17,082.95 $ 232,970.63
$11,641.51 $ 4,659.41 $ 745.51 $17,046.42 $ 221,329.12
$11,874.34 $ 4,426.58 $ 708.25 $17,009.17 $ 209,454.79
$12,111.82 $ 4,189.10 $ 670.26 $16,971.17 $ 197,342.97
$12,354.06 $ 3,946.86 $ 631.50 $16,932.42 $ 184,988.91
$12,601.14 $ 3,699.78 $ 591.96 $16,892.88 $ 172,387.77
$12,853.16 $ 3,447.76 $ 551.64 $16,852.56 $ 159,534.61
$13,110.23 $ 3,190.69 $ 510.51 $16,811.43 $ 146,424.38
$13,372.43 $ 2,928.49 $ 468.56 $16,769.48 $ 133,051.95
$13,639.88 $ 2,661.04 $ 425.77 $16,726.68 $ 119,412.07
$13,912.68 $ 2,388.24 $ 382.12 $16,683.04 $ 105,499.39
$14,190.93 $ 2,109.99 $ 337.60 $16,638.52 $ 91,308.46
$14,474.75 $ 1,826.17 $ 292.19 $16,593.10 $ 76,833.72
$14,764.24 $ 1,536.67 $ 245.87 $16,546.79 $ 62,069.47
$15,059.53 $ 1,241.39 $ 198.62 $16,499.54 $ 47,009.94
$15,360.72 $ 940.20 $ 150.43 $16,451.35 $ 31,649.23
$15,667.93 $ 632.98 $ 101.28 $16,402.20 $ 15,981.29
$15,981.29 $ 319.63 $ 51.14 $16,352.06 $ 0.00
$ 282,444.05 $45,191.05 $61,491.97

También podría gustarte