Question: Sensitivity analysis measures the effect of changes in a particular variable, say revenues, on a projects NPV. To perform a sensitivity analysis, all variables are

Sensitivity analysis measures the effect of changes in a particular variable, say revenues, on a projects NPV. To perform a sensitivity analysis, all variables are fixed at their expected values except one. This one variable is then changed, often by specified percentages, and the resulting effect on NPV is noted. An Excel "Data Table" is used below to find NPV for unit sales, salvage value, and cost of capital for the project, with the deviations from base case. This produces the sensitivity analysis for WACC as shown below. NPV Dev from base case WACC #DIV/0! -20% 8% #DIV/0! -10% 9% #DIV/0! 0% 10% #DIV/0! 10% 11% #DIV/0! 20% 12% #DIV/0! NPV Salvage #DIV/0! -20% 20 #DIV/0! -10% 22.5 #DIV/0! 0% 25 #DIV/0! 10% 27.5 #DIV/0! 20% 30 #DIV/0! NPV Salvage #DIV/0! -20% 20 #DIV/0! -10% 22.5 #DIV/0! 0% 25 #DIV/0! 10% 27.5 #DIV/0! 20% 30 #DIV/0! NPV Values for Deviations from Base Case Dev from base case WACC Units Sold Salvage -20% Copy Copy Copy -10% Cells Cells Cells 0% C72 to F72 to I72 to 10% C76 F76 I76 20% Here Here Here

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!

Shrek Casting Company is considering adding a new line to its product mix. The production line would be set up in unused space in Shrek's main plant. The machinery's invoice price would be...

Sensitivity analysis measures the effect of changes in a particular variable, say revenues, on a projects NPV. To perform a sensitivity analysis, all variables are fixed at their expected values...

please answer all questions Sensitisity analysis mearuren the effect of changes in a particular variable, say rerenues, on a project's NPV. To perform a sensitirity analysis, all variables are fired...

The objective of the Homework assignment is to provide an opportunity to apply or practice the tools and techniques covered in the course and to provide an opportunity to articulate key concepts...

5. Methods of analyzing risk for capital budgeting decisions Several types of analyses are available for evaluating a project's risk. In the following table, correctly identify the analysis being...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

PLEASE COMPLETE NO LATER THAN 10/07 @8:00AM Each question(1,2,& 3) must be a minimum of 200 words. Please make answers detailed and knowledgeable based off the attached reading. ARE YOU ABLE TO...

Please help me find the remaining salvage values and solve for Part B (with formulas and work included). Thanks! A B D E F G H 1 J 6 7 Shrieves Hospital Ltd. is considering adding a new line to its...

Hi everyone. Can someone please help me to help me to answer the questions below from my finance 101 midterm exam? Q1. Jiffy Co. expects to pay a dividend of $3.00 per share in one year. The current...

In each set of measurements, find the measurement that is (a) The least accurate (b) The least precise. 1. 16.4 in.; 0.075 in.; 0.05 in. 2. 475 ft; 300 ft; 360 ft 3. 27.5 m; 0.65 m; 12.02 m 4. 5.7...

A certain manufacturing plant is having problems meeting its delivery commitments. One of the problems has been traced to purchased materials which are frequently late, received in the wrong...

Sam works out that 365 24 = 8760 Use this information to write the answers to these calculations. a 365 2.4 b 36.5 2.4 c 3.65 0.24 d 8760 24 e 8760 2.4 f 876 2.4

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...