PLEASE PROVIDE STEP BY STEP IN EXCEL Your group is a decision making team in your firm and is considering an estimated $10 million production expansion project Estimates of key input factors are as following (all uniformly distributed) Market size 100,000 to 350,000 tons Selling price $375 to $575 Market growth rate 0 to 6 per year Market share 3 to 17 Total investment required $7 million to $10 5 million Useful life of the new facility 5 to 15 years Residual value of the facility $3 5 million to $5 million Operating costs $320 to $550 per ton Fixed costs $250,000 to $375,000 per year Analyze the risks associated with this project The results of the risk analysis include estimated net profit loss, possible minimum profit or maximum loss, possible maximum profit or minimum loss, and probability of making loss from this investment

The Answer is in the image, click to view ...

Question: PLEASE PROVIDE STEP BY STEP IN EXCEL Your group is a decision-making team in your firm and is considering an estimated $10-million production expansion project.

PLEASE PROVIDE STEP BY STEP IN EXCEL

Your group is a decision-making team in your firm and is considering an estimated $10-million production expansion project. Estimates of key input factors are as following (all uniformly distributed):

Market size: 100,000 to 350,000 tons
Selling price: $375 to $575
Market growth rate: 0 to 6% per year
Market share: 3% to 17%
Total investment required: $7 million to $10.5 million
Useful life of the new facility: 5 to 15 years
Residual value of the facility: $3.5 million to $5 million
Operating costs: $320 to $550 per ton
Fixed costs: $250,000 to $375,000 per year

Analyze the risks associated with this project. The results of the risk analysis include: estimated net profit/loss, possible minimum profit or maximum loss, possible maximum profit or minimum loss, and probability of making loss from this investment.

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 Accounting Questions!

Application of Risk Analysis Problem: Your group is a decision-making team in your firm and is considering an estimated $10 million production expansion project. Estimates of key input factors are as...

Your group is a decision-making team in your firm and is considering an estimated $10-million production expansion project. Estimates of key input factors are as following (all uniformly...

Has anyone been able to solve this? Application of Risk Analysis Problem: Your group is a decision - making team in your firm and is considering an estimated $ 1 0 million expansion project....

Your group is a decision - making team in your firm and is considering an estimated $ 1 0 million expansion project. Estimates of key input factors are as following ( all uniformly distributed ) :...

Your group is a decision - making team in your firm and is considering an estimated $ 1 0 million expansion project. Estimates of key input factors are as following ( all uniformly distributed ) :

Q. Was the outcome for these companies inevitable? BALANCED SCORECARD INSTITUTE Straten Management Group Veolia Water North America Case Study O VEOLIA The Situation Based in Chicago, Veolia Water...

I need help on the data tables and the scenario manager sections. Thanks Mini Case 2 Situation Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting...

Please help with the assigned discussion. The hyperlinks are attached. MY COMPANY IS WALMART Assigned Discussions: 1. Develop and explain a recommended corporate strategy for the selected company....

I have attached the case study and the rubric for this. can I get help here to organzie an answer? CATERPILLAR, INC: THE IMPACT OF DECISION BIASES AND RISK ON CAPITAL BUDGETING Timothy D. West...

A 30 year 9% coupon bond currently sells for $100. A 30 year 3% coupon bond with exactly the same coupon dates and maturity currently sells for $50. both bonds have $100 as the principal at maturity....

How do the operations of repression inform the work?

Diamond Company ( Diamond ) owes BC $ 8 2 , 0 0 0 for a computer system installation that was purchased in March of 2 0 X 3 . Diamond has run into financial difficulties due to dramatic decreases in...

WHAT IS the cash flow statement BBINFIT ,AND HOW WE CAN ANALAYSES

11. Identify and state the significance of each of the following trade-related entities: (a) the WTO; (b) the EU; (c) the eurozone; and (d) NAFTA. LO40.6

6. Why is a quota more detrimental to an economy than a tariff that results in the same level of imports as the quota? What is the net outcome of either tariffs or quotas for the world economy? LO40.4

6. Suppose that the opportunity-cost ratio for watches and cheese is 1C 1W in Switzerland but 1C 4W in Japan. At which of the following international exchange ratios (terms of trade) will...