Question

In: Finance

1. Perform sensitivity analysis on the following project by first finding the NPV for the base...

1. Perform sensitivity analysis on the following project by first finding the NPV for the base case, then for a 10% decline in quantity sold and a 10% increase in quantity sold.

      Investment = $270,000 Straight line depreciation

                                     over 3 years

      quantity sold per year = 20,000

      Price per unit = $20

      Operating Cost = $10 per unit (all variable)

      Tax rate 25%   cost of capital 10%

      Project will have a 3-year life

Show Work

Solutions

Expert Solution


Related Solutions

Why perform sensitivity analysis? Of what use is sensitivity analysis where good probability estimates are difficult...
Why perform sensitivity analysis? Of what use is sensitivity analysis where good probability estimates are difficult to obtain?
Calculations of the NPV, IRR and the payback for the project and an analysis of the...
Calculations of the NPV, IRR and the payback for the project and an analysis of the results. I need the excel formula calculation and analysis of the questions You have identified a potential opportunity for WBC, which involves undertaking a project that will have a ten-year life. The project requires an initial purchase of equipment and furniture totalling $4,500,000, plus ancillary programming capability and machinery costing $1,500,000. The equipment and furniture will depreciate and have a salvage value of $500,000...
Question 1. Cashion International (Sensitivity Analysis) Cashion International are considering a project that is susceptible to...
Question 1. Cashion International (Sensitivity Analysis) Cashion International are considering a project that is susceptible to risk. An initial investment of £90,000 will be followed by three years each with the following most likely cash flows The initial investment consists of £70,000 in machines, which have a zero scrap value at the end of the three year life of the project and £20,000 in additional working capital which is recoverable at the end. The discount rate is 10%. Sales (100,000...
Sensitivity Analysis Consider the project where the initial cost is $200,000, and the project has a...
Sensitivity Analysis Consider the project where the initial cost is $200,000, and the project has a 5-year life. There is no salvage. Depreciation is straight-line (Depreciation = 200,000/5 = 40,000) Unit Sales = 6000, Price per unit = $80 (Sales = 6,000 x 80) Variable cost per unit = $60 (Variable Costs = 6,000 x 60) The required return is 12%, and the tax rate is 21%  What are the cash flow each year, NPV and IRR in each...
Perform a sensitivity analysis for the effects of key variables (e.g., sales growth rate, cost of...
Perform a sensitivity analysis for the effects of key variables (e.g., sales growth rate, cost of capital, unit costs, sales price) on the estimated NPV or IRR in order to demonstrate the sensitivity of the model. The Scenario analysis of several variables simultaneously is encouraged (but not required).
Explain the meaning of the term ‘sensitivity analysis’ in the context of project appraisal, and discuss...
Explain the meaning of the term ‘sensitivity analysis’ in the context of project appraisal, and discuss how it is carried out for both standard project variables and also the discount rate. kindly note that i need a full answer and correct with full details
You are performing a sensitivity analysis on an investment project and looking at the EXPECTED case...
You are performing a sensitivity analysis on an investment project and looking at the EXPECTED case of outcome. At t = 0, you invest $5 million in a 10-year project and expect to receive a revenue (sales) of $10 million each year. Variable cost is 75% of revenue (sales) and the cost of capital is 8% p.a. Using the straight-line depreciation method, determine the depreciation per year. A. $ 500,000 B. $ 750,000 C. $ 1,000,000 D. $ 1,500,000 E....
1) Describe "Sensitivity Analysis" within the Linear Programming context. Why is sensitivity analysis important? 2) Discuss...
1) Describe "Sensitivity Analysis" within the Linear Programming context. Why is sensitivity analysis important? 2) Discuss the impact of the changes in the following to your optimal solution: objective function coefficient resources or right-hand-side values. I need at least 200 words
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 36,000​, with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at ​$45.00 and will grow at 2.00% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of ​$2,400,000. It will be...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales...
NPV.  Miglietti Restaurants is looking at a project with the following forecasted​ sales: ​ first-year sales quantity of 33,000​, with an annual growth rate of 4.00​% over the next ten years. The sales price per unit will start at ​$43.00 and will grow at 2.00% per year. The production costs are expected to be 55​% of the current​ year's sales price. The manufacturing equipment to aid this project will have a total cost​ (including installation) of $2,300,000. It will be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT