Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the formulas to fill in the green with the information listed on the income statement and the balance sheet. Thank you! Balance Sheet
I need the formulas to fill in the green with the information listed on the income statement and the balance sheet. Thank you!
Balance Sheet All figures in millions of U.S. Dollar except per share items. FY2015 FY2016 FY2017 Assets Cash & Short-Term Investments Short-Term Receivables Inventories Other Current Assets Total Current Assets Property and equipment, at cost Accumulated depreciation and amortization Net Property, Plant & Equipment Intangible Assets Deferred Tax Assets Other Assets Total Assets 2,216 1,890 11,809 1,078 16,993 39,266 17,075 22,191 2,665 48 652 42,549 2,538 2,029 12,549 608 17,724 40,426 18,512 21,914 2,093 91 1,144 42,966 3,595 1,952 12,748 638 18,933 41,414 19,339 22,075 2,275 119 1,127 44,529 Liabilities & Shareholders' Equity ST Debt & Curr. Portion LT Debt Accounts Payable Income Tax Payable Other Current Liabilities Total Current Liabilities Long-Term Debt Deferred Tax Liabilities Other Liabilities Total Liabilities Common Equity Total Shareholders' Equity Total Equity Total Liabilities & Shareholders' Equity 427 6,565 36 5,498 12,526 20,888 854 1,965 36,233 6,316 6,316 6,316 42,549 1,252 7,000 25 5,856 14,133 22,349 296 1,855 38,633 4,333 4,333 4,333 42,966 2,761 7,244 54 6,135 16,194 24,267 440 2,174 43,075 1,454 1,454 1,454 44,529 Income Statement All figures in millions of U.S. Dollar except per share items. Net sales Cost of goods sold Gross profit Selling, general and administrative (SG&A) Depreciation and amortization Operating income (EBIT) Interest and investment income Interest expense Pre-Tax Income Income taxes Net earnings / loss FY2015 FY2016 FY2017 88,519 94,595 100,904 -58,254 -62,282 -66,548 30,265 32,313 34,356 -16,801 -17,132 -17,864 -1,690 -1,754 -1,811 11,774 13,427 14,681 166 36 74 -919 -972 -1,057 11,021 12,491 13,698 -4,012 -4,534 -5,068 7,009 7,957 8,630 1. Calculate the following measures for fiscal years 2015, 2016, and 2017: (1) profit margin, (2) ROA, (3) ROE, (4) debt- to-equity ratio, (5) accounts receivable days, (6) days inventory outstanding, (7) accounts payable days. FY2015 FY2016 FY2017 Profit margin ROA ROE Debt-to-equity ratio Accounts receivable days Days inventory outstanding Accounts payable daysStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started