Title | Semana 7 - Excel - Excel para la tarea Terminado |
---|---|
Course | Herramientas informaticas para la toma de desiciones |
Institution | Universidad Tecnológica del Perú |
Pages | 5 |
File Size | 102.9 KB |
File Type | |
Total Downloads | 62 |
Total Views | 800 |
Download Semana 7 - Excel - Excel para la tarea Terminado PDF
Funciones Financieras Supongamos un préstamo (Principal) de 5000 soles, se debe pagar una cuota inicial del 10%. Para ello solicita un préstamo con una TEA de 12% y pagos mensuales de 148 soles con 15 centimos.
Principal Duración Tasa
Cuota mensual
Tasa
Anual Mensual S/.5,000.00 S/.5,000.00 3 36 12.00% 0.9489%
S/.148.15
0.3532%
Duración
40.87433376
Principal
S/.4,500.02
Mes 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
33 34 35 36
Cuota S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15
Cuadro de amortización Amortización Interes S/.117.17 S/.47.44 S/.118.28 S/.46.33 S/.119.40 S/.45.21 S/.120.53 S/.44.08 S/.121.68 S/.42.93 S/.122.83 S/.41.78 S/.124.00 S/.40.61 S/.125.17 S/.39.44 S/.126.36 S/.38.25 S/.127.56 S/.37.05 S/.128.77 S/.35.84 S/.129.99 S/.34.62 S/.131.23 S/.33.38 S/.132.47 S/.32.14 S/.133.73 S/.30.88 S/.135.00 S/.29.61 S/.136.28 S/.28.33 S/.137.57 S/.27.04 S/.138.88 S/.25.73 S/.140.19 S/.24.42 S/.141.53 S/.23.09 S/.142.87 S/.21.74 S/.144.22 S/.20.39 S/.145.59 S/.19.02 S/.146.97 S/.17.64 S/.148.37 S/.16.24 S/.149.78 S/.14.83 S/.151.20 S/.13.41 S/.152.63 S/.11.98 S/.154.08 S/.10.53 S/.155.54 S/.9.07 S/.157.02 S/.7.59
Saldo S/.4,394.57 S/.4,288.12 S/.4,180.66 S/.4,072.18 S/.3,962.67 S/.3,852.12 S/.3,740.52 S/.3,627.86 S/.3,514.14 S/.3,399.33 S/.3,283.44 S/.3,166.44 S/.3,048.34 S/.2,929.11 S/.2,808.76 S/.2,687.26 S/.2,564.61 S/.2,440.79 S/.2,315.80 S/.2,189.63 S/.2,062.25 S/.1,933.67 S/.1,803.87 S/.1,672.84 S/.1,540.56 S/.1,407.03 S/.1,272.23 S/.1,136.15 S/.998.78 S/.860.11 S/.720.12 S/.578.80
S/.148.15 S/.148.15 S/.148.15 S/.148.15
S/.158.51 S/.160.01 S/.161.53 S/.163.06
S/.6.10 S/.4.60 S/.3.08 S/.1.55
S/.436.15 S/.292.14 S/.146.76 S/.0.00...