EXCEL ONLY AND PLEASE POST STEP BY STEP AND FORMULAS USED

A group of Midwest California farmers who currently cultivate pecans are considering switching to olive farming and need to create a strategic plan. The shift in farming will require an initial investment of $1 million in new farm equipment, as well as an additional annual cost of $(35,000 + CCC) per acre from year 1. Additionally, there will be an initial waiting period of 4 years until the first yield is achieved in olive farming. a. Assuming the farmers can produce an average yield of 500 pounds per acre, and the selling price of each pound is $35, what is the minimum number of acres the farmers need to cultivate to break even in 10 years, assuming a minimum acceptable rate of return (MARR) of (AAA+3)%? b. The olive farmers are uncertain about their annual costs and decide to hire a crop expert who predicts that the annual costs for olive farming are either $55,000, $25,000, or $90,000, with associated probabilities of 0.6, 0.3, and 0.1, respectively. If the selling price of olives remains the same, what is the expected number of acres the farmers need to cultivate to break even in the same time period?