$2,223,847.02 24.99% NPV IRR I. Conduct Sensitivity Analysis of NPV on Price and S Sales Volume 2,223,847.02 3,200,000 4,000,000 4,800,000 Note: I refer to this as the "sensitlvity Analysis Table (SAT $1.31 | -52,55 954,906.81 | 1,962,368.43 | Hint: This is the area that you will highlight in order to use the "Data Table" option under the "what-H Analysis. tool. $1.64962,597.362,223,847.023,485,096.67When this SAT is correct, the NPV in cell E45 will equal the base case NPV from C35 in the pro-forma above. $1.97 1,977,749.52 3,492,787.22 5,007,824.92 Unit Price Dollar sensitivity of NPV to a chan Hint: Divide the entire Dollar Sensitivity formula in cell E49 by 100 so that our analysis actually represents the "Cent" sensitivity. This is more relevant because the juice drink is a relatively cheap product. In other words, the firm would only adjust the selling price by cents, not dollars. Percentage sensitivity of NPV to a Dollar sensitivity of NPV to a chan Hint: These Percentage Sensitivity formulas must be divided by 100 to present correctly in the cell Percentage sensitivity of NPV to a Il. Conduct Sensitivity Analysis of NPV on Fixed and Variable Costs 2,223,847.02 $1,100,000.00 3,676,038.03 2,540,913.341,405,788.65 $1,250,000.00 3,358,971.71 2,223,847.02 1,088,722.32 1,400,000.00 3,041,905.391,906,780.69771,656.00 53% 60% 67% When this SAT is correct, the NPV in cell E62 will equal the base case NPV from C35 in the pro-forma above. Fixed Costs Dollar sensitivity of NPV to a chan Percentage sensitivity of NPV to a Dollr sensitivity of NPV to a chan Percentage sensitivity of NPV to a Hint: This Percentage Sensitivity formula must be divided by 100 to present correctly in the cell. 7.57 $2,223,847.02 24.99% NPV IRR I. Conduct Sensitivity Analysis of NPV on Price and S Sales Volume 2,223,847.02 3,200,000 4,000,000 4,800,000 Note: I refer to this as the "sensitlvity Analysis Table (SAT $1.31 | -52,55 954,906.81 | 1,962,368.43 | Hint: This is the area that you will highlight in order to use the "Data Table" option under the "what-H Analysis. tool. $1.64962,597.362,223,847.023,485,096.67When this SAT is correct, the NPV in cell E45 will equal the base case NPV from C35 in the pro-forma above. $1.97 1,977,749.52 3,492,787.22 5,007,824.92 Unit Price Dollar sensitivity of NPV to a chan Hint: Divide the entire Dollar Sensitivity formula in cell E49 by 100 so that our analysis actually represents the "Cent" sensitivity. This is more relevant because the juice drink is a relatively cheap product. In other words, the firm would only adjust the selling price by cents, not dollars. Percentage sensitivity of NPV to a Dollar sensitivity of NPV to a chan Hint: These Percentage Sensitivity formulas must be divided by 100 to present correctly in the cell Percentage sensitivity of NPV to a Il. Conduct Sensitivity Analysis of NPV on Fixed and Variable Costs 2,223,847.02 $1,100,000.00 3,676,038.03 2,540,913.341,405,788.65 $1,250,000.00 3,358,971.71 2,223,847.02 1,088,722.32 1,400,000.00 3,041,905.391,906,780.69771,656.00 53% 60% 67% When this SAT is correct, the NPV in cell E62 will equal the base case NPV from C35 in the pro-forma above. Fixed Costs Dollar sensitivity of NPV to a chan Percentage sensitivity of NPV to a Dollr sensitivity of NPV to a chan Percentage sensitivity of NPV to a Hint: This Percentage Sensitivity formula must be divided by 100 to present correctly in the cell. 7.57
