¡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.