Scribd
Upload
21 views12 pages

Cálculo de Interés Simple Anual

The document shows the amortization schedule for a loan of $65,267 at an annual interest rate of 10% over 36 months. It includes the monthly interest payment, principal payment, total monthly payment, accumulated payment, and remaining debt over the life of the loan. The interest on the loan totals $19,580.10 and the loan is fully paid off after 36 monthly payments.

Uploaded by

Cristian L Mendoza Asencios
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views12 pages

Cálculo de Interés Simple Anual

The document shows the amortization schedule for a loan of $65,267 at an annual interest rate of 10% over 36 months. It includes the monthly interest payment, principal payment, total monthly payment, accumulated payment, and remaining debt over the life of the loan. The interest on the loan totals $19,580.10 and the loan is fully paid off after 36 monthly payments.

Uploaded by

Cristian L Mendoza Asencios
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

CAPITAL TASA ANUAL PLAZO MESES INTERES MONTO

20,000.00 15% 18 4,500.00 24,500.00 25,011.55

CUOTA INTERES CAPITAL TOTAL CUOTA ACUMULADO DEUDA

0 0 0 0 0 24,500.00
1 250.00 1,111.11 1,361.11 1,361.11 23,138.89
2 250.00 1,111.11 1,361.11 2,722.22 21,777.78
3 250.00 1,111.11 1,361.11 4,083.33 20,416.67
4 250.00 1,111.11 1,361.11 5,444.44 19,055.56
5 250.00 1,111.11 1,361.11 6,805.56 17,694.44
6 250.00 1,111.11 1,361.11 8,166.67 16,333.33
7 250.00 1,111.11 1,361.11 9,527.78 14,972.22
8 250.00 1,111.11 1,361.11 10,888.89 13,611.11
9 250.00 1,111.11 1,361.11 12,250.00 12,250.00
10 250.00 1,111.11 1,361.11 13,611.11 10,888.89
11 250.00 1,111.11 1,361.11 14,972.22 9,527.78
12 250.00 1,111.11 1,361.11 16,333.33 8,166.67
13 250.00 1,111.11 1,361.11 17,694.44 6,805.56
14 250.00 1,111.11 1,361.11 19,055.56 5,444.44
15 250.00 1,111.11 1,361.11 20,416.67 4,083.33
16 250.00 1,111.11 1,361.11 21,777.78 2,722.22
17 250.00 1,111.11 1,361.11 23,138.89 1,361.11
18 250.00 1,111.11 1,361.11 24,500.00 -
4,500.00 20,000.00 24,500.00
CAIDA LINEAL DE LA DEUDA
30,000.00

25,000.00
DEUDA
20,000.00

15,000.00

10,000.00

5,000.00

-
0 2 4 6 8 10 12 14 16 18 20

NUMERO DE CUOTA
CAPITAL TASA ANUAL PLAZO MESES INTERES MONTO
20,000.00 15% 18 4500 24,500.00

CUOTA INTERES CAPITAL TOTAL CUOTA ACUMULADO DEUDA

0 0 0 0 0 24,500.00
1 250.00 1,111.11 1,361.11 1,361.11 23,138.89
2 250.00 1,111.11 1,361.11 2,722.22 21,777.78
3 250.00 1,111.11 1,361.11 4,083.33 20,416.67
4 250.00 1,111.11 1,361.11 5,444.44 19,055.56
5 250.00 1,111.11 1,361.11 6,805.56 17,694.44
6 250.00 1,111.11 1,361.11 8,166.67 16,333.33
7 250.00 1,111.11 1,361.11 9,527.78 14,972.22
8 250.00 1,111.11 1,361.11 10,888.89 13,611.11
9 250.00 1,111.11 1,361.11 12,250.00 12,250.00
10 250.00 1,111.11 1,361.11 13,611.11 10,888.89
11 250.00 1,111.11 1,361.11 14,972.22 9,527.78
12 250.00 1,111.11 1,361.11 16,333.33 8,166.67
13 250.00 1,111.11 1,361.11 17,694.44 6,805.56
14 250.00 1,111.11 1,361.11 19,055.56 5,444.44
15 250.00 1,111.11 1,361.11 20,416.67 4,083.33
16 250.00 1,111.11 1,361.11 21,777.78 2,722.22
17 250.00 1,111.11 1,361.11 23,138.89 1,361.11
18 250.00 1,111.11 1,361.11 24,500.00 -
4,500.00 20,000.00 24,500.00
CAIDA LINEAL DE LA DEUDA
30,000.00

25,000.00
DEUDA

20,000.00

15,000.00

10,000.00

5,000.00

-
0 2 4 6 8 10 12 14 16 18 20

