Docsity
Docsity

Prepara tus exámenes
Prepara tus exámenes

Prepara tus exámenes y mejora tus resultados gracias a la gran cantidad de recursos disponibles en Docsity


Consigue puntos base para descargar
Consigue puntos base para descargar

Gana puntos ayudando a otros estudiantes o consíguelos activando un Plan Premium


Orientación Universidad
Orientación Universidad

ACTIVIDAD 7 MATEMATICA FINANCIERA, AMORTIZACIONES, Ejercicios de Matemática Financiera

AMORTIZACIONES, ACTIVIDAD 7, MATE FINANCIERAS

Tipo: Ejercicios

2022/2023

Subido el 29/05/2023

diego-acuna-10
diego-acuna-10 🇲🇽

1 documento

1 / 7

Toggle sidebar

Esta página no es visible en la vista previa

¡No te pierdas las partes importantes!

bg1
MATEMÁTICAS FINANCIERAS
UNIDAD 4. AMORTIZACIONES
ACTIVIDAD 7. RESOLUCIÓN DE PROBLEMAS
Datos de identificación
Instrucciones:
1. Resolver los siguientes problemas realizando los cálculos y operaciones que correspondan. Realizar
todos los cálculos y operaciones en una hoja de Excel e integrar los resultados en este documento;
puedes integrar los cálculos de la hoja de Excel al final de este documento, o enviar ambos
archivos (el de Excel y este Word) en la plataforma de Blackboard.
Problema A.
Una pareja de recién casada desea comprar un departamento con valor de $3,800,000. El crédito
hipotecario que solicitaron consiste en un enganche de $760,000. El financiamiento es a 15 años con
pagos mensuales vencidos y causa un interés nominal de 9.60%, capitalizable mensualmente.
**Considerar que los créditos hipotecarios para adquisición de casa-habitación no son sujetos del pago
del IVA.
Con la información anterior:
¿Cuánto deberán pagar mensualmente?
Datos:
C= $3,800,000.00 - $760,000.00= i= 9.60% capitalizable mensualmente=
9.60/12=0.8/100= 0.008%
N= 15 años = 180 meses. R=
Ci
1−(1+i)n
Nombre(s) estudiante(s) - Vianney Fernanda Mar Herrera.
- Ángel Sánchez Martínez.
- Diego Acuña Martínez.
Nombre docente Carlos Escamilla Jiménez.
Fecha 20 de febrero de 2023.
pf3
pf4
pf5

Vista previa parcial del texto

¡Descarga ACTIVIDAD 7 MATEMATICA FINANCIERA, AMORTIZACIONES y más Ejercicios en PDF de Matemática Financiera solo en Docsity!

MATEMÁTICAS FINANCIERAS

UNIDAD 4. AMORTIZACIONES ACTIVIDAD 7. RESOLUCIÓN DE PROBLEMAS Datos de identificación Instrucciones:

1. Resolver los siguientes problemas realizando los cálculos y operaciones que correspondan. Realizar todos los cálculos y operaciones en una hoja de Excel e integrar los resultados en este documento; puedes integrar los cálculos de la hoja de Excel al final de este documento, o enviar ambos archivos (el de Excel y este Word) en la plataforma de Blackboard.

Problema A.

Una pareja de recién casada desea comprar un departamento con valor de $3,800,000. El crédito hipotecario que solicitaron consiste en un enganche de $760,000. El financiamiento es a 15 años con pagos mensuales vencidos y causa un interés nominal de 9.60%, capitalizable mensualmente. **Considerar que los créditos hipotecarios para adquisición de casa-habitación no son sujetos del pago del IVA. Con la información anterior:  ¿Cuánto deberán pagar mensualmente? Datos: C= $3,800,000.00 - $760,000.00= i= 9.60% capitalizable mensualmente= 9.60/12=0.8/100= 0.008% N= 15 años = 180 meses. R=

Ci

1 −( 1 + i )

