For this assignment, answer the questions posed by modeling the scenarios in a spreadsheet. You will create your own Excel file from scratch, but you are welcome to use the sample spreadsheet in this module as the starting point.Requirements for All PartsComplete each part in separate worksheets (tabs) in a single Excel file.Keep the inputs, calculations, and outputs in separate sections.Do not hard-code numbers into formulas cells (i.e., do not paste the value of an output cell into a function argument of another input cell).Part 1: Monte Carlo SimulationYou are a financial analyst at Delicious Sweets Company. Your supervisor wants to know the most profitable production level for a new product line the company is introducing. She has heard about the Monte Carlo simulation, but she is not sure how to run it. She asks you to construct a model that she can understand. The company will use your model to determine what level of production would be the most profitable for the new Timeless Wonder Chocolate Peanut Butter Wafer.You have been given the following information: Number of wafers made 300000 cost per wafer $ 0.45 price per wafer $ 2.00 disposal cost per wafer $ 0.07 Build a Monte Carlo simulation model using this data in Excel and determine the best level of production the company should choose. Include the following items:Short description of what the model doesDemand levels and associated probabilitiesInputs including probability distribution of demand rangesOutputs random number generatedamount soldtotal revenuetotal variable coststotal disposing costprofit A two-way data table showing 1,000 trials for each demand levelHighlight the cells that contain the best production level and profitPart 2: Stock Price SimulationIn a separate worksheet from Part 1, build a simulation model in Excel to determine whether an investment in Intel stock (symbol: INTC) is worth pursuing. Include the following in your spreadsheet.Today’s date (date you are completing this assignment)Current price of Intel stockData for the monthly returns on Intel for the last 60 months (for example, if the current month is June 2018, the data range would be June 2013 to June 2018).Monthly returnsBeginning prices and end prices for the next 12 monthsData table with 1,000 scenarios for Intel’s stock price in one yearSimulation summary Mean Return Probably lose money Probably make more than 10% Make between 0 and 10% in return Lose between 0 and 10% Lose More than 10% What is the probability that the stock will be at least $70?Explanation of whether or not you would invest in Intel today

