Question: When creating the data table on the Assumptions worksheet (Table 7), would what the column input cell be? Do not enter an equal sign at

 When creating the data table on the Assumptions worksheet (Table 7),

When creating the data table on the Assumptions worksheet (Table 7), would what the "column input cell" be? Do not enter an equal sign at the beginning of the formula, use relative references. Table 7 Sensitivity Analysis (Loan Term) Beer Sales 101 $ 102 $ 103 $ 104 $ (Sales Multiple) 105 $ Totals $ COGS Pints 103,063 $ 19,556 24250 103,063 $ 22,492 22312 111,560 $ 34,564 28573 214,298 $ 26,879 22220 155,540 $ 20,410 28120 105,450 $ 123,901 125475 When creating the data table on the Assumptions worksheet (Table 7), would what the "column input cell" be? Do not enter an equal sign at the beginning of the formula, use relative references. Table 7 Sensitivity Analysis (Loan Term) Beer Sales 101 $ 102 $ 103 $ 104 $ (Sales Multiple) 105 $ Totals $ COGS Pints 103,063 $ 19,556 24250 103,063 $ 22,492 22312 111,560 $ 34,564 28573 214,298 $ 26,879 22220 155,540 $ 20,410 28120 105,450 $ 123,901 125475

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!