segundo taller de fundamentación financiera.xlsx

8/19/2019 Segundo taller de fundamentación financiera.xlsx

1/14

1)

E.M 3.00% E.A 42.58%E.B 6.00% E.A 41.85%E.T 9.00% E.A 41.16%E.S 18.00% E.A 39.24%E.A 36.00% E.A 36.00%

2)

36% A.M.V M.V 3.00% E.TA.T.V

3)

30% A.T.V T.V 7.50% E.MA.M.V

4)

I.V. 5.26% I.A

5)

SEGUNDO TALLER EVTASAS DE INTER

UNDAMENTA!I"N

I#$&'(#$*

Leidy Marcela Aristizábal Osorio CC 1.017.182.781Lady o!a"a Casta#eda $&e CC '3.(88.311)l*a +liet! Acosta Arboleda CC '3.,(8.783

A -artir de "a tasa "o*i"al a"al del 36% calclar la tasa e/ectia a"al sLa ca-italizaci" es *e"salLa ca-italizaci" es bi*estralLa ca-italizaci" es tri*estralLa ca-italizaci" es se*estralLa ca-italizaci" es a"al

Co" "a tasa del 36% AMV calclar "a tasa "o*i"al ca-italizable tri*estral455 La tasa "o*i"al ca-italizable e&iale"te es 37 0(% A.T.V

$ada "a tasa del 30% A.T.V calclar "a tasa "o*i"al AMV e&iale"te455La tasa "o*i"al AMV e&iale"te es 2(28%

tasa *e"sal e"cida e&iale a "a tasa del ,% *e"sal a"tici-ada9e"cido9455 :.V. ,26% y :.A.1(6%

A -artir de "a tasa de i"ters del 3'% A"al co" ca-italizaci" *e"sal cal455 la tasa e/ectia a"al ;


2/14

3'% A"al ca-italizaciM.V 2.83% E.A

6)

M.V 2.92% E.T. 9.01%

7)

M.V 2.17% E.T. 6.64%M.V 3.50% E.T. 10.87%

8)

M.A 3.00% 3.09% E.AT.A 9.00% 9.89% E.AS.A 18.00% 21.95% E.A

A.A 36.00% 56.25% E.A

9)

0.25% S.A 0.249%A.S.A 0.498%

A.S.A 1.498%S.A 0.749%E.S 0.755%E.M 0.13%

> 10000000

A ?

" ,

Cál es la tasa e/ectia tri*estral e&iale"te a "a tasa del 3,% A"al ca455 (01%


3/14

i 0.13%

