Semana 7 - Excel - Excel para la tarea PDF

Title	Semana 7 - Excel - Excel para la tarea
Author	Dante Sialer
Course	Herramientas informaticas para la toma de desiciones
Institution	Universidad Tecnológica del Perú
Pages	5
File Size	134.3 KB
File Type	PDF
Total Downloads	197
Total Views	305

Preview

CLICK TO PREVIEW PDF

Summary

Download Semana 7 - Excel - Excel para la tarea PDF

Description

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.

Anual Principal Duración Tasa

Mensual S/ 4,500 S/ 4,500.00 3 36 12.00% 0.95%

Cuota mensual

S/.148.15

Tasa

0.95%

Duración

36

Principal

S/.4,500.00

Cuota mensual

S/ 210.70 S/ 117.35

Duración

24 48

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

Cuadro de amortización Amortización Interes S/.105.45 S/.42.70 S/.106.45 S/.41.70 S/.107.46 S/.40.69 S/.108.48 S/.39.67 S/.109.51 S/.38.64 S/.110.55 S/.37.60 S/.111.60 S/.36.55 S/.112.66 S/.35.49 S/.113.73 S/.34.42 S/.114.80 S/.33.34 S/.115.89 S/.32.26 S/.116.99 S/.31.16 S/.118.10 S/.30.05 S/.119.22 S/.28.92 S/.120.36 S/.27.79 S/.121.50 S/.26.65 S/.122.65 S/.25.50 S/.123.81 S/.24.33 S/.124.99 S/.23.16

Saldo S/.4,394.55 S/.4,288.10 S/.4,180.64 S/.4,072.16 S/.3,962.65 S/.3,852.10 S/.3,740.50 S/.3,627.85 S/.3,514.12 S/.3,399.32 S/.3,283.42 S/.3,166.43 S/.3,048.33 S/.2,929.10 S/.2,808.75 S/.2,687.25 S/.2,564.60 S/.2,440.78 S/.2,315.79

S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15

S/.126.18 S/.127.37 S/.128.58 S/.129.80 S/.131.03

S/.21.97 S/.20.78 S/.19.57 S/.18.35 S/.17.12

S/.2,189.62 S/.2,062.25 S/.1,933.66 S/.1,803.86 S/.1,672.83

S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15

S/.132.28 S/.133.53 S/.134.80 S/.136.08 S/.137.37

S/.15.87 S/.14.62 S/.13.35 S/.12.07 S/.10.78

S/.1,540.55 S/.1,407.02 S/.1,272.22 S/.1,136.15 S/.998.78

S/.148.15

S/.138.67

S/.9.48

S/.860.11

S/.148.15

S/.139.99

S/.8.16

S/.720.12

S/.148.15 S/.148.15 S/.148.15 S/.148.15 S/.148.15

S/.141.32 S/.142.66 S/.144.01 S/.145.38 S/.146.76

S/.6.83 S/.5.49 S/.4.14 S/.2.77 S/.1.39

S/.578.80 S/.436.15 S/.292.13 S/.146.76 S/.0.00...