Taller 14 a Jorge Martinez 8a Calculadora de Prestamos

7/24/2019 Taller 14 a Jorge Martinez 8a Calculadora de Prestamos

1/12

Calculadora simple de prstamos

Escriba los valores

Importe del prstamo $ 20,000,000

Inters anual 18.68%

Perodo del prstamo en a!os "

#eca inicial del prstamo 01012016

Pa&o mensual $ '(",6)0

*+mero de pa&os "8

Inters total $ 8,'"2,260

Costo total del prstamo $ 28,'"2,260

* #eca de pa&o -aldo inicial Pa&o Capital Inters -aldo inal

1 212016 / 20,000,000.00 / '(",6)0."2 / 28),2(.08 / )11,))).)) / 1(,16,02.(2

2 )12016 / 1(,16,02.(2 / '(",6)0."2 / 28,0.08 / )06,(2).)" / 1(,"28,(('.8"

) "12016 / 1(,"28,(('.8" / '(",6)0."2 / 2(2,18'.2 / )02,""".0 / 1(,1)6,810.1)

" '12016 / 1(,1)6,810.1) / '(",6)0."2 / 2(6,)".0 / 2(,8(6.)" / 18,8"0,06.0'

' 612016 / 18,8"0,06.0' / '(",6)0."2 / )01,)').2) / 2(),2.18 / 18,')8,22.82

6 12016 / 18,')8,22.82 / '(",6)0."2 / )06,0"".)0 / 288,'86.12 / 18,2)2,68.'2

812016 / 18,2)2,68.'2 / '(",6)0."2 / )10,808.)( / 28),822.0) / 1,(21,80.1)

8 (12016 / 1,(21,80.1) / '(",6)0."2 / )1',6"6.6" / 28,(8).8 / 1,606,22)."(

( 1012016 / 1,606,22)."( / '(",6)0."2 / )20,'60.20 / 2",00.21 / 1,28',66).2(

10 1112016 / 1,28',66).2( / '(",6)0."2 / )2',''0.26 / 26(,080.16 / 16,(60,11).0)

11 1212016 / 16 (60 11) 0) / '(" 6)0 "2 / ))0 61 (( / 26" 012 ") / 16 62( "(' 0"


2/12

11 1212016 / 16 (60 11) 0) / '(" 6)0 "2 / ))0 61 (( / 26" 012 ") / 16 62( "(' 0"


1" )1201 $ 1',('2,)(.08 $ '(",6)0."2 $ )"6,2((."' $ 2"8,))0.( $ 1',606,")(.6)

1' "1201 $ 1',606,")(.6) $ '(",6)0."2 $ )'1,6(0.1 $ 2"2,("0.2" $ 1',2'","(."6

16 '1201 $ 1',2'","(."6 $ '(",6)0."2 $ )',16".82 $ 2),"6'.60 $ 1",8(,'8".6"

1 61201 $ 1",8(,'8".6" $ '(",6)0."2 $ )62,2".68 $ 2)1,(0'.) $ 1",')",8'(.(6

18 1201 $ 1",')",8'(.(6 $ '(",6)0."2 $ )68,)1.10 $ 226,2'(.)2 $ 1",166,"88.86

1( 81201 $ 1",166,"88.86 $ '(",6)0."2 $ )",10'."1 $ 220,'2'.01 $ 1),(2,)8)."6

20 (1201 $ 1),(2,)8)."6 $ '(",6)0."2 $ )(,(28.(8 $ 21",01."" $ 1),"12,"'"."

21 101201 $ 1),"12,"'"." $ '(",6)0."2 $ )8',8").21 $ 208,8.21 $ 1),026,611.26

22 111201 $ 1),026,611.26 $ '(",6)0."2 $ )(1,8"(.'0 $ 202,80.(2 $ 12,6)",61.6

2) 121201 $ 12,6)",61.6 $ '(",6)0."2 $ )(,("(.2( $ 1(6,681.12 $ 12,2)6,812."

2" 112018 $ 12,2)6,812." $ '(",6)0."2 $ "0",1"".0" $ 1(0,"86.)8 $ 11,8)2,668.")

2' 212018 $ 11,8)2,668.") $ '(",6)0."2 $ "10,")'.21 $ 18",1('.21 $ 11,"22,2)).22


3/12


4/12


5/12


Escriba los valores

Importe del prstamo $ 12,000,000

Inters anual 2).%

Perodo del prstamo en a!os 2


Pa&o mensual $ 6)2,6'8

*+mero de pa&os 2"

Inters total $ ),18),8

Costo total del prstamo $ 1',18),8


$ 12,000,000.00 $ 6)2,6'.80 $ )(',6'.80 $ 2),000.00 $ 11,60",)"2.20

$ 11,60",)"2.20 $ 6)2,6'.80 $ "0),"2.0" $ 22(,18'.6 $ 11,200,80.16

$ 11,200,80.16 $ 6)2,6'.80 $ "11,""0.61 $ 221,21.1( $ 10,8(,"2(.'' $ 10,8(,"2(.'' $ 6)2,6'.80 $ "1(,'66.'6 $ 21),0(1.2) $ 10,)6(,862.((

$ 10,)6(,862.(( $ 6)2,6'.80 $ "2,8').00 $ 20",80".( $ (,("2,00(.(8

$ (,("2,00(.(8 $ 6)2,6'.80 $ ")6,)0).10 $ 1(6,)'".0 $ (,'0',06.88

$ (,'0',06.88 $ 6)2,6'.80 $ """,(20.0( $ 18,).1 $ (,060,86.(

$ (,060,86.( $ 6)2,6'.80 $ "'),0.26 $ 18,('0.'" $ 8,60,0(.')

$ 8,60,0(.') $ 6)2,6'.80 $ "62,66.(8 $ 16(,(8(.82 $ 8,1"","11.'6

$ 8,1"","11.'6 $ 6)2,6'.80 $ "1,80'.6 $ 160,8'2.1) $ ,62,60'.8(

$ 62 60' 8( $ 6)2 6' 80 $ "81 12) 8) $ 1'1 ')) ( $ 1(1 "82 0'


6/12


$ 6,200,'"0.1" $ 6)2,6'.80 $ '10,1(.1) $ 122,"60.6 $ ',6(0,)").01

$ ',6(0,)").01 $ 6)2,6'.80 $ '20,2).'2 $ 112,)8".2 $ ',10,06(."8

$ ',10,06(."8 $ 6)2,6'.80 $ ')0,'"8.() $ 102,108.8 $ ",6)(,'20.'6

$ ",6)(,'20.'6 $ 6)2,6'.80 $ '"1,02.2 $ (1,6)0.') $ ",0(8,"().2(

$ ",0(8,"().2( $ 6)2,6'.80 $ ''1,12.'6 $ 80,("'.2" $ ),'"6,80.)

$ ),'"6,80.) $ 6)2,6'.80 $ '62,608.88 $ 0,0"8.(2 $ 2,(8",11.8'

$ 2,(8",11.8' $ 6)2,6'.80 $ '),20."0 $ '8,().)( $ 2,"10,"'1."'

$ 2,"10,"'1."' $ 6)2,6'.80 $ '8',0'1.)8 $ ",606."2 $ 1,82',"00.0

$ 1,82',"00.0 $ 6)2,6'.80 $ '(6,606.1' $ )6,0'1.6' $ 1,228,().(2

$ 1,228,().(2 $ 6)2,6'.80 $ 608,)8(.12 $ 2",268.68 $ 620,"0".80

$ 620,"0".80 $ 6)2,6'.80 $ 620,"0".80 $ 12,2'2.(( $ 0.00

Err'10 Err'08 *34E5 *34E5 *34E5 *34E5 *34E5


7/12


8/12


9/12


Escriba los valoresImporte del prstamo $ '0,000,000

Inters anual 18%

Perodo del prstamo en a!os '


Pa&o mensual $ 1,26(,61

*+mero de pa&os 60

Inters total $ 26,180,282Costo total del prstamo $ 6,180,282


$ '0,000,000.00 $ 1,26(,61.) $ '1(,61.) $ '0,000.00 $ "(,"80,)28.6)

$ "(,"80,)28.6) $ 1,26(,61.) $ '2,"66."" $ "2,20".() $ "8,('2,862.1(

$ "8,('2,862.1( $ 1,26(,61.) $ ')',)8."" $ )",2(2.() $ "8,"1,"8).' $ "8,"1,"8).' $ 1,26(,61.) $ '"),"0(.12 $ 26,262.26 $ ",8",0".6)

$ ",8",0".6) $ 1,26(,61.) $ ''1,'60.2' $ 18,111.12 $ ",)22,'1".)8

$ ",)22,'1".)8 $ 1,26(,61.) $ ''(,8)).66 $ 0(,8).2 $ "6,62,680.)

$ "6,62,680.) $ 1,26(,61.) $ '68,2)1.16 $ 01,""0.21 $ "6,1(",""(.'

$ "6,1(",""(.' $ 1,26(,61.) $ '6,'".6) $ 6(2,(16." $ "',61,6(".("

$ "',61,6(".(" $ 1,26(,61.) $ '8',"0'.(' $ 68",26'."2 $ "',0)2,288.((

$ "',0)2,288.(( $ 1,26(,61.) $ '(",18.0" $ 6',"8".)) $ "",")8,101.('

$ "" ")8 101 (' $ 1 26( 61 ) $ 60) 0(( 8" $ 666 '1 ') $ ") 8)' 002 11


10/12


$ "2,601,'2.2" $ 1,26(,61.) $ 6)0,6"8."6 $ 6)(,022.(1 $ "1,(0,88.

$ "1,(0,88. $ 1,26(,61.) $ 6"0,108.1( $ 62(,'6).18 $ "1,))0,0.'8

$ "1,))0,0.'8 $ 1,26(,61.) $ 6"(,0(.81 $ 61(,(61.'6 $ "0,681,060.

$ "0,681,060. $ 1,26(,61.) $ 6'(,"''."6 $ 610,21'.(1 $ "0,021,60'.)1

$ "0,021,60'.)1 $ 1,26(,61.) $ 66(,)".2( $ 600,)2".08 $ )(,)'2,2'8.02

$ )(,)'2,2'8.02 $ 1,26(,61.) $ 6(,)8.'0 $ '(0,28).8 $ )8,62,80.'2

$ )8,62,80.'2 $ 1,26(,61.) $ 68(,'8.)1 $ '80,0().06 $ ),(8),2(2.21

$ ),(8),2(2.21 $ 1,26(,61.) $ 6((,(21.(( $ '6(,"(.)8 $ ),28),)0.22

$ ),28),)0.22 $ 1,26(,61.) $ 10,"20.82 $ ''(,2'0.'' $ )6,'2,("(."0

$ )6,'2,("(."0 $ 1,26(,61.) $ 21,0.1) $ '"8,'(".2" $ )',8'1,82.2

$ )',8'1,82.2 $ 1,26(,61.) $ )1,8().2( $ '),8.08 $ )',11(,(8.(8

Err'08 $ )',11(,(8.(8 $ 1,26(,61.) $ "2,81.6( $ '26,((.68 $ )",),10.2(


11/12


12/12

Documents

Taller 14 a Jorge Martinez 8a Calculadora de Prestamos