BUSI 402 Ch 8

# BUSI 402 Ch 8 - Chapter 8 Using Data Tables and Excel...

This preview shows pages 1–2. Sign up to view the full content.

Chapter 8: Using Data Tables and Excel Scenarios for What-If Analysis I. Level 1: Using Data Tables to Perform Break-Even and Sensitivity Analysis a. Break-even analysis – a type of what-if analysis that concentrates on an activity at or around the point at which a product breaks even. The point at which the expenses of creating and selling the product are equal to the revenue it produces, or where the profit is \$0. b. Sensitivity analysis – another type of what-if analysis that attempts to examine how sensitive the results of an analysis are to changes in the assumptions b.i. How tolerant the projected results are of changes in those estimates and assumptions c. Data table – a range of cells containing values and formulas. When you change the values, the data table shows you how those changes affect the results of the formulas c.i. Allow you to organize and present the results of multiple what-if analyses d. Input cells – cells containing values that can vary e. Result cells – contain formulas that involve the input cells in their calculations

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 02/22/2012 for the course BUSI 402 taught by Professor Staff during the Fall '10 term at UNC.

### Page1 / 2

BUSI 402 Ch 8 - Chapter 8 Using Data Tables and Excel...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online