NUMERO DE CUOTA
INTERES SIMPLE
CAPITAL TASA ANUAL PLAZO AÑOS INTERES MONTO
5,000.00 3% 2 300 5,300.00

AÑO INTERES RETIRO CADA AÑO


0 0
1 150.00 5,150.00
2 150.00 5,300.00
FIN 300.00
INTERES COMPUESTO
CAPITAL TASA ANUAL PLAZO AÑOS INTERES MONTO
5,000.00 3% 2 304.500 5,304.50

AÑO INTERES CAPITALIZABLE


0 0 5,000.00
1 150.00 5,150.00
2 154.50 5,304.50
FIN 304.50
INGRESO POR VENTAS

Producto P.U unidades Sub total


Pan 0.200 50,000.000 10,000.000 1666.666667
Tortas 25.000 10.000 250.000 3333.333333
Bocaditos 10.000 10.000 100.000
Total 10,350.000

EGRESOS DE LA ACTIVIDAD

Materia Prima C/U Unidades Sub total


Harina 0.067 50,000.000 3,350.000

MARGEN BRUTO 7,000.000


Gastos Operativos
Local 1000 1 1000
Sueldo 1000 3 3000
Agua y Luz 600 1 600
Sub Total 4,600.000

MARGEN NETO 2,400.000


4,600.00
0.20
0.07
0.13
34,586.47
1,152.88
576.44

50,000.00
1667
3,333
6,667
CAPITAL TASA ANUAL PLAZO MESES INTERES MONTO
65,267.00 10% 36 19,580.10 84,847.10

CUOTA INTERES CAPITAL TOTAL CUOTA ACUMULADO DEUDA

0 0 0 0 0 84,847.10
1 543.89 1,812.97 2,356.86 2,356.86 82,490.24
2 543.89 1,812.97 2,356.86 4,713.73 80,133.37
3 543.89 1,812.97 2,356.86 7,070.59 77,776.51
4 543.89 1,812.97 2,356.86 9,427.46 75,419.64
5 543.89 1,812.97 2,356.86 11,784.32 73,062.78
6 543.89 1,812.97 2,356.86 14,141.18 70,705.92
7 543.89 1,812.97 2,356.86 16,498.05 68,349.05
8 543.89 1,812.97 2,356.86 18,854.91 65,992.19
9 543.89 1,812.97 2,356.86 21,211.78 63,635.33
10 543.89 1,812.97 2,356.86 23,568.64 61,278.46
11 543.89 1,812.97 2,356.86 25,925.50 58,921.60
12 543.89 1,812.97 2,356.86 28,282.37 56,564.73
13 543.89 1,812.97 2,356.86 30,639.23 54,207.87
14 543.89 1,812.97 2,356.86 32,996.09 51,851.01
15 543.89 1,812.97 2,356.86 35,352.96 49,494.14
16 543.89 1,812.97 2,356.86 37,709.82 47,137.28
17 543.89 1,812.97 2,356.86 40,066.69 44,780.41
18 543.89 1,812.97 2,356.86 42,423.55 42,423.55
19 543.89 1,812.97 2,356.86 44,780.41 40,066.69
20 543.89 1,812.97 2,356.86 47,137.28 37,709.82
21 543.89 1,812.97 2,356.86 49,494.14 35,352.96
22 543.89 1,812.97 2,356.86 51,851.01 32,996.09
23 543.89 1,812.97 2,356.86 54,207.87 30,639.23
24 543.89 1,812.97 2,356.86 56,564.73 28,282.37
25 543.89 1,812.97 2,356.86 58,921.60 25,925.50
26 543.89 1,812.97 2,356.86 61,278.46 23,568.64
27 543.89 1,812.97 2,356.86 63,635.33 21,211.78
28 543.89 1,812.97 2,356.86 65,992.19 18,854.91
29 543.89 1,812.97 2,356.86 68,349.05 16,498.05
30 543.89 1,812.97 2,356.86 70,705.92 14,141.18
31 543.89 1,812.97 2,356.86 73,062.78 11,784.32
32 543.89 1,812.97 2,356.86 75,419.64 9,427.46
33 543.89 1,812.97 2,356.86 77,776.51 7,070.59
34 543.89 1,812.97 2,356.86 80,133.37 4,713.73
35 543.89 1,812.97 2,356.86 82,490.24 2,356.86
36 543.89 1,812.97 2,356.86 84,847.10 -
19,580.10 65,267.00 84,847.10
CAIDA LINEAL DE LA DEUDA
90,000.00
80,000.00
70,000.00

DEUDA
60,000.00
50,000.00
40,000.00
30,000.00
20,000.00
10,000.00
-
0 5 10 15 20 25 30 35 40

NUMERO DE CUOTA
35 40

You might also like