Formuario.xlsx

Futuro dado Presente (F/P)

P i N F

$

-

Presente dado Futuro (P/F)

F i N

$

35,000.00 8% 10

P

$

16,211.77

Anualidad dado Futuro (A/F)

F i N A

Futuro dado Anualidad (F/A)

A i N #DIV/0

F

Anualidad dado Presente (A/P)

P i N A

Presente dado Anualidad

A i N #DIV/0

P

Anualidad dado !radiente (A/!)

G i N A

#DIV/0

#DIV/0

Presente dado !radiente (P/!)

G i N #DIV/0

P

#DIV/0

A i # N F

Gradiente exponencial Creciente FUTUR $ 30,000.00 "% "% 3 $ ",1,&&.11

A i # N F

A i # N P

Gradiente exponcecial Creciente PR'('NT' $ 0,000.00 10% 10% " $ "3,33."

A i # N P

Futuro dado un !radiente (F/!)

G i N

$

50.00 % 1

F

$

","0.22

Gradiente exponencial !ecreciente FUTUR

)!*+0Gradiente exponcecial !ecreciente PR'('NT'

)!*+0-

3 ao/ 5 ao/ & ao/ 10 ao/ 15 ao/ 0.3333 0. 0.1" 0.1 0.05 0.""5 0.3 0."" 0.18 0.05 0.1"81 0.1 0.1&" 0.1"" 0.0855 0.0&"1 0.115 0.1" 0.115 0.0&& 0.115 0.083 0.0 0.03 0.05& 0.08 0.0&3& 0.03 0.083 0.055 0.05 0.0"" 0.055 0.05 0.05 0.051 0.055 0.05 0.038 0.051 0.05 0.051 0.05 0.051 0.05

