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), 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
Get step-by-step solutions from verified subject matter experts
