Avalin resp cap7

Avalição de InvestimentosAdriano Leal Bruni ([email protected])

Respostas do livroCapítulo 7

www.MinhasAulas.com.br

http://www.minhasaulas.com.br/

TMA Respostas: VFL4% PBS 4.00 VPL 10,000.01 VUL

PBD 4.45 TIR 16% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (20,000.00) (20,000.00) (20,000.00) (20,000.00)1 4,998.29 (15,001.71) 1.00 4,806.05 (15,193.95)2 4,998.29 (10,003.42) 1.00 4,621.20 (10,572.75)3 4,998.29 (5,005.13) 1.00 4,443.46 (6,129.29)4 4,998.29 (6.84) 1.00 4,272.56 (1,856.73)5 4,998.29 4,991.45 0.00 4,108.23 2,251.50 6 4,998.29 9,989.74 3,950.22 6,201.72 7 4,998.29 14,988.03 3,798.29 10,000.01 8 14,988.03 - 10,000.01 9 14,988.03 - 10,000.01

10 14,988.03 - 10,000.01 Soma

13,159.33 1,666.10 1.50

PBD

1.00 1.00 1.00 1.00 0.45

TMA Respostas: VFL5% PBS 5.86 VPL (7,999.99) VUL

PBD 10.00 TIR 1% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (60,000.00) (60,000.00) (60,000.00) (60,000.00)1 10,244.91 (49,755.09) 1.00 9,757.06 (50,242.94)2 10,244.91 (39,510.18) 1.00 9,292.44 (40,950.51)3 10,244.91 (29,265.27) 1.00 8,849.94 (32,100.57)4 10,244.91 (19,020.36) 1.00 8,428.51 (23,672.06)5 10,244.91 (8,775.45) 1.00 8,027.16 (15,644.90)6 10,244.91 1,469.46 0.86 7,644.91 (7,999.99)7 1,469.46 - (7,999.99)8 1,469.46 - (7,999.99)9 1,469.46 - (7,999.99)

10 1,469.46 - (7,999.99)Soma

(10,720.75) (1,576.14) 0.87

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

TMA Respostas: VFL6% PBS 10.00 VPL (5,000.00) VUL

PBD 10.00 TIR -6% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (30,000.00) (30,000.00) (30,000.00) (30,000.00)1 13,635.92 (16,364.08) 1.00 12,864.08 (17,135.92)2 13,635.92 (2,728.16) 1.00 12,135.92 (5,000.00)3 (2,728.16) 1.00 - (5,000.00)4 (2,728.16) 1.00 - (5,000.00)5 (2,728.16) 1.00 - (5,000.00)6 (2,728.16) 1.00 - (5,000.00)7 (2,728.16) 1.00 - (5,000.00)8 (2,728.16) 1.00 - (5,000.00)9 (2,728.16) 1.00 - (5,000.00)

10 (2,728.16) 1.00 - (5,000.00)Soma

(5,618.00) (2,727.19) 0.83

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

TMA Respostas: VFL12% PBS 2.38 VPL 4.38 VUL

PBD 2.97 TIR 13% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (500.00) (500.00) (500.00) (500.00)1 210.00 (290.00) 1.00 187.50 (312.50)2 210.00 (80.00) 1.00 167.41 (145.09)3 210.00 130.00 0.38 149.47 4.38 4 130.00 - 4.38 5 130.00 - 4.38 6 130.00 - 4.38 7 130.00 - 4.38 8 130.00 - 4.38 9 130.00 - 4.38

10 130.00 - 4.38 Soma

6.16 1.83 1.01

PBD

1.00 1.00 0.97

TMA Respostas: VFL10% PBS - VPL 2,248.43 VUL

PBD - TIR Err:523 IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 - - - 1 400.00 400.00 - 363.64 363.64 2 400.00 800.00 330.58 694.21 3 400.00 1,200.00 300.53 994.74 4 400.00 1,600.00 273.21 1,267.95 5 200.00 1,800.00 124.18 1,392.13 6 200.00 2,000.00 112.89 1,505.03 7 200.00 2,200.00 102.63 1,607.66 8 200.00 2,400.00 93.30 1,700.96 9 200.00 2,600.00 84.82 1,785.78

10 1,200.00 3,800.00 462.65 2,248.43 Soma

5,831.85 365.92

#DIV/0!

PBD

-

TMA Respostas: VFL12% PBS - VPL 14,645.49 VUL

