Otobai's staff has come up with the following revised estimates for the electric scooter project:

Conduct a sensitivity analysis.

Attached you can find the excel sheet, please, provide formulas

Thanks

Otobai's staff has come up with the following revised estimates for the electric scooter project: Pessimistic Market size 0.8 Market share 0.04 Unit price 300000 Unit variable c 350000 Fixed cost 5 Expected 1 0.1 375000 300000 3 Optimistic 1.2 0.16 400000 275000 1 Conduct a sensitivity analysis using the "live" spreadsheets. What are the principal uncertainties in the project? Enter the values in blue colored cells. Student Name: Course Name: Student ID: Course Number: Calculate the NPV under the new assumptions listed above. To undertake a sensitivity analysis of the electric scooter project, we set each v to its most pessimistic or optimistic value and recalculate the NPV of the Operating cash flow (yen bn) = Range Variable Pessimistic Market size, mill Market share Unit price, yen Unit variable cos Fixed cost, bns 0.8 0.04 300,000 350,000 5 Expected 1 0.1 375,000 300,000 3 net income + depreciation tax shield Optimistic Pessimistic 1.2 0.16 400,000 275,000 1 What are the principal uncertainties in the project? The principal uncertainties are market share, unit price, and unit variable cost. Expected oter project: scooter project, we set each variable in turn and recalculate the NPV of the project cash flow (yen bn) = reciation tax shield Optimistic NPV (billions of yen) Pessimistic Expected Optimistic