Episode 3: Net profit scenarios with Goal Seek and Solver.
Welcome to the 3rd episode of our series. “Excel for FP&A and cost management”. In our video today will discuss how to optimize your contribution margin, and net profit using the excel function of Goal Seek. Also, discuss how to avoid the limitations of the goal seek function by using the add-in solver or scenario manager.
Let’s start with a simple example.
Our topics today:
Using excel Goal Seek to find a contribution margin, and EBIT, by adjusting an input value (for ex; total quantity or unit price)
Applying 3 ways of using the Goal Seek function
1- Data tab, What-If Analysis, and then click Goal Seek
2- keyboard shortcut (Alt + A + W and G)
3- Adding goal seek to the quick access toolbar
Also, discussing important tutorial videos by professional experts
Tim Vipond (The CEO at the Corporate Finance Institute.)
Mynda Treacy (Co-founder My Online Training Hub)
Kenji Farré (a co-founder at Career Principles)
Mohamed Elrify (The founder of Excel Expert)
Detailed post with all sources and references (also discussions & advice), in this link (LinkedIn)
https://www.linkedin.com/posts/hamdy-hafez-acca%C2%AE-mba-dip-87b11958_e3net-profit-scenarios-with-goal-seek-and-activity-7002267298497466368-Z-0a?utm_source=share&utm_medium=member_desktop
For further discussion about this topic (and other topics), please visit my LinkedIn page.
LINKEDIN: https://www.linkedin.com/in/hamdy-hafez-acca%C2%AE-mba-dip-87b11958/
