Create a Dynamic Break Even Analysis Chart in Excel | Break Even Formula | Break Even Point Table

[@wayneedmondson1065]

Hi Chester. Cool solutions! Thanks for sharing them. Also, for dynamic fixed cost formula, you could use SEQUENCE to spill as follows: =SEQUENCE(C5,,C9,0). Basically, rows = no. of increments, [start] = total fixed cost and [step] = 0. This will spill 10,000 down 10 rows and react to changes in the no. of increments input. Your videos are great! Keep them coming. Thumbs up!!

[@ChesterTugwell]

Thanks. That's a much better solution 😃

[@wayneedmondson1065]

@@ChesterTugwell Great.. glad to contribute! Cheers :))

[@countduckula9977]

Cheers Chester!
Another brilliant training video showing how to create break even on new & old versions of Excel.

[@jimenaguardiola1678]

This has to be one of the best tutorials on RUclips. Keep up the good work spreading knowledge!

[@IvanCortinas_ES]

Extremely good. The tutorial is told in exquisite detail. Thank you Chester!!!

[@TA-MUSIIQUE]

Subbed, I would not done this alone

[@GeorgeAJululian]

Thanks Sir very helpful

[@paipanthanalerdsopit3573]

Thanks!

[@ChesterTugwell]

Many thanks

[@jacobnorman5420]

Thank you

[@gwynethp2874]

Hi Chester, I would like to ask, How will you know your incremental units, if your break even in units for example is 4,757?

[@bonniedang1403]

Hi Chester, is there any suggestion for dynamic step fixed cost? like when it reach a certain units sold, our fixed cost will increase. Thanks

[@chrisapperley2616]

👍🙏