How do you find the expected market value for the following:
- Probability
- units
- average unit price
How do you find the expected market value for the following: - Probability - units -...
The Alliance Corp. expects to sell the following number of units of copper cables at the prices indicated, under three different scenarios in the economy. The probability of each outcome is indicated. Outcome Probability Units Price 0.50 270 29 0.30 460 C 0.20 690 What is the expected value of the total sales projection? Total expected value
Break-even and Profitability analysis You are the proud owner of a sock store. You sell one type of sock, but in thousands of colours. Before you set the price of the sock, you must conduct break-even analysis and profitability analysis. The cost of your operation are: Rent: 5000 Salary: 5000 Advertising: 10,000 Cost of socks wholesale: 1 The price for comparable socks at other stores ranges from $1 to $6, Calculate the breakeven point for each price level: Fixed Cost...
4. Sensitivity and scenario analysis Different techniques for analyzing project risk require different input variables and assumptions. Suppose you are using the scenario analysis technique to evaluate project risk. You would change in the model to evaluate the effect of the input factors on the expected value. Tanya is a risk analyst. She is conducting a sensitivity analysis to evaluate the riskiness of a new project that her company is considering investing in. Her risk analysis report includes the sensitivity...
Question: I need help with the excel spreadsheet. Can
you please do the spreadsheet for me? Thank you so much.
Cooper Pharmaceuticals, a specialty pharmaceutical company, has
made significant investments to develop several product lines of 3D
printed drugs. However, with patents on some of its most popular
brand-name drugs expiring in the near future, the company is
expecting a significant financial hit. As a result, the Finance
Department has determined that only two of the five product lines
under...
Question: I need help with the excel spreadsheet. Can you please do the spreadsheet for me? Thank you so much. Cooper Pharmaceuticals, a specialty pharmaceutical company, has made significant investments to develop several product lines of 3D printed drugs. However, with patents on some of its most popular brand-name drugs expiring in the near future, the company is expecting a significant financial hit. As a result, the Finance Department has determined that only two of the five product lines under...
answer using excel please
123 Inc. is considering purchasing a new machine. The machine will cost $3,500,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $300,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will be able to charge...
Please answer using excel ONLY & add formulas
123 Inc. is considering purchasing a new machine. The machine will cost $3,500,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $300,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will...
1. Gibson Manufacturing Corporation expects to sell the following number of units of steel cables at the prices indicated, under three different scenarios in the economy. The probability of each outcome is indicated. Outcome Probability Units Price A 0.70 280 $31 B 0.20 480 46 C 0.10 730 56 What is the expected value of the total sales projection? Total expected value $ 2. Sales for Ross Pro’s Sports Equipment are expected to be 41,000 units for October....
You are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows: Expected sales: 115,000 units per year Unit price: $220 Variable cost: $132 Fixed cost: $4,890,000 The project will last for 10 years and requires an initial investment of $16.70 million, which will be depreciated straight-line over the project life to a final value of zero. The firm’s tax rate is 30%, and the required rate of return...
Please explain how to obtain the above answer (step by step
explanation). Thank you.
40. Pigeon Ltd holds a well-diversified portfolio of shares with a current market value on 1 May 2014 of $900 000. On this date Pigeon Ltd decides to hedge the portfolio by taking a sell position in ten SPI futures units. The All Ordinaries SPI is 2980 on 1 May 2014. A unit contract in SPI futures is priced based on All Ordinaries SPI and a...