PBD - TIR Err:523 IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 - - - 1 5,000.00 5,000.00 - 4,464.29 4,464.29 2 3,000.00 8,000.00 2,391.58 6,855.87 3 3,000.00 11,000.00 2,135.34 8,991.21 4 3,000.00 14,000.00 1,906.55 10,897.76 5 3,000.00 17,000.00 1,702.28 12,600.04 6 1,000.00 18,000.00 506.63 13,106.67 7 1,000.00 19,000.00 452.35 13,559.02 8 1,000.00 20,000.00 403.88 13,962.91 9 1,000.00 21,000.00 360.61 14,323.52

10 1,000.00 22,000.00 321.97 14,645.49 Soma

45,486.67 2,592.02

#DIV/0!

PBD

-


PBD 3.37 TIR 26% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (300.00) (300.00) (300.00) (300.00)1 100.00 (200.00) 1.00 94.34 (205.66)2 100.00 (100.00) 1.00 89.00 (116.66)3 - (100.00) 1.00 - (116.66)4 400.00 300.00 0.25 316.84 200.18 5 300.00 - 200.18 6 300.00 - 200.18 7 300.00 - 200.18 8 300.00 - 200.18 9 300.00 - 200.18

10 300.00 - 200.18 Soma

Resp: 238.41

252.72 57.77 1.67

PBD

1.00 1.00 1.00 0.37


PBD 6.41 TIR 15% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (90,000.00) (90,000.00) (90,000.00) (90,000.00)1 10,000.00 (80,000.00) 1.00 9,708.74 (80,291.26)2 10,000.00 (70,000.00) 1.00 9,425.96 (70,865.30)3 10,000.00 (60,000.00) 1.00 9,151.42 (61,713.89)4 20,000.00 (40,000.00) 1.00 17,769.74 (43,944.15)5 20,000.00 (20,000.00) 1.00 17,252.18 (26,691.97)6 20,000.00 - 1.00 16,749.69 (9,942.28)7 30,000.00 30,000.00 - 24,392.75 14,450.46 8 30,000.00 60,000.00 23,682.28 38,132.74 9 30,000.00 90,000.00 22,992.50 61,125.24

10 30,000.00 120,000.00 22,322.82 83,448.06 Soma

Resp: 91,185.95

112,147.21 9,782.66 1.93

PBD

1.00 1.00 1.00 1.00 1.00 1.00 0.41


PBD 3.22 TIR 30% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (400.00) (400.00) (400.00) (400.00)1 120.00 (280.00) 1.00 115.38 (284.62)2 160.00 (120.00) 1.00 147.93 (136.69)3 120.00 - 1.00 106.68 (30.01)4 160.00 160.00 - 136.77 106.76 5 120.00 280.00 98.63 205.39 6 160.00 440.00 126.45 331.84 7 120.00 560.00 91.19 423.03 8 160.00 720.00 116.91 539.94 9 720.00 - 539.94

10 720.00 - 539.94 Soma

738.95 80.20 2.35

PBD

1.00 1.00 1.00 0.22


PBD 1.78 TIR 34% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (4,000.00) (4,000.00) (4,000.00) (4,000.00)1 3,000.00 (1,000.00) 1.00 2,400.00 (1,600.00)2 3,200.00 2,200.00 0.31 2,048.00 448.00 3 2,200.00 - 448.00 4 2,200.00 - 448.00 5 2,200.00 - 448.00 6 2,200.00 - 448.00 7 2,200.00 - 448.00 8 2,200.00 - 448.00 9 2,200.00 - 448.00

10 2,200.00 - 448.00 Soma

700.00 311.11 1.11

PBD

1.00 0.78


PBD 2.92 TIR 10% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (95.00) (95.00) (95.00) (95.00)1 40.00 (55.00) 1.00 37.04 (57.96)2 25.00 (30.00) 1.00 21.43 (36.53)3 50.00 20.00 0.60 39.69 3.16 4 20.00 - 3.16 5 20.00 - 3.16 6 20.00 - 3.16 7 20.00 - 3.16 8 20.00 - 3.16 9 20.00 - 3.16

10 20.00 - 3.16 Soma

3.98 1.23 1.03

PBD

1.00 1.00 0.92


PBD 2.11 TIR 71% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (4.00) (4.00) (4.00) (4.00)1 2.00 (2.00) 1.00 1.67 (2.33)2 3.00 1.00 0.67 2.08 (0.25)3 4.00 5.00 2.31 2.06 4 5.00 10.00 2.41 4.48 5 6.00 16.00 2.41 6.89 6 16.00 - 6.89 7 16.00 - 6.89 8 16.00 - 6.89 9 16.00 - 6.89

