Presupuesto de Ventas Consultoria Pinilla

Télécharger au format xlsx, pdf ou txt
Télécharger au format xlsx, pdf ou txt
Vous êtes sur la page 1sur 2

N X Y X² XY

2018 -2 $ 15,420,000 4 -$ 30,840,000


2019 -1 $ 18,100,000 1 -$ 18,100,000
2020 0 $ 10,045,000 0 $ -
2021 1 $ 150,000,000 1 $ 150,000,000
2022 2 $ 25,500,000 4 $ 51,000,000
2023 3 $ 30,000,000 9 $ 90,000,000
2024 4 $ 30,950,000 16 $ 123,800,000
TOTALES 7 $ 280,015,000 35 $ 365,860,000
2025 5

AÑOS 2018 2019 2020 2021

CONSULTORIAS $ 15,420,000 $ 18,100,000 $ 10,045,000 $ 150,000,000

$ 92,267,857
PROYECCIONES $ 81,814,714
$ 71,361,571
$ 60,908,429
$ 50,455,286
$ 40,002,143
$ 29,549,000
$ 19,095,857

y1 y2 y3 y4 y5 y6 Y7 Y8
2018 2019 2020 2021 2022 2023 2024 2025
Yʺ Y-Yʺ
$ 19,095,857 -$ 3,675,857
$ 29,549,000 -$ 11,449,000 Y= A + B
$ 40,002,143 -$ 29,957,143 $ 280,015,000 $ 365,860,000
$ 50,455,286 $ 99,544,714 7 35
$ 60,908,429 -$ 35,408,429
$ 71,361,571 -$ 41,361,571 $ 40,002,143 $ 10,453,143
$ 81,814,714 -$ 50,864,714

$ 92,267,857

2022 2023 2024 2025

$ 25,500,000 $ 30,000,000 $ 30,950,000 $ 92,267,857

PROYECCIONES
2018 y1 $ 19,095,857
2019 y2 $ 29,549,000
2020 y3 $ 40,002,143
2021 y4 $ 50,455,286
2022 y5 $ 60,908,429
2023 y6 $ 71,361,571
2024 Y7 $ 81,814,714
2025 Y8 $ 92,267,857

Vous aimerez peut-être aussi