Scribd Logo
Carregar

Bem-vindo(a) ao Scribd!

  • 2 visualizações

    EXERCICIO 11

    Enviado por

    Marco Tulio Reis Messias

    Direitos autorais:

    © All Rights Reserved
    Baixe no formato XLSX, PDF, TXT ou leia online no Scribd

    EXERCICIO 11

    Enviado por

    Marco Tulio Reis Messias
    2 visualizações6 páginas

    Direitos autorais

    © © All Rights Reserved

    Formatos disponíveis

    XLSX, PDF, TXT ou leia online no Scribd

    Você considera este documento útil?

    Este conteúdo é inapropriado?

    Direitos autorais:

    © All Rights Reserved
    Baixe no formato XLSX, PDF, TXT ou leia online no Scribd
    Fazer download em xlsx, pdf ou txt
    2 visualizações6 páginas

    EXERCICIO 11

    Enviado por

    Marco Tulio Reis Messias

    Direitos autorais:

    © All Rights Reserved
    Baixe no formato XLSX, PDF, TXT ou leia online no Scribd
    Fazer download em xlsx, pdf ou txt
    Você está na página 1de 6

    MARCO TÚLIO REIS MESSIAS

    Item Cenário pessimista Cenário esperado

    Investimento 110,000,000 100,000,000


    Vida útil 10 10
    Mercado 1,000,000 1,000,000
    Market share % 2% 3%
    Preço 45,201.50 45,201.50

    Custo variável unitário 3,300 3,000

    Custo fixo 37,000,000 36,000,000


    IR (%) 30% 30%
    TMA 3% 3%

    ANO 0 ANO 1
    (-) INVESTIMENTO -R$ 110,000,000.00
    (+) RECEITA R$ 904,030,000.00
    (-) CUSTO FIXO -R$ 37,000,000.00
    (-) CUSTO VARIÁVEL -R$ 66,000,000.00
    EBTIDA -R$ 110,000,000.00 R$ 801,030,000.00
    (-) DEPRECIAÇÃO -R$ 11,000,000.00
    LAJIR -R$ 110,000,000.00 R$ 790,030,000.00
    (-) IMPOSTOS SOBRE O LAJIR -R$ 237,009,000.00
    (+) DEPRECIAÇÃO R$ 11,000,000.00
    FCL -R$ 110,000,000.00 R$ 564,021,000.00
    VPL PESSIMISTA R$ 4,701,213,534.20

    ANO 0 ANO 1
    (-) INVESTIMENTO -R$ 100,000,000.00
    (+) RECEITA R$ 1,356,045,000.00
    (-) CUSTO FIXO -R$ 36,000,000.00
    (-) CUSTO VARIÁVEL -R$ 90,000,000.00
    EBTIDA -R$ 100,000,000.00 R$ 1,230,045,000.00
    (-) DEPRECIAÇÃO -R$ 10,000,000.00
    LAJIR -R$ 100,000,000.00 R$ 1,220,045,000.00
    (-) IMPOSTOS SOBRE O LAJIR -R$ 366,013,500.00
    (+) DEPRECIAÇÃO R$ 10,000,000.00
    FCL -R$ 100,000,000.00 R$ 864,031,500.00
    VPL ESPERADO R$ 7,270,363,952.36

    ANO 0 ANO 1
    (-) INVESTIMENTO -R$ 100,000,000.00
    (+) RECEITA R$ 1,808,060,000.00
    (-) CUSTO FIXO -R$ 35,000,000.00
    (-) CUSTO VARIÁVEL -R$ 997,199.96
    EBTIDA -R$ 100,000,000.00 R$ 1,772,062,800.04
    (-) DEPRECIAÇÃO -R$ 10,000,000.00
    LAJIR -R$ 100,000,000.00 R$ 1,762,062,800.04
    (-) IMPOSTOS SOBRE O LAJIR -R$ 528,618,840.01
    (+) DEPRECIAÇÃO R$ 10,000,000.00
    FCL -R$ 100,000,000.00 R$ 1,243,443,960.03
    VPL OTIMISTA R$ 10,506,829,195.20

    VPL FINAL VARIÇÃO


    Investimento R$ 7,255,482,074.07 -0.20%
    Market Share R$ 8,782,310,843.43 20.80%
    Custo Variável R$ 7,162,883,396.62 -1.48%
    Custo Fixo R$ 7,227,371,730.07 -0.59%

    VPL INICIAL R$ 7,270,363,952.36


    106460

    Cenário otimista

    100,000,000
    10
    1,000,000
    4%
    45,201.50

    2,800

    35,000,000
    30%
    3%

    Cenário pessimista
    ANO 2 ANO 3 ANO 4 ANO 5 ANO 6

    R$ 904,030,000.00 R$ 904,030,000.00 R$ 904,030,000.00 R$ 904,030,000.00 R$ 904,030,000.00


    -R$ 37,000,000.00 -R$ 37,000,000.00 -R$ 37,000,000.00 -R$ 37,000,000.00 -R$ 37,000,000.00
    -R$ 66,000,000.00 -R$ 66,000,000.00 -R$ 66,000,000.00 -R$ 66,000,000.00 -R$ 66,000,000.00
    R$ 801,030,000.00 R$ 801,030,000.00 R$ 801,030,000.00 R$ 801,030,000.00 R$ 801,030,000.00
    -R$ 11,000,000.00 -R$ 11,000,000.00 -R$ 11,000,000.00 -R$ 11,000,000.00 -R$ 11,000,000.00
    R$ 790,030,000.00 R$ 790,030,000.00 R$ 790,030,000.00 R$ 790,030,000.00 R$ 790,030,000.00
    -R$ 237,009,000.00 -R$ 237,009,000.00 -R$ 237,009,000.00 -R$ 237,009,000.00 -R$ 237,009,000.00
    R$ 11,000,000.00 R$ 11,000,000.00 R$ 11,000,000.00 R$ 11,000,000.00 R$ 11,000,000.00
    R$ 564,021,000.00 R$ 564,021,000.00 R$ 564,021,000.00 R$ 564,021,000.00 R$ 564,021,000.00

    Cenário esperado
    ANO 2 ANO 3 ANO 4 ANO 5 ANO 6

    R$ 1,356,045,000.00 R$ 1,356,045,000.00 R$ 1,356,045,000.00 R$ 1,356,045,000.00 R$ 1,356,045,000.00


    -R$ 36,000,000.00 -R$ 36,000,000.00 -R$ 36,000,000.00 -R$ 36,000,000.00 -R$ 36,000,000.00
    -R$ 90,000,000.00 -R$ 90,000,000.00 -R$ 90,000,000.00 -R$ 90,000,000.00 -R$ 90,000,000.00
    R$ 1,230,045,000.00 R$ 1,230,045,000.00 R$ 1,230,045,000.00 R$ 1,230,045,000.00 R$ 1,230,045,000.00
    -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00
    R$ 1,220,045,000.00 R$ 1,220,045,000.00 R$ 1,220,045,000.00 R$ 1,220,045,000.00 R$ 1,220,045,000.00
    -R$ 366,013,500.00 -R$ 366,013,500.00 -R$ 366,013,500.00 -R$ 366,013,500.00 -R$ 366,013,500.00
    R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00
    R$ 864,031,500.00 R$ 864,031,500.00 R$ 864,031,500.00 R$ 864,031,500.00 R$ 864,031,500.00

    Cenário otimista
    ANO 2 ANO 3 ANO 4 ANO 5 ANO 6

    R$ 1,808,060,000.00 R$ 1,808,060,000.00 R$ 1,808,060,000.00 R$ 1,808,060,000.00 R$ 1,808,060,000.00


    -R$ 35,000,000.00 -R$ 35,000,000.00 -R$ 35,000,000.00 -R$ 35,000,000.00 -R$ 35,000,000.00
    -R$ 997,199.96 -R$ 997,199.96 -R$ 997,199.96 -R$ 997,199.96 -R$ 997,199.96
    R$ 1,772,062,800.04 R$ 1,772,062,800.04 R$ 1,772,062,800.04 R$ 1,772,062,800.04 R$ 1,772,062,800.04
    -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00
    R$ 1,762,062,800.04 R$ 1,762,062,800.04 R$ 1,762,062,800.04 R$ 1,762,062,800.04 R$ 1,762,062,800.04
    -R$ 528,618,840.01 -R$ 528,618,840.01 -R$ 528,618,840.01 -R$ 528,618,840.01 -R$ 528,618,840.01
    R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00
    R$ 1,243,443,960.03 R$ 1,243,443,960.03 R$ 1,243,443,960.03 R$ 1,243,443,960.03 R$ 1,243,443,960.03

    LOGO, A VARIÁVEL MAIS SENSÍVEL É O MARKET SHARE


    ANO 7 ANO 8 ANO 9 ANO 10

    R$ 904,030,000.00 R$ 904,030,000.00 R$ 904,030,000.00 R$ 904,030,000.00


    -R$ 37,000,000.00 -R$ 37,000,000.00 -R$ 37,000,000.00 -R$ 37,000,000.00
    -R$ 66,000,000.00 -R$ 66,000,000.00 -R$ 66,000,000.00 -R$ 66,000,000.00
    R$ 801,030,000.00 R$ 801,030,000.00 R$ 801,030,000.00 R$ 801,030,000.00
    -R$ 11,000,000.00 -R$ 11,000,000.00 -R$ 11,000,000.00 -R$ 11,000,000.00
    R$ 790,030,000.00 R$ 790,030,000.00 R$ 790,030,000.00 R$ 790,030,000.00
    -R$ 237,009,000.00 -R$ 237,009,000.00 -R$ 237,009,000.00 -R$ 237,009,000.00
    R$ 11,000,000.00 R$ 11,000,000.00 R$ 11,000,000.00 R$ 11,000,000.00
    R$ 564,021,000.00 R$ 564,021,000.00 R$ 564,021,000.00 R$ 564,021,000.00

    ANO 7 ANO 8 ANO 9 ANO 10

    R$ 1,356,045,000.00 R$ 1,356,045,000.00 R$ 1,356,045,000.00 R$ 1,356,045,000.00


    -R$ 36,000,000.00 -R$ 36,000,000.00 -R$ 36,000,000.00 -R$ 36,000,000.00
    -R$ 90,000,000.00 -R$ 90,000,000.00 -R$ 90,000,000.00 -R$ 90,000,000.00
    R$ 1,230,045,000.00 R$ 1,230,045,000.00 R$ 1,230,045,000.00 R$ 1,230,045,000.00
    -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00
    R$ 1,220,045,000.00 R$ 1,220,045,000.00 R$ 1,220,045,000.00 R$ 1,220,045,000.00
    -R$ 366,013,500.00 -R$ 366,013,500.00 -R$ 366,013,500.00 -R$ 366,013,500.00
    R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00
    R$ 864,031,500.00 R$ 864,031,500.00 R$ 864,031,500.00 R$ 864,031,500.00

    ANO 7 ANO 8 ANO 9 ANO 10

    R$ 1,808,060,000.00 R$ 1,808,060,000.00 R$ 1,808,060,000.00 R$ 1,808,060,000.00


    -R$ 35,000,000.00 -R$ 35,000,000.00 -R$ 35,000,000.00 -R$ 35,000,000.00
    -R$ 997,199.96 -R$ 997,199.96 -R$ 997,199.96 -R$ 997,199.96
    R$ 1,772,062,800.04 R$ 1,772,062,800.04 R$ 1,772,062,800.04 R$ 1,772,062,800.04
    -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00 -R$ 10,000,000.00
    R$ 1,762,062,800.04 R$ 1,762,062,800.04 R$ 1,762,062,800.04 R$ 1,762,062,800.04
    -R$ 528,618,840.01 -R$ 528,618,840.01 -R$ 528,618,840.01 -R$ 528,618,840.01
    R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00 R$ 10,000,000.00
    R$ 1,243,443,960.03 R$ 1,243,443,960.03 R$ 1,243,443,960.03 R$ 1,243,443,960.03

    Você também pode gostar