Avalição de InvestimentosAdriano Leal Bruni ([email protected])
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