Examen financiero.
Enviado por adrian12 • 20 de Junio de 2016 • Tarea • 537 Palabras (3 Páginas) • 272 Visitas
SECANO | |||||||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|
|
Tractor nuevo 0 | 30,443 |
|
|
|
|
|
|
|
|
|
|
|
|
tractor existente | 9,557 |
|
|
|
|
|
|
|
|
|
|
|
|
reposicion tractor existente |
|
|
|
|
|
| -40,000 |
|
|
|
|
|
|
Tractor nuevo 10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
rendimientos secano |
| 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 |
|
|
residual tractor existente |
|
|
|
|
|
| 956 |
|
|
|
|
|
|
inversion tractor existente |
|
|
|
|
|
| 96 |
|
|
|
|
|
|
residual tractor nuevo 0 |
|
|
|
|
|
|
|
|
|
| 3,044 |
|
|
inversion tractor nuevo 0 |
|
|
|
|
|
|
|
|
|
| 304 |
|
|
|
|
|
|
|
|
| 361,051 |
|
|
| 403,349 |
|
|
cuota de amortizacion tractor existente |
| -1,434 | -1,720 | -2,150 | -2,867 | -4,301 | -8,601 |
|
|
|
|
|
|
cuota de amortizacion tractor nuevo 0 |
| -2,740 | -3,044 | -3,425 | -3,914 | -4,566 | -5,480 | -6,850 | -9,133 | -13,699 | -27,399 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
cuota de amortizacion tractores |
| -4,173 | -4,765 | -5,575 | -6,781 | -8,867 | -14,081 | -6,850 | -9,133 | -13,699 | -27,399 |
|
|
beneficio antes de impuestos BAI |
| 395,827 | 395,235 | 394,425 | 393,219 | 391,133 | 346,970 | 393,150 | 390,867 | 386,301 | 375,950 |
|
|
Impuestos sociedades 25% |
| -98,957 | -98,809 | -98,606 | -98,305 | -97,783 | -86,743 | -98,288 | -97,717 | -96,575 | -93,988 |
|
|
Beneficio despues de impuestos BDI |
| 296,870 | 296,427 | 295,819 | 294,914 | 293,350 | 260,228 | 294,863 | 293,150 | 289,725 | 281,963 |
|
|
+ cuota de amortizacion tractores |
| 4,173 | 4,765 | 5,575 | 6,781 | 8,867 | 14,081 | 6,850 | 9,133 | 13,699 | 27,399 |
|
|
Cash - Flow o Flujo de Caja |
| 301,043 | 301,191 | 301,394 | 301,695 | 302,217 | 274,309 | 301,712 | 302,283 | 303,425 | 309,361 |
|
|
rendimientos netos | -40,000 | 301,043 | 301,191 | 301,394 | 301,695 | 302,217 | 274,309 | 301,712 | 302,283 | 303,425 | 309,361 | VAN | 1,637,625.48 € |
|
|
|
|
|
|
|
|
|
|
|
| TIR | 752.7% |
REGADIO | |||||||||||||
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
|
|
Tractor nuevo 0 | 40,000 |
|
|
|
|
|
|
|
|
|
|
|
|
tractor existente | 9,557 |
|
|
|
|
|
|
|
|
|
|
|
|
reposicion tractor existente | 40,000 |
|
|
|
|
| -40,000 |
|
|
|
|
|
|
Tractor nuevo 10 |
|
|
|
|
|
|
|
|
|
| -40,000 |
|
|
Obras | 500,000 |
|
|
|
|
|
|
|
|
|
|
|
|
Eq. Riego | 600,000 |
|
|
|
|
|
|
|
|
|
|
|
|
rendimientos secano |
| 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 | 400,000 |
|
|
rendimientos regadio |
| 600,000 | 700,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 | 800,000 |
|
|
residual tractor existente |
|
|
|
|
|
| 956 |
|
|
|
|
|
|
inversion tractor existente |
|
|
|
|
|
| 96 |
|
|
|
|
|
|
residual tractor nuevo 0 |
|
|
|
|
|
|
|
|
|
| 4,000 |
|
|
inversion tractor nuevo 0 |
|
|
|
|
|
|
|
|
|
| 400 |
|
|
residual obra |
|
|
|
|
|
|
|
|
|
| 50,000 |
|
|
|
|
|
|
|
|
| 761,051 |
|
|
| 814,400 |
|
|
cuota de amortizacion tractor existente |
| -1,434 | -2,150 | -2,867 | -1,434 | -4,301 | -8,601 |
|
|
|
|
|
|
cuota de amortizacion tractor nuevo 0 |
| -3,600 | -4,000 | -4,500 | -5,143 | -6,000 | -7,200 | -9,000 | -12,000 | -18,000 | -36,000 |
|
|
amortizacion riego |
| -60,000 | -66,667 | -75,000 | -85,714 | -100,000 | -120,000 | -150,000 | -200,000 | -300,000 | -600,000 |
|
|
amortizacion obra |
| -50,000 | -50,000 | -50,000 | -50,000 | -50,000 | -50,000 | -50,000 | -50,000 | -50,000 | -50,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
cuota de amortizaciones |
| -115,034 | -122,817 | -132,367 | -142,291 | -160,301 | -185,801 | -209,000 | -262,000 | -368,000 | -686,000 |
|
|
beneficio antes de impuestos BAI |
| 484,966 | 577,183 | 667,633 | 657,709 | 639,699 | 614,199 | 591,000 | 538,000 | 432,000 | 114,000 |
|
|
Impuestos sociedades 25% |
| -121,242 | -144,296 | -166,908 | -164,427 | -159,925 | -153,550 | -147,750 | -134,500 | -108,000 | -28,500 |
|
|
Beneficio despues de impuestos BDI |
| 363,725 | 432,887 | 500,725 | 493,282 | 479,775 | 460,649 | 443,250 | 403,500 | 324,000 | 85,500 |
|
|
+ cuota de amortizacion tractores |
| 115,034 | 122,817 | 132,367 | 142,291 | 160,301 | 185,801 | 209,000 | 262,000 | 368,000 | 686,000 |
|
|
Cash - Flow o Flujo de Caja |
| 478,758 | 555,704 | 633,092 | 635,573 | 640,075 | 646,450 | 652,250 | 665,500 | 692,000 | 771,500 |
|
|
rendimientos netos | -1,189,557 | 478,758 | 555,704 | 633,092 | 635,573 | 640,075 | 646,450 | 652,250 | 665,500 | 692,000 | 771,500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| VAN | 2,375,567.66 € |
|
|
|
|
|
|
|
|
|
|
|
| TIR | 46.9% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$236.66 |
...