Need % of sales and forecast for 2019.
Also questions after statements are done.
Can you please show the work. I have done them myself but I want to see if I am right.
Complete the Pro-forma Financial Statements using a standardized format based on the assumptions below: Assumptions 1) The sales are projected to increase by 20% in 2019 2) All other expenses in 2019 are expected to grow proportionally as a percentage of sales with the increase in sales. 3) The average tax rate is expected to be 25.7% 4) The dividend payout ratio is expected to remain 0% in 2019 5) Both current assets and long term assets are expected to increase proportionally with the increase in sales in 2019 6) Current Liabilities and Long-Term Liabilities are unchanged from 2018 7) The company is not expected to finance from shareholders, i.e. Common Stock, Cap Surplus, Treasury Stock, Other Equity accounts are unchanged. Hint: Retained Earnings IS affected 8) Depreciation remains a constant percentage of Fixed Assets, there are no income adjustments. 9) Changes in Operating Activities are constant percentage of Sales; there are no cash flow changes from Investing Activities Amazon Consolidated Statement of Operations (Income Statement) USD in millions 2018 % of sales 2019 (Est) Total Revenue 232,887 Cost of Revenue 139,156 Gross Profit 93,731 Operating Expenses Research & Development 0 Sales, General, and Administrative 81,310 Non-Recurring Items Operating Income 12,421 Add'l Income/expense items 257 Earnings Before Interest and Taxes 12,678 Interest Expense 1,417 Earnings Before Taxes 11,261 Income Taxes 1,197 Equity Earnings/Loss Unconsolidated Subsidiary 9 Net Income 10,073 Dividend Payout Ratio 0%Amazon Balance Sheet USD in millions 2018 % of sales 2019 (Est) 2018 % of sales 2019 (Est) Current Assets Current Liabilities Cash and Cash Equivalents 31,750 Accounts Payable 61,855 Short-Term Investments 9,500 Short-Term Debt/Current portion of Long-Term Debt 0 Net Receivables 16,677 Other Current Liabilities 6,536 Inventory 17,174 Other Current Assets 0 Total Current Assets 75,101 Total Current Liabilities 58,391 Long Term Assets Long Term Liabilities (including debt) Long-Term Investments 0 Long-Tem Debt 23,495 Fixed Assets 61,797 Other Liabilities 27,213 Goodwill 14,548 Deferred Liability Charges 0 Intangible Assets Misc. Stocks Other Assets 11,202 Minority Interest O O Deferred Asset Charges 0 Total Long Term Assets 87,547 Long Term Liabilities (including debt) 50,708 Total Assets 162,648 Total Liabilities 119,099 Owner's Equity Common Stocks 5 Capital Surplus 26,791 Retained Earnings 19,625 Treasury Stock -1,837 Other Equity -1,035 Total Owners Equity 43,549 Total Liabilities and Owners Equity 162,648 Required External FinancingAmazon Cash Flow Statement USD in millions 2019 [Est] Net Income Cash Flows Operating Activities Depreciation Net Income Adjustments Changes in Operating Activities Accounts Receivable Changes in lnventc-rlyr Other Operating Activities Liabilities Cash Flows Operating Activities Capital Expenditures Investments Other Investing Activities Net Cash Flows - Investing Activities Sales and Purchase of Stock Net Borrowings Other Financing Activities Net Cash Flows Financing Activities Effect of Exchange Rate Net Cash Flow Question 1 Total revenue Forecast Gross Profit Forecast Operating Income Forecast Net Income Forecast Total Current Assets Forecast Total Long Term Assets Forecast Total Current Liabilities Forecast Total Long Term Liabilities Forecast Transfer to Retained Earnings Total Owners' Equity Forecast Required External Financing Cash Flows - Operating Activities Forecast Cash Flows - Investing Activities Forecast Cash Flows - Financing Activities Forecast Net Cash Flow ForecastShort-Term Solvency/Liquidity Ratios Current ratio Quick Ratio Cash Ratio NWC to Total Assets Interval Measure Long-Term Solvency/Liquidity Ratios Total debt ratio Debt-equity ratio Equity multiplier Long-term debt ratio Times interest earned ratio Cash coverage ratio Long-Term Solvency/Liquidity Ratios Efficiency/Asset management/Turnover Inventory turnover Days's sales in inventory NWC turnover Fixed Asset turnover Total asset turnover Profitability Ratios Profit margin Return on Assets (ROA) Return on Equity (ROE) DuPont Identity (give formula and numbers) Profitability Ratios Price-earnings Ratio PEG ratio Price-sales ratio Market-to-book ratio Tobin's Q ratio Enterprise value to EBITDA ratio