Locate the most recent annual report from the General Electric Company. Read the letter to shareholders and evaluate whether the writing is clear and the six principles of clear writing identified by the SEC were followed (be as specific as possible in your responses). Do you think companies who effectively adhere to these six principles are, in general, better corporate citizens than those companies who do not? Why, or why not? Do you think companies who have bad news to communicate that do so following these six principles will be rewarded in the marketplace by a smaller stock price drop? Why, or why not? Reference United States Securities and Exchange Commission. (1998). A plain English handbook. https://www.sec.gov/pdf/handbook.pdf Do the discussion first then do response each posted below. Posted 1 The most recent annual report from the General Electric Company is the GE Annual Report 2020.  This letter to the shareholders indicates the clear plan they began the year with.  Strength in Aviation, Healthcare, Power and Renewable Energy was quickly changed by COVID-19.  The rapid decline in air travel and sudden global supply chain disruption hit the company hard.  A show of gratification was greatly expressed for the employee commitment during the difficult time, not only for employees on the front line, but all of the employees that make this company operate.  They outlined how they were successful in their adaptation to the situation by first embracing reality, second redefining winning, and third executing the plan.  “These steps, combined with the headway we already had been making to improve execution, strengthened our capacity to work through the uncertainties triggered by the pandemic.  And they helped us move faster on our journey to transform GE’s performance and culture” (GE, 2022, pp6).  The letter continues to provide a detailed and clear overview of the year’s report.  Do you think companies who effectively adhere to these six      principles are, in general, better corporate citizens than those companies      who do not? Why, or why not? I do feel that companies who effectively adhere to the six principles are better corporate citizens.  I feel that by using these principles to provide clear and transparent language with their clients or consumers, they are looking out for the best interest of the public and not attempting to hide any details in confusing language.  Do you think companies who have bad news to communicate that      do so following these six principles will be rewarded in the marketplace      by a smaller stock price drop? Why, or why not? “Even good companies face setbacks, such as litigation and recalls.  However, just because a company experiences one negative event doesn’t mean that the company isn’t still fundamentally valuable or that is stock won’t bounce back” ().  I think this statement applies to a company that uses the six principles to communicate bad news more than a company that does not.  Using clear and understandable language reassures the public that the company has their best interest at heart and is not trying to hide even worse news.  Resources: GE Annual Report 2020. General Electric. (2022). Retrieved January 13, 2022, from https://www.ge.com/investor-relations/annual-repor... Posted 2            The most recent letter available for General Electric Company is the 2020 Shareholder Letter from the CEO. I believe this letter does follow the six principles of clear writing. Reading through the letter, there does not appear to be any glaring cases of the use of passive voice. It is written in the active voice, making it easy to follow without having to assume the subject of the sentence. Also, most of the sentences are short, and the sentences that were longer seemed to be out of necessity. They did not include superfluous words and, as the third principle indicates, they used everyday language. Technical terms and products include brief explanations, such as the 12- and 13-megawatt Halicade-X. Had they included only the name of the product, readers that are unfamiliar with Offshore Wind would not know what it was. However, they explain that it is the most powerful offshore wind turbine. At the end of the letter, there are tables presenting comparisons of revenues for 2020 and 2019 for the total company and each sector. They also excluded legal jargon and there were no noticeable multiple negatives (Culp, 2020). Do you think companies who      effectively adhere to these six principles are, in general, better      corporate citizens than those companies who do not? Why, or why not? I do think that companies who effectively use the six principles are generally better corporate citizens. As I mentioned in the first discussion board for this unit, not adhering to these principles makes it easy to hide unflattering details. Even if that is not the intent behind forgoing the six principles, doing so still shows a lack of care and consideration for the reader. If a company does not consider their shareholders when writing documents for them, I question if they are for their shareholders when making other decisions. Do you think companies who      have bad news to communicate that do so following these six principles      will be rewarded in the marketplace by a smaller stock price drop? Why, or      why not? I think the company may see a smaller stock price drop. If the company clearly presents bad news, it also allows them to clearly state any plans they have to address the bad news. Hiding bad news in hard-to-read documents delays the inevitable and leads shareholders to feel lied to. This in turn will lead to a greater stock price drop. References Culp, H.L. (2020). 2020 Annual Report CEO Letter. General Electric Company. Retrieved from https://www.ge.com/sites/default/files/GE_AR20_Ann... Posted 3          The shareholder letter is a fantastic place to start when you're looking for a general overview of a company to invest in or to simply learn more about them. I reviewed the 2020 Berkshire Hathaway Annual Report. The shareholder letter was written by Warren Buffet and I specifically chose this company as Mr. Buffett wrote the preface in A Plain English Handbook (SEC, 1998). His “unoriginal but useful tip was to write with a specific person in mind” (SEC, 1998). Mr. Buffett stated that he imagined he was talking to his sisters when composing the Berkshire Hathaway’s Annual report.            During my analysis of the letter I felt an informal manner in which he wrote. It reminded me of the Christmas letters we receive from loved ones that detail the year in review. He did not use superfluous words and make the data very easy to read. He used short sentences through the 12 page letter, with many paragraphs only having 4 or 5 sentences. The letter was formatted in paragraph style instead of bullet points but it was easy to follow when he changed the topic or information he wanted to convey. He used personal pronoun choice and referred to Charlie Munger (his long-time partner) simply as “Charlie and I” (Berkshire Hathaway, 2021). He closed almost every topic with a one line summary of what he was discussing. For example, “Whatever the obstacles, BHE will be a leader in delivering ever-cleaner energy” (Berkshire Hathaway, 2021).  This was simple way for the reader to know the synopsis of the information. Do you think companies who effectively adhere to these six principles are, in general, better corporate citizens than those companies who do not? Why, or why not? Utilizing these six principles shows the companies are transparent in their reporting and want their readers to understand what they are reporting. The more honest you are, the better corporate citizen you are. If I was choosing to invest in a company I would want to be able to understand their current operational position and that would be very difficult to do so if I could not understand what they are saying by using superfluous words or jargon. Do you think companies who have bad news to communicate that do so following these six principles will be rewarded in the marketplace by a smaller stock price drop? Why, or why not? I think the stock price drop would be a direct correlation to the bad news. However, investors have to be able to take on some type of risk. It is possible for a company to have a lower than average profit margin but still strong compared to its competitors. I think the bigger issue would be if the company repeatedly hid bad news and gave a false sense of achievement only to find out later that the numbers or data they used were masked by unclear language use. This would result in a large stock price drop. Investors and consumers want to know they can trust a company and would appreciate transparency and honesty.https://www.sec.gov/pdf/handbook.pdf