Tarea-3_102007_12
xlsx
keyboard_arrow_up
School
National Open and Distance University *
*We aren’t endorsed by this school
Course
102024
Subject
Accounting
Date
Nov 24, 2024
Type
xlsx
Pages
24
Uploaded by geovana24puello
Tarea 3: Series uniformes y amortizaciones
1- Alix Berrio Pertuz 2-Maria Helena Ortega Silva
3-Jose Javier Rodriguez Rodriguez
4-
5-
Grupo: 12 Presentado a:
Ludwin Alexander Sanchez Vargas UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA UNAD
ESCUELA DE CIENCIAS ADMINISTRATIVAS, CONTABLES, ECONÓMICAS Y DE NEGOCIOS (ECACEN)
Administración de Empresas
Matemática Financiera
102007_1394
Valledupar
Saturday, November 18, 2023
Copyright Juán Carlos Rojas Paredes
Adapted Humberto Bedoya Valencia
Variables
I
Es el valor de los interés generados
P
Es el valor presente o capital inicial
i
Es la tasa de interés aplicada que se expresa en forma decimal o porcen
n
Es el tiempo de la operación financiera
F
Es la suma acumulada final. El capital inicial más los intereses generado
A
Es el valor de la anualidad
Fórmulas Anualidades
A =
P =
Interés compuesto
Funciones financieras de Exc
P
F
NPER: Hallar el tiempo de la TASA: Halla la tasa de interés
n
Log (F / P)
VA: Halla el Valor presente
Log(1 + ip)
VF: Halla el Valor futuro
i =
Mediante Excel
Conversión de tasas
Formulas:
Funciones financieras de Exc
TASA.NOMINAL
INT.EFECTIVO
PAGO: Valor de la anualidad
Debe recalcarse que tanto la tasa periódica de interés “i
p
” como el tiempo “n” deben
base, es decir que si la tasa periódica de interés es mensual el tiempo debe ser en m
trimestral el tiempo debe ser trimestres, y así respectivamente.
A
= F i
p
(1 + i
p
)
n
- 1
P (1 + i
p
)
n
* i
p
(1 + i
p
)
n
- 1
A (1 + i
p
)
n
- 1 (1 + i
p
)
n
* i
p
F = A (1 + i
p
)
n
- 1 i
p
F = P x (1+i) n
(1 +i)
n
iea = (1 + ip)
n
– 1
ip = ((1 + iea)
1/n
) – 1
TN = i
p
X no. Capitalizaciones anuales
i
p
= TN/ no. Capitalizaciones
iea
Interés efectivo anual
Interés periódico
n
Es el numero de periodos durante los cuales se causa el interés (capitali
TN
Tasa nominal
Gradientes
Gradiente aritmético
G
n
Creciente
i
G
n
Decreciente
i
Gradiente geométrico
(G - i)
i
p
iea
= ((1 + i
p
)
(360 / días del periodo)
) - 1
i
p
= ((1 + iea)
(días del periodo/360)
) - 1
P = A
1
(1+i)
n
- 1
(1+i)
n
- 1
i (1+i)
n
i (1+i)
n
(1+i)
n
P = A
1
(1+i)
n
- 1
(1+i)
n
- 1
i (1+i)
n
i (1+i)
n
(1+i)
n
P
= A
1
[(1+G)
n
(1+i)
-n
- 1]
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ntual
os
cel
operación financiera
s
cel
n expresarse en la misma meses, si la tasa periódica es
izaciones)
A=
-$ 3,519,031.57
CUOTA FIJA
P=
-$ 32,600,000
n=
12 TRIMESTRAL
I=
4.22% TRIMESTRAL
VARIABLES
VALOR
OBSERVACIONES P
$ 32,600,000.00
IEA
18% EFECTIVO ANUAL
PLAZO
3 AÑOS
PERIODO DEL AÑO
4 TRIMESTRAL
NPER
12 TRIMESTRAL
IPV
?
TRIMESTRAL
IPV
0.042246635456321 TRIMESTRAL
A
-$ 3,519,031.57
PERIODO
#CUOTAS
SALDO INICIAL
INTERES
0
0
1
1
$ 32,600,000.00
$ 1,377,240.32
2
2
$ 30,458,208.74
$ 1,286,756.84
3
3
$ 28,225,934.01
$ 1,192,450.74
4
4
$ 25,899,353.18
$ 1,094,160.53
5
5
$ 23,474,482.14
$ 991,717.89
6
6
$ 20,947,168.46
$ 884,947.39
7
7
$ 18,313,084.27
$ 773,666.20
8
8
$ 15,567,718.90
$ 657,683.75
9
9
$ 12,706,371.07
$ 536,801.43
10
10
$ 9,724,140.92
$ 410,812.24
11
11
$ 6,615,921.58
$ 279,500.43
12
12
$ 3,376,390.44
$ 142,641.14
2. Si se ahorran cada mes $ 250.000 en una entidad financiera que le reconoce el 10.2
P=
?
-$ 10,477,274.41
1. Un vehículo se adquiere mediante una cuota inicial del 40% del valor de contado, q
trimestrales durante tres años. ¿A cuánto ascenderá cada cuota fija que se debe
trimestralmente
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
A=
$ 250,000.00
MENSUAL
n=
36
MESES
I=
0.85%
MENSUAL
NAPER
DEPOSITO
INTERES
DEPOSITO + INTERES
0
$ 250,000.00
$ 2,125.00
$ 252,125.00
1
$ 250,000.00
$ 2,143.06
$ 252,143.06
2
$ 250,000.00
$ 4,286.28
$ 254,286.28
3
$ 250,000.00
$ 6,447.71
$ 256,447.71
4
$ 250,000.00
$ 8,627.52
$ 258,627.52
5
$ 250,000.00
$ 10,825.85
$ 260,825.85
6
$ 250,000.00
$ 13,042.87
$ 263,042.87
7
$ 250,000.00
$ 15,278.74
$ 265,278.74
8
$ 250,000.00
$ 17,533.60
$ 267,533.60
9
$ 250,000.00
$ 19,807.64
$ 269,807.64
10
$ 250,000.00
$ 22,101.01
$ 272,101.01
11
$ 250,000.00
$ 24,413.86
$ 274,413.86
12
$ 250,000.00
$ 26,746.38
$ 276,746.38
13
$ 250,000.00
$ 29,098.73
$ 279,098.73
14
$ 250,000.00
$ 31,471.07
$ 281,471.07
15
$ 250,000.00
$ 33,863.57
$ 283,863.57
16
$ 250,000.00
$ 36,276.41
$ 286,276.41
17
$ 250,000.00
$ 38,709.76
$ 288,709.76
18
$ 250,000.00
$ 41,163.79
$ 291,163.79
19
$ 250,000.00
$ 43,638.68
$ 293,638.68
20
$ 250,000.00
$ 46,134.61
$ 296,134.61
21
$ 250,000.00
$ 48,651.76
$ 298,651.76
22
$ 250,000.00
$ 51,190.30
$ 301,190.30
23
$ 250,000.00
$ 53,750.41
$ 303,750.41
24
$ 250,000.00
$ 56,332.29
$ 306,332.29
25
$ 250,000.00
$ 58,936.12
$ 308,936.12
26
$ 250,000.00
$ 61,562.07
$ 311,562.07
27
$ 250,000.00
$ 64,210.35
$ 314,210.35
28
$ 250,000.00
$ 66,881.14
$ 316,881.14
29
$ 250,000.00
$ 69,574.63
$ 319,574.63
30
$ 250,000.00
$ 72,291.01
$ 322,291.01
31
$ 250,000.00
$ 75,030.49
$ 325,030.49
32
$ 250,000.00
$ 77,793.25
$ 327,793.25
33
$ 250,000.00
$ 80,579.49
$ 330,579.49
34
$ 250,000.00
$ 83,389.42
$ 333,389.42
35
$ 250,000.00
$ 86,223.23
$ 336,223.23
36
$ 250,000.00
$ 89,081.12
$ 339,081.12
P=
?
$ 17,523,507.44
A=
-$ 1,250,000.00 SEMESTRALES
3. ¿Cuál es el capital prestado por una entidad financiera si la deuda se amortizó m
1.250.000, en la que se acordó una tasa de interés efectivo anual d
n=
30 SEMESTRALES
I=
6% SEMESTRALES
VARIABLES
VALOR
OBSERVACIONES P
-$ 17,523,507.44
IEA
12% EFECTIVO ANUAL
PLAZO
5 AÑOS
PERIODO DEL AÑO
2 SEMESTRAL
NPER
30 SEMESTRE
IPV
?
SEMESTRAL
IPV
0.058300524425836 SEMESTRAL
A
$ 1,250,000.00 SEMSATRAL
NAPER
#CUOTAS
SALDO INICIAL
INTERES
0
0 -$ 17,523,507.4 1
1
-$ 17,523,507.44
-$ 1,021,629.67
2
2
-$ 17,295,137.11
-$ 1,008,315.56
3
3
-$ 17,053,452.68
-$ 994,225.23
4
4
-$ 16,797,677.91
-$ 979,313.43
5
5
-$ 16,526,991.34
-$ 963,532.26
6
6
-$ 16,240,523.60
-$ 946,831.04
7
7
-$ 15,937,354.65
-$ 929,156.13
8
8
-$ 15,616,510.78
-$ 910,450.77
9
9
-$ 15,276,961.55
-$ 890,654.87
10
10
-$ 14,917,616.42
-$ 869,704.86
11
11
-$ 14,537,321.28
-$ 847,533.45
12
12
-$ 14,134,854.73
-$ 824,069.44
13
13
-$ 13,708,924.18
-$ 799,237.47
14
14
-$ 13,258,161.64
-$ 772,957.78
15
15
-$ 12,781,119.42
-$ 745,145.97
16
16
-$ 12,276,265.39
-$ 715,712.71
17
17
-$ 11,741,978.10
-$ 684,563.48
18
18
-$ 11,176,541.58
-$ 651,598.24
19
19
-$ 10,578,139.81
-$ 616,711.10
20
20
-$ 9,944,850.91
-$ 579,790.02
21
21
-$ 9,274,640.93
-$ 540,716.43
22
22
-$ 8,565,357.37
-$ 499,364.83
23
23
-$ 7,814,722.19
-$ 455,602.40
24
24
-$ 7,020,324.59
-$ 409,288.61
25
25
-$ 6,179,613.20
-$ 360,274.69
26
26
-$ 5,289,887.89
-$ 308,403.24
27
27
-$ 4,348,291.13
-$ 253,507.65
28
28
-$ 3,351,798.78
-$ 195,411.63
29
29
-$ 2,297,210.41
-$ 133,928.57
30
30
-$ 1,181,138.98
-$ 68,861.02
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Ejercicios de Anu
…
0 1
2 3
FORMULAS A UTILIZAR
A =
ABONO A CAPITAL (Ak)
CUOTA (Ak)
SALDO FINAL (Sk)
A
$ 32,600,000.00
P
-$ 2,141,791.26
-$ 3,519,031.57
$ 30,458,208.74
N
-$ 2,232,274.73
-$ 3,519,031.57
$ 28,225,934.01
I
-$ 2,326,580.83
-$ 3,519,031.57
$ 25,899,353.18
-$ 2,424,871.04
-$ 3,519,031.57
$ 23,474,482.14
-$ 2,527,313.68
-$ 3,519,031.57
$ 20,947,168.46
-$ 2,634,084.18
-$ 3,519,031.57
$ 18,313,084.27
-$ 2,745,365.38
-$ 3,519,031.57
$ 15,567,718.90
-$ 2,861,347.83
-$ 3,519,031.57
$ 12,706,371.07
-$ 2,982,230.15
-$ 3,519,031.57
$ 9,724,140.92
-$ 3,108,219.34
-$ 3,519,031.57
$ 6,615,921.58
-$ 3,239,531.15
-$ 3,519,031.57
$ 3,376,390.44
-$ 3,376,390.44
-$ 3,519,031.57
$ 0.00
20% NACM ¿Cuál será el monto al cabo de 3 años?
P=?
que es de $ 54.000.000 y el saldo se financia mediante el pago de cuotas e pagar si la tasa de interés nominal anual es del 18% capitalizable e?
P (1 + i
p
)
n
* i
p
(1 + i
p
)
n
- 1
I= 4,5%TRIMESTRAL
=4,484,827
0
$250,000
...
𝐼𝑃?= (1 + 𝑖𝑒𝑎)^(
/360
(?𝐼?????𝑃??𝐼???
)-1
1 2 3
…..
12
I=0,28%
SALDO
$ 252,125.00
$ 504,268.06
P=
$ 250,000.00
$ 758,554.34
A=
$250000
$ 1,015,002.05
N=
36
$ 1,273,629.57
I=
0.85%
$ 1,534,455.42
$ 1,797,498.29
$ 2,062,777.03
$ 2,330,310.63
$ 2,600,118.27
$ 2,872,219.28
$ 3,146,633.14
$ 3,423,379.52
$ 3,702,478.25
$ 3,983,949.32
$ 4,267,812.88
$ 4,554,089.29
$ 4,842,799.05
$ 5,133,962.85
$ 5,427,601.53
$ 5,723,736.14
$ 6,022,387.90
$ 6,323,578.20
$ 6,627,328.61
$ 6,933,660.90
$ 7,242,597.02
$ 7,554,159.10
$ 7,868,369.45
$ 8,185,250.59
$ 8,504,825.22
$ 8,827,116.23
$ 9,152,146.72
$ 9,479,939.97
$ 9,810,519.46
$ 10,143,908.87
$ 10,480,132.10
$ 10,819,213.22
30
mediante pagos semestrales iguales de $ del 12% durante 5 años?
0
$250,000
...
...
I= 6%
FORMULAS A UTILIZAR
P =
ABONO A CAPITAL (Ak)
CUOTA (Ak)
SALDOFINAL (Sk)
-$ 17,523,507.44
$ 228,370.33
$ 1,250,000.0 -$ 17,295,137.11
$ 241,684.44
$ 1,250,000.0 -$ 17,053,452.68
$ 255,774.77
$ 1,250,000.0 -$ 16,797,677.91
$ 270,686.57
$ 1,250,000.0 -$ 16,526,991.34
$ 286,467.74
$ 1,250,000.0 -$ 16,240,523.60
$ 303,168.96
$ 1,250,000.0 -$ 15,937,354.65
$ 320,843.87
$ 1,250,000.0 -$ 15,616,510.78
$ 339,549.23
$ 1,250,000.0 -$ 15,276,961.55
$ 359,345.13
$ 1,250,000.0 -$ 14,917,616.42
$ 380,295.14
$ 1,250,000.0 -$ 14,537,321.28
$ 402,466.55
$ 1,250,000.0 -$ 14,134,854.73
$ 425,930.56
$ 1,250,000.0 -$ 13,708,924.18
$ 450,762.53
$ 1,250,000.0 -$ 13,258,161.64
$ 477,042.22
$ 1,250,000.0 -$ 12,781,119.42
$ 504,854.03
$ 1,250,000.0 -$ 12,276,265.39
$ 534,287.29
$ 1,250,000.0 -$ 11,741,978.10
$ 565,436.52
$ 1,250,000.0 -$ 11,176,541.58
$ 598,401.76
$ 1,250,000.0 -$ 10,578,139.81
$ 633,288.90
$ 1,250,000.0 -$ 9,944,850.91
$ 670,209.98
$ 1,250,000.0 -$ 9,274,640.93
$ 709,283.57
$ 1,250,000.0 -$ 8,565,357.37
$ 750,635.17
$ 1,250,000.0 -$ 7,814,722.19
$ 794,397.60
$ 1,250,000.0 -$ 7,020,324.59
$ 840,711.39
$ 1,250,000.0 -$ 6,179,613.20
$ 889,725.31
$ 1,250,000.0 -$ 5,289,887.89
$ 941,596.76
$ 1,250,000.0 -$ 4,348,291.13
$ 996,492.35
$ 1,250,000.0 -$ 3,351,798.78
$ 1,054,588.37
$ 1,250,000.0 -$ 2,297,210.41
$ 1,116,071.43
$ 1,250,000.0 -$ 1,181,138.98
A (1 + i
p
)
n
- 1 (1 + i
p
)
n
* i
p
0
1
2
3
...
$1,250,000
𝐼𝑃?= (1 + 𝑖𝑒𝑎)^(
/360
(?𝐼?????𝑃??𝐼???
)-1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
$ 1,181,138.98
$ 1,250,000.0 $ 0.00
ualidades
9
- 3,519,031.6 -$ 32,600,000
12
4.22%
P=
$ 17,523,507.4 A=
-$ 1,250,000.0 N=
30
I=
6%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Ejercic
Banco Cafetero: Plazo 3 años, tasa de interés 15% EA, cu
VARIABLES
VALOR
OBSERVACIONES P
$ 350,000,000.00
A =
IEA
15% EFECTIVO ANUAL
PLAZO
3 AÑOS
PERIODO DEL
12 MENSUAL
NPER
36 MESES
IPV
?
MENSUAL
IPV
0.011714916919853 MENSUAL
A
?
A
-$ 11,972,015.35
A=
?
-$ 11,972,015.35 P=
$ 350,000,000.00 I=
1.17% MENSUAL
N=
36 MESES
NAPER
#CUOTAS
SALDO INICIAL
INTERES
0
0 MENSUAL 1
1
$ 350,000,000.00
$ 4,100,220.92
2
2
$ 342,128,205.57
$ 4,008,003.50
3
3
$ 334,164,193.73
$ 3,914,705.77
4
4
$ 326,106,884.15
$ 3,820,315.05
5
5
$ 317,955,183.85
$ 3,724,818.56
6
6
$ 309,707,987.07
$ 3,628,203.34
7
7
$ 301,364,175.06
$ 3,530,456.27
8
8
$ 292,922,615.98
$ 3,431,564.11
9
9
$ 284,382,164.74
$ 3,331,513.43
10
10
$ 275,741,662.83
$ 3,230,290.67
11
11
$ 266,999,938.15
$ 3,127,882.09
12
12
$ 258,155,804.90
$ 3,024,273.81
13
13
$ 249,208,063.35
$ 2,919,451.76
14
14
$ 240,155,499.76
$ 2,813,401.73
15
15
$ 230,996,886.14
$ 2,706,109.33
16
16
$ 221,730,980.12
$ 2,597,560.01
La empresa Tropical S.A.S. necesita financiar la adquisición de un vehículo, para lo cual r
alternativas de financiación:
𝐼𝑃?= (1 + 𝑖𝑒𝑎)^((?𝐼?????𝑃
17
17
$ 212,356,524.79
$ 2,487,739.05
18
18
$ 202,872,248.48
$ 2,376,631.54
19
19
$ 193,276,864.67
$ 2,264,222.41
20
20
$ 183,569,071.74
$ 2,150,496.42
21
21
$ 173,747,552.81
$ 2,035,438.15
22
22
$ 163,810,975.61
$ 1,919,031.97
23
23
$ 153,757,992.23
$ 1,801,262.10
24
24
$ 143,587,238.99
$ 1,682,112.58
25
25
$ 133,297,336.21
$ 1,561,567.22
26
26
$ 122,886,888.08
$ 1,439,609.68
27
27
$ 112,354,482.42
$ 1,316,223.43
28
28
$ 101,698,690.50
$ 1,191,391.71
29
29
$ 90,918,066.86
$ 1,065,097.60
30
30
$ 80,011,149.11
$ 937,323.96
31
31
$ 68,976,457.73
$ 808,053.47
32
32
$ 57,812,495.85
$ 677,268.59
33
33
$ 46,517,749.09
$ 544,951.57
34
34
$ 35,090,685.30
$ 411,084.46
35
35
$ 23,529,754.42
$ 275,649.12
36
36
$ 11,833,388.19
$ 138,627.16
Banco Nacional: Plazo 36 meses, tasa de interés 3.56% trimestre vencido, periodo de gra
VARIABLES
VALOR
OBSERVACIONES P
$ 350,000,000.00
A =
IEA
14% EFECTIVO ANUAL
PLAZO
3 AÑOS
4 TRIMESTRAL
NPER
12 TRIMESTRE
periodo gracia
2 trimestral
IPV
?
TRIMESTAL
IPV
0.0356
TREMETRAL
NPER 1
10
A
-$ 42,211,848.33
A=
?
-$ 36,347,394.75
P=
$ 350,000,000.00
I=
-$ 42,211,848.33 TRIMESTRAL
N=
12 TRIMESTRAL
NAPER
#CUOTAS
SALDO INICIAL
INTERES
PERIODO DEL AÑO
PERIODOS DE AMORTIZACION 𝐼𝑃?= (1 + 𝑖𝑒𝑎)^((?𝐼?????𝑃
𝐼𝑃?= (1 + 𝑖𝑒𝑎)^((?𝐼?????𝑃
0
0
1
1
$ 350,000,000.00
$ 12,460,000.00
2
2
$ 350,000,000.0 $ 12,460,000.00
3
3
$ 350,000,000.00
$ 12,460,000.00
4
4
$ 320,248,151.67
$ 11,400,834.20
5
5
$ 289,437,137.54
$ 10,303,962.10
6
6
$ 257,529,251.31
$ 9,168,041.35
7
7
$ 224,485,444.32
$ 7,991,681.82
8
8
$ 190,265,277.81
$ 6,773,443.89
9
9
$ 154,826,873.37
$ 5,511,836.69
10
10
$ 118,126,861.74
$ 4,205,316.28
11
11
$ 80,120,329.68
$ 2,852,283.74
12
12
$ 40,760,765.09
$ 1,451,083.24
A=
?
-$ 73,417,937.37
P=
$ 350,000,000.00
I=
7.00% SEMESTRE
N=
6 SEMESTRAL
VARIABLES
VALOR
OBSERVACIONES P
$ 350,000,000.00
A =
IEA
14% EFECTIVO ANUAL
PLAZO
3 AÑOS
PERIODO DEL
2 SEMESTRAL
NPER
6 SEMESTRAL
IPV
?
SEMESTRAL
IPV
0.069953270007621 SEMESTRAL
A
?
A
-$ 73,417,937.37
PERIODO
#CUOTAS
SALDO INICIAL
INTERES
0
$ 350,000,000.00
1
1
$ 350,000,000.00
$ 24,483,644.50
2
2
$ 301,065,707.13
$ 21,060,530.70
3
3
$ 248,708,300.46
$ 17,397,958.90
4
4
$ 192,688,321.99
$ 13,479,178.22
5
5
$ 132,749,562.84
$ 9,286,266.01
6
6
$ 68,617,891.48
$ 4,800,045.89
Banco Comercial: Plazo 3 años, tasa de interés 7,24% semestre vencido, cuota fija. Se
millones que se realizará al final del año 𝐼𝑃?= (1 + 𝑖𝑒𝑎)^((?𝐼?????𝑃
𝐼𝑃?= (1 + 𝑖𝑒𝑎)^((?𝐼?????𝑃
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
cios de Amortizacion
uota fija mensual.
FORMULAS A UTILIZAR
A=
$ 11,867,195.00
P=
$ 350,000,000.00 I=
1.17%
N=
36
ABONO A CAPITAL (Ak)
CUOTA (Ak)
SALDO FINAL (Sk)
$ 350,000,000.00
-$ 7,871,794.43 -$ 11,972,015.3 $ 342,128,205.57
-$ 7,964,011.84 -$ 11,972,015.3 $ 334,164,193.73
-$ 8,057,309.58 -$ 11,972,015.3 $ 326,106,884.15
-$ 8,151,700.29 -$ 11,972,015.3 $ 317,955,183.85
-$ 8,247,196.79 -$ 11,972,015.3 $ 309,707,987.07
-$ 8,343,812.01 -$ 11,972,015.3 $ 301,364,175.06
-$ 8,441,559.08 -$ 11,972,015.3 $ 292,922,615.98
-$ 8,540,451.24 -$ 11,972,015.3 $ 284,382,164.74
-$ 8,640,501.92 -$ 11,972,015.3 $ 275,741,662.83
-$ 8,741,724.68 -$ 11,972,015.3 $ 266,999,938.15
-$ 8,844,133.26 -$ 11,972,015.3 $ 258,155,804.90
-$ 8,947,741.54 -$ 11,972,015.3 $ 249,208,063.35
-$ 9,052,563.59 -$ 11,972,015.3 $ 240,155,499.76
-$ 9,158,613.62 -$ 11,972,015.3 $ 230,996,886.14
-$ 9,265,906.02 -$ 11,972,015.3 $ 221,730,980.12
-$ 9,374,455.34 -$ 11,972,015.3 $ 212,356,524.79
requiere 350 millones y cuenta con las siguientes P (1 + i
p
)
n
* i
p
(1 + i
p
)
n
- 1
𝑃??𝐼???/360)−1
-$ 9,484,276.30 -$ 11,972,015.3 $ 202,872,248.48
-$ 9,595,383.81 -$ 11,972,015.3 $ 193,276,864.67
-$ 9,707,792.94 -$ 11,972,015.3 $ 183,569,071.74
-$ 9,821,518.92 -$ 11,972,015.3 $ 173,747,552.81
-$ 9,936,577.20 -$ 11,972,015.3 $ 163,810,975.61
-$ 10,052,983.38 -$ 11,972,015.3 $ 153,757,992.23
-$ 10,170,753.24 -$ 11,972,015.3 $ 143,587,238.99
-$ 10,289,902.77 -$ 11,972,015.3 $ 133,297,336.21
-$ 10,410,448.13 -$ 11,972,015.3 $ 122,886,888.08
-$ 10,532,405.66 -$ 11,972,015.3 $ 112,354,482.42
-$ 10,655,791.92 -$ 11,972,015.3 $ 101,698,690.50
-$ 10,780,623.64 -$ 11,972,015.3 $ 90,918,066.86
-$ 10,906,917.75 -$ 11,972,015.3 $ 80,011,149.11
-$ 11,034,691.38 -$ 11,972,015.3 $ 68,976,457.73
-$ 11,163,961.88 -$ 11,972,015.3 $ 57,812,495.85
-$ 11,294,746.76 -$ 11,972,015.3 $ 46,517,749.09
-$ 11,427,063.78 -$ 11,972,015.3 $ 35,090,685.30
-$ 11,560,930.89 -$ 11,972,015.3 $ 23,529,754.42
-$ 11,696,366.23 -$ 11,972,015.3 $ 11,833,388.19
-$ 11,833,388.19 -$ 11,972,015.3 $ 0.00
acia 1 semestre.
FORMULAS A UTILIZAR
ABONO A CAPITAL (Ak)
CUOTA (Ak)
SALDOFINAL (Sk)
P (1 + i
p
)
n
* i
p
(1 + i
p
)
n
- 1
𝑃??𝐼???/360)−1
𝑃??𝐼???/360)−1
$ 350,000,000.00
$ 350,000,000.00
$ 350,000,000.00
-$ 29,751,848.33 -$ 42,211,848.3 $ 320,248,151.67
-$ 30,811,014.13 -$ 42,211,848.3 $ 289,437,137.54
-$ 31,907,886.23 -$ 42,211,848.3 $ 257,529,251.31
-$ 33,043,806.98 -$ 42,211,848.3 $ 224,485,444.32
-$ 34,220,166.51 -$ 42,211,848.3 $ 190,265,277.81
-$ 35,438,404.44 -$ 42,211,848.3 $ 154,826,873.37
-$ 36,700,011.64 -$ 42,211,848.3 $ 118,126,861.74
-$ 38,006,532.05 -$ 42,211,848.3 $ 80,120,329.68
-$ 39,359,564.59 -$ 42,211,848.3 $ 40,760,765.09
-$ 40,760,765.09 -$ 42,211,848.3 $ 0.00
FORMULAS A UTILIZAR
ABONO A CAPITAL (Ak)
CUOTA (Ak)
SALDOFINAL (Sk)
$ 350,000,000.00
-$ 48,934,292.87
-$ 73,417,937.37
$ 301,065,707.13
-$ 52,357,406.67
-$ 73,417,937.37
$ 248,708,300.46
-$ 56,019,978.47
-$ 73,417,937.37
$ 192,688,321.99
-$ 59,938,759.15
-$ 73,417,937.37
$ 132,749,562.84
-$ 64,131,671.36
-$ 73,417,937.37
$ 68,617,891.48
-$ 68,617,891.48
-$ 73,417,937.37
$ 0.00
e contempla un abono extraordinario de $ 50 2
P (1 + i
p
)
n
* i
p
(1 + i
p
)
n
- 1
𝑃??𝐼???/360)−1
𝑃??𝐼???/360)−1
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
nes
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Ejercicio
VARIABLESVALOR
OBSERVACIONES N
P
$ 84,000,000.00
0
Pagos trimestrales 1
g
$ 1,000,000.00 Desendiente 2
Plazo
3 Años
3
Tasa 2.56% Trimestal vencida
4
No. de perio
4
Trimestal 5
NPER
12
Trimestral
6
7
8
9
10
11
12
Una empresa desea adquirir una máquina cuyo valor de contado es de $ 120.000.000. Si se da una cu
financia a 3 años mediante cuotas trimestrales, ¿Cuál debe ser el valor de estos abonos si cada uno
interés es de 2,56% trimestral vencida.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
os de gradientes
Cuota
Interesses
Capital
Saldo de capital
$ 84,000,000.00
$ 13,417,933.67
$ 2,150,400.00
$ 11,267,533.67
$ 72,732,466.33
$ 12,417,933.67
$ 1,861,951.14
$ 10,555,982.53
$ 62,176,483.80
$ 11,417,933.67
$ 1,591,717.99
$ 9,826,215.68
$ 52,350,268.11
$ 10,417,933.67
$ 1,340,166.86
$ 9,077,766.81
$ 43,272,501.31
$ 9,417,933.67
$ 1,107,776.03
$ 8,310,157.64
$ 34,962,343.67
$ 8,417,933.67
$ 895,036.00
$ 7,522,897.67
$ 27,439,446.00
$ 7,417,933.67
$ 702,449.82
$ 6,715,483.85
$ 20,723,962.15
$ 6,417,933.67
$ 530,533.43
$ 5,887,400.24
$ 14,836,561.91
$ 5,417,933.67
$ 379,815.98
$ 5,038,117.69
$ 9,798,444.22
$ 4,417,933.67
$ 250,840.17
$ 4,167,093.50
$ 5,631,350.72
$ 3,417,933.67
$ 144,162.58
$ 3,273,771.09
$ 2,357,579.63
$ 2,417,933.67
$ 60,354.04
$ 2,357,579.63
$ 0.00
uota inicial del 30% del valor de contado y el resto se o será $ 1.000.000 menor que el anterior? La tasa de
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
In which document would you find the MD&A?
O A. Form 8-K
O B. Form 10-K
O C. Both A and B
O D. Neither A nor B
arrow_forward
On Targets annual report review Item 7 beginning on page 28. This is typically referred to as the MD&A. What is the purpose of the MD&A? What is Target sharing in this item?
arrow_forward
TB 02-57 Transactions include which two types of even...
Transactions include which two types of events?
Multiple Choice
Monetary events and production events.
External exchanges and internal events.
Direct events and indirect events.
Current events and future events.
arrow_forward
Subject :- Accounting
arrow_forward
Testing NCAA Compliance atSoutheastern State University:A Case Study Julia L. Higgs and John T. Reisch
arrow_forward
Q-4
What are the major categories of depository institution assets and their approximate percentage contribution to total resources? What are the major categories of depository institution liabilities? What are the fundamental differences between them?
arrow_forward
You have the followinginformation for Oriole inc. Oriole inc uses the periodic method of accounting for its inventory transactions.
1 Beginning inventory 2200 liters at a cost of 60e per liter.
3 Purchased 2.500 liters atacost of 70e per liter.
March
March
March
Sold 2.300 iters for $1.05 per liter.
March
10
Purchased 4.000 liters at a cost of 77e per liter.
Purchased 2400 iters ata cost of 85e per liter.
March
20
March
30
Sold S.000 liters for $1.25 per liter.
(a1)
Calculate the value of ending inventory that would be reported on the balance sheet, under each of the following cost flow
Prepare partial income statements for 2022 through gross profit, under each of the following cost flow assumptions. (Round
answers to 2 decimal places, eg 125.25J
(1) Specific identifcation method assuming
O The March 5 sale consisted of 1,000 liters from the March 1 beginning inventory and 1,300 liters from the March 3
purchase; and
O The March 30 sale consisted of the following number of units sold…
arrow_forward
Define Regulation National Market System (Reg NMS)
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Business/Professional Ethics Directors/Executives...
Accounting
ISBN:9781337485913
Author:BROOKS
Publisher:Cengage

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Related Questions
- In which document would you find the MD&A? O A. Form 8-K O B. Form 10-K O C. Both A and B O D. Neither A nor Barrow_forwardOn Targets annual report review Item 7 beginning on page 28. This is typically referred to as the MD&A. What is the purpose of the MD&A? What is Target sharing in this item?arrow_forwardTB 02-57 Transactions include which two types of even... Transactions include which two types of events? Multiple Choice Monetary events and production events. External exchanges and internal events. Direct events and indirect events. Current events and future events.arrow_forward
- Subject :- Accountingarrow_forwardTesting NCAA Compliance atSoutheastern State University:A Case Study Julia L. Higgs and John T. Reischarrow_forwardQ-4 What are the major categories of depository institution assets and their approximate percentage contribution to total resources? What are the major categories of depository institution liabilities? What are the fundamental differences between them?arrow_forward
- You have the followinginformation for Oriole inc. Oriole inc uses the periodic method of accounting for its inventory transactions. 1 Beginning inventory 2200 liters at a cost of 60e per liter. 3 Purchased 2.500 liters atacost of 70e per liter. March March March Sold 2.300 iters for $1.05 per liter. March 10 Purchased 4.000 liters at a cost of 77e per liter. Purchased 2400 iters ata cost of 85e per liter. March 20 March 30 Sold S.000 liters for $1.25 per liter. (a1) Calculate the value of ending inventory that would be reported on the balance sheet, under each of the following cost flow Prepare partial income statements for 2022 through gross profit, under each of the following cost flow assumptions. (Round answers to 2 decimal places, eg 125.25J (1) Specific identifcation method assuming O The March 5 sale consisted of 1,000 liters from the March 1 beginning inventory and 1,300 liters from the March 3 purchase; and O The March 30 sale consisted of the following number of units sold…arrow_forwardDefine Regulation National Market System (Reg NMS)arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Business/Professional Ethics Directors/Executives...AccountingISBN:9781337485913Author:BROOKSPublisher:CengageSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Business/Professional Ethics Directors/Executives...
Accounting
ISBN:9781337485913
Author:BROOKS
Publisher:Cengage

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning