Tiwala Lhungz Company Income Statement Tiwala Lhungz Company Balance Sheet As of December 31, 2016 Forthe yearended December 31, 2016 2016 2015 2016 2015 P8,000, 000.00 P6,500,000.00 5,000,000.00 4,000,000. 00 3,000, 000.00 2,500,000. 00 1,300,000. 00 1,000,000. 00 1,700,000.00 50,000.00 1,650,000.00 660,000.00 990,000.00 Assets Net Sales Current Assets: Less: Cost of Goods Sold Cash 2, 500,000 Gross Margin P2,800,000.00 800,000.00 900,000.00 490,000.00 93,000.00 5,083,000.00 Marketable Securities 700,000.00 Less: Operating Expenses Operating Income Less:Interest Expense Accounts Receivable (net) 900,000.00 260,000.00 74,000.00 4,434,000.00 1,500,000.00 50,000. 00 1,450,000.00 580,000. 00 870,000.00 Inventories Other Current Assets Interest before taxes Total Current Assets Less: Income Tax Non-Current Assets: Netincome 1,500,000.00 1,340,000.00 2,840,000.00 7,923,000.00 1, 500,000.00 1,150,000.0 2,650,000.00 7,084,000.00 Land Analyze using: A. Horizontal Analysis B. Vertical Analysis Building (net) Total Non-Current Assets Total Assets C. Ratio Analysis 1. Return on Sales Liabilities and Stockholder's Equity Current Liabilities: 2. Return on Assets Accounts Payable Notes Payable Accrued payables 290,000.00 1,100,000.00 200,000.00 1, 590, 000.00 101,500.00 540,000.00 57,000.00 698,500.00 3. Average Total Assets 4. Average Common Stockholder's Equity 5. Return on Stockholder's Equity 6. Earnings per share 7. Price-Earnings Ratio Total Current Liabilities Non-Current Liabilities: Bonds Payable, 10% 50,000.00 1,640,000.00 50,000.00 8. Current Ratio Total Liabilities 748,500.00 9. Quick Ratio Stockholder's Equity: Common Stock, P1.50 par Additional Paid-in Capital Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity 10. Accounts Receivable Turn-over Ratio 3,000,000.00 2,000,000.00 1,283,000.00 6,283,000.00 7,923,000.00 3,000,000.00 2,000,000.00 1,335,500.00 6,335,500.00 7,084,000.00 11. Average Accounts Receivable 12. Average Age of Receivable 13. Inventory Turn-ove Ratio 14. Average Inventory 15. Average age of inventories 16. Times interest Earned Ratio 17. Debt Ratio 18. Debt-to-equity Ratio
Tiwala Lhungz Company Income Statement Tiwala Lhungz Company Balance Sheet As of December 31, 2016 Forthe yearended December 31, 2016 2016 2015 2016 2015 P8,000, 000.00 P6,500,000.00 5,000,000.00 4,000,000. 00 3,000, 000.00 2,500,000. 00 1,300,000. 00 1,000,000. 00 1,700,000.00 50,000.00 1,650,000.00 660,000.00 990,000.00 Assets Net Sales Current Assets: Less: Cost of Goods Sold Cash 2, 500,000 Gross Margin P2,800,000.00 800,000.00 900,000.00 490,000.00 93,000.00 5,083,000.00 Marketable Securities 700,000.00 Less: Operating Expenses Operating Income Less:Interest Expense Accounts Receivable (net) 900,000.00 260,000.00 74,000.00 4,434,000.00 1,500,000.00 50,000. 00 1,450,000.00 580,000. 00 870,000.00 Inventories Other Current Assets Interest before taxes Total Current Assets Less: Income Tax Non-Current Assets: Netincome 1,500,000.00 1,340,000.00 2,840,000.00 7,923,000.00 1, 500,000.00 1,150,000.0 2,650,000.00 7,084,000.00 Land Analyze using: A. Horizontal Analysis B. Vertical Analysis Building (net) Total Non-Current Assets Total Assets C. Ratio Analysis 1. Return on Sales Liabilities and Stockholder's Equity Current Liabilities: 2. Return on Assets Accounts Payable Notes Payable Accrued payables 290,000.00 1,100,000.00 200,000.00 1, 590, 000.00 101,500.00 540,000.00 57,000.00 698,500.00 3. Average Total Assets 4. Average Common Stockholder's Equity 5. Return on Stockholder's Equity 6. Earnings per share 7. Price-Earnings Ratio Total Current Liabilities Non-Current Liabilities: Bonds Payable, 10% 50,000.00 1,640,000.00 50,000.00 8. Current Ratio Total Liabilities 748,500.00 9. Quick Ratio Stockholder's Equity: Common Stock, P1.50 par Additional Paid-in Capital Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity 10. Accounts Receivable Turn-over Ratio 3,000,000.00 2,000,000.00 1,283,000.00 6,283,000.00 7,923,000.00 3,000,000.00 2,000,000.00 1,335,500.00 6,335,500.00 7,084,000.00 11. Average Accounts Receivable 12. Average Age of Receivable 13. Inventory Turn-ove Ratio 14. Average Inventory 15. Average age of inventories 16. Times interest Earned Ratio 17. Debt Ratio 18. Debt-to-equity Ratio
Financial & Managerial Accounting
13th Edition
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Carl Warren, James M. Reeve, Jonathan Duchac
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 15.1APR: Horizontal analysis of income statement For 2016, Clapton Company reported a decline in net income....
Related questions
Question
100%
Requirements:
Prepare a Ratio Analysis
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
Recommended textbooks for you
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Corporate Financial Accounting
Accounting
ISBN:
9781305653535
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Corporate Financial Accounting
Accounting
ISBN:
9781305653535
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning