{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

MBA - Aut or Andr Saleme Hachem Exerccio MBA Dados do...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Autor: André Saleme Hachem Exercício: MBA Dados do Problema Cálculos Invt. Inic. R$ 50,000.00 ANO Franquia R$ 80,000.00 0 1 2 3 4 5 6 7 CF R$ 126,000.00 Alunos 20.7652529607 30.4566670285 41.9854438281 52.2850099433 63.050087671 72.8264155657 79.4319744088 Receita/aluno R$ 6,000.00 Custo Franquia 8% Invest -R$ 130,000.00 Custo Var R$ 300.00 Receita R$ 124,591.52 R$ 182,740.00 R$ 251,912.66 R$ 313,710.06 R$ 378,300.53 R$ 436,958.49 R$ 476,591.85 TMA 10% Custo Fixo R$ 126,000.00 R$ 126,000.00 R$ 126,000.00 R$ 126,000.00 R$ 126,000.00 R$ 126,000.00 R$ 126,000.00 Custo Fran R$ 9,967.32 R$ 14,619.20 R$ 20,153.01 R$ 25,096.80 R$ 30,264.04 R$ 34,956.68 R$ 38,127.35 Variável de Saida Custo Var R$ 6,229.58 R$ 9,137.00 R$ 12,595.63 R$ 15,685.50 R$ 18,915.03 R$ 21,847.92 R$ 23,829.59 VPL R$ 469,304.62 RESULTADO -R$ 130,000.00 -R$ 17,605.38 R$ 32,983.80 R$ 93,164.02 R$ 146,927.75 R$ 203,121.46 R$ 254,153.89 R$ 288,634.91 Variáveis Aleator. Min Mais Prov. Max Aleatório C = 0.3333333333 N° Inic. Alunos 20.765 15 20 30 0.4314629808 Cresc Ano 2 47% 45.0% 50.0% 55.0% 0.167130271 Cresc Ano 3 38% 31.5% 35.0% 38.5% 0.9075782904 Simulação VPL Cresc Ano 4 25% 22.5% 25.0% 27.5% 0.4062556811 1 R$ 469,304.62 Cresc Ano 5 21% 18.0% 20.0% 22.0% 0.647305958 2 R$ 469,304.62 Cresc Ano 6 16% 13.5% 15.0% 16.5% 0.6685510445 3 R$ 469,304.62 Cresc Ano 7 9% 9.0% 10.0% 11.0% 0.035139339 4 R$ 469,304.62 5 R$ 469,304.62 6 R$ 469,304.62 7 R$ 469,304.62 8 R$ 469,304.62 9 10 R$ 469,304.62 11 R$ 469,304.62 12 R$ 469,304.62 13 R$ 469,304.62 14 R$ 469,304.62 15 R$ 469,304.62 16 17 R$ 469,304.62 18 R$ 469,304.62 19 R$ 469,304.62 20 R$ 469,304.62 21 R$ 469,304.62 22 R$ 469,304.62 23 24 R$ 469,304.62 25 R$ 469,304.62 26 R$ 469,304.62 27 R$ 469,304.62 28 R$ 469,304.62 29 R$ 469,304.62 30 31 R$ 469,304.62 32 R$ 469,304.62 33 R$ 469,304.62 34 R$ 469,304.62 35 R$ 469,304.62 36 37 R$ 469,304.62 38 R$ 469,304.62 39 R$ 469,304.62 40 R$ 469,304.62 41 R$ 469,304.62 42 R$ 469,304.62 43 44 R$ 469,304.62 45 R$ 469,304.62 46 R$ 469,304.62 47 R$ 469,304.62 48 R$ 469,304.62 49 R$ 469,304.62 50 51 R$ 469,304.62 52 R$ 469,304.62 53 R$ 469,304.62 54 R$ 469,304.62 55 R$ 469,304.62 56 R$ 469,304.62 57 58 R$ 469,304.62 59 R$ 469,304.62 60 R$ 469,304.62 61 R$ 469,304.62 62 R$ 469,304.62 63 R$ 469,304.62 64 65 R$ 469,304.62 66 R$ 469,304.62 67 R$ 469,304.62 68 R$ 469,304.62 69 R$ 469,304.62 70 R$ 469,304.62 71 72 R$ 469,304.62 73 R$ 469,304.62 74 R$ 469,304.62 75 R$ 469,304.62 76 R$ 469,304.62 77 R$ 469,304.62 78 79 R$ 469,304.62 80 R$ 469,304.62 81 R$ 469,304.62 82 R$ 469,304.62 83 R$ 469,304.62 84 R$ 469,304.62 85 86 R$ 469,304.62 87 R$ 469,304.62 88 R$ 469,304.62 89 R$ 469,304.62 90 R$ 469,304.62 91 R$ 469,304.62 92 93 R$ 469,304.62 94 R$ 469,304.62 95 R$ 469,304.62 96 R$ 469,304.62 97 R$ 469,304.62 98 R$ 469,304.62 99 100 R$ 469,304.62 101 R$ 469,304.62 102 R$ 469,304.62 103 R$ 469,304.62 104 R$ 469,304.62 105 106 R$ 469,304.62 107 R$ 469,304.62 108 R$ 469,304.62 109 R$ 469,304.62 110 R$ 469,304.62 111 R$ 469,304.62 112 113 R$ 469,304.62 114 R$ 469,304.62 115 R$ 469,304.62 116 R$ 469,304.62 117 R$ 469,304.62 118 R$ 469,304.62 119 120 R$ 469,304.62 121 R$ 469,304.62 122 R$ 469,304.62 123 R$ 469,304.62 124 R$ 469,304.62 125 R$ 469,304.62 126 127 R$ 469,304.62 128 R$ 469,304.62 129 R$ 469,304.62 130 R$ 469,304.62 131 R$ 469,304.62 132 R$ 469,304.62 133 134 R$ 469,304.62 135 R$ 469,304.62 136 R$ 469,304.62 137 R$ 469,304.62 138 R$ 469,304.62 139 R$ 469,304.62 140 141 R$ 469,304.62 142 R$ 469,304.62 143 R$ 469,304.62 144 R$ 469,304.62 145 R$ 469,304.62 146 R$ 469,304.62 147 148 R$ 469,304.62 149 R$ 469,304.62 150 R$ 469,304.62 151 R$ 469,304.62 152 R$ 469,304.62 153 R$ 469,304.62 154 155 R$ 469,304.62 156 R$ 469,304.62 157 R$ 469,304.62 158 R$ 469,304.62 159 R$ 469,304.62 160 R$ 469,304.62 161 162 R$ 469,304.62 163 R$ 469,304.62 164 R$ 469,304.62 165 R$ 469,304.62 166 R$ 469,304.62 167 168 R$ 469,304.62 169 R$ 469,304.62 170 R$ 469,304.62 171 R$ 469,304.62 172 R$ 469,304.62 173 R$ 469,304.62 174 175 R$ 469,304.62 176 R$ 469,304.62 177 R$ 469,304.62 178 R$ 469,304.62 179 R$ 469,304.62 180 R$ 469,304.62 181 182 R$ 469,304.62 183 R$ 469,304.62 184 R$ 469,304.62 185 R$ 469,304.62 186 R$ 469,304.62 187 R$ 469,304.62 188 189 R$ 469,304.62 190 R$ 469,304.62
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}