10 16.00 - 6.89 Soma

17.14 2.30 2.72

PBD

1.00 1.00 0.11


PBD 2.10 TIR 58% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (75.00) (75.00) (75.00) (75.00)1 40.00 (35.00) 1.00 35.71 (39.29)2 45.00 10.00 0.78 35.87 (3.41)3 50.00 60.00 35.59 32.18 4 55.00 115.00 34.95 67.13 5 60.00 175.00 34.05 101.18 6 65.00 240.00 32.93 134.11 7 240.00 - 134.11 8 240.00 - 134.11 9 240.00 - 134.11

10 240.00 - 134.11 Soma

264.70 32.62 2.79

PBD

1.00 1.00 0.10

TMA Respostas: VFL7% PBS 3.52 VPL (3.32) VUL

PBD 10.00 TIR 5% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (88.00) (88.00) (88.00) (88.00)1 25.00 (63.00) 1.00 23.36 (64.64)2 25.00 (38.00) 1.00 21.84 (42.80)3 25.00 (13.00) 1.00 20.41 (22.39)4 25.00 12.00 0.52 19.07 (3.32)5 12.00 - (3.32)6 12.00 - (3.32)7 12.00 - (3.32)8 12.00 - (3.32)9 12.00 - (3.32)

10 12.00 - (3.32)Soma

(4.35) (0.98) 0.96

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00


PBD 3.51 TIR 47% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (90.00) (90.00) (90.00) (90.00)1 (150.00) (240.00) 1.00 (133.93) (223.93)2 (60.00) (300.00) 1.00 (47.83) (271.76)3 200.00 (100.00) 1.00 142.36 (129.40)4 400.00 300.00 0.25 254.21 124.80 5 500.00 800.00 283.71 408.52 6 800.00 - 408.52 7 800.00 - 408.52 8 800.00 - 408.52 9 800.00 - 408.52

10 800.00 - 408.52 Soma

719.95 113.33 5.54

PBD

1.00 1.00 1.00 0.51


PBD 10.00 TIR 29% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (25,000.00) (25,000.00) (25,000.00) (25,000.00)1 10,000.00 (15,000.00) 1.00 7,692.31 (17,307.69)2 10,000.00 (5,000.00) 1.00 5,917.16 (11,390.53)3 10,000.00 5,000.00 0.50 4,551.66 (6,838.87)4 10,000.00 15,000.00 3,501.28 (3,337.59)5 10,000.00 25,000.00 2,693.29 (644.30)6 25,000.00 - (644.30)7 25,000.00 - (644.30)8 25,000.00 - (644.30)9 25,000.00 - (644.30)

10 25,000.00 - (644.30)Soma

(2,392.25) (264.54) 0.97

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

TMA Respostas: VFLPBS Não tem VPL - VULPBD Não tem TIR Err:523 IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 - - - 1 - 1.00 - - 2 - 1.00 - - 3 - 1.00 - - 4 - 1.00 - - 5 - 1.00 - - 6 - 1.00 - - 7 - 1.00 - - 8 - 1.00 - - 9 - 1.00 - -

10 - 1.00 - - Soma

- #NUM!

#DIV/0!

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00


PBD 3.35 TIR 32% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (80.00) (80.00) (80.00) (80.00)1 34.00 (46.00) 1.00 28.81 (51.19)2 34.00 (12.00) 1.00 24.42 (26.77)3 34.00 22.00 0.35 20.69 (6.07)4 34.00 56.00 17.54 11.46 5 34.00 90.00 14.86 26.32 6 90.00 - 26.32 7 90.00 - 26.32 8 90.00 - 26.32 9 90.00 - 26.32

10 90.00 - 26.32 Soma

60.22251 8.42 1.33

PBD

1.00 1.00 1.00 0.35



Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (650.00) (650.00) (650.00) (650.00)1 120.00 (530.00) 1.00 103.45 (546.55)2 120.00 (410.00) 1.00 89.18 (457.37)3 120.00 (290.00) 1.00 76.88 (380.49)4 120.00 (170.00) 1.00 66.27 (314.22)5 120.00 (50.00) 1.00 57.13 (257.08)6 120.00 70.00 0.42 49.25 (207.83)7 120.00 190.00 42.46 (165.37)8 120.00 310.00 36.60 (128.77)9 120.00 430.00 31.55 (97.21)

