Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please. Can you help me calculate a set of financial ratios for Monsanto (from the given tables)? I will use these numbers to forecast 2009

Please. Can you help me calculate a set of financial ratios for Monsanto (from the given tables)? I will use these numbers to forecast 2009 income statement and balance sheet.image text in transcribedimage text in transcribedimage text in transcribed

Exhibit 1 MONSANTO COMPANY Income Statement (in millions of dollars) Years Ended August 31 2006 2007 2005 2008 4,094 Net Sales Roundup Corn Seeds and Traits All other 2,049 1,494 2,732 6,275 3,280 2,995 2,262 1,793 3,010 7,065 3,622 3,443 2,568 2,807 2,974 8,349 4,119 4,230 3,542 3,729 11,365 5,188 6,177 Cost of Goods Sold Gross Profits 1,604 Selling, General, and Administrative Research and Development Operating Expenses 1,404 813 2,217 700 1,858 963 2,821 2,312 1,144 3,456 2,304 Net Income from Operations 778 1,139 1,409 2,721 Other Expenses Interest Expense Income Before Taxes Income Taxes Net Income 304 115 359 104 255 (13) 133 1,019 330 (123) 136 1,396 (312) 110 2,923 899 2,024 403 689 993 Data source: Monsanto Company annual reports, 200508. Exhibit 2 MONSANTO COMPANY Balance Sheet (in millions of dollars) As of August 31 2006 2007 2005 2008 Assets Cash Accounts Receivable a) Inventory Other Current Assets Current Assets 525 1,473 1,664 982 4,644 1,460 1,455 1,688 858 5,461 866 1,578 1,719 1,000 5,163 1,613 2,703 2,453 1,476 8,245 Property, Plant, and Equipment, Net Goodwill Other Long-Term Assets(b) Fixed assets 2,378 2,401 1,156 2,418 2,751 1,098 6,267 2,656 4,040 1,124 7,820 3,323 4,663 1,760 9,746 5,935 Total Assets 10,579 11,728 12,983 17,991 126 270 525 649 208 Liabilities and Shareholders' Equity Short-Term Debt Accounts Payable Income Taxes Payable Dividends Payable Deferred Revenues Other Accruals Current Liabilities 28 514 234 55 120 1,328 2,279 150 96 260 1,650 3,075 24 1,090 161 132 867 2,165 4,439 1,300 2,159 Long-Term Debt Other Deferred Revenue/Liabilities 1,458 1,349 1,639 1,285 1,150 1,255 1,792 2,386 Total Liabilities 4,966 5,203 5,480 8,617 6 Common Stock Treasury Stock Additional Contributed Capital Retained Earnings Shareholders' Equity 3 (500) 8,588 (2,478) 5,613 6 (623) 8,879 (1,737) (814) 9,106 (795) 7,503 (1,177) 9,495 1,050 9,374 6,525 Total Liabilities and Equity 10,579 11,728 12,983 17,991 (a) Includes some long-term receivables (Largely deferred taxes Data source: Monsanto annual reports, 2005-08. Exhibit 3 MONSANTO COMPANY Statement of Cash Flows (in millions of dollars) Year Ended August 31 2006 2007 2008 689 993 2,024 519 527 (26) 573 (636) 18 (123) Operating Activities Net Income Adjustments for Items that Did Not Require (Provide) Cash: Depreciation and Amortization Deferred Taxes (Other Long-Term Assets) Changes in Assets and Liabilities that Provided (Required) Cash: Accounts Receivable Inventory Other Current Assets Accounts Payable Income Taxes Payable Dividends Payable Deferred Revenues Other Accruals Other Deferred Revenue/Liabilities Net Cash Provided by Operating Activities (24) 124 (11) 26 (31) (142) 135 (84) (1,125) (734) (476) 441 11 55 41 36 120 28 (64) 1,538 140 322 (30) 1,722 607 515 1,131 2,367 Investing Activities Capital Expenditures Acquisitions Net Cash Required by Investing Activities (370) (539) (909) (509) (1,545) (2,054) (918) (945) (1,863) 242 Financing Activities Net Purchases of Short-Term Investments Net Long-Term Debt Proceeds Dividend Treasury Stock Purchase Other Equity Account Changes Net Cash Required by Financing Activities (98) 181 (133) (123) 479 (489) (299) (191) 475 (262) (246) 642 (481) (363) 691 306 243 Net Increase (Decrease) in Cash 935 (594) 747 Note: Statement developed by case writer to be consistent with accompanying income statement and balance sheet while employing reported depreciation and capital expenditure amounts. Company reported figures may differ since they are reported net of acquisitions. Data source: Monsanto annual reports, 2005-08. Exhibit 1 MONSANTO COMPANY Income Statement (in millions of dollars) Years Ended August 31 2006 2007 2005 2008 4,094 Net Sales Roundup Corn Seeds and Traits All other 2,049 1,494 2,732 6,275 3,280 2,995 2,262 1,793 3,010 7,065 3,622 3,443 2,568 2,807 2,974 8,349 4,119 4,230 3,542 3,729 11,365 5,188 6,177 Cost of Goods Sold Gross Profits 1,604 Selling, General, and Administrative Research and Development Operating Expenses 1,404 813 2,217 700 1,858 963 2,821 2,312 1,144 3,456 2,304 Net Income from Operations 778 1,139 1,409 2,721 Other Expenses Interest Expense Income Before Taxes Income Taxes Net Income 304 115 359 104 255 (13) 133 1,019 330 (123) 136 1,396 (312) 110 2,923 899 2,024 403 689 993 Data source: Monsanto Company annual reports, 200508. Exhibit 2 MONSANTO COMPANY Balance Sheet (in millions of dollars) As of August 31 2006 2007 2005 2008 Assets Cash Accounts Receivable a) Inventory Other Current Assets Current Assets 525 1,473 1,664 982 4,644 1,460 1,455 1,688 858 5,461 866 1,578 1,719 1,000 5,163 1,613 2,703 2,453 1,476 8,245 Property, Plant, and Equipment, Net Goodwill Other Long-Term Assets(b) Fixed assets 2,378 2,401 1,156 2,418 2,751 1,098 6,267 2,656 4,040 1,124 7,820 3,323 4,663 1,760 9,746 5,935 Total Assets 10,579 11,728 12,983 17,991 126 270 525 649 208 Liabilities and Shareholders' Equity Short-Term Debt Accounts Payable Income Taxes Payable Dividends Payable Deferred Revenues Other Accruals Current Liabilities 28 514 234 55 120 1,328 2,279 150 96 260 1,650 3,075 24 1,090 161 132 867 2,165 4,439 1,300 2,159 Long-Term Debt Other Deferred Revenue/Liabilities 1,458 1,349 1,639 1,285 1,150 1,255 1,792 2,386 Total Liabilities 4,966 5,203 5,480 8,617 6 Common Stock Treasury Stock Additional Contributed Capital Retained Earnings Shareholders' Equity 3 (500) 8,588 (2,478) 5,613 6 (623) 8,879 (1,737) (814) 9,106 (795) 7,503 (1,177) 9,495 1,050 9,374 6,525 Total Liabilities and Equity 10,579 11,728 12,983 17,991 (a) Includes some long-term receivables (Largely deferred taxes Data source: Monsanto annual reports, 2005-08. Exhibit 3 MONSANTO COMPANY Statement of Cash Flows (in millions of dollars) Year Ended August 31 2006 2007 2008 689 993 2,024 519 527 (26) 573 (636) 18 (123) Operating Activities Net Income Adjustments for Items that Did Not Require (Provide) Cash: Depreciation and Amortization Deferred Taxes (Other Long-Term Assets) Changes in Assets and Liabilities that Provided (Required) Cash: Accounts Receivable Inventory Other Current Assets Accounts Payable Income Taxes Payable Dividends Payable Deferred Revenues Other Accruals Other Deferred Revenue/Liabilities Net Cash Provided by Operating Activities (24) 124 (11) 26 (31) (142) 135 (84) (1,125) (734) (476) 441 11 55 41 36 120 28 (64) 1,538 140 322 (30) 1,722 607 515 1,131 2,367 Investing Activities Capital Expenditures Acquisitions Net Cash Required by Investing Activities (370) (539) (909) (509) (1,545) (2,054) (918) (945) (1,863) 242 Financing Activities Net Purchases of Short-Term Investments Net Long-Term Debt Proceeds Dividend Treasury Stock Purchase Other Equity Account Changes Net Cash Required by Financing Activities (98) 181 (133) (123) 479 (489) (299) (191) 475 (262) (246) 642 (481) (363) 691 306 243 Net Increase (Decrease) in Cash 935 (594) 747 Note: Statement developed by case writer to be consistent with accompanying income statement and balance sheet while employing reported depreciation and capital expenditure amounts. Company reported figures may differ since they are reported net of acquisitions. Data source: Monsanto annual reports, 2005-08

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Chapters 14-23

Authors: Charles T. Horngren, Walter T. Harrison Jr, M. Suzanne Oliver

8th Edition

0136073018, 978-0136073017

More Books

Students also viewed these Accounting questions

Question

=+Show photos of consumers?

Answered: 1 week ago

Question

=+Exhibit children's artwork?

Answered: 1 week ago

Question

=+What kind of product or service would work in these locations?

Answered: 1 week ago