Homework Help is Here – Start Your Trial Now!
Business
Accounting
Requirement: Prepare a Horizontal and Vertical Analysis for the Statement of Financial Position and Statement of Comprehensive Income.  Write it on any piece of paper in good form (report form). Please write your name at the top of each piece of paper.

Requirement: Prepare a Horizontal and Vertical Analysis for the Statement of Financial Position and Statement of Comprehensive Income.  Write it on any piece of paper in good form (report form). Please write your name at the top of each piece of paper.

FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
See similar textbooks
icon
Related questions
Question
100%

Requirement: Prepare a Horizontal and Vertical Analysis for the Statement of Financial Position and Statement of Comprehensive Income.  Write it on any piece of paper in good form (report form). Please write your name at the top of each piece of paper. 

 

Tiwala Lhungz Company Tiwala Lhung Company Balance Sheet Income Statement As of December 31, 2016 Forthe yearended December 31, 2016 2016 2015 2016 2015 Assets Net Sales P8,000,000.00 P6,500,000.00 5,000,000.00 3,000,000.00 Current Assets: Less: Cost of Goods Sold 4,000,000.00 2,500,000.00 Cash P2,800,000.00 2,500,000 Gross Margin Less: Operating Expenses Marketable Securities 800,000.00 700,000.00 1,300,000.00 900,000.00 490, 000.00 1,000,000.00 1,500,000.00 Accounts Receivable (net) 900,000.00 Operating Income Less:Interest Expense 1,700,000.00 50,000.00 1,650, 000.00 Inventories 260,000.00 50,000.00 1,450,000.00 580,000.00 Other Current Assets 93,000.00 5,083,000.00 74,000.00 Interest before taxes Total Current Assets 4,434,000.00 Less: Income Tax 660,000.00 Non-Current Assets: NetIncome 990,000.00 870,000.00 Land 1,500,000.00 1,500,000.00 Analyze using: A. Horizontal Analysis Building (net) 1,340,000.00 2,840,000.00 7,923,000.00 1,150,000.00 2,650,000.00 7,084,000.00 Total Non-Current Assets Total Assets B. Vertical Analysis C. Ratio Analysis Liabilities and Stockholder's Equity 1. Return on Sales Current Liabilities: 2. Return on Assets 3. Average Total Assets 4. Average Common Stockholder's Equity 5. Return on Stockholder's Equity Accounts Payable 290, 000.00 101,500.00 Notes Payable 1, 100,000.00 540,000.00 Accrued payables 200,000.00 57,000.00 Total Current Liabilities 1,590,000.00 698,500.00 6. Earnings per share 7. Price-Earnings Ratio 8. Current Ratio 9. Quick Ratio Non-Current Liabilities: Bonds Payable, 10% 50,000.00 50,000.00 Total Liabilities 1,640,000.00 748,500.00 Stockholder's Equity: 10. Accounts Receivable Turn-over Ratio Common Stock, P1.50 par 3,000,000.00 3,000,000.00 11. Average Accounts Receivable Additional Paid-in Capital 2,000,000.00 2,000,000.00 12. Average Age of Receivable Retained Earnings 1,283,000.00 1,335,500.00 13. Inventory Turn-ove Ratio Total Stockholder's Equity 6,283,000.00 7,923,000.00 6,335,500.00 14. Average Inventory Total Liabilities and Stockholder's Equity 7,084,000.00 15. Average age of inventories 16. Times interest Earned Ratio 17. Debt Ratio 18. Debt-to-equity Ratio
Transcribed Image Text:Tiwala Lhungz Company Tiwala Lhung Company Balance Sheet Income Statement As of December 31, 2016 Forthe yearended December 31, 2016 2016 2015 2016 2015 Assets Net Sales P8,000,000.00 P6,500,000.00 5,000,000.00 3,000,000.00 Current Assets: Less: Cost of Goods Sold 4,000,000.00 2,500,000.00 Cash P2,800,000.00 2,500,000 Gross Margin Less: Operating Expenses Marketable Securities 800,000.00 700,000.00 1,300,000.00 900,000.00 490, 000.00 1,000,000.00 1,500,000.00 Accounts Receivable (net) 900,000.00 Operating Income Less:Interest Expense 1,700,000.00 50,000.00 1,650, 000.00 Inventories 260,000.00 50,000.00 1,450,000.00 580,000.00 Other Current Assets 93,000.00 5,083,000.00 74,000.00 Interest before taxes Total Current Assets 4,434,000.00 Less: Income Tax 660,000.00 Non-Current Assets: NetIncome 990,000.00 870,000.00 Land 1,500,000.00 1,500,000.00 Analyze using: A. Horizontal Analysis Building (net) 1,340,000.00 2,840,000.00 7,923,000.00 1,150,000.00 2,650,000.00 7,084,000.00 Total Non-Current Assets Total Assets B. Vertical Analysis C. Ratio Analysis Liabilities and Stockholder's Equity 1. Return on Sales Current Liabilities: 2. Return on Assets 3. Average Total Assets 4. Average Common Stockholder's Equity 5. Return on Stockholder's Equity Accounts Payable 290, 000.00 101,500.00 Notes Payable 1, 100,000.00 540,000.00 Accrued payables 200,000.00 57,000.00 Total Current Liabilities 1,590,000.00 698,500.00 6. Earnings per share 7. Price-Earnings Ratio 8. Current Ratio 9. Quick Ratio Non-Current Liabilities: Bonds Payable, 10% 50,000.00 50,000.00 Total Liabilities 1,640,000.00 748,500.00 Stockholder's Equity: 10. Accounts Receivable Turn-over Ratio Common Stock, P1.50 par 3,000,000.00 3,000,000.00 11. Average Accounts Receivable Additional Paid-in Capital 2,000,000.00 2,000,000.00 12. Average Age of Receivable Retained Earnings 1,283,000.00 1,335,500.00 13. Inventory Turn-ove Ratio Total Stockholder's Equity 6,283,000.00 7,923,000.00 6,335,500.00 14. Average Inventory Total Liabilities and Stockholder's Equity 7,084,000.00 15. Average age of inventories 16. Times interest Earned Ratio 17. Debt Ratio 18. Debt-to-equity Ratio
Expert Solution
steps

Step by step

Solved in 5 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS