Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the attached financial statements, you need to create a vertical analysis as percentage of Total Assets for the Balance Sheet and as a percentage
Using the attached financial statements, you need to create a vertical analysis as percentage of Total Assets for the Balance Sheet and as a percentage of Sales for the Income Statement, as well as a horizontal analysis of the Balance Sheet and Income Statement. Complete this for both years. In addition to the vertical and horizontal analysis, you need to calculate the following ratios:
Liquidity & Efficiency:
- Current Ratio
- Acid-Test Ratio
- Receivables Turnover & Days Sales Uncollected
- Inventory Turnover & Days sales in Inventory
Solvency:
- Debt Ratio
- Equity Ratio
- Debt to Equity Ratio
Profitability:
- Profit Margin Ratio
- Gross Margin Ratio
- Return on Total Assets (ROA)
- Return on Equity (ROE)
For the Years Ended December 31, 2018 and 2017 12/31/2018 12/31/2017 5665,600 630,000 451,500 178,500 Sales Cost of Goods Sold Gross Profit 468,000 197,600 72,800 31,200 93,600 79,800 27,300 71,400 Operating Expenzes Selling & Administrative Expenses Operating Income 7,280 16,640 Interest Expense Income Tax Expense 8,400 14,700 $69,68048 Net Income Comparative Balance Sheet For the Years Ended December 31, 2018 and 2017 12/31/2018 12/31/2017 Current Assets 543,120 52.500 75,600 25,200 153,300 Cash Accounts Receivable 74,480 19,600 137,200 Total Current Assets Long-Term Assets 176,400 189,000 (52,500) Total Long Term Assets 137,200 $274,400 289,800 Total Assets Liabilities and Shareholders' Equity: Current Liabilities 535,280 46,200 11,760 47,040 Accounts Payable Salaries Payable Total Current Liabilities 8,400 54,600 Long-Term Liabilities Notes Payable Total Long-Term Liabilities 83,200 73,500 Total Liabilities 135,240 Shareholders' Equity Common Stock, $1 par Paid In Capital Retained Earnings 39,200 29,400 70,560 42,000 31,500 88,200 Total Shareholders' Equity 139,160 161,700 $274,400$289,800 Total Liabilities and Shareholders Equity
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started