{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

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

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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}