Boyd Enterprises is considering developing a new baseball souvenir for use in the new baseball stadium. It is very big, very bright, and very noisy!  Boyd will immediately spend $50,000 on a design and test marketing study that will take a year to complete. If the fan focus groups hate it (30% probability) Boyd will abandon the project and receive nothing. If they love it (70% probability) then in Year 1 Boyd will invest $30,000 in new manufacturing equipment. Sales will begin in Year 2. If actual fans in the stadium love it (80% probability), Boyd will receive cash flows of $40,000 per year for 5 years starting in Year 2. If fans don't like them (20% probability) Boyd will only receive cash flows of $2,000 per year for 5 years. What is the expected NPV of the project? Boyd's WACC is 10%.  Hint: Draw a decision tree. $9,068.22 $9,975.04 $10,972.55 $12,069.80 $13,276.78

Kindly help me solve this problem using Excel. Have to calculate the payback period for the project, calculate the NPV for the project and calculate the IRR for the project.

Your latest project involves the development of a death ray.  Initial estimates predict that the project has a 50% chance of failure, with a potential loss of $1,000,000.  However, you could hire an expert for $450,000.  This is likely to reduce the chance of failure to 20% and the potential loss to $300,000.   Questions: a) What is the dollar value of the net benefit of hiring the expert?  Should you hire the expert? (Show all calculations for credit) b) As the skeptical accountant, do you have any concerns with this analysis?  Be specific in order to receive credit

A careful buyer is deciding whether to buy artificial Christmas trees or continue cutting down trees. The artificial tree costs him $34 and he can use it for 8 years after which it is thrown away as garbage. The other alternative is to continue cutting trees at a cost of $8 today, $9 next year, $10 the next year and so on during those same 8 years. If he buys the artificial tree, what is the return on investment?

A farmer in Vancouver faces a dilemma. The weather forecast is for hot weather, and there is a 50% chance that the temperature this weekend will be too hot and destroy his entire flower garden, which is worth some $60,000. He can take two possible actions to try to alleviate his loss if the temperature rises (the objective is to maximize his expected flower value). First, he could use mulch which helps keep soil temperatures low. This would cost $3,000, but he could still expect to incur damage of approximately $27,000 to $32,000. Second, he can use shade cloth which offers partial and temporary protection from the sun. This method is more expensive ($6,000), and also more effective. With the shade cloth, he could expect to incur as much as $16,000 to $22,000 of the loss. Compare the farmers expected values for the three alternatives he has, considering the various possible loss scenarios for the mulch and the shade cloth. Which alternative would you suggest the farmer take? Why?…

Use the following information for the next four questions: The Anti-Zombie Corporation is considering expanding one of its production facilities to research a new type of virus, which will hopefully not cause a future zombie outbreak. The project would require a $24,000,000 capital investment and will be depreciated (straight-line to zero) over its 3 year life. They know that they will be able to salvage $6,000,000 for the equipment at that time. Incremental sales are expected to be $16,000,000 annually for the 3 year period with costs (excluding depreciation) of 40% of sales. The company would also have to commit initial working capital to the project of $2,000,000. The company has a 30% tax rate, and requires a 15% rate of return for projects of this risk level.

Wilma is considering opening a widget factory. The unlevered cost of equity for making widgets is 0.1. This factory would cost $10 million to set up, and would produce EBIT of $3 million per year for the foreseeable future. She is thinking of applying for a $3 million subsidized perpetual loan to finance this project. Complying with the auditing requirements of this loan would have a present value of $2 million. This loan would have a rate of 0.04, while the rate she could get from the bank is 0.07. Her tax rate is 0.41. What is the NPV of this project, using the APV method?

A chemical company is planning to release a new brand of insecticide that will kill many insect pests but not harm useful pollinators. Buying new equipment to manufacture the product will cost $15 million. The equipment is expected to have a lifetime of nine years and will be depreciated by the straight-line method over its lifetime. The firm expects that they should be able to sell 1,400,000 gallons per year at a price of $65 per gallon. It will take $36 per gallon to manufacture and support the product. If the company's marginal tax rate is 40%, what are the incremental earnings after tax in year 3 of this project?     $23.36 million $9.58 million $12.72 million $15.30 million $14.30 million $24.36 million

You own a coal mining company and are considering opening a new mine. The mine will cost $117.1 million to open. If this money is spent immediately, the mine will generate $21.5 million for the next 10 years. After that, the coal will run out and the site must be cleaned and maintained at environmental standards. The cleaning and maintenance are expected to cost $1.9 million per year in perpetuity. What does the IRR rule say about whether you should accept this opportunity? If the cost of capital is 8.1%, what does the NPV rule say? Use the graph below to determine the IRR(s) in the problem. NPV ($ millions) 31- 21- NPV of the Investment in the Coal Mine 5 10 15 20 Discount Rate (%) What does the IRR rule say about whether you should accept this opportunity? (Select the best choice below.) A. Accept the opportunity because the IRR is greater than the cost of capital. O B. The IRR is r= 11.83%, so accept the opportunity. O C. Reject the opportunity because the IRR is lower than the 8.1%…