10 120.00 550.00 27.20 (70.01)Soma

(308.86) (14.48570) 0.89

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

6 14.00% 580.00 149.15

1

MATEMÁGICA FINANCEIRA NO EXCELClique sobre o valor que deseja obter

Operações financeiras com juros compostos.

Regime N I PV PMT

3 6 14.0000% 580.00

Juros Compostos (149.15)

Resposta A prestação é igual a -149.15135 no regime de juros compostos

Operações na HP12C [f] [REG] 6 [n] 14 [i] 580 [PV] [g] [END] [PMT] Visor => -149.1513

Operações no Excel =PGTO(0.14;6;580;;0)

4

N I PV PMT

JS 1 ### ### #VALUE! Não existe

D 2 ### ### #VALUE! Não existe

JC 3 ### ### #VALUE! [f] [REG] 6 [n

l 3 c 4 fómula ==>

Opção : 3 juros compostos (Não Mexa !!!)

1 - Juros Simples

2 - Desconto Bancário

3 - Juros Compostos

Cálculos Financeiros Gerais (Não Mexa !!!)

2 3 4 5

1 (7.14) -16.67% - Não tem

2 #DIV/0! #DIV/0! - Não tem

3 #NUM! -99.84% - (149.15)

Cálculos na HP 12C - Não Mexa Nunca !!!

Juros N I PV PMT

6 [n] 14 [i] 580 [PV]

N #VALUE!

I #VALUE!

PV #VALUE!

PMT [f] [REG] 6 [n] 14 [i] 580 [PV] [g] [END] [PMT] Visor => -149.1513

FV #VALUE!

Regimes

1 - Juros simples

2 - Desconto comercial

3 - Juros compostos

Tipos

0 - postecipado

1 - antecipado

Legenda

cod desc simb conc

1 O número períodos=NPER(0.14;;580;;0)

2 A taxa de % a.p. =TAXA(6;;580;;0;)

3 O valor presente =VP(0.14;6;;;0)

4 A prestação =PGTO(0.14;6;580;;0)

5 O valor futuro =VF(0.14;6;;580;0)

Taxa

1 % a.d. dias 1

2 % a.m. meses 30

3 % a.b. bimestre 60

4 % a.t. trimestre 90

5 % a.q. quadrime 120

TAXA(nper;pgto;vp;vf;tipo;estimativa)

VF(taxa;nper;pgto;vp;tipo)

VP(taxa;nper;pgto;vf;tipo)

6 % a.s. semestre 180

7 % a.a. ano come 360

8 % a.a. (eano civil 365

-

1


FV Tipo

0 1

Sem entrada

A prestação é igual a -149.15135 no regime de juros compostos

[f] [REG] 6 [n] 14 [i] 580 [PV] [g] [END] [PMT] Visor => -149.1513

H7

Tipo: 0 = postecipado, sem entrada, 1 = antecipado, com entrada

FV Tipo

#VALUE!

#VALUE!

#VALUE!

[f] [REG] 6 [n] 14 [i] 580 [

(Não Mexa !!!)

6

(1,067.20)

(3,625.00)

(1,273.08)

FV TIPO

[g] [END]

nper;pgto;vp;vf;tipo;estimativa)

nper;pgto;vp;tipo)

;nper;pgto;vf;tipo)

7 14.00% 620.00 144.58

1


Operações financeiras com juros compostos.

Regime N I PV PMT

3 7 14.0000% 620.00

Juros Compostos (144.58)

Resposta A prestação é igual a -144.57927 no regime de juros compostos

Operações na HP12C [f] [REG] 7 [n] 14 [i] 620 [PV] [g] [END] [PMT] Visor => -144.5793

Operações no Excel =PGTO(0.14;7;620;;0)

4

N I PV PMT

JS 1 ### ### #VALUE! Não existe

D 2 ### ### #VALUE! Não existe

JC 3 ### ### #VALUE! [f] [REG] 7 [n

l 3 c 4 fómula ==>

Opção : 3 juros compostos (Não Mexa !!!)

1 - Juros Simples

2 - Desconto Bancário

3 - Juros Compostos

Cálculos Financeiros Gerais (Não Mexa !!!)

2 3 4 5

1 (7.14) -14.29% - Não tem

2 #DIV/0! #DIV/0! - Não tem

3 #NUM! -99.63% - (144.58)

Cálculos na HP 12C - Não Mexa Nunca !!!

Juros N I PV PMT

