Question
Please include how to solve the answer by excel Problem 3: Risk Preferences and Insurance Steve, Clark, and Drew are sunflower farmers in the village
Please include how to solve the answer by excel
Problem 3: Risk Preferences and Insurance Steve, Clark, and Drew are sunflower farmers in the village of Gold. They each have zero wealth, so their consumption is equal to the income they earn from their economic activity. Each of them must choose one (and only one) of the following three activities: Activity 1: Full time farming. Sunflower farming is risky because of a combination of weather and pests. Under full time farming, the farmer works 7 days per week on their farm. There is a 50% probability of having a GOOD harvest and a 50% chance of having a BAD harvest. If the harvest is GOOD, the farmer earns an income of $200. If the harvest is BAD, the farmer earns an income of only $40. Activity 2: Full time construction work. This activity has no risk. An individual who decides to work full time in construction earns $80 with certainty. Activity 3: Part-time farming. In this third activity, the farmer works during the week as a sunflower farmer and works in construction during the weekend. Since she is not able to work full time on the farm, the probability of having a GOOD harvest and earning $200 drops to 25%, and the probability of having a BAD harvest and earning only $40 increases to 75%. The individual also earns $30 with certainty as a construction worker (the person earns this $30 from construction in addition to her farm income under both a GOOD and BAD harvest).
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678b82c0f081_4996678b82bf2eeb.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6678b82c83ba7_5006678b82c690e4.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started