I need help filling out the financial info so I can make a analysis based on the info.

Prompt:Produce a financial statement analysis and valuation report that summarizes the financial health, projected future performance, and estimated value of the publicly traded (S&P 500) company that you selected at the beginning of the course. As an independent financial accounting analyst working for a major trade journal, your report is intended to inform a general audience about the overall financial well-being of the company and how it compares to a major competitor. Your report should cover information of interest to both internal and external stakeholderssummarizing major findings, suggesting ways to improve operational performance, and assessing investment potential. Keep in mind that brief, clear communications are essential in effectively reaching business and media audiences.

I have chosen Amazon. I am having issues completing the section below and filling out the images I have posted.

Specifically, the following critical elements must be addressed:I.Balance Sheet Analysis.In this section, use financial statements and accompanying notes to:A.Analyze what the companys current and prior year liquidity and debt-to-equity ratios say about the companys financial health, justifying your response. Consider the appropriate level of debt and how this years performance compares to the previous years.B.Consider normalization adjustments when adjusting the balance sheet to be comparable to competitors, when creating the prospective balance sheet, and when calculating the final company valuation as either a premium or discount. (Include your analysis spreadsheet in Excel as an appendix.)C.Analyze the companys balance sheet for the current and previous year using a horizontal analysis. (Include your horizontal analysis spreadsheet in Excel as an appendix.) Explain your findings.D.Comparison.Analyze the competitors balance sheet indicators for opportunities for the selected company to improve its own performance. Justify your response using the financial statements of both the company and its competitor.II.Income Statement and Cash Flow Analysis.In this section, use financial statements and accompanying notes to:A.Analyze the profitability of your selected company using appropriate profitability ratio(s) and a vertical analysis of the companys current and prior year income statement. (Include your vertical analysis spreadsheet in Excel as an appendix.)Be sure to explain your findings.B.Normalization adjustments.Analyze historical income statements to determine whether there were any non-recurring or extraordinary items that should be removed from the income statement. An example would be aggressive expense recognition or conservative revenue recognition, which could either depress or inflate earnings. Adjusting these items will make the target company more comparable to the others.C.Free cash flow.Analyze what your selected companys free cash flow figures for the current and prior year say about the companys financial health. Consider other sources or uses of available discretionary cash.D.Dividend paying capacity of the company.Determine if the company is on track to pay out dividends this year and whether the dividend payout ratio increase or decrease.

Show transcribed image text

Common-size analysis 2013 2014 2015 2016 2017 2013 2014 2015 2016 2017 Assets . $ - 31.7 E Current Assets Cash and cash equivalents Accounts receivable, net Inventory Other current assets Total current assets 17,8s 3.15 234 1,953 31,327 20,043 5,3] 10.243 2,70[] 35,705 26,531 7,765 11,461 4.12 45,731 32.321 12.174 iE,047 5575 E0,137 30.0 * 30.9 7 3 15. 3 13. 3 24. 13 12.2 Property, plant & equipment, net 22,730 :30,053 42,441 72.65E | | Other assets Intangibles Other assets Total other assets 4,083 371 5,054 4,751 1,953 4,639 2,70[] 7,33g iE,721 4,12 20,347 E 7]. | | Total Assets 56,34] 67,00 36,022 1:31,31g * 105.3 * 112.0 115.3 121.4 Liabilities and Stockholders' Equity $ 1E.453 20,337 $ 25,33 34.51 . 23.2 30.4 ; 23.4 ; 26.4 Current Liabilities Accounts payable Accrued expenses & other current liabilities Current portion of debt and leases Total current liabilities 18, 459 20,33? 25,303 34.616 30.4 23, 28 Long-Term Liabilities Long-term debt and lease obligations Other long-term liabilities Total long-term liabilities | |:|: 1:| Total Liabilities 1E,454 20,337 25,303 34,61 |#| 1:| # 1:| 1:| 1:| | | | | | | 1:| # Stockholders' Equity Common stock, less treasury Additional paid in capital Retained earnings Other comprehensive income (loss) Total Stockholders' Equity * 16, 453 20,337 25,303 34,61 | | 23.2 30.4 23.4 * _26.4 33,881 48,611 60,713 36,634 2013 3 Common-size analysis 2014 2015 2016 2017 % - % - % - % - % Sales Cost of Sales Gross Profit General, administrative and non-operating expenses | | | | | 1 | Operating Income ..!!!! Other Income (Expense) Interest (expense) Gain (loss) on sale of assets Other 11 11 || | I... ...! M | | Normalization adjustments Non-recurring items Legal settlements Other H.. 11 11 Net income, before tax 2018 2019 2020 2021 2022 Terminal Revenue S $ $ $ - $ - - 257 - 257 - 257 - 25% Gross profit Facendaye ofrecenze 0 500 0 500 0 5 Operating expenses Favereye ofrecede 50% . Other income (expense) Interest income (expense) Other Avenaye ofreceve 0.0% 0.0% 00% 00% 0.0% Net income - S - S - S - S 2.6 % 6.0 Risk-free long term U.S. Government bond rate Equity risk premium Industry premium estimate Specific company risk Note (A) (B) (C) (D) 1.5 3.0 Cost of equity (Discount rate) Less: Long-term sustainable growth rate 13.1 (2.5) Sum of (A) - (D) (E) Capitalization rate 10.6 % (A) Yield on the twenty-year U.S. Treasury bond as of December 31, 20XX, per the U.S. Treasury (B) Long-horizon expected return of large stocks over risk free securities, U.S. Equity Risk Premium (6.0%) (C) SIC code XX, 1.5% (D) Appraiser's judgement concerning company-specific risk (E) Estimated long-term growth rate based on inflation, Federal Reserve Bank of Philadelphia Sources: United States Treasury ***You may use other sources to update any of these values, list the applicable source if used. Existing values are actual figures obtained from sources used in prior years. You may use these as default values since a detailed development of the discount rate is beyond the scope of this class. Projected for Years Ending December 31, Terminal 2019 2022 Value 2018 $ - 2020 . 2021 . Forecasted Net Income Plus: Depreciation Less: Capital expenditures Debt reduction I Net Cash Flow Present value of cash flows ] Discount rate: 13.1% Terminal period cash flows Capitalization rate: 10.6% 10.6% Capitalized terminal cash flow Net present value of terminal cash flow, discounted into perpetuity Net present value - five years ending YE: 2022 Net present value of terminal cash flow Total indication of value (rounded) 1 2 3 4 5 Income Approach: Discounted Cash Flow Method Indicated Value of Equity Weight 100 Weighted Value (rounded) Indicated value with voting rights Less: DLOC (Discount for Lack of Control) 15.0% Marketable, minority value Less: DLOM (Discount for Lack of Marketability) 25.0% Nonmarketable, minority value Value of a one-percent interest (in millions) Common-size analysis 2013 2014 2015 2016 2017 2013 2014 2015 2016 2017 Assets . $ - 31.7 E Current Assets Cash and cash equivalents Accounts receivable, net Inventory Other current assets Total current assets 17,8s 3.15 234 1,953 31,327 20,043 5,3] 10.243 2,70[] 35,705 26,531 7,765 11,461 4.12 45,731 32.321 12.174 iE,047 5575 E0,137 30.0 * 30.9 7 3 15. 3 13. 3 24. 13 12.2 Property, plant & equipment, net 22,730 :30,053 42,441 72.65E | | Other assets Intangibles Other assets Total other assets 4,083 371 5,054 4,751 1,953 4,639 2,70[] 7,33g iE,721 4,12 20,347 E 7]. | | Total Assets 56,34] 67,00 36,022 1:31,31g * 105.3 * 112.0 115.3 121.4 Liabilities and Stockholders' Equity $ 1E.453 20,337 $ 25,33 34.51 . 23.2 30.4 ; 23.4 ; 26.4 Current Liabilities Accounts payable Accrued expenses & other current liabilities Current portion of debt and leases Total current liabilities 18, 459 20,33? 25,303 34.616 30.4 23, 28 Long-Term Liabilities Long-term debt and lease obligations Other long-term liabilities Total long-term liabilities | |:|: 1:| Total Liabilities 1E,454 20,337 25,303 34,61 |#| 1:| # 1:| 1:| 1:| | | | | | | 1:| # Stockholders' Equity Common stock, less treasury Additional paid in capital Retained earnings Other comprehensive income (loss) Total Stockholders' Equity * 16, 453 20,337 25,303 34,61 | | 23.2 30.4 23.4 * _26.4 33,881 48,611 60,713 36,634 2013 3 Common-size analysis 2014 2015 2016 2017 % - % - % - % - % Sales Cost of Sales Gross Profit General, administrative and non-operating expenses | | | | | 1 | Operating Income ..!!!! Other Income (Expense) Interest (expense) Gain (loss) on sale of assets Other 11 11 || | I... ...! M | | Normalization adjustments Non-recurring items Legal settlements Other H.. 11 11 Net income, before tax 2018 2019 2020 2021 2022 Terminal Revenue S $ $ $ - $ - - 257 - 257 - 257 - 25% Gross profit Facendaye ofrecenze 0 500 0 500 0 5 Operating expenses Favereye ofrecede 50% . Other income (expense) Interest income (expense) Other Avenaye ofreceve 0.0% 0.0% 00% 00% 0.0% Net income - S - S - S - S 2.6 % 6.0 Risk-free long term U.S. Government bond rate Equity risk premium Industry premium estimate Specific company risk Note (A) (B) (C) (D) 1.5 3.0 Cost of equity (Discount rate) Less: Long-term sustainable growth rate 13.1 (2.5) Sum of (A) - (D) (E) Capitalization rate 10.6 % (A) Yield on the twenty-year U.S. Treasury bond as of December 31, 20XX, per the U.S. Treasury (B) Long-horizon expected return of large stocks over risk free securities, U.S. Equity Risk Premium (6.0%) (C) SIC code XX, 1.5% (D) Appraiser's judgement concerning company-specific risk (E) Estimated long-term growth rate based on inflation, Federal Reserve Bank of Philadelphia Sources: United States Treasury ***You may use other sources to update any of these values, list the applicable source if used. Existing values are actual figures obtained from sources used in prior years. You may use these as default values since a detailed development of the discount rate is beyond the scope of this class. Projected for Years Ending December 31, Terminal 2019 2022 Value 2018 $ - 2020 . 2021 . Forecasted Net Income Plus: Depreciation Less: Capital expenditures Debt reduction I Net Cash Flow Present value of cash flows ] Discount rate: 13.1% Terminal period cash flows Capitalization rate: 10.6% 10.6% Capitalized terminal cash flow Net present value of terminal cash flow, discounted into perpetuity Net present value - five years ending YE: 2022 Net present value of terminal cash flow Total indication of value (rounded) 1 2 3 4 5 Income Approach: Discounted Cash Flow Method Indicated Value of Equity Weight 100 Weighted Value (rounded) Indicated value with voting rights Less: DLOC (Discount for Lack of Control) 15.0% Marketable, minority value Less: DLOM (Discount for Lack of Marketability) 25.0% Nonmarketable, minority value Value of a one-percent interest (in millions)