PLEASE HELP ME WITH THE REQUIREMENTS A. Prepare comparative Balance Sheets for 2016 and 2017, showing peso and percentage increases or decreases (Horizontal Analysis).B. Prepare Income Statement for the year ended December 31, 2017 with common-size percentages (Vertical Analysis). C. Evaluate the Firm's Liquidity, Leverage, Efficiency, Profitability, and Market Growth for 2017 by computing: with solutions 1. Net Working Capital 2. Current Ratio 3. Quick Ratio 4. Accounts Receivable Turnover 5. Average Collection Period (use 360 days) 6. Inventory Turnover 7. Day's Supply in Inventory 8. Accounts Payable Turnover 9. Current Asset Turnover 10. Debt-to-Asset Ratio 11. Debt-to-Equity Ratio 12. Capital Ratio 13. Interest Coverage Ratio 14. Operating Cycle 15. Gross Profit Margin 16. Operating Ratio 17. Operating Profit Margin 18. Net Profit Margin 19. Operating Return on Assets 20. Return on Assets 21. Return on Equity 22. Earnings per Share 23. Price/Earnings Ratio 24. Dividends per share 25. Dividend Payout Ratio

A. FINANCIAL STATEMENT ANALYSIS December 31 Balance Sheet Accounts 2016 2017 AMOUNT PERCENT P Cash on Hand P30,00 P52.000 (22,000) (42.30 0 Marketable Securities 170,00 200,000 (30,000) (15.00) 0 Accounts Receivable, net 100,00 200,000 (100,000) (50.00) Inventories 150,00 100,000 50,000 50.00 0 Machinery & Equipment, net 340,00 300,000 40,000 13.33 D Land and Building, net 110,00 100.000 10,000 10.00 Goodwill 80,000 80.000 0 0.00 Deferred Charges 20,000 18,000 2.000 11.11 Notes Payable 20,000 30,000 (10,000) (33.33) Accounts Payable 122,00 158,000 (36,000) (22.78) D Salaries Payable 12.000 (4,000) (33.33) 8,00 0 Long-term Notes-Due 2025 500,00 450.000 50,000 11.11 0 15% Preference Shares, P100 par 100,00 100,000 0.00 D Common Shares, P10par 200,00 200,000 0.00 Retained Earnings 50.000 100,000 (50,000) (50.00) 2017 Income Statement Accounts Sales P1,050,000 Sales returns and allowances 50,000 5% Inventory, December 31, 2017 100,000 10% Inventory, December 31, 2016 150,000 14% Purchases 550,000 52% Selling Expenses 80,000 79% Administrative Expenses 120,000 11% Interest on Long-term notes 50,000 5% Income Taxes, 35% 52,500 5% Additional Information: 1. Dividends paid on preference shares 15,000 1% 2. Dividends paid on common shares 32,500 3% 3. Market price per share of common shares 18