Question: I need a step by step explanation on how to fill this table out (quantity, variable cost, cost of capital) based off of the information

I need a step by step explanation on how to fill this table out (quantity, variable cost, cost of capital) based off of the information given.
and NOT by using Excel. Thank you!
I need a step by step explanation on how to fill this
table out (quantity, variable cost, cost of capital) based off of the

SENSITIVITY ANALYSIS Expected Values Initial Investment = $150 Straight Line Depreciation over 3 years Quantity = 50 units Price = $3 per unit Revenues from project $150 per year for 3 years Fixed cost each year = $30 Variable costs = $1 per unit Cost of Capital = 10% Tax Rate = 25% NPV Table Change NPV Quantity Variable Cost Cost of Capital -10% 0 +10% Base Case Yr 0 Yr 1 Quantity 50 Price 3 Yr 2 Yr 3 -150 Rev $150 VC 50 FC 30 Dep 50 Oper Inc BT 20 Taxes 25% 5 NOPAT 15 + DEP 50 OCF 65 NPV 10%

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!