Question: create a sensitivity analysis in excel from the following data with a price drop of 25% and a price rise of 25% : Distribution of

create a sensitivity analysis in excel from the following data with a price drop of 25% and a price rise of 25% : Distribution of price in 6 months Price Probability $0.078 0.05 $0.083 0.25 $0.087 0.35 $0.091 0.20 $0.096 0.15 PART A DECISION 1 POUNDS OF SUGAR EXPECTED PRICE CONTRACT PRICE FINAL PRICE20,000 $0.09 $110 $1,812.00 DECISION 2 POUNDS OF SUGAR EXPECTED PRICE CONTRACT PRICE FINAL PRICE10,000 $0.09 $65 $916.00 10,000 $0.087 0 $870.00 DECISION 3 POUNDS OF SUGAR EXPECTED PRICE CONTRACT PRICE FINAL PRICE20,000 $0.087 $0 $1,740.00

Distribution of price in 6 months Price Probability SO.078 0.05 50.083 0.25 SO.087 0.35 50.091 0.20 50.096 0.15 PART A DECISION 1 POUNDS OF SUGAR EXPECTED PRICE | CONTRACT PRICE | FINAL PRICE 20,000 $0.09 $110 | $1,812.00 DECISION 2 POUNDS OF SUGAR EXPECTED PRICE | CONTRACT PRICE | FINAL PRICE 10,000 $0.09 $916.00 10,000 so.087| so] _s $870.00 DECISION 3 POUNDS OF SUGAR EXPECTED PRICE | CONTRACT PRICE | FINAL PRICE 20,000 50.087 $1,740.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Most Likely Best Case Scenario Worst Case Scenario Hint was given for the above spreadsheets: Most Likely NPV of $554,942, IRR of 11.35% and MIRR of 10.21 with 5.3 year payback...... Best case NPV of...

Use Excel to complete this exam. Use one spreadsheet with tabs for each question. Label the tabs as "Question 1," "Question 2, etc. Submit your completed spreadsheet in the appropriate D2L Dropbox by...

Please use Excel and also show all the formulas so that it is clear F A B D E G H M N 2 3 Create a Sensitivity Analysis of your Income Statement, Cashflow, Resulting NPV, IRR and MIRR assuming the...

NIKE INC (5) Cash Flow Estimation - 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...

FOR QUESTIONS 13-15: LOOK AT THE NOTES TO THE FINANCIAL STATEMENTS (beginning on page 6) 13. (1 Point) In what state did Sprouts Farmers Market, Inc. incorporate? 14. (1 Point) For 2019, what...

Finder Fiv Edit View Go Windo x | + O File /Users/owner/Downloads/assignment.html LILUKULL. LIETILI WA KUWA WILyuda RIWILI ILULIITMIL THAIL 16 2.5 Calculate the social security tax. The social...

Your company is going to purchase new equipment with a price of $500,000, which the manufacturer is willing to finance, and you are trying to work out a payment schedule. Due to cash flow needs...

For this assignment, you are to examine the 2018 financial statements of Sprouts Farmers Market, Inc., and use that report to answer the questions that follow. Each answer should be numbered, and...

ScenarioFX, Inc.is a volume manufacturer of high technology automotive mirrors (including cell link and voice activation).FX is looking to expand their operations to add a second product line capable...

2. What is the pressure in pascals if a force of 3.44 104 MN is pressed against an area of 1.09 km2 ? 3. What is the final temperature of a gas whose initial conditions are 667 mL, 822 torr, and...

Show that the relation of logical equivalence on the set of all compound propositions is an equivalence relation. What are the equivalence classes of F and of T?

When should the service auditor obtain a representation letter from management? At the same time as when assessing the design of controls. Before obtaining an understanding of the service...

Solve B. 6a2-23a +20. a +2 2a2-a-10 2a-5