Excel sheet is provided below, please fill in all missing


Question Description:

24.99

Excel sheet is provided below, please fill in all missing information. accfinalexam.xlsx This project is comprised of 3 parts: – Horizontal Analysis of an Income Statement: Complete the horizontal analysis given data for the XYZ Company. See part a tab. – Vertical Analysis of an Income Statement: Complete the vertical analysis given data for the XYZ Company. See part b tab. – Ratio Analysis and Comparison: Complete the ratio analysis for the XYZ Company, see part c tab. Compare your calculated ratios to the given industry ratios by category. Provide your assessment/future outlook of the XYZ Company XYZ Company Income Statement For the year ended 12/31/2015 12/31/2014 Horizontal Analysis Net sales Cost of goods sold Gross profit Research & development Selling expenses Administrative expenses Depreciation expense Patent amortization expense Income (loss) from operations Other revenue (expense), net Net income (loss) $435,760 135,465 300,295 50,000 49,400 156,900 74,000 4,000 -34,005 -25,400 ($59,405) * Comprised mostly of Interest Expense for 2015 Comment on the significance of the trend results: $335,200 105,230 229,970 55,000 38,000 142,100 36,000 333 -41,463 427 ($41,036) XYZ Company Income Statement For the year ended 12/31/2015 Vertical Analysis 12/31/2014 Vertical Analysis Net sales Cost of goods sold Gross profit Research & development Selling expenses Administrative expenses Depreciation expense Patent amortization expen Income (loss) from operati Other revenue (expense), Net income (loss) $435,760 135,465 300,295 50,000 49,400 156,900 74,000 4,000 -34,005 -25,400 ($59,405) * Comprised mostly of Interest Expense for 2015 Comment on the significance of the trend results: $335,200 105,230 229,970 55,000 38,000 142,100 36,000 333 -41,463 427 ($41,036) Compute the following ratios for XYZ Company for 2015 (See Balance Sheet below). Comment on the results when compared to the industry averages and provide your thoughts as far as the future outlook for XYZ Company. Ratios for XYZ Industry Averages Comparison/Analysis Ÿ Liquidity: 1.75:1 Ÿ Current 1.16:1 Ÿ Quick Ratio 7.59 Ÿ Receivables Turnover Ÿ Solvency: 73% Ÿ Debt Ratio Ÿ Profitability: 37% Ÿ Return on equity 20% Ÿ Return on assets 20% Ÿ Asset turnover Overall Future Outlook for XYZ Company: Comparative Balance Sheets 2015 Assets Current assets Cash Notes receivable Accounts receivable, net Interest receivable Inventory Office supplies Prepaid insurance Total current assets Property, plant and equipment Building Less: accumulated depreciation Equipment Less: accumulated depreciation Investments Patent Total assets Liabilities and Stockholders’ Equity Current liabilities Notes payable Accounts payable Interest payable Wages payable Total current liabilities Long term liabilities Bonds payable Total liabilities Common Stock ($1 par) Additional Paid-In Capital Retained Earnings Less: Unrealized loss on Available For Sale Securities Total stockholders’ equity Total liabilities and stockholders’ equity 2014 429,802 0 39,200 1,200 20,840 7,000 0 498,042 66,420 5,500 45,000 27 12,250 6,400 12,000 147,597 120,000 120,000 48,000 24,000 246,000 46,000 62,000 12,000 349,500 15,667 1,119,209 0 19,667 297,264 50,000 60,250 28,600 7,200 146,050 79,000 492,000 717,050 124,600 380,000 -100,441 64,000 80,400 3,600 6,700 154,700 79,000 0 233,700 104,600 0 -41,036 -2,000 0 402,159 63,564 1,119,209 297,264 Read more

Answer

24.99