Breakeven Analysis
Flupsie
Registered Posts: 4
I have tried to compute the breakeven sales by taking the fixed costs/contribution margin
The gross profit is the sales  variable costs. I computed the Contribution margin by taking the gross profit/sales x 100
I have attached my sample data as it is giving me an incorrect breakeven sales. However If I use Goal Seek, the Sales is 436000, which we then show a zero Net profit
It would be appreciated if someone could check my formula and advise
The gross profit is the sales  variable costs. I computed the Contribution margin by taking the gross profit/sales x 100
I have attached my sample data as it is giving me an incorrect breakeven sales. However If I use Goal Seek, the Sales is 436000, which we then show a zero Net profit
It would be appreciated if someone could check my formula and advise
0
Comments

resolved my problem in computing the estimated Net Profit using data tables.
My Breakeven was 100% but I was getting an incorrect answer when computing forecasted Net Profit based on increased sales data when using a data table.
My Contribution margin was 27.1111% (GP %)
To resolve the problem regarding the incorrect forecasted net profit , I set my variable costs to be Sales * (10.271111) and now I get correct forecasted net profit0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 234 NEW! Qualifications 2022
 133 General Qualifications 2022 discussion
 7 AAT Level 2 Certificate in Accounting
 31 AAT Level 3 Diploma in Accounting
 55 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 91 Software
 272 Tax
 135 Bookkeeping
 7.3K General accounting discussion
 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 586 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 47 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership