Project NPV Scenario Analysis
Not what you're looking for?
Scenario Analysis. The most likely outcomes for a particular project are estimated as follows :
Unit price: $50
Variable cost: $30
Fixed cost: $300,000
Expected sales: 30,000 units per year
However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10 percent higher or 10 percent lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1 million, which will be depreciated straight-line over the project life to a final value of zero. The firm's tax rate is 35 percent and the required rate of return is 12 percent. What is project NPV in the "best-case scenario," that is, assuming all variables take on the best possible value? What about the worst-case scenario?
Purchase this Solution
Solution Summary
The solution examines project NPV scenario analysis.
Solution Preview
See the attached file (Excel file). The solution pasted here is not complete. You can see the formulas in cell in excel file.
First of all make the Normal Projections
Year Initial Investment Sales Revenue Variable Cost Fixed Cost Depreciation Taxable Income Tax Net Cash Flow ...
Purchase this Solution
Free BrainMass Quizzes
Motivation
This tests some key elements of major motivation theories.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Basics of corporate finance
These questions will test you on your knowledge of finance.