Prepare a financial analysis. This takes a close look at two corporations, Bayer and Monsanto. Bayer is considering a bid for United States seed company Monsanto (Snider, 2016). For purposes of this project, you will act as the Chief Financial Officer of Monsanto Corporation, analyzing financial documents and determining whether Monsanto should indeed go forward with acceptance of the purchase.

You will demonstrate your mastery of the following course outcomes:
Analyze financial reports to determine a firm's performance.
Apply the strategic planning processes necessary to manage the long- and short-term financial activities of the firm.
Perform valuation of financial instruments.
Evaluate the appropriateness of an investment using applicable economic, industry, and competitive analysis.
Background Information
Bayer is a life science firm with a more than 150-year history and core competencies in the areas of healthcare and agriculture. With its innovative products, it contributes to finding solutions major challenges, such as a growing and aging world population requiring improved medical care and an adequate supply of food. Bayer addresses these issues by preventing, alleviating and treating diseases, and helping to provide a reliable supply of high-quality food, feed and plant-based raw materials. Bayer Pharmaceutical is Bayer's largest division in terms of total sales. This division focuses on researching, developing and marketing innovative medicines with a positive cost-benefit ratio primarily in the therapeutic areas of cardiology, oncology, gynecology, hematology and ophthalmology. To safeguard long-term growth, Bayer is currently seeking increase its investment in research and development. Besides expanding early research, Bayer is concentrating on the clinical development of active drug substance candidates in the therapeutic areas of cardiology, oncology, hematology and gynecology. In addition, it is selectively expanding and supplementing its development portfolio through licensing agreements and acquisitions. The Crop Science Division of Bayer, on the other hand, focuses on improvement in agricultural sustainability, crop yields and quality, as well as the leveraging of digitization to help make products safer (Bayer, 2016). Bayer's aim is to help shape the future of the agricultural industry with innovative offerings that increase its productivity, thus generating profitable and sustainable growth for Crop Science and its customers and enabling the production of sufficient food, animal feed and renewable raw materials for a growing world population despite the limited amount of available arable land. This strategy is complementary to its Animal Science Division, which produces animal feed products. Bayer Crop Science Division's current strategy is to enhance its Crop Protection and Environmental Science portfolio, expand its Seeds business, and to lead the way in innovation and develop holistic solution (Bayer AG, 2016). For purposes of this discussion, assume that Bayer aims to build on its expertise in the integration of seed technology with chemical and biological crop protection.
For purposes of this project, assume that Bayer is seeking to acquire Monsanto Corporation. Monsanto, along with its subsidiaries, is a leading global provider of agricultural products for farmers. Through its seeds, biotechnology-trait products, herbicides and precision agriculture tools, Monsanto (Monsanto, 2016) seeks to provide farmers with solutions that help improve productivity, reduce the costs of farming and produce better foods for consumers and better feed for animals. Monsanto has a worldwide distribution, sales and marketing organization for its agricultural-productivity products. In a growing number of locations throughout the world, it produces directly or contracts with third-party growers for corn seed, soybean, vegetable, cotton, canola and other seeds. The global market for its "Seeds and Genomics" segment is increasingly competitive. Both its row crops and its vegetable seed businesses compete with numerous multinational agrichemical and seed marketers globally, and with hundreds of smaller companies regionally.
Bayer's proposal would pair Monsanto, the world's largest seed company, with drug-maker Bayer's growing seed and crop protection portfolio. Upon announcement of the possibility of such a bid, shares of St. Louis-based Monsanto (MON) rose by 8.7% (Kirchfield, et. al., 2016). Across 2015, immediately following announcement of a possible merger between the two firms, Bayer's growing agribusiness division saw sales rise 9% to $11.8 billion, while its healthcare sales rose 19% to $26 billion, as market participants reacted to news of the possible merger. Overall, Bayer's 2015 sales rose 12%, to $52.8 billion (Business Wire, 2014). On the other hand, Monsanto, which makes seeds (corn, cotton, fruits and other vegetables) and crop protection chemicals such as RoundUp, reported sales of $15 billion in its 2015 fiscal year. This was a 5% decline from the previous year (Daily Management Review, 2016). See Table 1, below, for an alternative view of these results.
Bayer is considering a bid for United States seed company Monsanto. Assume that relevant tax rate is 35%. EBIT, depreciation, capital spending, and the change in net working capital will grow at the same rate as sales, which is expected to grow at a rate of 3% across the current year, while capital investment will remain stable. Assume that operational results quoted outside of Tables 4, 5 and 6 (income statement, balance sheet, and statement of cash flows, below), are interim measures to be used for purposes of your calculations.
Based on the proposal's likely effect on shareholder value, determine whether to accept or reject this proposal for $62B, using evidence provided here in Tables 1 through 6, to support your analyses. Evaluate each of the following:
Whether to accept or reject this proposal, using evidence drawn from ratio analysis, and time and trend analysis and other evidence from assigned readings covered in Modules One through Three to support your determinations. Compute and include two ratios per each of the four main areas of ratio analysis, including short-term solvency, asset utilization, long-term solvency, and profitability.
B. Evaluate limitations that may exist in using these varieties of analysis to make this determination.

Immediate Results from the Bayer Announcement in 2015 Monsanto (MON) Share Price Increased 8.7% Sales increased 9% to $11.8 billion Bayer Crop Science Division Bayer Healthcare Division Sales Increased 19% to $26 billion Increased 12%, to $52.8 billion Bayer Pharmaceutical Sales Decreased 5% to $15 billion Monsanto Sales Table 1 Immediate Results from the Bayer Announcement in 2015 ValuPro Net Online Valuation of MONSANTO CORPORATION - 2015 Return on Assets 8.56 Return on Equity 14.93 Sales ($mil) 14,757 Investment Rate (% of Rev) 4.78 Growth Rate (%) Working Capital (% of Rev) 13.5 29.19 Net Oper. Profit Margin (%) 21.3 Short-Term Assets ($mil) 11141 Tax Rate (%) 30.584 Short-Term Liab. ($mil) 4055 Stock Price ($) 86.74 Equity Risk Premium (%) Shares Outstanding (mil) 533.8 Company Beta 1.05 10-Yr Treasury Yield (%) 500% Value Debt Out. ($mil) 2.054 Bond Spread Treasury (%) 1.5 Value Pref. Stock Out. ($mil) 0 Preferred Stock Yield (%) 7.5 Company WACC (%) 8% 2. Table 2 ValuePro Net Online Valuation