Question: Need help with my final project Part 2 ASAP It has a part A and Part B Part A is an Excel Sheet and Part
Need help with my final project Part 2 ASAP It has a part A and Part B Part A is an Excel Sheet and Part B is a word document. Will provide extra information. The directions will be found in the Guidlines and Rubric attatchment. One attatchment is a guide for the excel portion.

FIN 320 Final Project Guidelines and Rubric Final Project Part I Part I Overview Business professionals typically need to demonstrate a core set of financial knowledge to earn the job and to succeed on a job. For this part of the assessment, you will be given a scenario in which you are asked to illustrate your financial management knowledge. This part of the final project addresses the following course outcomes: Analyze the roles and responsibilities of financial managers in confirming compliance with federal and shareholder requirements Differentiate between various financial markets and institutions by comparing and contrasting options when selecting appropriate private and corporate investments Part I Prompt You have completed an internship in the finance division of a fast-growing information technology corporation. Your boss, the financial manager, is considering hiring you for a full-time job. He first wants to evaluate your financial knowledge and has provided you with a short examination. When composing your answers to this employment examination, ensure that they are cohesive and read like a short essay. Your submission must address the following critical elements: I. Analyze Roles and Responsibilities for Compliance A. Examine the types of decisions financial managers make. How are these decisions related to the primary objective of financial managers? B. Analyze the various ethical issues a financial manager could potentially face and how these could be handled. C. Compare and contrast the different federal safeguards that are in place to reduce financial reporting abuse. Why are these considered appropriate safeguards? II. Investment Options A. If a private company is \"going public,\" what does this mean, and how would the company do this? What are the advantages of doing this? Do you see any disadvantages? If so, what are they? B. How do the largest U.S. stock markets differ? Out of those choices, which would be the smartest private investment option, in your opinion? Why? C. Compare and contrast the various investment products that are available and the types of institutions that sell them. Final Project Part I Rubric Guidelines for Submission: Ensure that your employment examination is submitted as one comprehensive and cohesive short essay. It should use double spacing, 12-point Times New Roman font, and one-inch margins. Citations should be formatted according to APA style. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions. Critical Elements Roles and Responsibilities: Examine Exemplary (100%) Meets \"Proficient\" criteria and includes examples in analysis Roles and Responsibilities: Analyze Meets \"Proficient\" criteria, and analysis indicates a clear understanding of ethical standards in finance Roles and Meets \"Proficient\" criteria, and Responsibilities: analysis indicates a clear Compare and Contrast understanding of federal safeguards in finance Investment: Private Company Meets \"Proficient\" criteria and includes examples in analysis Investment: U.S. Stock Meets \"Proficient\" criteria and Markets explains choice of smartest stock market to invest private money into Proficient (85%) Comprehensively examines the types of decisions financial managers make, including how these decisions are related to their primary objective Needs Improvement (55%) Examines the types of decisions financial managers make, including how these decisions are related to their primary objective, but examination is not comprehensive Comprehensively analyzes the Analyzes the various ethical issues various ethical issues a financial a financial manager could manager could potentially face potentially face and how these and how these issues could be issues could be handled, but handled analysis is not comprehensive Accurately analyzes different Analyzes different federal federal safeguards that are in safeguards that are in place to place to reduce financial reduce financial reporting abuse, reporting abuse, including why but analysis is inaccurate or these safeguards are appropriate cursory, or analysis of why these safeguards are appropriate is inaccurate or cursory Comprehensively compares and Compares and contrasts the contrasts the advantages and advantages and disadvantages of disadvantages of a company a company \"going public\" versus \"going public\" versus staying staying private, but analysis is not private comprehensive Comprehensively and accurately Differentiates between the differentiates between the largest largest U.S. stock markets, but U.S. stock markets and indicates analysis is inaccurate or cursory choice of smartest stock market or is missing choice of smartest to invest private money into stock market to invest private money into Not Evident (0%) Does not examine the types of decisions financial managers make Value 15.83 Does not analyze the various ethical issues a financial manager could potentially face and how these issues could be handled 15.83 Does not analyze different federal safeguards 15.83 Does not compare and contrast the advantages and disadvantages of a company \"going public\" versus staying private Does not differentiate between the largest U.S. stock markets 15.83 15.83 Investment: Compare and Contrast Articulation of Response Meets \"Proficient\" criteria and includes both foreign and domestic institutions Comprehensively compares and contrasts the various investment products available and the types of institutions that sell them Submission is free of errors Submission has no major errors related to citations, grammar, related to citations, grammar, spelling, syntax, and organization spelling, syntax, or organization and is presented in a professional and easy to read format Compares and contrasts the various investment products and the types of institutions that sell them, but analysis is not comprehensive Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas Does not compare and contrast the various investment products and the types of institutions that sell them 15.83 Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas Earned Total 5.02 100% Final Project Part II Part II Overview For this part of the final project, you will be given a scenario in which you are asked to illustrate your financial computation and analysis skills. This part of the assessment addresses the following course outcomes: Compute financial ratios, time value, variables, and returns using industry standard tools for optimizing financial success Analyze corporate financial data for multiple companies in evaluating past and future financial performances Part II Prompt For this section of your employment exam, you will select two companies. The first company needs to come from your TDAU thinkorswim portfolio. The second needs to be a competitor of the first company from the same industry. You will be responsible for collecting, synthesizing, and making decisions regarding both companies. After evaluating these companies' financial data, you will then decide which company's stock is the better investment. This section of your employment examination must be submitted in two parts. Part A will contain the workbooks that house all of your quantitative data and formulas, along with any of the information that is relevant for your chosen companies. Part B will contain your answers to the questions asked below, composed in a cohesive manner. If you are referring to data that is found within the workbooks in Part A, be sure to include a citationfor example, \"rate of return is 3.570 USD (E64, WB2),\" where E64 is the cell that the calculation took place in and WB2 is designating \"workbook 2.\" This ensures that your instructor can quickly and accurately check data entry, formula use, and financial calculations. Your submission must address the following critical elements: I. Preparing the Workbooks A. Download the annual income statements, balance sheets, and cash flow statements for the last three completed fiscal years for your chosen companies. This information must be included in your final submission. B. Prepare a worksheet for each of the companies to display their financial data for the last three fiscal years. Ensure your data is accurate and organized. Include these worksheets as a workbook in your final submission. C. Find historical stock prices for both companies and add this information to the respective spreadsheets. Consider the appropriate date range you should use. II. Three-Year Returns A. What is the three-year return on the stock price of the first company (Company A)? How is the stock performing? Ensure that you use the appropriate formula in your spreadsheets to calculate the three-year return on the given company's stock price. B. What is the three-year return on the stock price of the second company (Company B)? How is this stock performing? Ensure that you use the appropriate formula in your spreadsheets to calculate the three-year return on your chosen company's stock price. C. How do these two stocks compare in terms of three-year returns? What does this indicate about these two companies? III. Financial Calculations A. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the price-to-earnings ratio for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula. B. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the debt-to-equity ratios for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula. C. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the return-on-equity ratios for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula. D. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the earnings per share for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula. E. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the profit margins for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula. F. Using the appropriate spreadsheets, which are to be included in the workbooks, calculate the free cash flows for the last three fiscal years of the given and your chosen companies. Be sure that you are entering and using the correct formula. IV. Industry Averages A. Obtain current industry averages of three of the financial calculations above for both companies and add this information to your spreadsheet for comparison. Ensure the accuracy and organization of your data. B. In this context, how is each company's financial health? How do these two companies compare to one another? Consider the appropriate date range you should use. V. Performance Over Time A. Analyze the performance of the Company A over time. What financial strengths and weaknesses does this company have? Consider addressing the free cash flows and ratios you calculated earlier. B. Analyze the performance of your Company B over time. What financial strengths and weaknesses does this company have? Consider addressing the free cash flows and ratios you calculated earlier. C. Analyze how the data differ between these two companies. Why do you think this is? Consider addressing the free cash flows and ratios you calculated earlier. VI. Investment A. Are the companies considered growth or value companies? Why? B. Which company's stock is the better investment? Consider supporting your answer with data. Final Project Part II Rubric Guidelines for Submission: This part of the final project will be submitted in two parts. Part A will contain the workbooks that house all of your quantitative data and formulas, along with any of the information that is relevant for your chosen company. Part B will contain your answers to the prompts, composed in a cohesive manner. Part B should use double spacing, 12-point Times New Roman font, and one-inch margins. Citations should be formatted according to APA style. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions. Critical Elements Preparing: Download Exemplary Preparing: Worksheet Preparing: Stock Prices Returns: Company A Meets \"Proficient\" criteria and logically explains reasoning behind indication of stock performance (100%) Returns: Company B Meets \"Proficient\" criteria and logically explains reasoning behind indication of stock performance (100%) Proficient Downloads and includes annual income statements, balance sheets, and cash flow statements for the last three fiscal years for chosen companies (100%) Prepares worksheet for chosen and given companies, displaying all financial data for the last three fiscal years in an accurate and organized manner (100%) Adds historical stock prices for an appropriate date range for the chosen and given companies to their respective worksheets (100%) Correctly calculates the threeyear return on the stock price of the given company and accurately indicates how this stock is performing (85%) Correctly calculates the threeyear return on the stock price of the chosen company and accurately indicates how this stock is performing (85%) Needs Improvement Downloads and includes annual income statements, balance sheets, and cash flow statements for chosen companies but is missing various components (55%) Not Evident Does not download and include annual income statements, balance sheets, and cash flow statements for the last three fiscal years for chosen companies (0%) Does not prepare worksheets for both the chosen and given companies (0%) Value 2 Adds historical stock prices for the chosen and given companies, but data has been inaccurately entered or is not for an appropriate date range (55%) Does not add historical stock prices for the given and chosen companies to their respective worksheets (0%) 2 Calculates the three-year return on the stock price of the given company, but calculation is incorrect or indication of how this stock is performing is inaccurate or missing (55%) Calculates the three-year return on the stock price of the chosen company, but calculation is incorrect or indication of how this stock is performing is inaccurate or missing (55%) Does not calculate the threeyear return on the stock price of the given company (0%) 5.63 Does not calculate the threeyear return on the stock price of the chosen company (0%) 5.63 Prepares worksheet for chosen and given companies, displaying financial data for the last three fiscal years, but worksheets are unorganized, inaccurate, or incomplete (55%) 2 Returns: Compare Meets \"Proficient\" criteria, and explanation demonstrates nuanced understanding of three-year returns and their implications (100%) Calculations: Price-toEarnings Ratios Calculations: Debt-toEquity Ratios Calculations: Returnon-Equity Ratios Calculations: Earnings Per Share Calculations: Profit Margins Calculations: Free Cash Flows Industry Averages: Industry Averages Industry Averages: Financial Health Meets \"Proficient\" criteria and includes current industry averages within an appropriate date range (100%) Compares the three-year returns of the given and chosen companies, explaining what this indicates about each company (85%) Correctly calculates the priceto-earnings ratios for the last three fiscal years of the given and chosen companies (100%) Correctly calculates the debtto-equity ratios for the last three fiscal years of the given and chosen companies (100%) Correctly calculates the returnon-equity ratios for the last three fiscal years of the given and chosen companies (100%) Correctly calculates the earnings per share for the last three fiscal years of the given and chosen companies (100%) Correctly calculates the profit margins for the last three fiscal years of the given and chosen companies (100%) Correctly calculates the free cash flows for the last three fiscal years of the given and chosen companies (100%) Adds current industry averages for chosen and given companies to worksheet in an accurate and organized manner (100%) Analyzes the given and chosen companies' financial health by comparing the two companies' current industry averages (85%) Compares the three-year returns of the given and chosen companies, but explanation of what this indicates about each company is cursory or missing (55%) Calculates the price-to-earnings ratios of the given and chosen companies, but calculations are incorrect or do not consider the last three fiscal years (55%) Calculates the debt-to-equity ratios of the given and chosen companies, but calculations are incorrect or do not consider the last three fiscal years (55%) Calculates the return-on-equity ratios of the given and chosen companies, but calculations are incorrect or do not consider the last three fiscal years (55%) Calculates the earnings per share of the given and chosen companies, but calculations are incorrect or do not consider the last three fiscal years (55%) Calculates the profit margins of the given and chosen companies, but calculations are incorrect or do not consider the last three fiscal years (55%) Calculates the free cash flows of the given and chosen companies, but calculations are incorrect or do not consider the last three fiscal years (55%) Adds current industry averages for chosen and given companies to worksheets, but some data is inaccurate, unorganized, or missing (55%) Analyzes the given and chosen companies' financial health by comparing the two companies' industry averages but does not consider the current industry rates (55%) Does not compare the threeyear returns of the given and chosen companies (0%) 6.43 Does not calculate the price-toearnings ratios of the given and chosen companies (0%) 5.63 Does not calculate the debt-toequity ratios of the given and chosen companies (0%) 5.63 Does not calculate the returnon-equity ratios of the given and chosen companies (0%) 5.63 Does not calculate the earnings per share ratios of the given and chosen companies (0%) 5.63 Does not calculate the profit margins of the given and chosen companies (0%) 5.63 Does not calculate the free cash flows of the given and chosen companies (0%) 5.63 Does not add current industry averages for chosen and given companies to worksheets (0%) 2 Does not analyze the given and chosen companies' financial health (0%) 6.43 Performance: Company Meets \"Proficient\" criteria and A references free cash flow and ratios calculated for the given company in analysis (100%) Performance: Company Meets \"Proficient\" criteria and B references free cash flow and ratios calculated for the chosen company in analysis (100%) Performance: Differ Meets \"Proficient\" criteria and references the companies' free cash flows and ratios calculated in analysis (100%) Comprehensively analyzes the strengths and weaknesses of the given company over time (85%) Comprehensively analyzes the strengths and weaknesses of the chosen company over time (85%) Accurately contrasts the performances of the given and chosen companies over time, including a logical, proposed explanation of these performances (85%) Comprehensively analyzes whether the companies are considered growth or value companies, including a logical explanation of why (85%) Analyzes each company's stock, including a logical explanation of personal preference of which stock to purchase (85%) Analyzes the strengths and weaknesses of the given company over time, but analysis is not comprehensive (55%) Does not analyze the strengths and weaknesses of the given company over time (0%) 6.43 Analyzes the strengths and weaknesses of the chosen company over time, but analysis is not comprehensive (55%) Does not analyze the strengths and weaknesses of the chosen company over time (0%) 6.43 Does not contrast the performances of the given and chosen companies over time (0%) 6.43 Does not analyze whether the companies are considered growth or value companies (0%) 6.43 Does not analyze each company's stock (0%) 6.43 Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas (0%) 1.95 Contrasts the performances of the given and chosen companies over time, but analysis is inaccurate or cursory, or the included explanation of these performances is illogical or cursory (55%) Investment: Growth or Meets \"Proficient\" criteria and Analyzes whether the companies are Value includes quantitative data to considered growth or value companies, support analysis (100%) but analysis is not comprehensive, or the explanation included is illogical or cursory (55%) Investment: Stock Meets \"Proficient\" criteria and Analyzes each company's stock, includes quantitative data to including an explanation of personal support analysis (100%) preference of stock options, but analysis or explanation is illogical or cursory (55%) Articulation of Submission is free of errors Submission has no major errors Submission has major errors related to Response related to citations, grammar, related to citations, grammar, citations, grammar, spelling, syntax, or spelling, syntax, and spelling, syntax, or organization organization that negatively impact organization and is presented in (85%) readability and articulation of main a professional and easy to read ideas (55%) format (100%) Earned Total 100% Final Project Part III Part III Overview To make corporate finance decisions, take an advanced finance course, or pursue a career in finance, you will need to understand basic concepts. This includes going beyond the number crunching and reading graphs in order to analyze various financial indicators. This analysis can lead to many important decisions in your financial career. For this part of the final project, you will be given a scenario in which you are asked to illustrate your financial knowledge and analysis skills. This part of the assessment addresses the following course outcomes: Analyze the roles and responsibilities of financial managers in confirming compliance with federal and shareholder requirements Differentiate between various financial markets and institutions by comparing and contrasting options when selecting appropriate private and corporate investments Compute financial ratios, time value, variables, and returns using industry standard tools for optimizing financial success Analyze corporate financial data for multiple companies in evaluating past and future financial performances Part III Prompt The results of both sections of your employment examination have finally been received, and you were offered the position. You have a few important decisions to make before you can formally accept or decline the position. When composing your answers to these decisions, ensure that they are cohesive and read like a short essay. Your submission must address the following critical elements: I. School Versus Work A. The school you would like to attend costs $100,000. To help finance your education, you need to choose whether or not to sell your 1,000 shares of Apple stock, 1,000 EE Savings Bonds (with $100 denominations and 4.25% coupon rate) that are five years from their 30-year maturity date, or a combination of both. Provide the appropriate data and calculations that you would perform to make this decision. B. What are the advantages and disadvantages of selling a combination of stocks and bonds? Be sure to support your answers. C. Suppose that you choose to sell your stocks, bonds, or a combination of both. What is your choice, and what is your financial reasoning behind this choice? Consider supporting your answer with quantitative data. D. Suppose that you choose to accept the job. What is your financial reasoning behind this choice? Be sure to support your answer with quantitative data. II. Bonus Versus Stock A. The company has offered you a $5,000 bonus, which you may receive today, or 100 shares of the company's stock, which has a current stock price of $50 per share. Mathematically, what is the best choice? Why? B. What are the advantages and disadvantages of each option? Be sure to support your answers. C. What would you ultimately choose to do? What is your financial reasoning behind this choice? Consider supporting your answer with quantitative data. III. Compliance A. While investigating the shares offered to you by your potential boss, you discover that the company you are considering working for is not registered as required under the Securities Act of 1933. How does this influence you as a potential employee and as a potential shareholder? Be sure to reference any applicable statutes or laws. B. You know that accepting this job may eventually lead to a promotion into the role of the financial manager. As the potential financial manager, what federal and shareholder requirements would you need to be familiar with in order to ensure that you are being completely compliant? Final Project Part III Rubric Guidelines for Submission: Please ensure that your decision plan is submitted as one comprehensive and cohesive short essay. It should use double spacing, 12point Times New Roman font, and one-inch margins. Citations should be formatted according to APA style. Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, review these instructions. Critical Elements School Versus Work: Finance Your Education School Versus Work: Advantages and Disadvantages School Versus Work: Choose to Sell School Versus Work: Accept the Job Bonus Versus Stock: Offered Exemplary Proficient Accurately calculates the worth of stocks, bonds, and combinations of stocks and bonds, including the appropriate data and calculations with submission (100%) Meets \"Proficient\" criteria and Comprehensively differentiates provides historical data, as well the advantages and as quantitative data, to support disadvantages of selling a answer (100%) combination of stocks and bonds and provides support for answer (85%) Meets \"Proficient\" criteria and Examines choice to sell stocks, supports examination with bonds, or combination of both, quantitative data (100%) explaining the financial reasoning behind the choice (85%) Meets \"Proficient\" criteria and Examines choice to accept the supports examination with job, explaining the financial quantitative data (100%) reasoning behind the choice (85%) Meets \"Proficient\" criteria, and Accurately calculates the best explanation of the best choice choice of receiving a cash bonus demonstrates nuanced versus receiving company stock, understanding of the time-value including an explanation of the of money (100%) best choice (85%) Needs Improvement Calculates the worth of stocks, bonds, and combinations of stocks and bonds, but calculation is inaccurate or appropriate data and/or calculations are not included in submission (55%) Differentiates the advantages and disadvantages of selling a combination of stocks and bonds, but analysis is not comprehensive or support is cursory or missing (55%) Examines choice to sell stocks, bonds, or combination of both, but explanation of the financial reasoning behind the choice is cursory or missing (55%) Examines choice to accept the job, but explanation of the financial reasoning behind the choice is cursory or missing (55%) Calculates the best choice of receiving a cash bonus versus receiving company stock, but calculation is inaccurate or explanation of best choice is cursory or missing (55%) Not Evident Does not calculate the worth of stocks, bonds, and combinations of stocks and bonds (0%) Value 11.88 Does not differentiate the advantages and disadvantages of selling a combination of stocks and bonds (0%) 11.88 Does not examine choice to sell stocks, bonds, or combination of both (0%) 7.92 Does not examine choice to accept the job (0%) 7.92 Does not calculate the best choice of receiving a cash bonus versus receiving company stock (0%) 11.88 Bonus Versus Stock: Advantages and Disadvantages Meets \"Proficient\" criteria, and analysis includes quantitative data (100%) Comprehensively analyzes the advantages and disadvantages of the cash and stock options, supporting each option (85%) Analyzes the advantages and disadvantages of the cash and stock options, but analysis is not comprehensive or support for each option is cursory or missing (55%) Bonus Versus Stock: Meets \"Proficient\" criteria and Chooses cash or stock option, Chooses cash or stock option, Choose supports choice with including logical financial including financial reasoning quantitative data (100%) reasoning behind the choice behind the choice, but reasoning (85%) is illogical or missing (55%) Compliance: Meets \"Proficient\" criteria and Comprehensively analyzes the Analyzes the influence of Investigating references demonstrate influence of noncompliance on noncompliance on potential knowledge of current events in potential employees and employees and potential finance (100%) potential shareholders, including shareholders, but analysis is not references to statutes and laws comprehensive or support does in analysis (85%) not include references to statutes or laws (55%) Compliance: Accepting Meets \"Proficient\" criteria, and Comprehensively analyzes the Analyzes the federal and analysis demonstrates nuanced federal and shareholder shareholder requirements understanding of requirements requirements necessary for a necessary for a financial manager for compliance with federal laws financial manager to become to become familiar with in order (100%) familiar with in order to ensure to ensure compliance, but compliance (85%) analysis is not comprehensive (55%) Articulation of Submission is free of errors Submission has no major errors Submission has major errors Response related to citations, grammar, related to citations, grammar, related to citations, grammar, spelling, syntax, and spelling, syntax, or organization spelling, syntax, or organization organization and is presented in (85%) that negatively impact readability a professional and easy to read and articulation of main ideas format (100%) (55%) Does not analyze the advantages or disadvantages of the cash and stock options (0%) 11.88 Does not choose cash or stock option (0%) 7.92 Does not analyze the influence of noncompliance on potential employees or potential shareholders (0%) 11.88 Does not analyze the federal and shareholder requirements necessary for a financial manager to become familiar with in order to ensure compliance (0%) 11.88 Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas (0%) 4.96 Earned Total 100% Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities Stockholders' Equity Misc. Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity Net Tangible Assets AMAZON INC. BALANCE SHEET 1000s 12/31/2016 12/31/2015 12/31/2014 $ 19,334,000.00 $ 15,890,000.00 $ 6,647,000.00 $ 3,918,000.00 $ 8,339,000.00 $ 5,654,000.00 $ 11,461,000.00 $ 10,243,000.00 $ 45,781,000.00 $ 35,705,000.00 $ 29,114,000.00 $ 21,838,000.00 $ 3,784,000.00 $ 3,759,000.00 $ 4,723,000.00 $ 3,445,000.00 $ 83,402,000.00 $ 64,747,000.00 $ 14,557,000.00 $ 2,859,000.00 $ 5,612,000.00 $ 8,299,000.00 $ 31,327,000.00 $ 16,967,000.00 $ 3,319,000.00 $ 2,892,000.00 $ 54,505,000.00 $ $ $ $ $ $ $ $39,048,000.00 $4,768,000.00 $43,816,000.00 $7,694,000.00 $12,607,000.00 $64,117,000.00 $30,769,000.00 $3,118,000.00 $33,887,000.00 $8,227,000.00 $9,249,000.00 $51,363,000.00 $26,266,000.00 $1,823,000.00 $28,089,000.00 $8,265,000.00 $7,410,000.00 $43,764,000.00 5,000.00 4,916,000.00 (1,837,000.00) 17,186,000.00 (985,000.00) 19,285,000.00 15,501,000.00 5,000.00 2,545,000.00 (1,837,000.00) 13,394,000.00 (723,000.00) 13,384,000.00 9,625,000.00 5,000.00 1,949,000.00 (1,837,000.00) 11,135,000.00 (511,000.00) 10,741,000.00 7,422,000.00 $ $ $ $ $ $ $ $ $ $ $ $ $ $ Reference AMZN Balance Sheet | Amazon.com, Inc. Stock - Yahoo Finance. (2017). Finance.yahoo.com. Retrieved 6 June 2017, from https Revenue Total Revenue Cost of Revenue Gross Profit Operating Expenses Research Development Selling General and Administrative Non Recurring Others Total Operating Expenses Operating Income or Loss Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest and Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest Net Income From Continuing Ops Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Net Income AMAZON INC. INCOME STATEMENT 1000s 12/31/2016 12/31/2015 12/31/2014 $135,987,000.00 $107,006,000.00 $ 88,988,000.00 $ 88,265,000.00 $ 71,651,000.00 $ 62,752,000.00 $ 47,722,000.00 $ 35,355,000.00 $ 26,236,000.00 $ 43,536,000.00 $ 33,122,000.00 $ 26,058,000.00 $ 4,186,000.00 $ 2,233,000.00 $ 178,000.00 $ $ $ $ $ $ $ $ $ $ $ $ $ Preferred Stock And Other Adjustments Net Income Applicable To Common Shares 190,000.00 4,376,000.00 484,000.00 3,892,000.00 1,425,000.00 2,371,000.00 2,371,000.00 $ - $ 2,371,000.00 $ (206,000.00) 2,027,000.00 459,000.00 1,568,000.00 950,000.00 596,000.00 $ $ $ $ $ $ 596,000.00 $ 596,000.00 $ (79,000.00) 99,000.00 210,000.00 (111,000.00) 167,000.00 (241,000.00) (241,000.00) (241,000.00) Reference AMZN Income Statement | Amazon.com, Inc. Stock - Yahoo Finance. (2017). Finance.yahoo.com. Retrieved 6 June 2017, from h AMAZON INC STATEMENT OF CASH FLOWS 1000S Period Ending 12/31/2016 12/31/2015 12/31/2014 Net Income $ 2,371,000.00 $ 596,000.00 $ (241,000.00) Operating Activities, Cash Flows Provided By or Used In Depreciation $8,116,000.00 $6,281,000.00 $4,746,000.00 Adjustments To Net Income $2,040,000.00 $2,486,000.00 $1,363,000.00 Changes In Accounts Receivables -$3,367,000.00 -$1,755,000.00 -$1,039,000.00 Changes In Liabilities $18,685,000.00 $12,608,000.00 $6,898,000.00 Changes In Inventories -$1,426,000.00 -$2,187,000.00 -$1,193,000.00 Changes In Other Operating Activities -$9,976,000.00 -$6,109,000.00 -$3,692,000.00 Total Cash Flow From Operating Activities $16,443,000.00 $11,920,000.00 $6,842,000.00 Investing Activities, Cash Flows Provided By or Used In Capital Expenditures $ (6,737,000.00) $ (4,589,000.00) $ (4,893,000.00) Investments $ (3,023,000.00) $ (1,066,000.00) $ 807,000.00 Other Cash flows from Investing Activities $ (116,000.00) $ (795,000.00) $ (979,000.00) Total Cash Flows From Investing Activities $ (9,876,000.00) $ (6,450,000.00) $ (5,065,000.00) Financing Activities, Cash Flows Provided By or Used In Dividends Paid Sale Purchase of Stock Net Borrowings $ (3,740,000.00) $ (3,882,000.00) $ Other Cash Flows from Financing Activities 4,426,000.00 - Total Cash Flows From Financing Activities $ (2,911,000.00) $ (3,763,000.00) $ 4,432,000.00 Effect Of Exchange Rate Changes Change In Cash and Cash Equivalents $ $ (310,000.00) 5,899,000.00 (212,000.00) $ 3,444,000.00 $ (374,000.00) $ 1,333,000.00 $ reference AMZN Cash Flow | Amazon.com, Inc. Stock - Yahoo Finance. (2017). Finance.yahoo.com. Retrieved 6 June 2017, from https://fi Financial Ratios Company A, Inc. 2016 Price to Earnings Ratio Debt to Equity Ratio Return on Equity Ratio Earnings per Share (EPS) Gross Profit Margin Free Cash Flow (in thousands) Average Shares Outstanding (in thousands) 2015 2014 rieved 6 June 2017, from https://finance.yahoo.com/quote/AMZN/balance-sheet?p=AMZN Retrieved 6 June 2017, from https://finance.yahoo.com/quote/AMZN/financials?p=AMZN ed 6 June 2017, from https://finance.yahoo.com/quote/AMZN/cash-flow?p=AMZN CDW Corp (NMS: CDW) Exchange rate used is that of the Year End reported date As Reported Annual Balance Sheet Report Date Currency Audit Status Consolidated Scale Cash & cash equivalents Accoutns receivable, gross Less: allowance for doubtful accounts Accounts receivable, net Merchandise inventory Miscellaneous receivables Prepaid expenses & other current assets Total current assets Land Machinery & equipment Building & leasehold improvements Computer & data processing equipment Computer software Furniture & fixtures Construction in progress Total property & equipment Less: accumulated depreciation Property & equipment, net Equity investments Goodwill Other intangible assets, net Deferred financing costs, net Other assets Total assets Accounts payable-trade Accounts payable-inventory financing Current maturities of long-term debt Deferred revenue Accrued expenses - compensation Accrued expenses - interest Accrued expenses - sales taxes Accrued expenses - advertising Accrued expenses - income taxes Other accred expenses Total current liabilities Unamortized discount on senior secured term loan facility Senior secured term loan facility Term loan Senior notes Unamortized premium on senior notes 12/31/2016 12/31/2015 USD USD Not Qualified Not Qualified Yes Thousands Yes Thousands 263700 2174500 5900 2168600 452000 234900 118900 3238100 27700 43200 120400 101700 10800 23800 20400 348000 184300 163700 2455000 1055600 36000 6948400 1072900 580400 18500 172600 167600 25100 38000 55800 149800 2280700 1468100 67500 1683100 - 37600 2023400 6000 2017400 393100 198400 144300 2790800 27700 56800 126700 99600 10300 29400 23900 374400 199000 175400 2500400 1276400 12300 6755300 866500 439600 27200 151900 120400 25100 38100 52300 166200 1887300 1491400 87800 1680500 - Other long-term obligations Total long-term debt Less current maturities of long-term debt Debt Deferred income taxes Other liabilities Total long-term liabilities Common stock Paid-in capital Retained earnings (accumulated deficit) Foreign currency translation Accumulated other comprehensive income (loss) Total stockholders' equity (deficit) 15700 3234400 18500 3215900 369200 37100 3622200 1600 2857300 -1673800 -139600 -139600 1045500 3259700 27200 3232500 469600 70000 3772100 1700 2806900 -1651600 -61100 1095900 CDW Corp (NMS: CDW) Exchange rate used is that of the Year End reported date As Reported Annual Income Statement Report Date Currency Audit Status Consolidated Scale Net sales Cost of sales Gross profit Selling & administrative expenses Advertising expense Income (loss) from operations Interest expense, net Net gain (loss) on extinguishments of long-term debt Gain on remeasurement of equity investment Other income (expense), net Income (loss) before income taxes - domestic Income (loss) before income taxes - foreign Income (loss) before income taxes Current federal income tax expense (benefit) Current state income tax expense (benefit) Current foreign income tax expense (benefit) Total current income tax expense (benefit) Deferred domestic income tax expense (benefit) Deferred foreign income tax expense (benefit) 12/31/2016 12/31/2015 USD USD Not Qualified Not Qualified Yes Thousands Yes Thousands 13981900 11654700 2327200 1345100 162900 819200 146500 -2100 1800 635500 36900 672400 295700 34900 16800 347400 -90500 -8900 12988700 10872900 2115800 1226000 147800 742000 159500 -24300 98100 -9300 626400 20600 647000 258500 28600 10100 297200 -48500 -4800 Total deferred income tax expense (benefit) Income tax expense (benefit) Net income (loss) Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Net income (loss) per share - basic Net income (loss) per share - diluted Cash dividends declared per common share Total number of employees Number of common stockholders Foreign currency translation adjustments -99400 248000 424400 163600 166000 160300 2.59 2.56 0.483 8516 45 -78500 -53300 243900 403100 170300 171800 168200 2.37 2.35 0.31 8465 59 -44500 CDW Corp (NMS: CDW) Exchange rate used is that of the Year End reported date As Reported Annual Cash Flow Report Date Currency Audit Status Consolidated Scale Net income (loss) Depreciation & amortization Equity-based compensation expense Deferred income taxes Allowance for doubtful accounts Amortization of deferred financing costs, debt premium & debt Net loss (gain) on extinguishments of long-term debt Loss (income) from equity investments Gain on remeasurement of equity investment Mark-to-market loss (gain) on interest rate cap agreements Other adjustments Accounts receivable Merchandise inventory Other assets Accounts payable-trade Other current liabilities Long-term liabilities Net cash flows from operating activities Capital expenditures 12/31/2016 12/31/2015 USD USD Not Qualified Not Qualified Yes Thousands Yes Thousands 424400 254500 39200 -97200 6500 2100 -2600 400 -179900 -68500 -50100 225100 80200 -30100 604000 -63500 403100 227400 31200 -54500 6400 24300 11200 -98100 2400 -342600 -31500 -71200 100500 47500 21400 277500 -90100 Payment for equity investment Payment of accrued charitable contribution related to the MPK Premium payments on interest rate cap agreements Acquisition of business, net of cash acquired Net cash flows from investing activities Proceeds from borrowings under revolving credit facility Repayments of borrowings under revolving credit facility Repayments of long-term debt Proceeds from issuance of long-term debt Payments to extinguish long-term debt Net change in other long-term obligation Payments of debt financing costs Net change in accounts payable-inventory financing Proceeds from stock option exercises Proceeds from coworker stock purchase plan Repurchases of common stock Dividends paid Excess tax benefits from equity-based compensation Principal payments under capital lease obligations Net cash flows from financing activities Effect of exchange rate changes on cash & cash equivalents Net increase (decrease) in cash & cash equivalents Cash & cash equivalents - beginning of period Cash & cash equivalents - end of period Interest paid Taxes paid, net -2400 -65900 338800 -338800 -20600 1483000 -1490400 15700 -5900 143600 7400 9300 -367400 -78700 -600 -304600 -7400 226100 37600 263700 144300 329200 -500 -263800 -354400 314500 -314500 -32800 525000 -525300 -6800 95900 2400 8700 -241300 -52900 600 -226500 -3500 -306900 344500 37600 -154600 -300200 Financial Ratios Company B, Inc. 2016 12/31/2014 USD Not Qualified Yes Thousands 344500 1566800 5700 1561100 337500 155600 54700 2453400 27700 54300 105100 65600 10600 21700 24700 309700 172500 137200 86700 2217600 1168800 33000 3200 6099900 704000 332100 15400 81300 130100 28100 29100 34000 200 113700 1468000 -3700 1513500 1678900 1300 Price to Earnings Ratio Debt to Equity Ratio Return on Equity Ratio Earnings per Share (EPS) Gross Profit Margin Free Cash Flow (in thousands) Average Shares Outstanding (in thousands) 3190000 15400 3174600 475000 45800 3695400 1700 2711900 -1760500 -16600 -16600 936500 12/31/2014 USD Not Qualified Yes Thousands 12074500 10153200 1921300 1110300 138000 673000 197300 -90700 2700 366600 21100 387700 206800 19300 5800 231900 -89000 -100 -89100 142800 244900 170600 172800 172200 1.44 1.42 0.195 7211 71 - 12/31/2014 USD Not Qualified Yes Thousands 244900 207900 16400 -89100 300 6400 90700 -1200 500 -117600 44200 -18700 43700 1700 4900 435000 -55000 -86800 -20900 -2100 -164800 -15400 1175000 -1299000 -21900 75500 1300 5800 -33600 300 -112000 -1800 156400 188100 344500 195800 241200 atios Inc. 2015 2014 Financial Ratios Industry Averages 2016 2015 2014 Price to Earnings Ratio Debt to Equity Ratio Return on Equity Ratio Earnings per Share (EPS) Net Profit Margin Free Cash Flow (in thousands) Average Shares Outstanding (in thousands) Company A, Inc. Historic Stock Prices Date Company B, Inc. Historic Stock Prices Close Reference 3-Year Return On Stock Price Date Close Reference xx% 3-Year Return On Stock Price xx% Company A Name & Stock Symbol As Reported Annual Balance Sheet Report Date Currency Audit Status Consolidated Scale Cash & cash equivalents Restricted cash & marketable securities Restricted cash Accounts receivable Raw materials Work in process Finished goods Service parts Inventory Prepaid expenses & other current assets Total current assets Operating lease vehicles, net Machinery, equipment & office furniture Tooling Leasehold improvements Building & building improvements Land Computer equipment & software Construction in progress Property & equipment, gross Less: accumulated depreciation & amortization Property & equipment, net Restricted cash Emission credits Debt issuance costs, net Other assets Other assets Other assets Total assets Accounts payable Accrued warranty, current portion Build to suit finance obligation, current portion Accrued interest Environmental liabilities, current portion Other accrued expenses Taxes payable Accrued purchases Payroll & related costs Warranty & other accrued expenses Accrued liabilities Deferred revenue 12/31/2015 12/31/2014 12/31/2013 USD USD USD Not Qualified Not Qualified Not Qualified Yes Thousands 1,196,908 22,628 168,965 528,935 163,830 Yes Thousands 1,905,713 17,947 226,604 392,292 56,114 Yes Thousands 845,889 3,012 49,109 184,665 42,500 476,512 108,561 1,277,838 125,229 2,791,568 1,791,403 1,694,910 550,902 338,392 461,303 60,234 175,512 693,207 3,974,460 571,126 3,403,334 31,522 74,633 8,092,460 916,148 101,206 140,540 86,859 94,193 422,798 423,961 397,318 107,951 953,675 94,718 3,198,657 766,744 720,746 295,906 230,270 154,362 49,478 98,970 572,125 2,121,857 292,590 1,829,267 11,374 43,209 5,849,251 777,946 32,321 21,030 7,222 3,573 10,470 71,229 68,547 54,492 268,884 191,651 69,324 43,866 340,355 27,574 1,265,939 382,425 322,394 230,385 94,763 67,707 45,020 42,073 76,294 878,636 140,142 738,494 6,435 13,930 7,315 2,392 23,637 2,416,930 303,969 19,917 2,132 2,578 38,067 19,023 26,535 108,252 91,882 Resale value guarantee Capital lease obligations, current portion Customer deposits Convertible debt, current portion Long term debt & capital leases Total current liabilities Deferred revenue Long term debt & capital leases Resale value guarantee Capital lease obligations, less current portion Convertible debt, less current portion Accrued warranty, less current portion Deferred rent liability Deferred tax liabilities Environmental liabilities, less current portion Other long-term liabilities Other long-term liabilities Other long-term liabilities Convertible senior notes Total liabilities Common stock Additional paid-in capital Accumulated other comprehensive income (loss) Retained earnings (accumulated deficit) Total stockholders' equity (deficit) 136,831 283,370 633,166 2,816,274 446,105 2,040,375 1,293,741 364,976 42,045 7,003,516 131 3,414,692 -3,556 -2,322,323 1,088,944 9,532 257,587 601,566 2,107,166 292,271 487,879 12,267 1,806,518 173,244 58,196 4,937,541 126 2,345,266 -1,433,682 911,710 7,722 163,153 182 675,160 181,180 236,299 12,855 586,119 33,265 9,886 6,821 3,364 4,861 1,749,810 123 1,806,617 -1,139,620 667,120 References: Industry Averages. (2017). Industry: Example Only - Major. Retrieved February 11, 2017 from: https://biz.yahoo.com/p/1conameu.html#f (Example link only) Mergent Online. (2017). Company A Retrieved January 21, 2017 from: http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=1&perio Company A Name & Stock Symbol As Reported Annual Income Statement Report Date Currency Audit Status Consolidated Scale Development services Automotive sales Services & other revenues Total revenues Development services Automotive sales Services & other cost of revenues Total cost of revenues 12/31/2015 12/31/2014 12/31/2013 USD USD USD Not Qualified Not Qualified Not Qualified Yes Thousands 3,740,973 305,052 4,046,025 2,823,302 299,220 3,122,522 Yes Thousands 5,633 3,192,723 3,198,356 6,674 2,310,011 2,316,685 Yes Thousands 15,710 1,997,786 2,013,496 13,356 1,543,878 1,557,234 Gross profit (loss) Research & development Selling, general & administrative Total operating expenses Income (loss) from operations Interest income Interest expense Other income (expense), net Income (loss) before income taxes - domestic Income (loss) before income taxes - international Income (loss) before income taxes Current state income taxes (benefit) Current foreign income taxes (benefit) Current income taxes (benefit) Deferred foreign income taxes (benefit) Deferred income taxes (benefit) Provision for income taxes (benefit) Net income (loss) Weighted average shares outstanding-basic Weighted average shares outstanding-diluted Year end shares outstanding Net income (loss) per share - basic Net income (loss) per share - diluted Number of full time employees Number of common stockholders Foreign currency translation adjustments 923,503 717,900 922,232 1,640,132 -716,629 1,508 118,851 -41,652 -415,694 -459,930 -875,624 525 10,342 10,867 2,172 2,172 13,039 -888,663 128,202 128,202 131,425 -7 -7 13,058 836 -10,999 881,671 464,700 603,660 1,068,360 -186,689 1,126 100,886 1,813 -60,451 -224,185 -284,636 257 9,203 9,460 -56 -56 9,404 -294,040 124,539 124,539 125,688 -2 -2 10,161 769 - 456,262 231,976 285,569 517,545 -61,283 189 32,934 22,602 -75,279 3,853 -71,426 178 2,349 2,527 61 61 2,588 -74,014 119,421 119,421 123,091 -1 -1 5,859 699 - References: Industry Averages. (2017). Industry: Example Only - Major. Retrieved February 11, 2017 from: https://biz.yahoo.com/p/1conameu.html#f (Example link only) Mergent Online. (2017). Company A Retrieved January 21, 2017 from: http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=1&period=Annuals&dat Company A Name & Stock Symbol Exchange rate used is that of the Year End reported date As Reported Annual Cash Flow Report Date Currency Audit Status Consolidated Scale Net income (loss) Depreciation & amortization Stock-based compensation 12/31/2015 12/31/2014 12/31/2013 USD USD USD Not Qualified Not Qualified Not Qualified Yes Thousands -888,663 422,590 197,999 Yes Thousands -294,040 231,931 156,496 Yes Thousands -74,014 106,083 80,737 Amortization of discount on convertible debt Inventory write-downs Write-off of Department of Energy (DOE) loan origination costs Change in fair value of DOE warrant liability Fixed asset disposal Other non-cash operating activities Foreign currency transaction loss (gain) Account receivables Inventories & operating lease vehicles Prepaid expenses & other current assets Other assets Accounts payable Accrued liabilities Accounts payable & accrued expenses Deferred revenue Customer deposits Resale value guarantee Other long-term liabilities Net cash flows from operating activities Purchases of property & equipment excluding capital leases Withdrawals out of (transfers into) our dedicated Department of Decrease (increase) in restricted cash Purchase of short-term marketable securities Maturities of short-term marketable securities Business acquisition Net cash flows from investing activities Proceeds from issuance of convertible debt Proceeds from issuance of convertible debt & other debt Proceeds from issuance of common stock in public Proceeds from issuance of warrants Proceeds from exercise of stock options & other stock issuance Proceeds from issuance of common stock in private placements Principal payments on DOE loans Purchase of convertible note hedges Common stock & convertible debt issuance costs Principal payments on capital leases & other debt Collateralized lease borrowings Net cash flows from financing activities Effect of exchange rate changes on cash & cash equivalents Net increase (decrease) in cash & cash equivalents Cash & cash equivalents at beginning of period Cash & cash equivalents at end of period Interest paid Income taxes paid 72,063 44,940 37,723 26,373 55,765 46,267 -1,573,860 -29,595 -24,362 263,345 322,203 36,721 442,295 23,697 -524,499 -1,634,850 -26,441 -12,260 -1,673,551 318,972 730,000 106,611 20,000 -17,025 -203,780 568,745 1,523,523 -34,278 -708,805 1,905,713 1,196,908 32,060 9,461 69,734 15,609 14,178 7,471 -1,891 -183,658 -1,050,264 -60,637 -4,493 252,781 162,075 209,681 106,230 249,492 61,968 -57,337 -969,885 -3,849 -205,841 189,131 -990,444 2,300,000 389,160 100,455 -603,428 -35,149 -11,179 3,271 2,143,130 -35,525 1,059,824 845,889 1,905,713 20,539 3,120 References: Industry Averages. (2017). Industry: Example Only - Major. Retrieved February 11, 2017 from: https://biz.yahoo.com/p/1conameu.html#f (Example link only) Mergent Online. (2017). Company A Retrieved January 21, 2017 from: 9,143 8,918 5,558 -10,692 3,611 3,655 -21,917 -463,270 -17,466 -342 -243 66,567 268,153 24,243 236,299 32,971 257,994 -264,224 14,752 55 -249,417 660,000 360,000 120,318 95,307 55,000 -452,337 -177,540 -16,901 -8,425 635,422 643,999 201,890 845,889 9,041 257 http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=1&period=Annuals&dat Financial Ratios Company A, Inc. 2015 Price to Earnings Ratio Debt to Equity Ratio Return on Equity Ratio Earnings per Share (EPS) Gross Profit Margin Free Cash Flow (in thousands) Average Shares Outstanding (in thousands) 2014 2013 rted&compnumber=1&period=Annuals&dataarea=BS&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh ber=1&period=Annuals&dataarea=BS&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh ber=1&period=Annuals&dataarea=BS&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh (Example link only) Company B Name & Stock Symbol As Reported Annual Balance Sheet Report Date Currency Audit Status Consolidated Scale Cash & cash equivalents Restricted cash & marketable securities Restricted cash Accounts receivable Raw materials Work in process Finished goods Service parts Inventory Prepaid expenses & other current assets Total current assets Operating lease vehicles, net Machinery, equipment & office furniture Tooling Leasehold improvements Building & building improvements Land Computer equipment & software Construction in progress Property & equipment, gross Less: accumulated depreciation & amortization Property & equipment, net Restricted cash Emission credits Debt issuance costs, net Other assets Other assets Other assets Total assets Accounts payable Accrued warranty, current portion Build to suit finance obligation, current portion Accrued interest Environmental liabilities, current portion Other accrued expenses Taxes payable Accrued purchases Payroll & related costs Warranty & other accrued expenses Accrued liabilities Deferred revenue 12/31/2015 12/31/2014 12/31/2013 USD USD USD Not Qualified Not Qualified Not Qualified Yes Thousands 1,196,908 22,628 168,965 528,935 163,830 Yes Thousands 1,905,713 17,947 226,604 392,292 56,114 Yes Thousands 845,889 3,012 49,109 184,665 42,500 476,512 108,561 1,277,838 125,229 2,791,568 1,791,403 1,694,910 550,902 338,392 461,303 60,234 175,512 693,207 3,974,460 571,126 3,403,334 31,522 74,633 8,092,460 916,148 101,206 140,540 86,859 94,193 422,798 423,961 397,318 107,951 953,675 94,718 3,198,657 766,744 720,746 295,906 230,270 154,362 49,478 98,970 572,125 2,121,857 292,590 1,829,267 11,374 43,209 5,849,251 777,946 32,321 21,030 7,222 3,573 10,470 71,229 68,547 54,492 268,884 191,651 69,324 43,866 340,355 27,574 1,265,939 382,425 322,394 230,385 94,763 67,707 45,020 42,073 76,294 878,636 140,142 738,494 6,435 13,930 7,315 2,392 23,637 2,416,930 303,969 19,917 2,132 2,578 38,067 19,023 26,535 108,252 91,882 Resale value guarantee Capital lease obligations, current portion Customer deposits Convertible debt, current portion Long term debt & capital leases Total current liabilities Deferred revenue Long term debt & capital leases Resale value guarantee Capital lease obligations, less current portion Convertible debt, less current portion Accrued warranty, less current portion Deferred rent liability Deferred tax liabilities Environmental liabilities, less current portion Other long-term liabilities Other long-term liabilities Other long-term liabilities Convertible senior notes Total liabilities Common stock Additional paid-in capital Accumulated other comprehensive income (loss) Retained earnings (accumulated deficit) Total stockholders' equity (deficit) 136,831 283,370 633,166 2,816,274 446,105 2,040,375 1,293,741 364,976 42,045 7,003,516 131 3,414,692 -3,556 -2,322,323 1,088,944 9,532 257,587 601,566 2,107,166 292,271 487,879 12,267 1,806,518 173,244 58,196 4,937,541 126 2,345,266 -1,433,682 911,710 7,722 163,153 182 675,160 181,180 236,299 12,855 586,119 33,265 9,886 6,821 3,364 4,861 1,749,810 123 1,806,617 -1,139,620 667,120 References: Industry Averages. (2017). Industry: Example Only - Major. Retrieved February 11, 2017 from: https://biz.yahoo.com/p/1conameu.html#f (Example link only) Mergent Online. (2017). Company A Retrieved January 21, 2017 from: http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=1&perio Company B Name & Stock Symbol As Reported Annual Income Statement Report Date Currency Audit Status Consolidated Scale Development services Automotive sales Services & other revenues Total revenues Development services Automotive sales Services & other cost of revenues Total cost of revenues 12/31/2015 12/31/2014 12/31/2013 USD USD USD Not Qualified Not Qualified Not Qualified Yes Thousands 3,740,973 305,052 4,046,025 2,823,302 299,220 3,122,522 Yes Thousands 5,633 3,192,723 3,198,356 6,674 2,310,011 2,316,685 Yes Thousands 15,710 1,997,786 2,013,496 13,356 1,543,878 1,557,234 Gross profit (loss) Research & development Selling, general & administrative Total operating expenses Income (loss) from operations Interest income Interest expense Other income (expense), net Income (loss) before income taxes - domestic Income (loss) before income taxes - international Income (loss) before income taxes Current state income taxes (benefit) Current foreign income taxes (benefit) Current income taxes (benefit) Deferred foreign income taxes (benefit) Deferred income taxes (benefit) Provision for income taxes (benefit) Net income (loss) Weighted average shares outstanding-basic Weighted average shares outstanding-diluted Year end shares outstanding Net income (loss) per share - basic Net income (loss) per share - diluted Number of full time employees Number of common stockholders Foreign currency translation adjustments 923,503 717,900 922,232 1,640,132 -716,629 1,508 118,851 -41,652 -415,694 -459,930 -875,624 525 10,342 10,867 2,172 2,172 13,039 -888,663 128,202 128,202 131,425 -7 -7 13,058 836 -10,999 881,671 464,700 603,660 1,068,360 -186,689 1,126 100,886 1,813 -60,451 -224,185 -284,636 257 9,203 9,460 -56 -56 9,404 -294,040 124,539 124,539 125,688 -2 -2 10,161 769 - 456,262 231,976 285,569 517,545 -61,283 189 32,934 22,602 -75,279 3,853 -71,426 178 2,349 2,527 61 61 2,588 -74,014 119,421 119,421 123,091 -1 -1 5,859 699 - References: Industry Averages. (2017). Industry: Example Only - Major. Retrieved February 11, 2017 from: https://biz.yahoo.com/p/1conameu.html#f (Example link only) Mergent Online. (2017). Company A Retrieved January 21, 2017 from: http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=1&period=Annuals&dat Company B Name & Stock Symbol Exchange rate used is that of the Year End reported date As Reported Annual Cash Flow Report Date Currency Audit Status Consolidated Scale Net income (loss) Depreciation & amortization Stock-based compensation 12/31/2015 12/31/2014 12/31/2013 USD USD USD Not Qualified Not Qualified Not Qualified Yes Thousands -888,663 422,590 197,999 Yes Thousands -294,040 231,931 156,496 Yes Thousands -74,014 106,083 80,737 Amortization of discount on convertible debt Inventory write-downs Write-off of Department of Energy (DOE) loan origination costs Change in fair value of DOE warrant liability Fixed asset disposal Other non-cash operating activities Foreign currency transaction loss (gain) Account receivables Inventories & operating lease vehicles Prepaid expenses & other current assets Other assets Accounts payable Accrued liabilities Accounts payable & accrued expenses Deferred revenue Customer deposits Resale value guarantee Other long-term liabilities Net cash flows from operating activities Purchases of property & equipment excluding capital leases Withdrawals out of (transfers into) our dedicated Department of Decrease (increase) in restricted cash Purchase of short-term marketable securities Maturities of short-term marketable securities Business acquisition Net cash flows from investing activities Proceeds from issuance of convertible debt Proceeds from issuance of convertible debt & other debt Proceeds from issuance of common stock in public Proceeds from issuance of warrants Proceeds from exercise of stock options & other stock issuance Proceeds from issuance of common stock in private placements Principal payments on DOE loans Purchase of convertible note hedges Common stock & convertible debt issuance costs Principal payments on capital leases & other debt Collateralized lease borrowings Net cash flows from financing activities Effect of exchange rate changes on cash & cash equivalents Net increase (decrease) in cash & cash equivalents Cash & cash equivalents at beginning of period Cash & cash equivalents at end of period Interest paid Income taxes paid 72,063 44,940 37,723 26,373 55,765 46,267 -1,573,860 -29,595 -24,362 263,345 322,203 36,721 442,295 23,697 -524,499 -1,634,850 -26,441 -12,260 -1,673,551 318,972 730,000 106,611 20,000 -17,025 -203,780 568,745 1,523,523 -34,278 -708,805 1,905,713 1,196,908 32,060 9,461 69,734 15,609 14,178 7,471 -1,891 -183,658 -1,050,264 -60,637 -4,493 252,781 162,075 209,681 106,230 249,492 61,968 -57,337 -969,885 -3,849 -205,841 189,131 -990,444 2,300,000 389,160 100,455 -603,428 -35,149 -11,179 3,271 2,143,130 -35,525 1,059,824 845,889 1,905,713 20,539 3,120 References: Industry Averages. (2017). Industry: Example Only - Major. Retrieved February 11, 2017 from: https://biz.yahoo.com/p/1conameu.html#f (Example link only) Mergent Online. (2017). Company A Retrieved January 21, 2017 from: 9,143 8,918 5,558 -10,692 3,611 3,655 -21,917 -463,270 -17,466 -342 -243 66,567 268,153 24,243 236,299 32,971 257,994 -264,224 14,752 55 -249,417 660,000 360,000 120,318 95,307 55,000 -452,337 -177,540 -16,901 -8,425 635,422 643,999 201,890 845,889 9,041 257 http://www.mergentonline.com.ezproxy.snhu.edu/companyfinancials.php?pagetype=asreported&compnumber=1&period=Annuals&dat Financial Ratios Company B, Inc. 2015 Price to Earnings Ratio Debt to Equity Ratio Return on Equity Ratio Earnings per Share (EPS) Gross Profit Margin Free Cash Flow (in thousands) Average Shares Outstanding (in thousands) 2014 2013 rted&compnumber=1&period=Annuals&dataarea=BS&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh ber=1&period=Annuals&dataarea=BS&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh ber=1&period=Annuals&dataarea=BS&range=3¤cy=AsRep&scale=AsRep&Submit=Refresh (Example link only) Financial Ratios Industry Averages 2015 2014 2013 Price to Earnings Ratio Debt to Equity Ratio Return on Equity Ratio Earnings per Share (EPS) Net Profit Margin Free Cash Flow (in thousands) Average Shares Outstanding (in thousands) References Company A, Inc. Historic Stock Prices Date Company B, Inc. Historic Stock Prices Close Reference 3-Year Return On Stock Price Date Close Reference xx% 3-Year Return On Stock Price xx%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