n Nombre(s) estudiante(s) - Vianney Fernanda Mar Herrera.

  • Ángel Sánchez Martínez.
  • Diego Acuña Martínez. Nombre docente Carlos Escamilla Jiménez. Fecha 20 de febrero de 2023.

R=

Ci

1 −( 1 + i )

n

R=

− 180

R= $31,928.

Elaborar la tabla de amortización correspondiente a los primeros 6 meses Periodo Pago Interés R Amortización Saldo 0 0 0 0 $3,040,000. 1 $31,928.12 $24,320.00 $7,608.12 $3,032,391. 2 $31,928.12 $24,259.14 $7,668.98 $3,024,722. 3 $31,928.12 $24,197.78 $7,730.34 $3,016,992. 4 $31,928.12 $24,135.94 $7,792.18 $3,009,200. 5 $31,928.12 $24,073.60 $7,854.52 $3,001,345. 6 $31,928.12 $24,010.77 $7,917.35 $2,993,428.  Calcular el saldo insoluto al final del año 10 Periodo Pago Interes R Amortización Saldo 0 0 0 0 $3,040,000. 1 $31,928.12 $24,320.00 $7,608.12 $3,032,391. 2 $31,928.12 $24,259.14 $7,668.98 $3,024,722. 3 $31,928.12 $24,197.78 $7,730.34 $3,016,992. 4 $31,928.12 $24,135.94 $7,792.18 $3,009,200. 5 $31,928.12 $24,073.60 $7,854.52 $3,001,345. 6 $31,928.12 $24,010.77 $7,917.35 $2,993,428. 7 $31,928.12 $23,947.43 $7,980.69 $2,985,447. 8 $31,928.12 $23,883.58 $8,044.54 $2,977,403. 9 $31,928.12 $23,819.23 $8,108.89 $2,969,294. 10 $31,928.12 $23,754.36 $8,173.76 $2,961,120. 11 $31,928.12 $23,688.96 $8,239.16 $2,952,881. 12 $31,928.12 $23,623.05 $8,305.07 $2,944,576. 13 $31,928.12 $23,556.61 $8,371.51 $2,936,204. 14 $31,928.12 $23,489.64 $8,438.48 $2,927,766.

C= $3,040,000.

