Answered step by step
Verified Expert Solution
Question
1 Approved Answer
TAB 1: Using the Data in the next tab, prepare a horizontal analysis of the 2015/2016 income statement and balance sheet. Include columns for dollar
TAB 1: Using the Data in the next tab, prepare a horizontal analysis of the 2015/2016 income statement and balance sheet. Include columns for dollar amount of change and percentage change from 2015 to 2016 (rounded to two decimal places). TAB 2: Prepare a vertical analysis of the 2015/2016 income statement and balance sheet. Include columns for the percentage that each account represents of total assets (for the balance sheet) or sales (for the income statement). TAB 3: Compute the following ratios for 2016 and 2015: Current Ratio Times-interest-earned Ratio Inventory Turnover Debt to Equity Ratio Earnings per Share of Common Stock Price/Earnings Ratio TAB 4: Prepare a column graph showing Total Assets for 2016, 2015, and 2014. DANGERFIELD, INC. Comparative Income Statement Years Ended December 31, 2016 and 2015 Net Sales Cost of Goods Sold Gross Profit Operating Expenses Income from Operations Interest Expense Income Before Income Tax Income Tax Expense Net Income 2016 $459,000 237,000 222,000 137,000 85,000 12,000 73,000 19,000 $54,000 2015 $424,000 215,000 209,000 135,000 74,000 14,000 60,000 25,000 $35,000 DANGERFIELD, INC. Comparative Balance Sheet December 31, 2016 and 2015 2016 2015 2014 Assets Current Assets: Cash Accounts Receivable, Net Merchandise Inventory Prepaid Expenses Total Current Assets Property, Plant, and Equipment, Net Total Assets $101,000 210,000 $99,000 110,000 145,000 12,000 366,000 219,000 $585,000 $96,000 116,000 163,000 7,000 382,000 180,000 $562,000 598,000 Liabilities Total Current Liabilities Long-term Liabilities Total Liabilities $223,000 120,000 343,000 $246,000 95,000 341,000 Stockholders' Equity Preferred Stock, 3% Common Stockholders' Equity, no par Total Liabilities and Stockholders' Equity 98,000 144,000 $585,000 98,000 123,000 $562,000 85,000 2014 Additional Information: Market Price of Common Shares Common Shares Outstanding All Sales are on Credit 2016 $84.32 10,000 2015 $51.75 9,000 9,000
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