Bishop Company has provided the estimated data that appear in rows 4 to 8 of the following spreadsheet:

Using the spreadsheet tips that follow, construct a spreadsheet that allows you to determine net income, break-even in units, and operating leverage for the estimates at the top of the spreadsheet and see the effects of changes to the estimates. Set up this spreadsheet so that any change in the estimates will automatically be reflected in the calculation of net income, break-even, and operating leverage.
Spreadsheet Tips
To center a heading across several columns, such as the Income Statement title, highlight the area to be centered (Columns B, C, and D), choose Format, then choose Cells, and click on the tab titled Alignment. Near the bottom of the alignment window, place a check mark in the box titled Mergecells.

  • CreatedFebruary 07, 2014
  • Files Included
Post your question