One powerful add-in in Microsoft Excel is Solver. You can use Solver to find the maximum or minimum value of a cell in your formula work or model. Instead of probably using a trial and error method to find a target value, you can use this tool to answer common business questions like:
-What is lowest price I can charge to remain profitable?
-By how much should an expense line change to give me a desired margin?
-What loan rate or tenor will be suitable for my monthly loan repayment budget?
In this webinar (video link below), you will learn practical ways to use Solver to simulate common business models.
If you have any questions after watching the webinar, please leave us a comment. Thank you