n= 180 meses i= 0. R= $31,928.

  • 15 $31,928.12 $23,422.13 $8,505.99 $2,919,260.
  • 16 $31,928.12 $23,354.08 $8,574.04 $2,910,686.
  • 17 $31,928.12 $23,285.49 $8,642.63 $2,902,043.
  • 18 $31,928.12 $23,216.35 $8,711.77 $2,893,331.
  • 19 $31,928.12 $23,146.66 $8,781.46 $2,884,550.
  • 20 $31,928.12 $23,076.40 $8,851.72 $2,875,698.
  • 21 $31,928.12 $23,005.59 $8,922.53 $2,866,776.
  • 22 $31,928.12 $22,934.21 $8,993.91 $2,857,782.
  • 23 $31,928.12 $22,862.26 $9,065.86 $2,848,716.
  • 24 $31,928.12 $22,789.73 $9,138.39 $2,839,578.
  • 25 $31,928.12 $22,716.62 $9,211.50 $2,830,366.
  • 26 $31,928.12 $22,642.93 $9,285.19 $2,821,081.
  • 27 $31,928.12 $22,568.65 $9,359.47 $2,811,721.
  • 28 $31,928.12 $22,493.78 $9,434.34 $2,802,287.
  • 29 $31,928.12 $22,418.30 $9,509.82 $2,792,777.
  • 30 $31,928.12 $22,342.22 $9,585.90 $2,783,191.
  • 31 $31,928.12 $22,265.54 $9,662.58 $2,773,529.
  • 32 $31,928.12 $22,188.23 $9,739.89 $2,763,789.
  • 33 $31,928.12 $22,110.32 $9,817.80 $2,753,971.
  • 34 $31,928.12 $22,031.77 $9,896.35 $2,744,075.
  • 35 $31,928.12 $21,952.60 $9,975.52 $2,734,099.
  • 36 $31,928.12 $21,872.80 $10,055.32 $2,724,044.
  • 37 $31,928.12 $21,792.36 $10,135.76 $2,713,908.
  • 38 $31,928.12 $21,711.27 $10,216.85 $2,703,691.
  • 39 $31,928.12 $21,629.53 $10,298.59 $2,693,393.
  • 40 $31,928.12 $21,547.15 $10,380.97 $2,683,012.
  • 41 $31,928.12 $21,464.10 $10,464.02 $2,672,548.
  • 42 $31,928.12 $21,380.39 $10,547.73 $2,662,000.
  • 43 $31,928.12 $21,296.00 $10,632.12 $2,651,368.
  • 44 $31,928.12 $21,210.95 $10,717.17 $2,640,651.
  • 45 $31,928.12 $21,125.21 $10,802.91 $2,629,848.
  • 46 $31,928.12 $21,038.79 $10,889.33 $2,618,958.
  • 47 $31,928.12 $20,951.67 $10,976.45 $2,607,982.
  • 48 $31,928.12 $20,863.86 $11,064.26 $2,596,918.
  • 49 $31,928.12 $20,775.35 $11,152.77 $2,585,765.
  • 50 $31,928.12 $20,686.12 $11,242.00 $2,574,523.
  • 51 $31,928.12 $20,596.19 $11,331.93 $2,563,191.
  • 52 $31,928.12 $20,505.53 $11,422.59 $2,551,768.
  • 53 $31,928.12 $20,414.15 $11,513.97 $2,540,255.
  • 54 $31,928.12 $20,322.04 $11,606.08 $2,528,648.
  • 55 $31,928.12 $20,229.19 $11,698.93 $2,516,950.
  • 56 $31,928.12 $20,135.60 $11,792.52 $2,505,157.
  • 57 $31,928.12 $20,041.26 $11,886.86 $2,493,270.
  • 58 $31,928.12 $19,946.17 $11,981.95 $2,481,288.
  • 59 $31,928.12 $19,850.31 $12,077.81 $2,469,210.
  • 60 $31,928.12 $19,753.69 $12,174.43 $2,457,036.
  • 61 $31,928.12 $19,656.29 $12,271.83 $2,444,764.
  • 62 $31,928.12 $19,558.12 $12,370.00 $2,432,394.
  • 63 $31,928.12 $19,459.16 $12,468.96 $2,419,925.
  • 64 $31,928.12 $19,359.41 $12,568.71 $2,407,356.
  • 65 $31,928.12 $19,258.86 $12,669.26 $2,394,687.
  • 66 $31,928.12 $19,157.50 $12,770.62 $2,381,917.
  • 67 $31,928.12 $19,055.34 $12,872.78 $2,369,044.
  • 68 $31,928.12 $18,952.35 $12,975.77 $2,356,068.
  • 69 $31,928.12 $18,848.55 $13,079.57 $2,342,988.
  • 70 $31,928.12 $18,743.91 $13,184.21 $2,329,804.
  • 71 $31,928.12 $18,638.44 $13,289.68 $2,316,515.
  • 72 $31,928.12 $18,532.12 $13,396.00 $2,303,119.
  • 73 $31,928.12 $18,424.95 $13,503.17 $2,289,615.
  • 74 $31,928.12 $18,316.93 $13,611.19 $2,276,004.
  • 75 $31,928.12 $18,208.04 $13,720.08 $2,262,284.
  • 76 $31,928.12 $18,098.28 $13,829.84 $2,248,454.
  • 77 $31,928.12 $17,987.64 $13,940.48 $2,234,514.
  • 78 $31,928.12 $17,876.11 $14,052.01 $2,220,462.
  • 79 $31,928.12 $17,763.70 $14,164.42 $2,206,297.
  • 80 $31,928.12 $17,650.38 $14,277.74 $2,192,020.
  • 81 $31,928.12 $17,536.16 $14,391.96 $2,177,628.
  • 82 $31,928.12 $17,421.03 $14,507.09 $2,163,121.
  • 83 $31,928.12 $17,304.97 $14,623.15 $2,148,497.
  • 84 $31,928.12 $17,187.98 $14,740.14 $2,133,757.
  • 85 $31,928.12 $17,070.06 $14,858.06 $2,118,899.
  • 86 $31,928.12 $16,951.20 $14,976.92 $2,103,922.
  • 87 $31,928.12 $16,831.38 $15,096.74 $2,088,826.
  • 88 $31,928.12 $16,710.61 $15,217.51 $2,073,608.
  • 89 $31,928.12 $16,588.87 $15,339.25 $2,058,269.
  • 90 $31,928.12 $16,466.15 $15,461.97 $2,042,807.
  • 91 $31,928.12 $16,342.46 $15,585.66 $2,027,221.
  • 92 $31,928.12 $16,217.77 $15,710.35 $2,011,511.
  • 93 $31,928.12 $16,092.09 $15,836.03 $1,995,675.
  • 94 $31,928.12 $15,965.40 $15,962.72 $1,979,712.
  • 95 $31,928.12 $15,837.70 $16,090.42 $1,963,622.
  • 96 $31,928.12 $15,708.98 $16,219.14 $1,947,402.
  • 97 $31,928.12 $15,579.22 $16,348.90 $1,931,054.
  • 98 $31,928.12 $15,448.43 $16,479.69 $1,914,574.
  • 99 $31,928.12 $15,316.60 $16,611.52 $1,897,962.
  • 100 $31,928.12 $15,183.70 $16,744.42 $1,881,218.
  • 101 $31,928.12 $15,049.75 $16,878.37 $1,864,340.
  • 102 $31,928.12 $14,914.72 $17,013.40 $1,847,326.
  • 103 $31,928.12 $14,778.61 $17,149.51 $1,830,177.
  • 104 $31,928.12 $14,641.42 $17,286.70 $1,812,890.
  • 105 $31,928.12 $14,503.12 $17,425.00 $1,795,465.
  • 106 $31,928.12 $14,363.72 $17,564.40 $1,777,901.
  • 107 $31,928.12 $14,223.21 $17,704.91 $1,760,196.
  • 108 $31,928.12 $14,081.57 $17,846.55 $1,742,349.
  • 109 $31,928.12 $13,938.80 $17,989.32 $1,724,360.
  • 110 $31,928.12 $13,794.88 $18,133.24 $1,706,227.
  • 111 $31,928.12 $13,649.82 $18,278.30 $1,687,948.
  • 112 $31,928.12 $13,503.59 $18,424.53 $1,669,524.
  • 113 $31,928.12 $13,356.19 $18,571.93 $1,650,952.
  • 114 $31,928.12 $13,207.62 $18,720.50 $1,632,231.
  • 115 $31,928.12 $13,057.85 $18,870.27 $1,613,361.
  • 116 $31,928.12 $12,906.89 $19,021.23 $1,594,340.
  • 117 $31,928.12 $12,754.72 $19,173.40 $1,575,166.
  • 118 $31,928.12 $12,601.34 $19,326.78 $1,555,840.
  • 119 $31,928.12 $12,446.72 $19,481.40 $1,536,358.
  • 120 $31,928.12 $12,290.87 $19,637.25 $1,516,721.

Resultados. Periodo Saldo Interes Interes Mensual IVA R Amortización Pago 0 $8,000,000.00 0 0 0 0 0 1 $6,116,000.00 0.0125 $100,000.00 $16,000.00 $1,884,000.00 $2,000,000. 2 $4,204,682.00 0.0125 $76,450.00 $12,232.00 $1,911,318.00 $2,000,000. 3 $2,765,649.89 0.0125 $52,558.53 $8,409.36 $1,439,032.11 $1,500,000. 4 $1,305,751.81 0.0125 $34,570.62 $5,531.30 $1,459,898.08 $1,500,000. 5 $0.00 0.0125 $16,321.90 $2,611.50 $1,286,818.41 $1,305,751.