Please see the instructions I am attaching showing step by step of the assistance I am requesting. Let me know if there are any questions.

Please notify me when you?re done.

Thank you so much

FINANCIAL ANALYSIS- INSTRUCTIONS Hi You will write a final Analysis paper that includes the following: Executive Summary: Introduce your company and its current status.. How are they performing? Are they profitable? Are they gaining or losing market share? Have they introduced new products?, etc. SWOT Analysis: Please include a comprehensive SWOT analysis about your chosen company. You should include 4-5 items under each heading (Strengths, Weaknesses, Threats, and Opportunities). Recommendations & Justifications: You will use the Recommendations below (or make up some of your own) and justify whether the firm should go along with the recommendation. Concluding thoughts: include what the potential is for your chosen company if they are able to execute your recommendations and the ramifications if they do not. As a financial consultant, what recommendations would you propose to current company management based on your findings? This added value content should include conclusions and recommendations for the firm going forward (as if you were a consultant for the firm). Adding value means having detailed conclusions and recommendations. Having detailed RECOMMENDATIONS and being able to JUSTIFY them are VERY IMPORTANT! Typical recommendations and conclusions that you will probably use include: Should the firm increase capital expenditures to increase competitiveness? Should the firm increase growth by acquiring other companies for synergies or grow internally? Should the firm risk increasing their leverage (debt) to increase earnings and return on capital or keep the leverage the same (or even decrease it?) Should the firm increase/decrease marketing spending? Should the firm increase/decrease R&D spending? How should they go about controlling costs including labor, health care, and pension liabilities? (GM and Ford need help in this department). There are many more recommendations you can offer. (Note: feel free to add more recommendations or change some of the ones above that fit your chosen company. Note that you want a minimum of at least 6 recommendations.) Feel free to be creative. If you make these recommendations, you want to list WHAT the recommendation is and JUSTIFY WHY the firm should embrace it (and how it benefits the firm). You are the chief financial consultant so you have full rein to make any recommendations. Feel free to use reference and be sure to cite them (APA) format if you do. References are not required though as the paper could be written entirely in your own words. I listed 6 common recommendations above and they are included in your Final Paper template. Feel free to use these and/or make up some of your own. The key is that you want to JUSTIFY any recommendation that you make. For example, if you recommend that a company should increase their capital expenditures, then justify why. Common justifications could that they need to increase capital expenditure to support their R&D spending, to expand domestic operations, or to expand internationally. You want to support your recommendations with thorough justifications. If you use references, then be sure to cite them using APA formatting. The format of your paper could be to list each Recommendation and Justify each one like below: Recommendation #1: Should the firm increase capital expenditures to increase competitiveness? Justification: Yes because to remain competitive, they need to invest in technologies to keep up with their main competitors. They also plan to expand internationally, so investing into these new markets and the learning curve involve will involve spending at least ? billion dollars. etc, etc, etc. Recommendation #2: Should the firm increase growth by acquiring other companies for synergies or grow internally? Justification: I feel that my company should grow internally. Due to my industry, acquiring a competitor involves integrating a different culture into our firm. Also, the companies are selling for such a high premium currently that it odes not justify buying our competitors. Finally, since our stock price is down currently and interest rates are high, it would be very expensive to borrow to finance the purchase. etc, etc, etc. For the Excel Tool Kit attached. For Amason.com. For this assignment, you will also complete the Financial Overview component of Amazon. To complete this assignment, use the Financial Analysis Toolkit Excel file, provided in the attachment, to complete a financial analysis of Amazon over the last two most recent years available in annual reports. Replace the numbers provided in the Excel file with the appropriate numbers for Amazon. Then, write a 2-3-page financial analysis of your company, addressing the following elements: I recommend using Yahoo's financial web site at http://finance.yahoo.com/ . Identify your company, its industry, and analyze the important segments (percentage of sales or subsidiaries) of your company compared to its industry and its overall business. Perform a complete financial analysis of your chosen company's financial statements horizontal, vertical (Percentage of Sales and Common-Size), and changes in ratiosfor the last two years. Compare all ratios to industry averages. Evaluate the company's ratios against the industry averages. Explain the significance of the company's ratios when compared to industry averages. Analyze the company's cash flows. Assess the overall financial health of your company based on this financial analysis. A great way to integrate the completed calculations from your Excel sheet into your written analysis is to paste pieces of the worksheet directly into your Word document. You are also encouraged to create graphs or charts from the data that may illustrate your analyses as well. Please notify me when you're done. Thank you so much A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 B C D E F G Tool Kit for Analysis of Financial Statements Financial statements are analyzed by calculating certain key ratios and then comparing them with the ratios of other firms and by examining the trends in ratios over time. We can also combine ratios to make the analysis more revealing, those indicated below are exceptionally useful for this type of analysis. RATIO ANALYSIS *Amazom.com, Inc. (AMZN) Fiscal Years starts and ends on Dec 31, such that FY14 represents Jan 01,2014 to Dec31, 2014 Input Data: 2014 2013 Year-end common stock price $310.35 $398.79 Year-end shares outstanding (in thousands) 46,200 45,700 Tax rate 41% 37% After-tax cost of capital Lease payments (in thousands) $0 $0 Required sinking fund payments $0 $0 Balance Sheets (in thousands of dollars) Assets Cash and equivalents Short-term investments Accounts receivable Inventories Total current assets Net plant and equipment Total assets 2014 $14,557,000 $2,859,000 $5,612,000 $8,299,000 $31,327,000 $23,178,000 $54,505,000 Liabilities and equity Accounts payable Notes payable Accruals Total current liabilities Long-term bonds Total liabilities Preferred stock Common stock (46200000 shares oustanding 2014 and 4570 Retained earnings Total common equity Total liabilities and equity $26,266,000 $0 $1,823,000 $28,089,000 $15,675,000 $43,764,000 $0 $5,000 $1,949,000 $10,741,000 $54,505,000 2013 $8,658,000 $3,789,000 $4,767,000 $7,411,000 $24,625,000 $15,534,000 * In addition to equpment also includes goodwill, intangible assets, $40,159,000 2014 3,319,000 2,892,000 $21,821,000 $0 $1,159,000 $22,980,000 $7,433,000 * In addition to Long Term Debt also include Other long term liabiliti $30,413,000 2014 $0 11,135,000 $5,000 -1,837,000 $2,190,000 -511000 $9,746,000 * Added to Total Common equity additional paid-in capital, treasuar $40,159,000 Income Statements (in thousands of dollars) Net sales Operating costs Earnings before interest, taxes, depr. & amort. (EBITDA) Depreciation Amortization Depreciation and amortization Earnings before interest and taxes (EBIT) Less interest Earnings before taxes (EBT) Taxes (40.93%, 37%) Net income before preferred dividends Preferred dividends Net income available to common stockholders Common dividends Addition to retained earnings 2014 $88,988,000.0 $88,298,000.0 $690,000.0 $362,000.0 $113,000.0 $475,000.0 $215,000.0 $289,000.0 -$74,000.0 $167,000.0 -$241,000.0 $0.0 -$241,000.0 $0.0 -$241,000.0 2013 $74,452,000.0 $73,559,700.0 $892,300.0 $246,000.0 $79,300.0 $325,300.0 $567,000.0 $132,000.0 $435,000.0 $161,000.0 $274,000.0 $0.0 $274,000.0 $0.0 $274,000.0 A 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 B C D 2014 $379,000.0 $23,557,000.0 $127,000.5 $234,000.0 $602,000.5 ($10,039,999.5) G 2013 ($2,144,000.0) $13,390,000.0 $357,210.0 $599,300.0 $682,510.0 N/A 2014 -$5.22 $0.00 $232.49 $5.06 ($217.32) 2013 $6.00 $0.00 $213.26 $13.11 N/A 2014 2013 Industry Average 1.12 0.82 1.07 0.75 2.22 1.3 2014 2013 Industry Average 10.72 23.0 3.84 1.63 10.05 23.37 4.79 1.85 2014 2013 80.29% 4.07 75.32% -0.74 2.39 75.73% 3.12 62.53% -4.30 6.76 2014 2013 -0.27% 0.39% -0.44% -2.24% 0.37% 1.41% 0.68% 2.81% Net operating working capital (NOWC) Total operating capital Net Operating Profit After Taxes (NOPAT) Net Cash Flow (Net income + Depreciation) Operating Cash Flow (OCF) Free Cash Flow (FCF) Calculated Data: Per-share Information Earnings per share (EPS) Dividends per share (DPS) Book value per share (BVPS) Cash flow per share (CFPS) Free cash flow per share (FCFPS) LIQUIDITY RATIOS Liquidity ratios Current Ratio Quick Ratio ASSET MANAGEMENT RATIOS Asset Management ratios Inventory Turnover Days Sales Outstanding Fixed Asset Turnover Total Asset Turnover 4.78 25.6 *Industry leader 1.89 *Industry leader 0.63 DEBT MANAGEMENT RATIOS Debt Management ratios Debt Ratio Debt-to-Equity Ratio Market Debt Ratio Times Interest Earned EBITDA Coverage Ratio Industry Average 39.30% *Industry leader 0.65 *Industry leader 24.40 *Industry leader 196.79 *Incorrect for 2014 and 2013 as interest combined is income not exp N/A PROFITABILITY RATIOS Profitability ratios Profit Margin Basic Earning Power Return on Assets Return on Equity Industry Average 19.96% 17.63% *Industry leader 12.56% 19.43% MARKET VALUE RATIOS 2014 Industry Average 2013 -59.49 61.27 20.78 1.33 Market Value ratios Price-to Earnings Ratio Price-to-Cash Flow Ratio Price-to-EBITDA Market-to-Book Ratio 66.51 30.41 20.42 1.87 25.77 9.66 5.13 *Industry Leader 3.59 COMMON SIZE ANALYSIS In common size income statements, all items for a year are divided by the sales for that year. Figure 3-2 Common Size Income Statements Net sales Operating costs Earnings before interest, taxes, depr. & amort. (EBITDA) Depreciation and amortization Earnings before interest and taxes (EBIT) Less interest Earnings before taxes (EBT) Taxes (40.93%, 37%) Net income before preferred dividends Preferred dividends Net income available to common stockholders (profit margi Industry Composite 2014 100.0% 72.1% 27.9% 0.0% 27.9% 0.0% 27.9% 7.3% 20.6% 0.0% 20.6% Amazon 2014 2013 100.0% ### 99.2% 98.8% 0.8% 1.2% 0.5% 0.4% 0.2% 0.8% 0.3% 0.2% -0.1% 0.6% 0.2% 0.2% -0.3% 0.4% 0.0% 0.0% -0.3% 0.4% In common sheets, all items for a year are divided by the total assets for that year. Figure 3-3 Common Size Balance Sheets Industry Composite 2014 144 145 146 147 148 149 150 151 152 153 154 155 F Calculated Data: Operating Performance and Cash Flows 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 E Assets Cash and equivalents Short-term investments Accounts receivable Inventories Total current assets Net plant and equipment Total assets Liabilities and equity 13.0% 11.5% 7.1% 5.6% 37.2% 62.8% 100.0% Amazon 2014 26.7% 5.2% 10.3% 15.2% 57.5% 42.5% 100.0% 2013 21.6% 9.4% 11.9% 18.5% 61.3% 38.7% 100.0% 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 A Accounts payable Notes payable Accruals Total current liabilities Long-term bonds Total liabilities Preferred stock Total common equity Total liabilities and equity B D 48.2% 0.0% 3.3% 51.5% 28.8% 80.3% 0.0% 19.7% 100.0% E 54.3% 0.0% 2.9% 57.2% 18.5% 75.7% 0.0% 24.3% 100.0% F PERCENT CHANGE ANALYSIS In percent change analysis, all items are divided by the that item's value in the beginning, or base, year. Figure 3-4 Income Statement Percent Change Analysis Base year = 2013 Net sales Operating costs Earnings before interest, taxes, depr. & amort. (EBITDA) Depreciation and amortization Earnings before interest and taxes (EBIT) Less interest Earnings before taxes (EBT) Taxes (40.93%, 37%) Net income before preferred dividends Preferred dividends Net income available to common stockholders Percent Change in 2014 19.5% 20.0% (22.7%) 0.0% (62.1%) 118.9% (117.0%) 3.7% (188.0%) 0.0% (188.0%) Balance Sheet Percent Change Analysis (not in textbook) Percent Change in 2014 Base year = 2013 Assets Cash and equivalents Short-term investments Accounts receivable Inventories Total current assets Net plant and equipment Total assets 68.1% -24.5% 17.7% 12.0% 27.2% 49.2% 35.7% Liabilities and equity Accounts payable Notes payable Accruals Total current liabilities Long-term bonds Total liabilities Preferred stock Common stock (46200000 shares oustanding 2014 and 4570 Retained earnings Total common equity Total liabilities and equity 20.4% 0.0% 57.3% 22.2% 110.9% 43.9% 0.0% 0.0% -11.0% 10.2% 35.7% DU PONT ANALYSIS (Section 3.8) 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 C 12.6% 0.4% 2.3% 15.3% 61.1% 76.4% 0.0% 23.6% 100.0% Amazon Amazon Industry Average 2014 2013 ROE = -2.24% 2.81% 20.72% (Profit margin) -0.27% 0.37% 19.96% (Equity (TA turnover) Multiplier) 1.63 5.07 1.85 4.12 0.63 1.65 G FINANCIAL ANALYSIS- INSTRUCTIONS Hi You will write a final Analysis paper about Amazon that includes the following: Executive Summary: Introduce your company and its current status.. How are they performing? Are they profitable? Are they gaining or losing market share? Have they introduced new products?, etc. SWOT Analysis: Please include a comprehensive SWOT analysis about your chosen company. You should include 4-5 items under each heading (Strengths, Weaknesses, Threats, and Opportunities). Recommendations & Justifications: You will use the Recommendations below (or make up some of your own) and justify whether the firm should go along with the recommendation. Concluding thoughts: include what the potential is for your chosen company if they are able to execute your recommendations and the ramifications if they do not. As a financial consultant, what recommendations would you propose to current company management based on your findings? This added value content should include conclusions and recommendations for the firm going forward (as if you were a consultant for the firm). Adding value means having detailed conclusions and recommendations. Having detailed RECOMMENDATIONS and being able to JUSTIFY them are VERY IMPORTANT! Typical recommendations and conclusions that you will probably use include: Should the firm increase capital expenditures to increase competitiveness? Should the firm increase growth by acquiring other companies for synergies or grow internally? Should the firm risk increasing their leverage (debt) to increase earnings and return on capital or keep the leverage the same (or even decrease it?) Should the firm increase/decrease marketing spending? Should the firm increase/decrease R&D spending? How should they go about controlling costs including labor, health care, and pension liabilities? (GM and Ford need help in this department). There are many more recommendations you can offer. (Note: feel free to add more recommendations or change some of the ones above that fit your chosen company. Note that you want a minimum of at least 6 recommendations.) Feel free to be creative. If you make these recommendations, you want to list WHAT the recommendation is and JUSTIFY WHY the firm should embrace it (and how it benefits the firm). You are the chief financial consultant so you have full rein to make any recommendations. Feel free to use reference and be sure to cite them (APA) format if you do. References are not required though as the paper could be written entirely in your own words. I listed 6 common recommendations above and they are included in your Final Paper template. Feel free to use these and/or make up some of your own. The key is that you want to JUSTIFY any recommendation that you make. For example, if you recommend that a company should increase their capital expenditures, then justify why. Common justifications could that they need to increase capital expenditure to support their R&D spending, to expand domestic operations, or to expand internationally. You want to support your recommendations with thorough justifications. If you use references, then be sure to cite them using APA formatting. The format of your paper could be to list each Recommendation and Justify each one like below: Recommendation #1: Should the firm increase capital expenditures to increase competitiveness? Justification: Yes because to remain competitive, they need to invest in technologies to keep up with their main competitors. They also plan to expand internationally, so investing into these new markets and the learning curve involve will involve spending at least ? billion dollars. etc, etc, etc. Recommendation #2: Should the firm increase growth by acquiring other companies for synergies or grow internally? Justification: I feel that my company should grow internally. Due to my industry, acquiring a competitor involves integrating a different culture into our firm. Also, the companies are selling for such a high premium currently that it odes not justify buying our competitors. Finally, since our stock price is down currently and interest rates are high, it would be very expensive to borrow to finance the purchase. etc, etc, etc. For the Excel Tool Kit attached. For Amason.com. For this assignment, you will also complete the Financial Overview component of Amazon. To complete this assignment, use the Financial Analysis Toolkit Excel file, provided in the attachment, to complete a financial analysis of Amazon over the last two most recent years available in annual reports. Replace the numbers provided in the Excel file with the appropriate numbers for Amazon. Then, write a 2-3-page financial analysis of your company, addressing the following elements: I recommend using Yahoo's financial web site at http://finance.yahoo.com/ . Identify your company, its industry, and analyze the important segments (percentage of sales or subsidiaries) of your company compared to its industry and its overall business. Perform a complete financial analysis of your chosen company's financial statements horizontal, vertical (Percentage of Sales and Common-Size), and changes in ratiosfor the last two years. Compare all ratios to industry averages. Evaluate the company's ratios against the industry averages. Explain the significance of the company's ratios when compared to industry averages. Analyze the company's cash flows. Assess the overall financial health of your company based on this financial analysis. A great way to integrate the completed calculations from your Excel sheet into your written analysis is to paste pieces of the worksheet directly into your Word document. You are also encouraged to create graphs or charts from the data that may illustrate your analyses as well. Please notify me when you're done. Thank you so much Running Head: FINANCIAL ANALYSIS 1 Financial Analysis Students Name Executive summary FINANCIAL ANALYSIS 2 This report created from the financial statements of The Amazon.com, Inc. Company (AMZN) provides an analysis and evaluation of the actual and the prospective liquidity, profitability and the financial stability of the company. The methods that have been used in the analysis include trend analysis, the vertical analysis and the horizontal analysis. Also we have used certain analysis such as Quick ratio, debt ratio, and the current ratios. More calculations that have been used includes the returns on the owners equity, the earning per share, net operating working capital, total operating capital, net operating capital, net operating profit after taxes, operating cash flow and free cash flow. A result from the data reveals that, all the company ratios are above the industries averages. Comparative performance is good in the area of the liquidity, credit control and inventory management. The report finds that the tidings for the company are positive in the near future. The major areas of weakness highlighted require further investigation and immediate action by management. The recommendations that were provided include; Improving the average accounts receivable collection period, Raising/ increasing the inventory turnover and reduction of prepayments in order to have enough operating cash for the subsequent periods. The investigation in this report also had its shortcomings that arose and are highlighted as; FINANCIAL ANALYSIS 3 The forecasted figures used are estimates that sometimes maybe arbitrate; we also cannot fully provide data on the position of other companies with the data limitation we have experienced. The monthly details would have given us more information from which we could base a proper in year trend analysis, rather than the blanket whole year analysis provided. Though we had the above mentioned strain in preparation of this report, we still great belief that the analysis provided is best suited to show the standing of the Amazon.com, Inc. Company (AMZN). In the financial report below, the strengths, weakness, opportunity and threats have been highlighted as we analyze the various financial sub segments. Identify your company, its industry, and analyze the important segments (percentage of sales or subsidiaries) of your company compared to its industry and its overall business Amazon.com, Inc. operates as an online retailer in North America and internationally. It operates through the North America, International, and Amazon Web Services (AWS) segments. The company serves consumers through retail websites, such as amazon.com, amazon.ca, and amazon.com.mx, which primarily include merchandise and content purchased for resale from vendors and those offered by thirdparty sellers. Amazon.com, Inc. was founded in 1994 and is headquartered in Seattle, Washington. The only company that has been able to match the flirtatious margins by competitors. This development must be watched to avoid the company slipping into a deep competition for sales. The company falls under the Catalog & Mail Order Houses Industry which is a service sector industry. Perform a complete financial analysis of your chosen company's financial statements horizontal, vertical (Percentage of Sales and Common-Size), and changes in ratiosfor the last two years. FINANCIAL ANALYSIS 4 In the income statement the revenue of 88.98 billion is an increase as compared to the financial year ended 31st December 2013 where it was at 74.45billion, which is a 19.52% increase. Such a positive increase is encouraging though it's not the best for company since it was raised against the increased net receivables. Such a situation is a weakness to the company since growth in sales with increased net receivables will have a negative impact in the future. Net receivables increase is a potential for increased bad debt which will be a threat to the long term operation of Amazon Company. The negative revenue growth is a weakness to the company since decreased growth will mean that the net profits will reduce. FINANCIAL ANALYSIS 5 The gross profit of the co is a decrease from the previous year. The earning before interest and taxes of 0.69 billion is lower than the markets EBITDA but lower than 2013. The amount of sales being higher than 2013 is strength but it gross profit being lower than that 2013 is a weakness. The balance sheet show the earning per share of -5.22 that is below the market and 2013 so it is the list EPS in the whole industry. Such a case is a weakness that must be analyzed by the board. It can be corrected by the board increasing the amount that is attributable for dividends and reducing the investment. FINANCIAL ANALYSIS 6 Compare all ratios to industry averages. Evaluate the company's ratios against the industry averages FINANCIAL ANALYSIS 7 The ratios provided for the market and the specific companies that are provided are the operating margin, gross margin, earning per share and price per earning. The gross margin of the co is the lowest in the industry. The margin being lower than that of the market means that the company has a greater cushion in terms of loss and the amount of loss that can be accommodated is quite large. This is one of the weaknesses of the company that is highly disregards in terms of boosting long term earnings. The earnings per share of the co is negative in year 2014 compare to market which is a weakness that the management must analyze and make changes in terms of the amount attributed to shareholder. The levels of comparison show that the company is operating below the market rates and therefore are at a risk threat of losing the shareholders. FINANCIAL ANALYSIS 8 Compare all ratios to industry averages. Evaluate the company's ratios against the industry averages. The company's ratios are quite lower than the market ratios in vital ratios such as the gross margin and the operating margin as compared to industries. The only ratio where the company performed below the industry is in the EPS where they showed a weakness at negative EPS against the markets positive EPS. Analyze the company's cash flows. The net cash flows for the year end period to December 2014 at negative meaning that the company ended the year with a negative outflow. The company also showed some form of laxity in changing the debtor's period and the creditor's period in order to better their cash in hand. This is a weakness that will threaten the performance of the company in the next financial year. The financial year returns from investment activities were all negative returns meaning that either most of the investments were at the early development with opportunity that the inflow will be positive in the future. FINANCIAL ANALYSIS 9 Assess the overall financial health of your company based on this financial analysis. The company is financially healthy since they can be able to meet their current obligations when they arise. The total current assets stand at 31,327,000 against the current liability of 28,089,000. From this data we can say that the company in the short term is financially healthy. This is an opportunity for the company to gain for the operations of the year and invest more to increase liquidity. Further more in the long-term the company is still solvent with assets of 54,505,000 against the liability of 43,764,000. This is another strong point and an opportunity to counter the competitors with lower assets to cover for the liability The company has been faced by the threat of contingency liabilities that affects the operation of the business. Contingencies though not recorded in the statement are potential source of cash outflow if those cases are ruled against the company. The law suits include those filed in relation to monopolistic and discriminatory practices. Some of those cases that have been settled out of court have ended up costing the company a lot of money. Such situations affect the company's cash flow and also the long term position of the state. The emergence of other co's as a strong competitor is worrying for the company and is also a big threat too. The other has had market capitalization which is higher than the markets and that of Amazon. Such emergence is a threat to the market share of sales and the oversea market strategy. References http://finance.yahoo.com FINANCIAL ANALYSIS 10