I've been trying to solve a breakeven analysis but I get stuck when I want to add a yearly growth on top of the product mix,
Does anyone have a solution for below scenario,
In total 5 products over a 6 year period, if possible I would like to calculate backwards, so accumulated Net profit year 2023 = 0 and then get the starting point (volumes) for year 1 given the yearly mix and Year on year growth
Margin %
<tbody>
</tbody>
Product mix %
<tbody>
</tbody>
Yearly volume growth
<tbody>
</tbody>
fixed costs 100 000 $ each year
Super grateful for any support on this challenge!
Does anyone have a solution for below scenario,
In total 5 products over a 6 year period, if possible I would like to calculate backwards, so accumulated Net profit year 2023 = 0 and then get the starting point (volumes) for year 1 given the yearly mix and Year on year growth
Margin %
Product | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Total |
A | 5% | 6% | 7% | 8% | 9% | 10% | |
B | 1% | 2% | 3% | 4% | 5% | 6% | |
C | 7% | 8% | 9% | 10% | 11% | 12% | |
D | 12% | 13% | 14% | 15% | 16% | 17% | |
E | 20% | 21% | 22% | 23% | 24% | 25% |
<tbody>
</tbody>
Product mix %
Product | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Total |
A | 100% | 75% | 60% | 50% | 40% | 35% | |
B | 0% | 10% | 15% | 15% | 15% | 15% | |
C | 0% | 10% | 20% | 30% | 35% | 40% | |
D | 0% | 2,5% | 2,5% | 2,5% | 5% | 5% | |
E | 0% | 2,5% | 2,5% | 2,5% | 5% | 5% |
<tbody>
</tbody>
Yearly volume growth
Product | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Total |
A | 50% | 25% | 20% | 10% | 5% | ||
B | 20% | 25% | 20% | 10% | 5% | ||
C | 10% | 25% | 20% | 5% | 2% | ||
D | 2,5% | 20% | 15% | 10% | 5% | ||
E | 5% | 10% | 20% | 10% | 10% | ||
<tbody>
</tbody>
fixed costs 100 000 $ each year
Super grateful for any support on this challenge!