Question: Hi i need a step by step solution for how to fill in this table using a financial calculator (NOT Excel) Thank you! BASE CASE

Hi i need a step by step solution for how to fill in this table using a financial calculator (NOT Excel) Thank you!
Hi i need a step by step solution for how to fill
in this table using a financial calculator (NOT Excel) Thank you! BASE

BASE CASE - Price =$3 Quantity = 50 units Revenues $150 per year for 3 years, Variable costs = $1 per unit , Fixed cost = $30 per year, initial Cost of Capital = 10% investment = $150 straight line depreciation over 3 years, no salvage value, tax rate 25% BEST CASE - Quantity = 70 units WORST CASE - Quantity = 33 units SCENARIO ANALYSIS Prob NPV Best Case 25% Most Likely 50% 11.645 Worst Case 25% Expected NPV = *.25 + 11.645 * .50 + * .25 = 14.443 BASE CASE - Price =$3 Quantity = 50 units Revenues $150 per year for 3 years, Variable costs = $1 per unit , Fixed cost = $30 per year, initial Cost of Capital = 10% investment = $150 straight line depreciation over 3 years, no salvage value, tax rate 25% BEST CASE - Quantity = 70 units WORST CASE - Quantity = 33 units SCENARIO ANALYSIS Prob NPV Best Case 25% 86.251 Most Likely 50% 11.645 Worst Case 25% -51.769 Expected NPV = 86.251 *.25 + 11.645 * .50 +-51.769 * 25 = 14.443

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!