• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to use Goal Seek tool to find breakeven point in Excel

0 Comments

Goal Seek is a very useful tool in Excel for finding the breakeven point. Follow the article below to learn how to use the Goal Seek tool in detail.

How to use Goal Seek tool to find breakeven point in Excel

For example, let’s say we have 1,000 products to sell with a regular price of 90,000 and a promotional price of 60,000. The breakeven point we need to achieve is 80,000,000. We need to find the number of products sold at the high price and the number of products sold at the low price to achieve the breakeven point. From there, we can calculate how many products we need to sell at the regular price of 90,000 to make a profit.

How to use Goal Seek tool to find breakeven point in Excel

How to use Goal Seek tool to find breakeven point in Excel

At this point, we need to create a table as shown in the picture above. Set the formula in B3 to be B4-B2. This means we need to find the quantity sold at the high price, subtract it from 1,000 to get the quantity sold at the low price to meet the total revenue of 80,000.

Now, we use the Goal Seek tool to find the quantity sold at the high price that meets the breakeven point of 80,000 by selecting the Data tab on the toolbar. Then, you select What-If Analysis under the Forecast section. The scroll bar appears and you choose Goal Seek.

How to use Goal Seek tool to find breakeven point in Excel

How to use Goal Seek tool to find breakeven point in Excel

At this point, the Goal Seek dialog box appears.
In the Set cell field, you enter a reference to the total revenue cell, which is D4. In the To value field, you enter the breakeven revenue point of 80,000,000. In the By changing cell field, you enter a reference to the cell that contains the quantity sold at the high price, which is B2. Finally, click OK to complete.

How to use Goal Seek tool to find breakeven point in Excel

How to use Goal Seek tool to find breakeven point in Excel

After Excel has finished calculating, the Goal Seek Status dialog box will appear. Here, there will be a notification that the total revenue value of 80,000,000 has been achieved in cell D4. You can see that the value in the cell for the quantity sold at the high price is 667 and the value in the cell for the quantity sold at the low price is 333. So, to achieve revenue of 80,000,000, we need to sell 667 products at a price of 90,000 and 333 products at a price of 60,000. Therefore, to make a profit, we need to sell more than 667 products at the regular price of 90,000.

How to use Goal Seek tool to find breakeven point in Excel

How to use Goal Seek tool to find breakeven point in Excel

In this way, the above article has guided you on how to use the Goal Seek tool to find the breakeven point in Excel. We hope this article is useful to you in your work. Good luck!

Rate this post
25
274 Views
Tips for quickly comparing data tables in ExcelPrevTips for quickly comparing data tables in ExcelApril 11, 2023
Quick and Effective Way to Hide and Unhide Rows and Columns in ExcelApril 11, 2023Quick and Effective Way to Hide and Unhide Rows and Columns in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Internet Security 2021 1 year 5 devices key Global Kaspersky Internet Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $45.00
  • Windows Server 2022 Datacenter Key Global Windows Server 2022 Datacenter Key Global
    Rated 5.00 out of 5
    $7.00
  • Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year Kaspersky Small Office Security 10 PCs + 10 Mobiles + 1 Server 1 Year
    Rated 5.00 out of 5
    $164.50
  • Avast Ultimate Suite 2021 1 Year 10 Devices Global Avast Ultimate Suite 2021 1 Year 10 Devices Global
    Rated 5.00 out of 5
    $54.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
Products
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services Device Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Project Professional 2021 Microsoft Project Professional 2021 - 1 PC $13.00
  • Avast Ultimate Suite 2021 3 Years 10 Devices Global Avast Ultimate Suite 2021 3 Years 10 Devices Global
    Rated 5.00 out of 5
    $90.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • Windows 11 Pro Product Activation Key Windows 11 Pro Product Activation Key
    Rated 5.00 out of 5
    $6.00
  • Office 2016 Home and Student for PC Key CD Key Global Office 2016 Home and Student for PC Key CD Key Global
    Rated 4.96 out of 5
    $14.00
  • Windows Server 2012 R2 Datacenter Key Global Windows Server 2012 R2 Datacenter Key Global
    Rated 4.71 out of 5
    $15.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Avast Premium Security 2021 10 Devices 1 Year Global Avast Premium Security 2021 10 Devices 1 Year Global
    Rated 5.00 out of 5
    $28.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.