90.2K

Verified Solution

Link Copied!

24 Example 2 25 Calculate the initial Cost, Operating Cash Flow, Terminal Non-operating Cash Flow, and NPV 26 Initial Cost: Equipment + NWC 27 OCF: (S-VC-FC 1-1)+Dt 28 TNOCF: SP-SP-BV]*t +NWC 29 NPV: 21 Example 3: 32 Scenario Analysis Scenario analysis is used to determine the range of possible outcomes for a project. Typically, the base case, best case, and worst case values are calculated when doing scenario analysis. Because of the repetitive nature of the calculations, spreadsheets are an 33 excellent tool for doing the analysis. Consider the values presented in the example in the textbook: Base case 6,000 80 Worst case 5,500 Best case 7,000 80 80 Unit alp Price per unit Variable costs per unit: Fixed costs per year: 60 50 50,000 60 50,000 $ 50,000 $ 200,000 $ 200,000 $ 200,000 Initial cost: Project life (years) Required return: Tax rate: 12% 12% 12% 34% 34% 34% 46 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 $ 18 Base Case income Statement 49 Sales so Variable costs 51 Fixed costs 52 Depreciation 53 EBIT 54 Taxes 55 Net income Worst Case Income Statement Best Case income Statement 480,000 Sales $ 440,000 Sales $ 560,000 360,000 Variable costs 330,000 Variable costs 420,000 50,000 Fixed costs 50,000 Fixed costs 50,000 40,000 Depreciation 40,000 Depreciation 40,000 30,000 EBIT $ 20,000 EDIT $ 50,000 10,200 Taxes 6.800 Takes 17,000 19,800 Net income $ 13,200 Net income $ 33,000 $ $ 57 OCF OCF OCF $9 NOV NPV NPV

Answer & Explanation Solved by verified expert

See Answer