Break-Even Point Formulas (Spreadsheet/ Excel)

Before making hiring or purchasing decisions, healthcare organizations must consider whether the decision is financially profitable. By calculating break-even points, organizations are able to examine actual costs and make more sound financial decisions. For this Assignment, you use data from an imaging center and calculate break-even points.

Given the imaging center scenario and financial data, create an Excel spreadsheet showing the following:.

  • Solve for monthly volume to break even.
  • Solve for monthly volume needed to break even at desired $5,000 per month profit level.
  • Solve for volume needed to break even at new reimbursement of $55 per screen and no profit.
  • Solve for volume needed to break even with additional labor.