Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

excel please show all work and excel formuls Scenario Analysis (Excel Scenario Manager) Scenario analysis is used to determine the range of possible outcomes for

excel please show all work and excel formuls image text in transcribed
Scenario Analysis (Excel Scenario Manager) Scenario analysis is used to determine the range of possible outcomes for a project. Typically, the base case, best (optimistic) case, and worst (pessimistic) case values are calculated when doing scenario analysis. Because of the repetitive nature of the calculations, spreadsheets are an excellent tool for doing the analysis. Consider the Sonar Electronics Corporation solar- powered jet engine project presented in the example in the textbook: Base case 0 2,000,000 1,000,000 1.940,000,000 Pessimistic 5.000 20% Expected or Best 10,000 30% Optimistic 20,000 50% Unit sales: Price per unit Variable costs per unit: Fixed costs per year: Market size (per year) Market share Units sold (per year Price Variable cost (per engine) Fixed cost (per engine) Investment 1.900.000 1.200,000 2,000,000,000 1,900,000,000 2,000,000 1,000,000 1,940,000,000 1,500,000,000 2,200,000 800,000 1.740,000,000 1,000,000,000 Initial cost: Project life (years): Required retum: Tax rate: 1.500,000,000 3 15% 21% With these values, we need to calculate the base case, best case, and worst case NPVs and IRRs. First, we want to calculate the NPV and IRR with the base case projections, which are: Base Case Income Statement Sales Variable costs Fixed costs Depreciation EBIT Taxes (21%) Net income OCH NPV

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Financial Management

Authors: Glen Arnold

4th Edition

0273719068, 978-0273719069

More Books

Students also viewed these Finance questions

Question

=+5 Identify online buyers and sellers.

Answered: 1 week ago

Question

identify the main types of research studies in HRM research;

Answered: 1 week ago

Question

decide what data to gather and when;

Answered: 1 week ago