Excel - Breakeven in Units and Sales

Using Excel, we can find the breakeven point in units and in sales. The Contribution Margin is a company's revenue minus its variable cost. You can use the Contribution Margin to find the Breakeven Point. The Breakeven Point is where you aren't making any profit nor have a loss. Your net is zero. Another way of looking at the contribution margin is the amount per unit to cover fixed costs. The Contribution Margin formula is Net Sales Revenue – Variable Costs = Contribution Margin. 0:00 Intro 0:18 Product Mix chart 0:48 Breakeven point overview 2:33 Breakeven in Units 3:10 Breakeven in Sales Breakeven in Units is the Fixed Cost / Contribution Margin per unit Breakeven in Sales is the Fixed Cost / Contribution Margin percentage Chris Menard's Blog post on Break-even analysis https://chrismenardtraining.com/post/... Related Videos Cost-Volume Profit Analysis / Breakeven analysis in Excel with multiple products by Chris Menard    • Cost-Volume Profit Analysis / Breakeven an...   Break-even analysis in Excel with a chart / cost-volume-profit analysis by Chris Menard    • Break-even analysis in Excel with a chart ...   Keywords Cost Volume Profit Analysis Cost accounting Managerial Accounting Accounting and Finance MBA students Business students Chris Menard training the Executive MBA and Professional MBA students at the Terry College of Business. The Terry College of Business is part of the University of Georgia. Webpage for training https://chrismenardtraining.com/train... #contributionmargin #accounting #msexcel #chrismenardtraining Cost Volume Profit Analysis And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!