taller n°14 juan luis giraldo 8°e

7/24/2019 Taller N14 Juan Luis Giraldo 8E

1/8

Calculadora simple de prstamos

Escriba los valores

Importe del prstamo $ 20,000,000.00

Inters anual 16.68%

Perodo del prstamo en a!os "

#eca inicial del prstamo 01012016

Pa&o mensual $ '(),(*'.0)

+mero de pa&os "8

Inters total $ (,'"2,161.6"

Costo total del prstamo $ 2(,'"2,161.6"

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

1 212016 $ 20,000,000.0 $ '(),(*'.0 $ 2*',(*'.0 $ 2(8,000.0 $ 1*,(0",20'.0

2 )12016 $ 1*,(0",20'.0 $ '(),(*'.0 $ 2**,*06.6 $ 2(),888." $ 1*,"0",2*8."

) "12016 $ 1*,"0",2*8." $ '(),(*'.0 $ )0",0('.) $ 26*,(1*.( $ 1*,100,22).1

" '12016 $ 1*,100,22).1 $ '(),(*'.0 $ )08,)01.* $ 26',"*).1 $ 18,(*1,*21.2

' 612016 $ 18,(*1,*21.2 $ '(),(*'.0 $ )12,'8(.) $ 261,20(.( $ 18,"(*,))).8

6 (12016 $ 18,"(*,))).8 $ '(),(*'.0 $ )16,*)2.) $ 2'6,862.( $ 18,162,"01.'

( 812016 $ 18,162,"01.' $ '(),(*'.0 $ )21,))(.( $ 2'2,"'(." $ 1(,8"1,06).*

8 *12016 $ 1(,8"1,06).* $ '(),(*'.0 $ )2',80".2 $ 2"(,**0.8 $ 1(,'1',2'*.6

* 1012016 $ 1(,'1',2'*.6 $ '(),(*'.0 $ ))0,))2.* $ 2"),"62.1 $ 1(,18",*26.(

10 1112016 $ 1(,18",*26.( $ '(),(*'.0 $ ))",*2".6 $ 2)8,8(0.' $ 16,8'0,002.2

11 1212016 $ 16 8'0 002 2 $ '() (*' 0 $ ))* '80 0 $ 2)" 21' 0 $ 16 '10 "22 2


2/8

11 1212016 $ 16 8'0 002 2 $ '() (*' 0 $ ))* '80 0 $ 2)" 21' 0 $ 16 '10 "22 2


1" )1201( $ 1',81(,0)6.1 $ '(),(*'.0 $ )'),*)8.2 $ 21*,8'6.8 $ 1',"6),0*(.8

1' "1201( $ 1',"6),0*(.8 $ '(),(*'.0 $ )'8,8'8.0 $ 21",*)(.1 $ 1',10",2)*.8

16 '1201( $ 1',10",2)*.8 $ '(),(*'.0 $ )6),8"6.1 $ 20*,*"8.* $ 1",("0,)*).(

1( 61201( $ 1",("0,)*).( $ '(),(*'.0 $ )68,*0).6 $ 20",8*1.' $ 1",)(1,"*0.2

18 (1201( $ 1",)(1,"*0.2 $ '(),(*'.0 $ )(",0)1.) $ 1**,(6).( $ 1),**(,"'8.*

1* 81201( $ 1),**(,"'8.* $ '(),(*'.0 $ )(*,2)0." $ 1*",'6".( $ 1),618,228.'

20 *1201( $ 1),618,228.' $ '(),(*'.0 $ )8",'01.( $ 18*,2*)." $ 1),2)),(26.8

21 101201( $ 1),2)),(26.8 $ '(),(*'.0 $ )8*,8"6.2 $ 18),*"8.8 $ 12,8"),880.6

22 111201( $ 12,8"),880.6 $ '(),(*'.0 $ )*',26'.1 $ 1(8,'2*.* $ 12,""8,61'.'

2) 121201( $ 12,""8,61'.' $ '(),(*'.0 $ "00,('*.) $ 1(),0)'.8 $ 12,0"(,8'6.2

2" 112018 $ 12,0"(,8'6.2 $ '(),(*'.0 $ "06,)2*.8 $ 16(,"6'.2 $ 11,6"1,'26."

2' 212018 $ 11,6"1,'26." $ '(),(*'.0 $ "11,*((.8 $ 161,81(.2 $ 11,22*,'"8.6


3/8


4/8


5/8

Calculadora simple de prstamos

Escriba los valores

Importe del prstamo $ '0,000,000.00

Inters anual 18.00%

Perodo del prstamo en a!os '

#eca inicial del prstamo 01012016

Pa&o mensual $ 1,26*,6(1.)(

+mero de pa&os 60

Inters total $ 26,180,282.28

Costo total del prstamo $ (6,180,282.28


Err'08 $ '0,000,000.0 +3E4 $ '1*,6(1." $ ('0,000.0 $ "*,"80,)28.6

Err'08 $ "*,"80,)28.6 +3E4 $ '2(,"66." $ ("2,20".* $ "8,*'2,862.2

Err'08 $ "8,*'2,862.2 +3E4 $ ')',)(8." $ ()",2*2.* $ "8,"1(,"8).( Err'08 $ "8,"1(,"8).( +3E4 $ '"),"0*.1 $ (26,262.) $ "(,8(",0(".6

Err'08 $ "(,8(",0(".6 +3E4 $ ''1,'60.) $ (18,111.1 $ "(,)22,'1"."

Err'08 $ "(,)22,'1"." +3E4 $ ''*,8)).( $ (0*,8)(.( $ "6,(62,680.(

Err'08 $ "6,(62,680.( +3E4 $ '68,2)1.2 $ (01,""0.2 $ "6,1*",""*.6

Err'08 $ "6,1*",""*.6 +3E4 $ '(6,('".6 $ 6*2,*16.( $ "',61(,6*".*

Err'08 $ "',61(,6*".* +3E4 $ '8',"0'.* $ 68",26'." $ "',0)2,28*.0

Err'08 $ "',0)2,28*.0 +3E4 $ '*",18(.0 $ 6(',"8".) $ "",")8,102.0

Err'08 $ "" ")8 102 0 +3E4 $ 60) 0** 8 $ 666 '(1 ' $ ") 8)' 002 1


6/8


Err'08 $ "2,601,'2(.2 +3E4 $ 6)0,6"8.' $ 6)*,022.* $ "1,*(0,8(8.8

Err'08 $ "1,*(0,8(8.8 +3E4 $ 6"0,108.2 $ 62*,'6).2 $ "1,))0,((0.6

Err'08 $ "1,))0,((0.6 +3E4 $ 6"*,(0*.8 $ 61*,*61.6 $ "0,681,060.8

Err'08 $ "0,681,060.8 +3E4 $ 6'*,"''.' $ 610,21'.* $ "0,021,60'.)

Err'08 $ "0,021,60'.) +3E4 $ 66*,)"(.) $ 600,)2".1 $ )*,)'2,2'8.0

Err'08 $ )*,)'2,2'8.0 +3E4 $ 6(*,)8(.' $ '*0,28).* $ )8,6(2,8(0.'

Err'08 $ )8,6(2,8(0.' +3E4 $ 68*,'(8.) $ '80,0*).1 $ )(,*8),2*2.2

Err'08 $ )(,*8),2*2.2 +3E4 $ 6**,*22.0 $ '6*,("*." $ )(,28),)(0.2

Err'08 $ )(,28),)(0.2 +3E4 $ (10,"20.8 $ ''*,2'0.6 $ )6,'(2,*"*."

Err'08 $ )6,'(2,*"*." +3E4 $ (21,0((.1 $ '"8,'*".2 $ )',8'1,8(2.)

Err'08 $ )',8'1,8(2.) +3E4 $ ()1,8*).) $ ')(,((8.1 $ )',11*,*(*.0

Err'08 $ )',11*,*(*.0 +3E4 $ ("2,8(1.( $ '26,(**.( $ )",)((,10(.)


7/8


8/8

taller n°14 juan luis giraldo 8°e

Documents