7 [n] 14 [i] 620 [PV]

N #VALUE!

I #VALUE!

PV #VALUE!

PMT [f] [REG] 7 [n] 14 [i] 620 [PV] [g] [END] [PMT] Visor => -144.5793

FV #VALUE!

Regimes

1 - Juros simples

2 - Desconto comercial

3 - Juros compostos

Tipos

0 - postecipado

1 - antecipado

Legenda

cod desc simb conc

1 O número períodos=NPER(0.14;;620;;0)

2 A taxa de % a.p. =TAXA(7;;620;;0;)

3 O valor presente =VP(0.14;7;;;0)

4 A prestação =PGTO(0.14;7;620;;0)

5 O valor futuro =VF(0.14;7;;620;0)

Taxa

1 % a.d. dias 1

2 % a.m. meses 30

3 % a.b. bimestre 60

4 % a.t. trimestre 90

5 % a.q. quadrime 120

TAXA(nper;pgto;vp;vf;tipo;estimativa)

VF(taxa;nper;pgto;vp;tipo)

VP(taxa;nper;pgto;vf;tipo)

6 % a.s. semestre 180

7 % a.a. ano come 360

8 % a.a. (eano civil 365

-

1


FV Tipo

0 1

Sem entrada

A prestação é igual a -144.57927 no regime de juros compostos

[f] [REG] 7 [n] 14 [i] 620 [PV] [g] [END] [PMT] Visor => -144.5793

H7

Tipo: 0 = postecipado, sem entrada, 1 = antecipado, com entrada

FV Tipo

#VALUE!

#VALUE!

#VALUE!

[f] [REG] 7 [n] 14 [i] 620 [

(Não Mexa !!!)

6

(1,227.60)

(31,000.00)

(1,551.41)

FV TIPO

[g] [END]

nper;pgto;vp;vf;tipo;estimativa)

nper;pgto;vp;tipo)

;nper;pgto;vf;tipo)


PBD 5.54 TIR 13% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (140.00) (140.00) (140.00) (140.00)1 15.00 (125.00) 1.00 13.39 (126.61)2 63.00 (62.00) 1.00 50.22 (76.38)3 58.00 (4.00) 1.00 41.28 (35.10)4 22.00 18.00 0.18 13.98 (21.12)5 30.00 48.00 17.02 (4.10)6 15.00 63.00 7.60 3.50 7 63.00 - 3.50 8 63.00 - 3.50 9 63.00 - 3.50

10 63.00 - 3.50 Soma

6.91429 0.85202 1.03

PBD

1.00 1.00 1.00 1.00 1.00 0.54


PBD 9.01 TIR 10% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (50.00) (50.00) (50.00) (50.00)1 8.00 (42.00) 1.00 7.41 (42.59)2 8.00 (34.00) 1.00 6.86 (35.73)3 8.00 (26.00) 1.00 6.35 (29.38)4 8.00 (18.00) 1.00 5.88 (23.50)5 8.00 (10.00) 1.00 5.44 (18.06)6 8.00 (2.00) 1.00 5.04 (13.02)7 8.00 6.00 0.25 4.67 (8.35)8 8.00 14.00 4.32 (4.03)9 8.00 22.00 4.00 (0.02)

10 8.00 30.00 3.71 3.68 Soma

7.94625 0.54853 1.07

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.01


PBD 3.46 TIR 14% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (1,350.00) (1,350.00) (1,350.00) (1,350.00)1 600.00 (750.00) 1.00 555.56 (794.44)2 400.00 (350.00) 1.00 342.94 (451.51)3 400.00 50.00 0.88 317.53 (133.98)4 400.00 450.00 294.01 160.04 5 450.00 - 160.04 6 450.00 - 160.04 7 450.00 - 160.04 8 450.00 - 160.04 9 450.00 - 160.04

10 450.00 - 160.04 Soma

217.73 48.32 1.12

PBD

1.00 1.00 1.00 0.46


PBD 7.46 TIR 12% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (98,000.00) (98,000.00) (98,000.00) (98,000.00)1 16,000.00 (82,000.00) 1.00 14,814.81 (83,185.19)2 16,000.00 (66,000.00) 1.00 13,717.42 (69,467.76)3 16,000.00 (50,000.00) 1.00 12,701.32 (56,766.45)4 18,000.00 (32,000.00) 1.00 13,230.54 (43,535.91)5 18,000.00 (14,000.00) 1.00 12,250.50 (31,285.41)6 18,000.00 4,000.00 0.78 11,343.05 (19,942.36)7 24,000.00 28,000.00 14,003.77 (5,938.59)8 24,000.00 52,000.00 12,966.45 7,027.86 9 24,000.00 76,000.00 12,005.98 19,033.84

