Avalin resp cap7

Avalição de InvestimentosAdriano Leal Bruni (albruni@minhasaulas.com.br)

Respostas do livroCapítulo 7

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

-

TMA Respostas: VFL6% PBS 3.25 VPL 200.18 VUL

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

TMA Respostas: VFL3% PBS 6.00 VPL 83,448.06 VUL

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

TMA Respostas: VFL4% PBS 3.00 VPL 539.94 VUL

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

TMA Respostas: VFL25% PBS 1.31 VPL 448.00 VUL

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

TMA Respostas: VFL8% PBS 2.60 VPL 3.16212 VUL

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

TMA Respostas: VFL20% PBS 1.67 VPL 6.88735 VUL

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

TMA Respostas: VFL12% PBS 1.78 VPL 134.10715 VUL

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

TMA Respostas: VFL12% PBS 3.25 VPL 408.52 VUL

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

TMA Respostas: VFL30% PBS 2.50 VPL (644.30) VUL

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

TMA Respostas: VFL18% PBS 2.35 VPL 26.32 VUL

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

TMA Respostas: VFL16% PBS 5.42 VPL (70.01) VUL

PBD 10.00 TIR 13% IL

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

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

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

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

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

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

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

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

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)

TMA Respostas: VFL12% PBS 3.18 VPL 3.50300 VUL

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

TMA Respostas: VFL8% PBS 6.25 VPL 3.68065 VUL

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

TMA Respostas: VFL8% PBS 2.88 VPL 160.04 VUL

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

TMA Respostas: VFL8% PBS 5.78 VPL 19,033.84 VUL

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

TMA Respostas: VFL8% PBS 2.64 VPL 538.50 VUL

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

TMA Respostas: VFL3% PBS 2.00 VPL 432.27 VUL

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

TMA Respostas: VFL18% PBS 4.69 VPL (39.04) VUL

PBD 10.00 TIR 14% IL

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