I did the ratios except for the price earnings ratio and the comprehensive income, so can you help me on those and in the requirements 1A and 1B? this is a project for school
$ 80 BOROUGH OF MANHATTAN COMMUNITY COLLEGE THE CITY UNIVERSITY OF NEW YORK Accounting 330 Accounting Department Professor S . Askew Fall 2018 - Project Using only US . based public corporations traded on U .S . stock exchanges ( excluding banks , financial instituti financial institutions and insurance companies in which the reports are ( excludi in US dollars , management plans to invest $100 million to satisfy one of the following prepared hedge fund strategies Aggressive Growth : Invests in equities expected to experience acceleration in growth of earnings per share . Generally high P / E ratios , low or no dividends Often smaller and micro-cap stocks which are expected to experience rapid growth . Includes sector specialist funds such as technology , banking , or biotechnology . Hedges by shorting equities where earnings disappointment is expected or by shorting stock indexes Tends to be " long - biased Distressed Securities : Buys equity , debt , or trade claims at deep discounts of companies in or facing bankruptcy or reorganization . Profits from the market's lack of understanding of the true value of the deeply discounted securities and because the majority of institutional investors cannot own below investment grade securities . ( This selling pressure creates the deep discount . ) Results generally not dependent on the direction of the markets You have been asked to analyze two col e two companies whether or not the companies are in the same industry . By performing the tasks listed below , select the company which you believe has had the strongest historical performance Download the annual income statements , balance sheets , and cash flow statements for the last three fiscal years . Enter each company's stock symbol and then go to nancials 2 . Find historical stock prices for each firm from Yahoo ! Finance ( http : / / finance . yahoo . com ) or another source . Use the closing stock prices ( not the adjusted close ) 3 . For each of the three years of statements , compute or show the following information for each firm Valuation Ratios Price - Earnings Ratio ( for EPS use Diluted EPS Total ) Market Cap ( for current period only ) Closing stock price Define Profitability Ratios Gross profit on net sales Operating income on net sales Return on shareholder's equity Return on average assets Net Income Comprehensive income10 BOROUGH OF MANHATTAN COMMUNITY COLLEGE THE CITY UNIVERSITY OF NEW YORK Accounting 330 Accounting Department Professor S . Askew Financial Strength Ratios Fall 2018 - Project Current Ratio Debt to equity ratio Acid - lest Ratio Inventory turnover Accounts receivable turnover Equity multiplier Requirements Part la : Based on your calculations of the above requirements , prepare a report to management ( Senior Vice President - Equity Investments ) in which you identify the corporation which has had the strongest historical performance Make any assumptions to support your decision . Also use any outside information to support your decision . You may also be creative and develop one or many alternative ratios to value the companies to support your decision Part 16 : Based on current events related to the corporation ( s ) , the industry and the ( s ) , the overall national or international economy , state whether you believe the current level of performance will ( a ) continue , ( 6 ) improve or ( c ) worsen . Also if you cannot come to conclusion , state why . Make any assumptions to support your decision Also . use any outside information to support your decision . You may also be creative and develop one or many alternative ratios to value the companies to support your decision | Part 1 : List and describe in about less than 20 words , seven areas functions within the accounting profession that are different than financial accounting . Much if not all of the nting . ) Sel content within A CC 330 is part of financial or intermediate accounting . ) Select one or two of the different are ifferent areas listed which interest you the most and describe how the unctions or duties or goals within your area (s ) of interest differ from that of financial accounting . ( Make any assumptions to support your opinion . ) The word count of Part II should not exceed 150 words Part 1 : List and define at least 10 terms that you learned as a result of completing this project . For example , define Hedge Fund - a hedge fund is an investment fund that pools capital from accredited individuals or institutional investors and invests in a variety of assets , often with complex portfolio -construction and risk - management techniques Part IV : Your overall report should not exceed five pages - typed , 1 15 space , font : 12 pt Times New Roman . ( This does not include the calculations for the ratios list below . ) You may use the following template to summarize your answers or you may create your own template . You m on may wish to perform a horizontal analysis to assess the movement of the ratios . Please use excel or word so I can see a summary of your calculationsjavascript:void(0) 10 0 W W BOROUGH OF MANHATTAN COMMUNITY COLLEGE esc THE CITY UNIVERSITY OF NEW YORK Accounting 330 Accounting Department F12 Name: Fall 2018 - Project Professor S. Askew + Financial Indicator: 2087 eXon zo16 As of date: Colex 2all Price-Earnings Ratio Year 3 Company #1 2015 Year 2 Year 1 20 13 Year 3 Company #2 2617 Year 2 Year 1 EPS Closing stock price 41 1 63 1. 83 3.85 6.08 5.33 5.37 Gross profit on net 83 864 9 196,26 715 1 86 2 Lo.1) 1612 50 sales Operating income on net sales Return on shareholder's equity Return on average assets Net Income Comprehensive income Current Ratio Acid-test Ratio Book Debt-Equity Ratio Accounts receivable turnover Inventory turnover Equity multiplier ??????? - optional ??????? - optional PROJECT DUE DATE: 5:25 PM (EST) November 15, 2018. Grade reductions apply for late assignments. Submit via Blackboard. Assignment will count as 10% of your course grade. DO NOT SUBMIT COMPANY FINANCIAL STATEMENTS. PRESENTATION DUE DATE: Your presentation is optional. However, if you plan to present your project, you must notify me via email @ saskew(@bmcc.cuny.edu by November 8, 2018. The duration of your presentation should not exceed 6 minutes. Your presentation will add an additional 10% to your overall course grade. You may video tape your presentation.Balance Shee Costco Wholesale Corporation All numbers in thousands Period Ending 9 / 3/ 2017 8/28/2016 813 130 / 2015 8/ 31 / 201 Current Assets Cash And Cash Equivalents 4 546 000 3 379.000 4 301 000 5 , 738 000 Short Term investments 1233 000 1350.000 7 618000 1,577 000 Net Receivables 1 . 432000 1 252 000 1 2 24 000 1 748 000 Inventory 9 834 .000 8 969 000 8 908 000 8 456 , 000 569.000 Other Current Assets 272000 268.000 228 000 Total Current Assets 17 . 317000 15 218000 16 . 779 000 17 588 090 Long Term Investments Property Plant and Equipment 18 . 161 000 17 043 .000 15 401 000 14 830 000 Goodwill Intangible Assets Accumulated Amortization 606000 Other Assets 869090 902 000 837 000 Deferred Long Term Asset Charges 254000 202000 19000 68000 Total Assets 36 347 000 33 163 000 33 017 000 33 024, 000 Current Liabilities Accounts Payable 9.608 000 7612000 9017 .000 8 491 000 Short Current Long Term Debt 7039 .000 5 . 161 000 6 . 135 000 5 093 00 Other Current Liabilities 4 . 130 .000 3 . 365 . 000 2 078 000 1 968 000 Total Current Liabilities 17 . 495 000 15 575 000 16 539 000 14 412 000 Long Term Debt 6573 000 4 061 000 4.852000 5 093 000 .827 000 1 , 195000 783000 1004000 Other Liabilities Deferred Long Term Liability Charges 212000 Minority Interest 301 000 253 000 226.000 Negative Goodwill Total Liabilities 25 268000 20 . 831 000 22 . 174 .000 20 . 509 000 Stockholders Equity Misc . Stocks Options Warrants Redeemable Preferred Stock Preferred Stock 4 000 2000 2000 2000 Common Stock Retained Earnings 5. 988000 7 686 000 6. 518 000 7 458 000 Treasury Stock 1 014000 - 1099 000 - 1 121 000 76000 Capital Surplus 5.800 000 5 490 000 5. 218000 4 919000 Other Stockholder Equity 1014000 - 1099000 - 1 121 000 76000 Total Stockholder Equity 10 778000 12 079000 10 617 000 12 303. 000 Net Tangible Assets 10.778000 12 079 000 10 617 000 12 , 303 000COSTCO WHOLE CORPORATION Income Statemen All numbers in thousands Revenue 913/2017 8 2812016 8130 1 2015 8/31 12 1 14 1 /2171 Total Revenue 129 025 . 000 18 719 000 716 199 000 172 640 , 000 Cost of Revenue 171 882 000 102 . 901 000 101 065, 000 98 458,000 Gross Profit 17. 143.000 15 818 000 15 134 000 14 182, 000 Operating Expenses Research Development Selling General and Administrative 12.950 000 12 068 000 11 445 000 10 899, 000 Non Recurring Others Total Operating Expenses 124 .914000 915 047 000 172 575 000 109 420 000 Operating Income or Loss 4 .171:000 3 672 000 3 624 000 3 . 220.000 Income from Continuing Operations Total Other Income / Expenses Net 72000 53000 20 000 23 000 rings Before Interest and Taxes 4 117,000 3 672 000 3 624 000 3 . 220.000 Interest Expense 134.000 133 000 124 000 1 13000 Income Before Tax 4 039.000 3 619.000 3 604 . 000 3 . 197 000 Income Tax Expense 1 325.000 1. 243.000 195 000 1. 109.000 Minority Interest 301000 253 000 226000 212 000 Net income Fro in Continuing Ops 2714.000 2 . 376.000 2 409 000 2 088000 Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other items Net Incom Net Income 2. 679.000 2. 350. 000 2 . 377 000 2058 000 Preferred Stock And Other Adjustments Net Income Applicable To Common Shares 2.679.000 2 350.000 2 377 000 2058.000Costco Wholesale Corporation Cash Flow All numbers in thousands Period Ending 13/ 2017 928 12016 4302015 9831204 Net income 2 679.000 2 350.000 2 377 000 2058 000 Operating Activities , Cash Flows Provided By or Used In Depreciation 1 370 000 1 . 127 000 Adjustments To Net Income 232 000 Changes in s In Accounts Receivables Changes In Liabilities 2 258 000 Changes In Inventories Changes in Other Operating Activities Total Cash Flow From Operating Activities 6 726000 3 292000 4 285.000 3 984 000 Investing Activities , Cash Flows Provided By or Used In Capital Expenditures 2 502 000 2 649.000 2 393 000 1.993 000 Investments her Cash flows from investing Activities tal Cash Flows From Investing Activities 2. 366.090 2. 345.000 2480 090 2. 093. 000 Financing Activities , Ca sh Flows Provided By or Used In Dividends Paid -6 64 000 Sale Purchase of Stock Net Borrowings 1. 346 000 1 079.000 178 000 Other Cash Flows from Financing Activitie ing Activities Total Cash Flows From Financing Activities 3 . 218. 000 2 419.000 2 324. 000 Effect Of Exchange Rate Changes -418000 Change In Cash and Cash Equivalents 1 167 000 1 . 422 090 1094.000Balance Shee EXXON MOBIL All numbers in thousands Period Ending Current Assets 12/31/2017 1231/2016 12 31 2015 12 31/ 2014 Cash And Cash Equivalents Short Term Investments 3 177 000 3 657 000 3. 705 000 4 616000 Net Receivables Inventory 25 597 000 21 394 000 19 .875 000 28009.000 16 . 992 000 15080.000 16 . 245. 000 16 678 000 Other Current Assets 1 368 000 1 . 285 000 2798000 3 607 000 Total Current Assets 47 134 000 41 . 416 000 42 623. 000 52910.090 Long Term Investments 24 528 000 20. 964 000 20 61 1 000 20 543. 000 Property Plant and Equipment 252 630 000 24 4 224,000 251 605 000 252 6 68.000 Goodwill Intangible Assets Accumulated Amortization Other Assets 24 399.000 23 710.000 21.919.000 23 372000 Deferred Long Term Asset Charges 3 . 318.000 4 . 120.000 3 421 000 3 . 955 000 Total Assets 348 691 000 330 . 314 000 336 758 000 349 493. 000 Current Liabilities Accounts Payable 21. 701000 17 801 000 18 074 000 25 286000 Short Current Long Term Debt 42 336 000 42 762. 000 38 687 000 29.121 090 Other Current Liabilities 14 829.000 13.354 000 14 203000 18 589.000 Total Current Liabilities 57 .771 000 47 638. 000 53 . 976000 64 633.000 Long Term Debt 23 079.000 27 707 000 18 687 000 11 278000 Other Liabilities 72014000 79 914.000 86 047 000 92 143000 Deferred Long Term Liability Charges Minority Interest 6812 000 6.505. 000 5.999. 000 6 685000 Negative Goodwill Total Liabilities 154 191 000 156 484 000 159 . 948.000 168 429, 000 Stockholders Equity Misc . Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock 14.656000 12 157 000 1 1 612000 10. 792 000 Retained Earnings 414 540,000 407 831,000 412 44 4000 408 384000 Treasury Stock 241 508000 - 252 663 000 - 253 245 000 24 4 . 717 000 Capital Surplus Other Stockholder Equity 16 262000 22. 239.000 23.511 000 18. 957 000 Total Stockholder Equity 187 688000 167 325 000 170 81 1 000 174 399.000 187 688 000 167 325.000 170 817 000 174 399. 000 Net Tangible AssetsEXXON MOBIL Income Statemen All numbers in thousands Revenue 12/31/ 2017 12/31/ 2016 1231 2015 12 31 / 2014 Total Revenue 238 8 83 000 201 626 000 241 406 000 364 763 000 Cost of Revenue 160 491 , 000 134 238000 163 605 000 234 , 856000 Gross Profit 78 392 000 67 388000 77 801000 129 . 907 000 Operating Expenses Research Development Selling General and Administrative Non Recurring 10 455 000 10 . 304 000 10 961 000 12 002 000 Total Operating Expenses 32 459 000 31 375 000 32 834 000 64 857 000 Operating income or Loss 223 584 000 199 692 000 2 26 971 000 3 30 681 000 Income from Continuing Operations 15 299 000 1 934 000 14 435 000 34 082 000 Total Other Income Expenses Ne Earnings Before Interest and Taxes 3 375 000 6 035 000 7 531 090 17, 548000 Interest Expense 15 299.090 1 934 000 14 435 000 34 082 ,000 Income Before Tax 601 000 453 000 317.000 286.000 Income Tax Expense 18 674000 7 969.000 21 , 966000 51 630.000 Minority Interest 1 , 174000 406000 5415 000 18015 000 Net Income From Continuing Ops 6 812 000 6.505 000 5 . 989 . 000 6 665. 000 Non -recurring Events 19 848 000 8 375 000 16 551 000 33 615. 000 Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income tock And Other Adj Preferred Stock And Other Adjustments 19 710.000 7 840 000 16 150 000 32 520 000 Net income Applicable To Common Shares 19710.090 7 840 000 16 150.000 32 520 000,000 231,000 281,000 32,520,000 -68,000 -133,000 17,297,000 3, 118,000 3,573,000 -6,639,000 12/31/2014 -1,343,000 6,966,000 -28,0 45, 116,000 -32,952,000 -17,888,000 -26,975,000 1,631, -11,568,000 45,000 255,000 -168,000 -741,000 4,692,000 -379,000 -394,000 -911,000 884,000 7,037,000 16, 150,000 18,048,000 -607,000 -7,471,000 12/31/2015 30,344,000 -26,490,000 -23,824,000 -12,090,000 -48,000 915,000 -434,000 7,840,000 -388,000 171,000 902,000 -2,090,000 -6,674,000 22,308,000 4,293,000 -162,000 12/31/2016 -9,293,000 22,082,000 -1,417,000 -16, 163,000 -12,403,000 -12,453,000 InKNOW VODK 314,000 480,000 5, 104,000 -3,954,000 -117,000 -7,384,000 19,710,000 -1,682,000 18,389,000 30,066,000 -13,001,000 -334,000 -5,507,000 2,076,000 -15,402,000 15, 130,000 12/31/2017 -1,048,000 -15,730,000 BOROUGH OF MANHATTAN COMMUNITY COLLEGE Operating Activities, Cash Flows Provided By or Used In EXXON MOBIL Investing Activities, Cash Flows Provided By or Used In Financing Activities, Cash Flows Provided By or Used In Total Cash Flow From Operating Activities Total Cash Flows From Investing Activities In Accounts Receivables Total Cash Flows From Financing Activities Other Cash flows from Investing Activities Other Cash Flows from Financing Activities Changes In Other Operating Activities Change In Cash and Cash Equivalents Effect Of Exchange Rate Changes Adjustments To Net Income Changes In Inventories Changes In Liabilities Sale Purchase of Stock Capital Expenditures Period Ending Cash Flow Depreciation Net Income Dividends Paid Net Borrowings Investments All numbers in Chan