Una e7pre/a e7pre/a portaria portaria dedicad dedicadaa a la con/trccion con/trccion de 9:e/ 9:e/ co7er co7ercial ciale/ e/ co7pr; co7pr; a para para ?acilitar ?acilitar la 7an?actr 7an?actraa de dicn ta9la/ de 7etodo (DARC @ BliEar con todo/ lo/ 7etodo/. a R 9 (!A c(! d(DARC

PARA R n +( P !T

& $ &50,000.00 $ 5,000,000.00 0&1".85&1" A2

+AR 'N *R 0 1  3 " 5  &

$ $ $ $ $ $ $ $

5,000, 5,000,000. 000.00 00 ",3, ",3,85&. 85&.1" 1" 3,&85, 3,&85,&1". &1".  3,1&8, 3,1&8,5&1. 5&1."3 "3 ,5&1, ,5&1,"8. "8.5& 5& 1,", 1,",85. 85.&1 &1 1,35&, 1,35&,1". 1".8 8 &50,000 &50,000.00 .00

+( P n (!A

$ $

A24t

PARA (!A &50,000.00 5,000,000.00 & 8

!'PR'C*AC*6N4!t 1  3 " 5  &

$ $ $ $ $ $ $

1,0,5 1,0,500. 00.00 00 10,&1" 10,&1". . &58,8 &58,8.5& .5& 0&,1" 0&,1".8 .8 "55,35& "55,35&.1" .1" 303,5&1 303,5&1."3 ."3 151,&85 151,&85.&1 .&1

/ o

+( P n dt7ax d +AR 'N *R $ $ $ $ $ $ $

3,3&,500.00 3,3&,500.00 3,0,&85.&1 3,0,&85.&1 ,&,85&.1" ,&,85&.1" 1,0,&1". 1,0,&1". 1,05,35&.1" 1,05,35&.1" 01,&85.&1 01,&85.&1 &50,000.00 &50,000.00

$ $

A24t

PARA (! &50,000.00 5,000,000.00 & 0.85&1"85& 0.3&35&53

!'PR'C*AC*6N4!t 1  3 " 5  &

$ $ $ $ $ $ $

1,18,8.88 1,18,8.88 05,1&.1 05,1&.1 0,30." 0,30." 5,"30.0 5,"30.0 "01,"5&.3 "01,"5&.3 30,15.&8 30,15.&8 33,"&3.1 33,"&3.1

+( P n

+AR 'N *R $ $ $ $ $ $ $

3,813,01&.1 3,813,01&.1 ,0&,81. ,0&,81. ,1&,513."3 ,1&,513."3 1,1,083.33 1,1,083.33 1,8,5." 1,8,5." 83,"&3.1 83,"&3.1 &50,000.00 &50,000.00

A24t 1  3 " 5  & 8

$ $

PARA (DARC &50,000.00 5,000,000.00 &

!'PR'C*AC*6N4!t +AR 'N *R  $ $ $ $ $ $ $ $

&1",500.00 1,",500.00 8&",500.00 ",500.00 "",500.00 "",000.00 "",500.00 3,000.00

$ $ $ $ $ $ $ $

",85,500.00 3,01,000.00 ,18,500.00 1,5,000.00 1,115,500.00 ,500.00 3,000.00 

U/ted nece/ita co7prar n e:ipo de ena/ado :e proporcionara in=re/o/ de $10,000 anale/ drante dieE ao/, lo/ co/to/ de 7anteni7iento 7anteni7iento @ operaci;n /eran de $5,000 para el pri7er ao @ tendran n a7ento del 5% en lo/ /i=iente/ ao/. 'l co/to del e:ipo e/ de $300,000 @ tendra n alor de /ala7ento /ala7ento de $35,000. $35,00 0. !eter7inar 7ediante +P con :e 7etodo de depreciacion, /i el car=o por depreciacion /e con/idera co7o n in=re/o. a ta/ de intere/ :e /e BliEa e/ del 8%.

!ato/ *n=re/o/ Co/to/ de operacion *ncre7ento de co/to/ P +( n i

A i # N

$10,000 $5,000 5% $300,000 $35,000 10 8%

Gradiente exponcecial Creciente PR'('NT' $ 5,000.00 8% 5% 10

P

Pre

A i N P

$ 20,%%.%

!T

$

PARA R ,500.00

!'PR'C*AC*6N4 !t

A2 1  3 " 5  & 8  10

$ $ $ $ $ $ $ $ $ $

,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00 ,500.00

(!A +AR 'N *R $&3,500 $&3,500 $"&,000 $"&,000 $0,500 $0,500 $1",000 $1",000 $1&,500 $1&,500 $1"1,000 $1"1,000 $11",500 $11",500 $88,000 $1,500 $35,000

*n=re/o/ de depre/iacion

Pre/ente dado ?tro $ $ $ $ $ $ $ $ $ $

",53&.0" ",53&.0" ,&1."8 ,&1."8 1,03.55 1,03.55 1,"&8. 1,"&8. 18,035."5 18,035."5 1,.50 1,.50 15,".50 15,".50 1",31&.13 1",31&.13 13,5.0 13,5.0 1,&".3 1,&".3

$ 1&&,81&.1

A2 1  3 " 5  & 8  10

Co/to/ de e:ipo Danteni7iento *n=re/o/ anale/ +alor de /ala7ento

$300,000 $ 0",588.85 $ 80 805,0.&& $ 1,11.&&

Total de in=re/o/

$ "",".85

+alor Danteni7iento *n=re/o/ Co/to del e:ipo

+alor pre/ente $ 0",588.85 $ 805,0.&& $300,000 $00,0.

sente dado Anualidad

Presente dado Futuro (P/F)

$

10,000.00 8% 10

F i N

$ 35,000.00 8% 10

$

%0,20&.77

P

$ 16,211.77

PARA (!A 55

dt7ax d

dado !'PR'C*AC*6N4!t +AR 'N *R Pre/ente ?tro $"8,181.8 $"8,181.8 $"3,33." $"3,33." $38,5"5."5 $38,5"5."5 $33,&&.& $33,&&.& $8,0.0 $8,0.0 $",00.1 $",00.1 $1,&.&3 $1,&.&3 $1","5".55 $1","5".55 $,3. $,3.3 3 $",818.18 $",818.18

PARA (! 0. 0.13338 !'PR'C*AC* 6N4!t

$51,818.18 $51,818.18 $08,"5".55 $08,"5".55 $1,0.0 $1,0.0 $13,181.8 $13,181.8 $10&,&.&3 $10&,&.&3 $83,181.8 $83,181.8 $3,0.0 $3,0.0 $","5".55 $","5".55 $3,81 $3,818.1 8.18 8 $35,000.00 $35,000.00

*n=re/o/ de depre/iacion depre/iacion

$ $ $ $ $ $ $ $ $ $

"",1.& "",1.& 3&,1&&.33 3&,1&&.33 30,58. 30,58. ",&0.55 ",&0.55 1,&5.0" 1,&5.0" 15,181.3 15,181.3 11,"5."5 11,"5."5 &,80.3" &,80.3" ",80. ",80.58 58 ,31.&5 ,31.&5

$ 18,1".8

A2 1  3 " 5  & 8  10

5&.83& 5&.83& "&8."& "&8."& 3&&"1.13&3 3&&"1.13&3 30""".55& 30""".55& "558."1 "558."1 1810.3" 1810.3" 1580.& 1580.& 181.055 181.055 1038.& 1038.&  8388.3&30" 8388.3&30" *n=re/o/ de

Co/to/ de e:ipo Danteni7iento *n=re/o/ anale/ +alor de /ala7ento

$300,000 $ 0",588.85 $ 805,0.&& $ 1,11.&&

Co/to/ de e: Danteni7ie *n=re/o/ an +alor de /ala

Total de in=re/o/

$ 51",&5.5

Total de in=r

+AR 'N *R

Pre/ente dado ?tro

$",000.3 $15,13.8" $15&,"&.&1 $1&,08.15 $10,".51 $8,58.8" $,&8. $53,&8&.1& $"3,388.3& $35,000.00

53&03."10&&& $ "0,111.8 $ ,0.13 $ ,3&&. $ 1,&1".0 $ 1,"8".08 $ ,3".5" $ ,".3 $ 5,01. $ 3,885.""

epre/iacion

$

00,&&."

 

i ipo to le/ ento

$ $ $

$300,000 0",588.85 805,0.&& 1,11.&&

/o/

$

51&,50.3

Una e7pre/a dedicada a la ?a9ricacion ?a9ricacion de 7e9le/ 7e9le/ actal7ente tra9aHa tra9aHa con na /ierra para corta 7adera :e co7pro
!AT( Pri7era /ierra +( P i n

(e=nda (ierra

$5,000 $"00,000 8% 5

+( P Danteni 7ao n

0 $00,000 $15,000 3% &

Pri7era /ierra

!T

$ A2 1  3 " 5

PARA R &5,000.00

(!A

!'PR'C*AC*6N4!t 

+AR 'N *R

$ $ $ $ $

&5,000.00 &5,000.00 &5,000.00 &5,000.00 &5,000.00 &5,000.00 &5,000.00 &5,000.00 &5,000.00 &5,000.00

$35,000.00 $35,000.00 $50,000.00 $50,000.00 $1&5,000.00 $1&5,000.00 $100,000.00 $100,000.00 $5,000.00 $5,000.00

$

PARA R 85,&1".

Ftro dado pre/ente

A2

$ 110,1.1 110,1.1 $ 10,03.& 10,03.& $ ","&8."0 ","&8."0 $ 8&,"80.00 8&,"80.00 $ 81,000.00 81,000.00 $ "&5,1".8

1  3 " 5

(e=nda /ierra

!T A2

!'PR'C*AC*6N4!t  1 $  $

85,&1". 85,&1". 85,&1". 85,&1".

(!A +AR 'N *R

Pre/ente dado ?tro

$51",85.&1 $51",85.&1 $ $"8,5&1."3 $"8,5&1."3 $

&,35.08 &,35.08 &3,"8.18 &3,"8.18

A2 1 

3 " 5  &

$ $ $ $ $

85,&1". 85,&1". 85,&1". 85,&1". 85,&1". 85,&1". 85,&1". 85,&1". 85,&1". 85,&1".

$3",85&.1" $3",85&.1" $5&,1".8 $5&,1".8 $1&1,"8.5& $1&1,"8.5& $85,&1". $85,&1". $0.00

$ 8,0".& 8,0".& $ 3,00.5 3,00.5 $ 58,335.&0 58,335.&0 $ 5",01".5" 5",01".5" $ 50,013." 50,013." $ "",0.

3 " 5  &

PARA R (ierra 1 +alor de /ala7ento !epreciacion Precio (ierra  +alor de /ala7ento !epreciacion Precio Danteni7iento TTA

$5,000 $ "&5,1".8 $ &,33.8 $0 $ "",0. $00,000 $ &,0&".& $,1".&

(ierra 1 +alor de /al !epreciacion Precio (ierra  +alor de /al !epreciacion Precio Danteni7ie

r en e/to/ ce/ta i e/to/ ion/ e/ /e

Gradiente exponcecial !ecreciente PR'('NT' $15,000.00 8% 3% & $&,0&".&

A i # N P

8%

PARA (!A 15

dt7ax d

!'PR'C*AC*6N4!t +AR 'N *R $15,000 $15,000 $100,000 $100,000 $&5,000 $50,000 $5,000

$&5,000 $&5,000 $1&5,000 $1&5,000 $100,000 $100,000 $50,000 $5,000

A2 $ $ $ $ $ $

183,.01 183,.01 13,0"8.0 13,0"8.0 ","&8."0 ","&8."0 58,30.00 58,30.00 &,000.00 &,000.00 ",513.31

PARA (!A 8

1  3 " 5

dt7ax d

!'PR'C*AC*6N4!t +AR 'N *R $150,000 $150,000 $18,5&1 $18,5&1

PARA (! 0." 0."55085 !'PR'C*AC*6 N4!t

Pre/ente dad ?tro

$"50,000 $"50,000 $ $31," $31," $

138,888.8 138,888.8 110,.8 110,.8

A2

$ $ $ $ $

10,000.00 10,000.00 ,000.00 ,000.00 5&,00.00 5&,00.00 3",50.00 3",50.00 0,&3.00 0,&3.00

PARA (! 0.85&1"85& 1 !'PR'C*AC*6 N4!t 1 $ 1&1,"8.5& 1&1,"8.5&  $ 1,""8.8 1,""8.8

$10&,1"3 $10&,1"3 $85,&1" $",8 $",85& $1,"

$1",8 $1",8 $18,5&1 $18,5&1 $",8 $1," $0

$ $ $ $ $ $

85,053."5 85,053."5 3,00.5 3,00.5 "3,&51.&8 "3,&51.&8 &,00&.& &,00&.& 1,503.3& 1,503.3& "80,"3.5

3 " 5  &

$ $ $ $ $

8&,"3.5 8&,"3.5 ,"&3.& ,"&3.& "",". "",". 31,8&"."& 31,8&"."& ,&&."8 ,&&."8

PARA (!A

PARA (!

7ento $ $ 7ento $ to TTA

$

$5,000 ",513.31 &,33.8 $0 "80,"3.5 $00,000 &,0&".& $0,"1.5

(ierra 1 +alor de /ala7ento !epreciacion !epreciacion Precio (ierra  +alor de /ala7ento !epreciacion !epreciacion Precio Danteni7iento TTA

Presente dado Futuro (P/F)

F i N

$ "00,000.00 8% 5

P

$ 272,2"".2%

PARA (DARC

+AR 'N *R $"0 $"0,0 ,000 00.0 .00 0 $1"", $1"",00 000. 0.00 00 $8, $8,"0 "00. 0.00 00 $51, $51,8" 8"0. 0.00 00 $31, $31,10 10". ".00 00

!'PR'C*AC* 6N4!t

A2 $ $ $ $ $ $

35, 35,0 0. ." " 130, 130,0 0. ." " &,5 &,55 5." ."1 1 "0,3 "0,310 10.& .&8 8 ,3 ,3" ".8 .88 8 500,".51

1  3 " 5 

+AR 'N *R

$80, $80,00 000 0 $18, $18,00 000 0 $&, $&,80 800 0 $", $",08 080 0 $", $",08 080 0 $3,0"0

$30 $30,0 ,000 00 $1,0 $1,000 00 $115 $115, ,00 00 $, $,1 10 0 $3, $3,0" 0"0 0 $0

PARA (DARC

+AR 'N *R $"8 $"8,5 ,5&1 &1." ."3 3 $ $30, $30,1 1. ."5 "5 $

Pre/ente dad ?tro 158, 158,&3 &30. 0.1 1 10", 10",80 80. . 

!'PR'C*AC* 6N4!t

A2 1 

$85, $85,&" &"0 0 $1", $1"," "0 0

+AR 'N *R $51" $51", ,0 0 $3&,3 $3&,30 0

$18, $18,5 58. 8.8 8 $15 $15,1 ,18" 8". .  $111 $111,5 ,50 0. .  $&, $&,8 8. .1 1 $5, $5,1 18. 8.&0 &0

$ $ $ $ $ $

," ,"31. 31.3 3 "5, "5,0 0. .3 3 30,3 30,3&0 &0.5 .5  0,0 0,08 8.3 .33 3 13, 13,8" 8". .1 1 "",803.50

3 " 5  & 8

$10", $10"," "0 0 $&", $&"," "0 0 $53, $53,58 580 0 $53, $53,5 50 0 $53, $53,58 580 0 $,&0

$, $,380 380 $18& $18&," ,""0 "0 $133 $133,8 ,80 0 $80, $80,3" 3"0 0 $, $,& &0 0 $0

PARA (DARC

$ $

$ $

$5,000 500,".51 &,33.8 $0 "",803.50 $00,000 &,0&".& $","5.&

(ierra 1 +alor de /ala7ento !epreciacion Precio (ierra  +alor de /ala7ento !epreciacion Precio Danteni7iento TTA

$ $

$ $

$5,000 3,03.5 &,33.8 $0 ""5,0.8 $00,000 &,0&".& 4$"51,058."1

$ $ $ $ $ $ $

11&,5".5 1&",1".5 ,&"5.88 53,&"&.&1 ",&."0 3,03.5 "1,"8.83

Pre/ente dad ?tro $ $

&,388.8 15,&&.3&

$ $ $ $ $ $ $

83,30".& 55,083.1" 3,"5.5 33,&.8 31,3." 1","5&.0 ""5,0.8

Una co7paia dedicada a la/ ?otocopia/ ?otocopia/ e/ta e/tdiando di?erente/ di?erente/ opcione/ para poder conta conta a Dediante n contrato de renta :e co/taria $5000 anale/ por cada 7a:ina, lo/ cale/ /e 9 Co7prarla/ al contado por $"0,000 cada na @ n /ala7ento /ala7ento de $,000 de/pe/ de 5 ao/ c Un en=a en=anc< nc
A i # N P

Gradiente exponcecial Creciente PR'('NT' $ "5,000.00 5% 5% 5 $ 1",85.&1

*nci/o a Futuro dado Anualidad (F/A)

Presente dad

A i N

$

5,000.00 5% 5

F i N

$&,8.1 5% 5

F

$

27,62%.16

P

$21,67."%

*nci/o 9 A2 +( P N (!A

$ $

,000.00 "0,000.00 5 15

1  3 " 5

!epreciacion

+

$ 11,333.33 $ ,0.& $ ,800.00 $ ",533.33 $ ,.& ,.&

$8,.& $1,00.00 $1,800.00 $ 8,.& $ ,000.00 ,000.00

con tre/ ?otocopiadora/ de alta elocidad a=arian al inicio de cada ao. de/pe/ /e de/precearian por el 7etodo de (!A cion anterior @ el re/to del pa=o al Inal del ao cinco, /e 7enten n 5% cada ao /i=iente. a ta/a de intere/ e/ del 5%. epreciacion /e con/idera co7o n in=re/o.

o Futuro (P/F)

*n=re/o/ '=re/o/

$ 1",85.&1 $ 1,"&.38

TTA

$ 1,38.33

Pre/ente dado ?tro $ $ $ $ $ $

10,&3.5 8,3.&3 5,8&".10 3,&.58 1,&&5. 30,3&.0

Presente dado Futuro (P/F)

F i N

$

,000.00 5% 5

P

$

,701.16

TTA *n=re/o/ !eprec. +( ':ipo

$ 1 1",85.&1 $ 30,3&.0 $ ",&01.1 $ "0,000.00

TTA

$ 0 0,383.3

$ 1,580.3