



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
The first thing we're going to do in Excel is set up a table for entering price, demand, unit cost, fixed cost, variable cost, total cost, revenue, and profit.
Typology: Lecture notes
1 / 6
This page cannot be seen from the preview
Don't miss anything!
Breakeven Analysis with Excel Using Goal Seek Method
In this tutorial, we are going to use the goal seek method with Excel to solve breakeven analysis.
Our objective is to use Excel to calculate the breakeven point using the goal seek method. The first thing we’re going to do in Excel is set up a table for entering price, demand, unit cost, fixed cost, variable cost, total cost, revenue, and profit.
Below is a table for doing the breakeven analysis using Goal Seek. The table will include price, the demand, the unit cost, the fixed cost, the revenue, the variable cost, total cost, and profit.
To begin, you will need to enter the following formulas in your table (shown below):
Your table should now look like this:
Next select the profit cell (B10), then click on the Data tab and click What-If Analysis as shown below:
From the What-If Analysis dropdown menu, select Goal Seek.
A pop-up window will appear, as shown here:
Set cell should already be set to your cell for profits (B10).
Now type 0 next to To value and enter $B$4 next to By changing cell. Then click OK twice.