V(+,' (-$(+ /+ 10% 993754) (0062'6!UOTA 1808031

',/, !,$( I#$' A,#, !($(+

01 1808031 12,3( 17(,'(2

2 1808031 10288 17(77'3

3 1808031 803' 17((((7

' 1808031 ,777 18022,'

, 2808031 3,17 280',1'

10)

>asar e/ectia *e"sal

M.A 2.50%

E.M 2.56%

> ,0000000

A ?

" '8

i 2.,6%

V(+,' (-$(+ D +( - 3042404) '6(,7,(6!UOTA 1669032

',/, !,$( I#$' A,#, 0 166(032

1 166(032 123(2,6 '2(777

2 166(032 1228236 ''07(7

3 166(032 1216(33 ',20((

' 166(032 120,3'1 '636(1

, 166(032 11(3',1 '7,,81

6 166(032 11812,7 '8777,

7 166(032 11687,0 ,00282

8 166(032 11,,(22 ,13110

( 166(032 11'2766 ,26267

10 166(032 112(271 ,3(761

Al co*-rar "a iie"da se &eda" debie"do ,0.000.000 -ara -aBarlos e"

el -lazo de 10.000.000. @i la tasa de F"a"ciaci" es del 30% a"al *e"sal455 las cotas so" de 1.66(.032


4/14

11 166(032 111,'31 ,,3601

12 166(032 1101237 ,677(6

13 166(032 1086678 ,823,,

1' 166(032 10717'6 ,(7287

1, 166(032 10,6'30 612602

16 166(032 10'0723 628310

17 166(032 102'612 6'''2018 166(032 100808( 660(''

1( 166(032 ((11'1 6778(1

20 166(032 (73760 6(,273

21 166(032 (,,(32 713100

22 166(032 (376'7 73138,

23 166(032 (188(' 7,0138

2' 166(032 8((660 76(373

2, 166(032 87((32 78(100

26 166(032 8,(6(( 80(33'

27 166(032 838('7 83008628 166(032 817662 8,1370

2( 166(032 7(,832 873200

30 166(032 773''3 8(,,(0

31 166(032 7,0'7( (18,,'

32 166(032 726(26 ('2106

33 166(032 702770 (66263

3' 166(032 677((' ((103(

3, 166(032 6,2,82 1016',0

36 166(032 626,20 10'2,13

37 166(032 ,((788 106(2''

38 166(032 ,72372 10(6660

3( 166(032 ,''2,2 112'780

'0 166(032 ,1,'12 11,3620

'1 166(032 '8,832 1183200

'2 166(032 ',,'(3 1213,3(

'3 166(032 '2'377 12''6,,

'' 166(032 3(2'63 1276,6(

', 166(032 3,(730 130(302

'6 166(032 3261,8 13'287'

'7 1166(032 2(1726 11377307

11)

M.A 3.00%

@e tie"e "a obliBaci" &e e" " *o*e"to se !aba -actado ca"celar e" 1decide a Elti*a !ora ca"celarla de co"tado. @i la tasa de i"ters acordada e455 @e debe -aBar de co"tado 211.02'


5/14

M.V 3.09%

A 1,000

?

" 18

i 3.0(%

V(+,' '#$ 211024

',/, !,$( I#$' A,#, 0 1,000

1 1,000 6063 8(37

2 1,000 ,786 (21'

3 1,000 ,,01 ('((

' 1,000 ,207 (7(3

, 1,000 '(0, 100(,

6 1,000 ',(2 10'08

7 1,000 '270 107308 1,000 3(3( 11061

( 1,000 3,(7 11'03

10 1,000 32'' 117,6

11 1,000 2880 12120

12 1,000 2,0, 12'(,

13 1,000 211( 12881

1' 1,000 1721 1327(

1, 1,000 1310 136(0

16 1,000 886 1'11'

17 1,000 ',0 1',,0

12)

A ,000000 100000000

> ? > ?

" 10 " 10

i ,% i ,%

V(+,' '#$ 38608675 V(+,' '#$ 61391325V(+,' '(,#(+ 100000000 B,#, ( +( (' ,' +( $(

@e ad&iere " bo"o co" las siBie"tes caractersticasValor "o*i"al 100.000.000 e"ci*ie"to 10 a#os c-" ,% tasa de i"ter


6/14


7/14

9.27%37.09%

2.44%29.28%

1.96%

LUATIVO 25%ÉS Y TIR

INAN!IERA

l*e"te e&iale"te

tasa de i"ters a"tici-ada es e&iale"te al 2% *es

clar la tasa e/ectia a"al e&iale"te


8/14

39.83%

44.12%45.83%48.72%

56.25%

italizable *e"sal*e"te9

*e"sales iBales y "a cota e" el *es , del 10% del alor dela"to será" las cotas *e"sales9


9/14

S(+/,

10000000820',08

6'06766

'606768

280',1'

0

S(+/, '8330(68

'7(011(1

'7'603('

'70082(,

'6,''60'

'606(023

',,812'7

',080(6,

'',678,,

''0'1,88

'3,01827

a#os co" cotas *e"sales a"tici-adas y "a cota E"ica al F"al

a"tici-ado calclar el alor de cada "a de las cotas


10/14

'2('8226

'2380'30

'17(8076

'120078(

'0,88187

3((,(877

3(31,',7386,',1'

37(76623

372813,0

36,682,0

3,83686,

3,086726

3'3173,'

33,282,3

32718(20

3188883'31037'6'

3016'26'

2(26867,

283,0121

27'0801,

26''17,2

2,',071'

2''3'26'

233(17,1

22322,07

2122,8'7

20101067

18('7''6

1776'2'6

16,,0707

1,3060,2

1'02('82

12720180

11377307

;0=

cotas iBales de 1,.000 cada "a -or *es a"tici-ado. @edel 3% *e"sal a"tici-ado !allar el alor.


11/14

S(+/, 1(602'

187087

177873

16837'

1,8,82

1'8'86

13807(

1273'(116288

10'88'

(3128

8100(

68,1'

,,633

'23,'

28663

1',,0

;0=

,# &(+)

,%

ro a la -ar -or&e la tasa de i"ters del *ercado es iBal al C-"


12/14


13/14

((' / #( $(( #,#(+ (#(+ ( $(( :-$;( (#(+

E.B 6.00% E.A 41.85%

M.V 3.00%((' / #( MV ( ET

E.T 9.27%((' / #( ET ( ATV

A.T.V 37.09%((' / #( TV ( EM

E.M 2.44% Mayor a *e"or((' / (#$-(/( ( ;#-/(

I.V. 5.26%((' / ;#-/( ( (#$-(/(

I.A 1.96%E:-$;( #,' ( #( (


14/14

segundo taller de fundamentación financiera.xlsx

Documents