Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Which accounts do I use to get the following Ratio Analysis? Assets, Common Equity, Free Cash Flow to Investors, and Sustainable Growth? The Red Highlighted

Which accounts do I use to get the following Ratio Analysis? Assets, Common Equity, Free Cash Flow to Investors, and Sustainable Growth? image text in transcribedimage text in transcribedimage text in transcribed The Red Highlighted Boxes are the answers, I just can't figure out how to get them using these accounts. image text in transcribed

Apple Inc. Link to Form 10-Ks Company Name and Ticker Common Shares Outstanding #REF! AAPL 4,443 (in 000s at most recent fiscal year end) Actual FY2015 Actual FY2016 Actual FY2017 Actual FY2018 Actual FY2019 Fiscal Year End (YYYY-MM-DD) Income Statement Sales (Net) Cost of Goods Sold Gross Profit R&D Expense SG&A Expense EBITDA Depreciation & Amortization EBIT Net Interest Expense Non-Operating Income (Loss) EBT Income Taxes Other Income (Loss) Net Income Before Ext. Items Ext. Items & Disc. Ops. Minority Interest in Earnings Preferred Dividends Net Income (available to common) 233,715 (140,089) 93,626 (8,067) (4,372) 81,187 (9,957) 71.230 (733) 2,018 72,515 (19,121) 0 53,394 0 0 0 53,394 215,639 (131,376) 84,263 (10,045) (3,689) 70,529 (10,505) 60,024 (1,456) 2,804 61,372 (15,685) 0 45,687 0 0 0 45,687 229,234 (141,048) 88,186 (11,581) (5,104) 71,501 (10,157) 61,344 (2,323) 5,068 64,089 (15,738) 0 48,351 0 0 0 48,351 265,595 (163.756) 101,839 (14,236) (5,802) 81,801 (10,903) 70,898 (3,240) 5,225 72,883 (13,372) 20 59,531 0 0 0 59,531 260,174 (161,782) 98,392 (16,217) (5,698) 76,477 (12,547) 63,930 (3,576) 5,414 65,768 (10,481) (31) 55,256 0 0 0 55,256 Balance Sheet Operating Cash and Market. Sec. Receivables Inventories Other Current Assets Total Current Assets PP&E (Net) Investments Intangibles Other Assets Total Assets 41,995 30,343 2,349 (5,790) 68,897 22,471 184,546 9,009 5,422 290,345 67,155 29,299 2,132 (38,388) 60,198 27,010 217,101 8,620 8,757 321,686 74,181 35,673 4,855 (39,956) 74,753 33,783 248,606 0 18,177 375,319 66,301 48,995 3,956 (28,301) 90.951 41,304 211,187 0 22,283 365,725 100,557 45,804 4,106 (39,361) 111,106 37,378 157,054 0 32,978 338,516 Current Debt Accounts Payable Income Taxes Payable Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Taxes Total Liabilities Minority Interest Preferred Stock Paid in Common Capital (Net) Retained Earninas 2,513 35,490 0 42.607 80,610 53,329 12,989 24,062 170,990 0 0 27,071 92.284 | 3,500 37,294 0 38,212 79,006 75,427 12,985 26,019 193,437 0 0 31,885 96.364 6,496 44,242 0 50,076 100,814 97,207 11,747 31,504 241,272 0 0 35,717 98.330 8,784 55,888 0 51,257 115,929 93,735 48,914 0 258,578 0 0 36,747 70.400 10,260 46,236 0 49,222 105,718 91,807 50,503 0 248,028 0 0 44,590 45.898 Fiscal Year End (YYYY-MM-DD) Retained Earnings Total Common Equity Total Liabilities and Equity Actual FY2015 92.284 119,355 290,345 Actual FY2016 96,364 128,249 321,686 Actual FY2017 98,330 134,047 375,319 Actual FY2018 70,400 107,147 365,725 Actual FY2019 45,898 90.488 338,516 Statement of Retained Earnings 0 0 0 0 Beg. Retained Earnings +Net Income -Common Dividends +/-Clean Surplus Plug (Ignore) =End. Retained Earnings (11,561) 92,284 45,687 (12,150)| (29,457) 96,364 96,364 48,351 (12,769) (33,616) 98,330 98,330 59,531 (13,712) (73,749) 70,400 70,400 55,256 (14,119) (65,639) 45.898 Values for Dupont Analysis and Valuation Net Operating Income Net Financial Expense Net Income Effective Tax Rate Net Operating Assets Net Financial Obligations Total Common Equity 53,934 (540) 53,394 0.2637 175,197 55,842 119,355 46,771 (1,084) 45,687 0.2556 207,176 78,927 128,249 50,104 (1,753) 48,351 0.2456 237,750 103,703 134,047 62,177 (2,646) 59,531 0.1835 209,666 102,519 107,147 58,262 (3,006) 55,256 0.1594 192,555 102,067 90,488 Raw Data Inputs Company Name and Ticker Common Shares Outstanding Fiscal Year End Form FYxxxx Sales (Net) Cost of Goods Sold R&D Expense SG&A Expense Depreciation & Amortization Interest Expense Non-Operating Income (Loss) Income Taxes Minority Interest in Earnings Extraordinary Items & Acc Change Earnings From Discotinued Op. Preferred Dividends Operating Cash and Market. Sec. Receivables Inventories Other Current Assets PP&E (Net) cut-and-paste raw data block from DataMaker file here Company Ticker Below Apple Inc. AAPL 4,443 FY2015 FY2016 FY2017 233,715 215,639 229,234 (140,089) (131,376) (141,048) (8,067) (10,045 (11,581) (22,396) (24,239) (26,842) (9,957) (10,505) (10,157) (733) (1,456) (2,323) 2,018 2,804 5,068 (19,121) (15,685 (15,738) 0 0 0 0 0 0 0 0 0 0 0 0 41,995 67,155 74,181 30,343 29,299 35,673 2,349 2,132 4,855 (5,790) (38,388) (39,956) 22,471 27,010 33,783 FY2018 265,595 (163,756) (14,236) (30,941) (10,903) (3,240) 5,225 (13,372) 0 20 0 0 66,301 48,995 3,956 (28,301) 41,304 FY2019 260,174 (161,782) (16,217) (34,462) (12,547) (3,576) 5,414 (10,481) 0 (31) 0 0 100,557 45,804 4,106 (39,361) 37,378 Investments Intangibles Other Assets Current Debt Accounts Payable Income Taxes Payable Other Current Liabilities Long-Term Debt Other Liabilities Deferred Taxes Minority Interest Preferred Stock Paid in Common Capital (Net) Retained Earnings Common Dividends 184,546 9,009 5,422 2,513 35,490 0 42,607 53,329 12,989 24,062 0 0 27,071 92,284 11,561 217,101 8,620 8,757 3,500 37,294 0 38,212 75,427 12,985 26,019 0 0 31,885 96,364 12,150 248,606 0 18,177 6,496 44,242 0 50,076 97,207 11,747 31,504 0 0 35,717 98,330 12,769 211,187 0 22,283 8,784 55,888 0 51,257 93,735 48,914 0 0 0 36,747 70,400 13,712 157,054 0 32,978 10,260 46,236 0 49,222 91,807 50,503 0 0 0 44,590 45,898 14,119 -7.7% 6.3% 15.9% -2.0% Annual Growth Rates Sales Assets Common Equity Earnings Free Cash Flow to Investors Sustainable Growth Rate 10.8 7.5 16.7 4.5 -2.6 -20.1 -7.4 -15.5 - 14.4% 5.8% 23.1% -7.2% -41 41.6 27.1 38 Apple Inc. Link to Form 10-Ks Company Name and Ticker Common Shares Outstanding #REF! AAPL 4,443 (in 000s at most recent fiscal year end) Actual FY2015 Actual FY2016 Actual FY2017 Actual FY2018 Actual FY2019 Fiscal Year End (YYYY-MM-DD) Income Statement Sales (Net) Cost of Goods Sold Gross Profit R&D Expense SG&A Expense EBITDA Depreciation & Amortization EBIT Net Interest Expense Non-Operating Income (Loss) EBT Income Taxes Other Income (Loss) Net Income Before Ext. Items Ext. Items & Disc. Ops. Minority Interest in Earnings Preferred Dividends Net Income (available to common) 233,715 (140,089) 93,626 (8,067) (4,372) 81,187 (9,957) 71.230 (733) 2,018 72,515 (19,121) 0 53,394 0 0 0 53,394 215,639 (131,376) 84,263 (10,045) (3,689) 70,529 (10,505) 60,024 (1,456) 2,804 61,372 (15,685) 0 45,687 0 0 0 45,687 229,234 (141,048) 88,186 (11,581) (5,104) 71,501 (10,157) 61,344 (2,323) 5,068 64,089 (15,738) 0 48,351 0 0 0 48,351 265,595 (163.756) 101,839 (14,236) (5,802) 81,801 (10,903) 70,898 (3,240) 5,225 72,883 (13,372) 20 59,531 0 0 0 59,531 260,174 (161,782) 98,392 (16,217) (5,698) 76,477 (12,547) 63,930 (3,576) 5,414 65,768 (10,481) (31) 55,256 0 0 0 55,256 Balance Sheet Operating Cash and Market. Sec. Receivables Inventories Other Current Assets Total Current Assets PP&E (Net) Investments Intangibles Other Assets Total Assets 41,995 30,343 2,349 (5,790) 68,897 22,471 184,546 9,009 5,422 290,345 67,155 29,299 2,132 (38,388) 60,198 27,010 217,101 8,620 8,757 321,686 74,181 35,673 4,855 (39,956) 74,753 33,783 248,606 0 18,177 375,319 66,301 48,995 3,956 (28,301) 90.951 41,304 211,187 0 22,283 365,725 100,557 45,804 4,106 (39,361) 111,106 37,378 157,054 0 32,978 338,516 Current Debt Accounts Payable Income Taxes Payable Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Taxes Total Liabilities Minority Interest Preferred Stock Paid in Common Capital (Net) Retained Earninas 2,513 35,490 0 42.607 80,610 53,329 12,989 24,062 170,990 0 0 27,071 92.284 | 3,500 37,294 0 38,212 79,006 75,427 12,985 26,019 193,437 0 0 31,885 96.364 6,496 44,242 0 50,076 100,814 97,207 11,747 31,504 241,272 0 0 35,717 98.330 8,784 55,888 0 51,257 115,929 93,735 48,914 0 258,578 0 0 36,747 70.400 10,260 46,236 0 49,222 105,718 91,807 50,503 0 248,028 0 0 44,590 45.898 Fiscal Year End (YYYY-MM-DD) Retained Earnings Total Common Equity Total Liabilities and Equity Actual FY2015 92.284 119,355 290,345 Actual FY2016 96,364 128,249 321,686 Actual FY2017 98,330 134,047 375,319 Actual FY2018 70,400 107,147 365,725 Actual FY2019 45,898 90.488 338,516 Statement of Retained Earnings 0 0 0 0 Beg. Retained Earnings +Net Income -Common Dividends +/-Clean Surplus Plug (Ignore) =End. Retained Earnings (11,561) 92,284 45,687 (12,150)| (29,457) 96,364 96,364 48,351 (12,769) (33,616) 98,330 98,330 59,531 (13,712) (73,749) 70,400 70,400 55,256 (14,119) (65,639) 45.898 Values for Dupont Analysis and Valuation Net Operating Income Net Financial Expense Net Income Effective Tax Rate Net Operating Assets Net Financial Obligations Total Common Equity 53,934 (540) 53,394 0.2637 175,197 55,842 119,355 46,771 (1,084) 45,687 0.2556 207,176 78,927 128,249 50,104 (1,753) 48,351 0.2456 237,750 103,703 134,047 62,177 (2,646) 59,531 0.1835 209,666 102,519 107,147 58,262 (3,006) 55,256 0.1594 192,555 102,067 90,488 Raw Data Inputs Company Name and Ticker Common Shares Outstanding Fiscal Year End Form FYxxxx Sales (Net) Cost of Goods Sold R&D Expense SG&A Expense Depreciation & Amortization Interest Expense Non-Operating Income (Loss) Income Taxes Minority Interest in Earnings Extraordinary Items & Acc Change Earnings From Discotinued Op. Preferred Dividends Operating Cash and Market. Sec. Receivables Inventories Other Current Assets PP&E (Net) cut-and-paste raw data block from DataMaker file here Company Ticker Below Apple Inc. AAPL 4,443 FY2015 FY2016 FY2017 233,715 215,639 229,234 (140,089) (131,376) (141,048) (8,067) (10,045 (11,581) (22,396) (24,239) (26,842) (9,957) (10,505) (10,157) (733) (1,456) (2,323) 2,018 2,804 5,068 (19,121) (15,685 (15,738) 0 0 0 0 0 0 0 0 0 0 0 0 41,995 67,155 74,181 30,343 29,299 35,673 2,349 2,132 4,855 (5,790) (38,388) (39,956) 22,471 27,010 33,783 FY2018 265,595 (163,756) (14,236) (30,941) (10,903) (3,240) 5,225 (13,372) 0 20 0 0 66,301 48,995 3,956 (28,301) 41,304 FY2019 260,174 (161,782) (16,217) (34,462) (12,547) (3,576) 5,414 (10,481) 0 (31) 0 0 100,557 45,804 4,106 (39,361) 37,378 Investments Intangibles Other Assets Current Debt Accounts Payable Income Taxes Payable Other Current Liabilities Long-Term Debt Other Liabilities Deferred Taxes Minority Interest Preferred Stock Paid in Common Capital (Net) Retained Earnings Common Dividends 184,546 9,009 5,422 2,513 35,490 0 42,607 53,329 12,989 24,062 0 0 27,071 92,284 11,561 217,101 8,620 8,757 3,500 37,294 0 38,212 75,427 12,985 26,019 0 0 31,885 96,364 12,150 248,606 0 18,177 6,496 44,242 0 50,076 97,207 11,747 31,504 0 0 35,717 98,330 12,769 211,187 0 22,283 8,784 55,888 0 51,257 93,735 48,914 0 0 0 36,747 70,400 13,712 157,054 0 32,978 10,260 46,236 0 49,222 91,807 50,503 0 0 0 44,590 45,898 14,119 -7.7% 6.3% 15.9% -2.0% Annual Growth Rates Sales Assets Common Equity Earnings Free Cash Flow to Investors Sustainable Growth Rate 10.8 7.5 16.7 4.5 -2.6 -20.1 -7.4 -15.5 - 14.4% 5.8% 23.1% -7.2% -41 41.6 27.1 38

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

Essentials Of Internal Auditing CIA Part 1 2021

Authors: Muhammad Zain

1st Edition

B09B36MRH2, 979-8542949130

More Books

Students also viewed these Accounting questions

Question

How are losses on the total long-term contracts accounted for?

Answered: 1 week ago

Question

5. Identify three characteristics of the dialectical approach.

Answered: 1 week ago

Question

6. Explain the strengths of a dialectical approach.

Answered: 1 week ago

Question

4. Explain the strengths and weaknesses of each approach.

Answered: 1 week ago