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

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