Páginas

viernes, 2 de marzo de 2018

Precio compra Cost.


costAÑO 0AÑO 1AÑO 2AÑO 3AÑO 4AÑO 5AÑO 6AÑO 7AÑO 8AÑO 9AÑO 10
Precio compra160.00
1132735.00140699.10149141.05158089.51167574.88177629.37188287.13199584.36211559.42224252.99237708.17
Margin ebit3.17%3.21%3.24%3.27%3.30%3.34%3.37%3.40%3.44%3.47%3.51%
EBIT4,213.004,510.444,828.875,169.795,534.785,925.546,343.886,791.767,271.257,784.618,334.20
Capital invertido16,373.0017,355.3818,396.7019,500.5020,670.5421,910.7723,225.4124,618.9426,096.0727,661.8429,321.55
CASH FLOW OPERATIVO
54.958.261.765.469.373.577.982.587.592.898.3
NOPAT2869.13071.63288.53520.63769.24035.34320.24625.24951.75301.35675.6
CAPEX Crec34.24%33.90%33.57%33.23%32.90%32.58%32.26%31.94%31.62%31.31%31.00%
% a FCF65.76%66.10%66.43%66.77%67.10%67.42%67.74%68.06%68.38%68.69%69.00%
Incremento ventas6.00%6.00%6.00%6.00%6.00%6.00%6.00%6.00%6.00%6.00%6.00%
crec7.0%7.00%7.00%7.00%7.00%7.00%7.00%7.00%7.00%7.00%7.00%
ROIC17.52%17.70%17.88%18.05%18.23%18.42%18.60%18.79%18.97%19.16%19.36%
Change profit margin1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%1.00%
Expansion PE0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%8.59%
NOPAT EARNINGS24.8623.2221.6920.2618.9317.6816.5115.4214.4113.4612.57
NOPAT EARNING FINAL24.8624.8624.8624.8624.8624.8624.8624.8624.8624.8627.00
Rentabilidad9.4%9.60%9.80%10.02%10.26%10.51%10.78%11.07%11.38%11.72%20.67%
10.04%11.58%

Precio compra Paychex


PAYXAÑO 0AÑO 1AÑO 2AÑO 3AÑO 4AÑO 5AÑO 6AÑO 7AÑO 8AÑO 9AÑO 10
Precio compra57.00
Ventas3237.003398.853568.793747.233934.594131.324337.894554.784782.525021.655272.73
Margin ebit39.64%39.95%40.27%40.59%40.92%41.25%41.58%41.91%42.24%42.58%42.92%
EBIT1,283.001,357.931,437.231,521.161,610.001,704.021,803.541,908.872,020.342,138.332,263.21
Capital invertido2,043.502,145.682,252.962,365.612,483.892,608.082,738.492,875.413,019.183,170.143,328.65
CASH FLOW OPERATIVO
54.957.660.563.666.770.173.677.281.185.289.4
NOPAT838.4887.4939.2994.11052.11113.61178.61247.41320.31397.41479.0
CAPEX Crec12.19%12.09%11.99%11.90%11.80%11.71%11.62%11.53%11.43%11.34%11.25%
% a FCF87.81%87.91%88.01%88.10%88.20%88.29%88.38%88.47%88.57%88.66%88.75%
Incremento ventas5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%
crec5.8%5.80%5.80%5.80%5.80%5.80%5.80%5.80%5.80%5.80%5.80%
ROIC41.03%41.36%41.69%42.02%42.36%42.70%43.04%43.38%43.73%44.08%44.43%
Change profit margin0.80%0.80%0.80%0.80%0.80%0.80%0.80%0.80%0.80%0.80%0.80%
Expansion PE0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%11.13%
NOPAT EARNINGS24.3022.9621.6920.4919.3618.2917.2816.3315.4314.5813.77
NOPAT EARNING FINAL24.3024.3024.3024.3024.3024.3024.3024.3024.3024.3027.00
Rentabilidad9.3%9.55%9.77%10.01%10.26%10.52%10.81%11.10%11.42%11.76%23.24%
10.02%11.84%