10 76,000.00 - 19,033.84 Soma

38,048.73 3,046.93 1.19

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.46


PBD 3.07 TIR 32% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (630.00) (630.00) (630.00) (630.00)1 230.00 (400.00) 1.00 212.96 (417.04)2 240.00 (160.00) 1.00 205.76 (211.28)3 250.00 90.00 0.64 198.46 (12.82)4 260.00 350.00 191.11 178.29 5 270.00 620.00 183.76 362.05 6 280.00 900.00 176.45 538.50 7 900.00 - 538.50 8 900.00 - 538.50 9 900.00 - 538.50

10 900.00 - 538.50 Soma

854.52 116.48 1.85

PBD

1.00 1.00 1.00 0.07

IL = VPL/INV + 1

IL = 1.4


PBD 2.09 TIR 39% IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (400.00) (400.00) (400.00) (400.00)1 200.00 (200.00) 1.00 194.17 (205.83)2 200.00 - 1.00 188.52 (17.31)3 200.00 200.00 - 183.03 165.72 4 300.00 500.00 266.55 432.27 5 500.00 - 432.27 6 500.00 - 432.27 7 500.00 - 432.27 8 500.00 - 432.27 9 500.00 - 432.27

10 500.00 - 432.27 Soma

486.52 116.29 2.08

PBD

1.00 1.00 0.09



Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (300.00) (300.00) (300.00) (300.00)1 64.00 (236.00) 1.00 54.24 (245.76)2 64.00 (172.00) 1.00 45.96 (199.80)3 64.00 (108.00) 1.00 38.95 (160.85)4 64.00 (44.00) 1.00 33.01 (127.84)5 64.00 20.00 0.69 27.97 (99.86)6 64.00 84.00 23.71 (76.15)7 64.00 148.00 20.09 (56.06)8 64.00 212.00 17.03 (39.04)9 212.00 - (39.04)

10 212.00 - (39.04)Soma

(146.73) (9.57) 0.8699

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

TMA Respostas: VFLPBS Não tem VPL - VULPBD Não tem TIR Err:523 IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 - - - 1 - 1.00 - - 2 - 1.00 - - 3 - 1.00 - - 4 - 1.00 - - 5 - 1.00 - - 6 - 1.00 - - 7 - 1.00 - - 8 - 1.00 - - 9 - 1.00 - -

10 - 1.00 - - Soma

- #NUM!

#DIV/0!

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

TMA Respostas: VFL10% PBS Não tem VPL (112.02) VUL

PBD Não tem TIR Err:523 IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (50.00) (50.00) (50.00) (50.00)1 (18.00) (68.00) 1.00 (16.36) (66.36)2 (18.00) (86.00) 1.00 (14.88) (81.24)3 (18.00) (104.00) 1.00 (13.52) (94.76)4 (18.00) (122.00) 1.00 (12.29) (107.06)5 (8.00) (130.00) 1.00 (4.97) (112.02)6 (130.00) 1.00 - (112.02)7 (130.00) 1.00 - (112.02)8 (130.00) 1.00 - (112.02)9 (130.00) 1.00 - (112.02)

10 (130.00) 1.00 - (112.02)Soma

(180.42) (29.55) (1.24)

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

TMA Respostas: VFL10% PBS Não tem VPL (139.88) VUL

PBD Não tem TIR Err:523 IL

Ano FC Saldo Simples PBS VP (FC) Saldo Desc0 (90.00) (90.00) (90.00) (90.00)1 (10.00) (100.00) 1.00 (9.09) (99.09)2 (10.00) (110.00) 1.00 (8.26) (107.36)3 (10.00) (120.00) 1.00 (7.51) (114.87)4 (10.00) (130.00) 1.00 (6.83) (121.70)5 (10.00) (140.00) 1.00 (6.21) (127.91)6 (10.00) (150.00) 1.00 (5.64) (133.55)7 (10.00) (160.00) 1.00 (5.13) (138.68)8 (10.00) (170.00) 1.00 (4.67) (143.35)9 (10.00) (180.00) 1.00 (4.24) (147.59)

10 20.00 (160.00) 1.00 7.71 (139.88)Soma

(362.81) (22.76) (0.55)

PBD

1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00

Sports

Avalin resp cap7