Question

In: Finance

Perform a scenario analysis with data provided Assume that your selected company is considering a potential...

Perform a scenario analysis with data provided
Assume that your selected company is considering a potential project with a new product that is expected to sell for an average price of $30 per unit and the company expects it can sell 350,000 units per year at this price for a period of 4 years. Launching this project will require purchase of a $3,500,000 equipment that has residual value in four years of $500,000 and adding $ 1,000,000 in working capital which is expected to be fully retrieved at the end of the project. Other information is available below:
Depreciation method: straight line Variable cost per unit: $20
Cash fixed costs per year $450,000 Discount rate: 12%
Tax Rate: 35%
Do a SCENARIO ANALYSIS with cash flows of the assumed project to determine the sensitivity of the project’s NPV to different scenarios that are defined in terms of the estimated values for each of the project’s value drivers. Please work on two scenarios corresponding to the worst- and best-case outcomes for the project. Your group needs to provide the results in (a) relevant tables:
Worst case: Unit sales decrease by 20%; price per unit decreases by 20%; variable cost per unit increases by 20 %; cash fixed cost per year increases by $200,000
Best case: Unit sales increase by 20%; price per unit increases by 20%; variable cost per unit decreases by 20%; cash fixed cost per year decreases by $200,000
Based on scenario analysis outcome,draw relevant conclusion about project NPV's sensitivity

Solutions

Expert Solution

Base Case NPV

The same with Excel formulas shown:

Worst Case NPV

The same with Excel formulas shown:

Best Case NPV

The same with Excel formulas shown:

The Base Case NPV of the Project is $3,272,126, Worst case NPV is Negative $4,032,699 and Best Case NPV is $13,340,939.


Related Solutions

Part 3: Risk analysis and project evaluation 3.1 Perform a scenario analysis on the data provided...
Part 3: Risk analysis and project evaluation 3.1 Perform a scenario analysis on the data provided Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 650 000 unit per year at this price for a period of 4 years. Launching this project will require...
Perform an incremental analysis of the two finalist projects using the data provided below. The company...
Perform an incremental analysis of the two finalist projects using the data provided below. The company uses a MARR of 10% and depreciates its assets using 7-year MACRS. The company’s effective income tax rate is 25%. Project 1: Milling machines Equipment cost: Two (2) machines that each cost $380,000 including trade-in allowance and sales tax. The total cost of the freight and handling is expected to be $25,000. The total cost to install the machines is $30,000. Total testing and...
Multivariate analysis Using the data provided, perform the following analysis: Determine the explanatory and response variables....
Multivariate analysis Using the data provided, perform the following analysis: Determine the explanatory and response variables. Run a multivariate regression analysis on all three variables. Interpret the results by answering the following questions: What is the calculated correlation coefficient? Do the sales figures correlate with the marketing expenditure and price? Comment on the coefficient of determination. What percentage of the response data can be explained by the explanatory variables? Determine the multiple regression line equation in the form: sales^ =...
Question #11 – Regression Analysis Use the data provided to: Perform the “Tests to Check the...
Question #11 – Regression Analysis Use the data provided to: Perform the “Tests to Check the Validity of a Regression” Show both the calculated and critical values Estimate Y when X = 4 (round to 2 decimal places) Use a level of significance of 5% (α = .05). Clearly show the null and alternate hypothesis. Graphs are not required. X Y 3 14 7 26 6 23 4 17 7 28 5 20 8 29 2 11
Descriptive Statistics Data Analysis Plan Scenario: Please write a few lines describing your scenario and the...
Descriptive Statistics Data Analysis Plan Scenario: Please write a few lines describing your scenario and the four variables (in addition to income) you have selected. Use Table 1 to report the variables selected for this assignment. Note: The information for the required variable, “Income,” has already been completed and can be used as a guide for completing information on the remaining variables. Table 1. Variables Selected for the Analysis Variable Name in the Data Set Description (See the data dictionary...
Perform a between-groups ANOVA on the provided data set. What are your hypotheses? What do you...
Perform a between-groups ANOVA on the provided data set. What are your hypotheses? What do you conclude from your analysis? Be sure to show all work. Major GPA Business 3.0 Business 3.3 Business 3.1 Business 3.2 Psychology 3.9 Psychology 4.0 Psychology 3.3 Psychology 3.7 History 3.8 History 3.6 History 3.7 History 3.5
- We assume that the company you selected is considering a new project. The project has...
- We assume that the company you selected is considering a new project. The project has 8 years’ life. This project requires initial investment of $195 million to purchase land, construct building, and purchase equipment, and $15 million for shipping & installation fee. The fixed assets (Total of 195+15= $210 M) fall in the 7-year MACRS class. The salvage value of fixed assets is $38 million. The number of units of the new product expected to be sold in the...
Perform a Cost and Benefit Analysis for a company of your choice. Where would you recommend...
Perform a Cost and Benefit Analysis for a company of your choice. Where would you recommend that the company should focus on cost reduction? Justify your recommendations with economics.
We assume that the company you selected is considering a new project. The project has 8...
We assume that the company you selected is considering a new project. The project has 8 years’ life. This project requires initial investment of $380 million to purchase equipment, and $30 million for shipping & installation fee. The fixed assets fall in the 7-year MACRS class. The salvage value of the fixed assets is 10.5% of the purchase price (including the shipping & installation fee). The number of units of the new product expected to be sold in the first...
We assume that the company you selected is considering a new project. The project has 8...
We assume that the company you selected is considering a new project. The project has 8 years’ life. This project requires initial investment of $380 million to purchase equipment, and $30 million for shipping & installation fee. The fixed assets fall in the 7-year MACRS class. The salvage value of the fixed assets is 10.5% of the purchase price (including the shipping & installation fee). The number of units of the new product expected to be sold in the first...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT