Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need assistance with the attached Accounting sheet. I am struggling with this subject. Information given Preston, Inc. Income Statement For the years ended December
I need assistance with the attached Accounting sheet. I am struggling with this subject.
Information given Preston, Inc. Income Statement For the years ended December 31, 2015 and 2016 Sales (all on credit) Cost of goods sold Gross margin 2016 447,501.00 295,120.00 152,381.00 2015 378,292.00 222,480.00 155,812.00 Depreciation expense Other operating expenses Operating expenses Operating income 15,482.00 99,454.00 114,936.00 37,445.00 13,078.00 95,929.00 109,007.00 46,805.00 Other income (expenses) Interest expense Gain on sale of investments Loss on sale of plant assets Total other income (expenses) (4,591.00) 4,802.00 (1,674.00) (1,463.00) (4,820.00) 2,282.00 (2,279.00) (4,817.00) Income before income taxes Income taxes expense 35,982.00 10,794.60 41,988.00 12,596.40 Net income 25,187.40 29,391.60 Preston, Inc. Statement of retained earnings For the year ended December 31, 2016 Retained earnings, January 1 Add: net income Deduct: Dividends Increase in retained earnings Retained earnings, December 31 2016 25,089.60 25,187.40 5,225.00 19,962.40 45,052.00 Preston, Inc. Comparative Balance Sheets December 31, 2016 and 2015 2016 Current assets: Cash 29,314.00 2015 29,391.60 4,302.00 25,089.60 25,089.60 2015 20,114.00 Accounts receivable (net) Inventory Prepaid expenses Other current assets Total current assets Long-term Investments Plant assets Less: accumulated depreciation Total plant assets Total assets 30,601.00 41,408.00 802.00 17,908.00 120,033.00 25,240.00 39,225.00 1,367.00 15,618.60 101,564.60 71,927.00 49,085.00 299,435.00 39,568.00 259,867.00 451,827.00 250,180.00 24,086.00 226,094.00 376,743.60 Current liabilities: Accounts payable Accrued liabilities Income taxes payable Total current liabilities Long term liabilities: Notes Payable Total liabilities 23,669.00 1,135.00 1,548.00 26,352.00 24,986.00 1,876.00 3,724.00 30,586.00 229,933.00 256,285.00 170,578.00 201,164.00 Common stock, $5 par value Additional paid-in capital Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 100,824.00 49,666.00 45,052.00 195,542.00 451,827.00 100,824.00 49,666.00 25,089.60 175,579.60 376,743.60 Other information Shares of common stock outstanding Dividends per share Market price per share, common stock 20,165 0.26 46.00 20,165 0.21 41.00 Part 1 Preston, Inc. Statement of Cash Flows For the year ended December 31, 2016 Cash flows from operating activities: Adjustments to reconcile net income: Net cash flows from operating activities Change 9,200.00 5,361.00 2,183.00 (565.00) 2,289.40 18,468.40 22,842.00 49,255.00 15,482.00 33,773.00 75,083.40 (1,317.00) (741.00) (2,176.00) (4,234.00) 59,355.00 55,121.00 19,962.40 19,962.40 75,083.40 Part 2 Preston, Inc. Income Statement (Horizontal analysis) For the years ended December 31, 2015 and 2016 Sales (all on credit) Cost of goods sold Gross margin 2016 447,501.00 295,120.00 152,381.00 2015 378,292.00 222,480.00 155,812.00 Depreciation expense Other operating expenses Operating expenses Operating income 15,482.00 99,454.00 114,936.00 37,445.00 13,078.00 95,929.00 109,007.00 46,805.00 Other income (expenses) Interest expense Gain on sale of investments Loss on sale of plant assets Total other income (expenses) (4,591.00) 4,802.00 (1,674.00) (1,463.00) (4,820.00) 2,282.00 (2,279.00) (4,817.00) Income before income taxes Income taxes expense 35,982.00 10,794.60 41,988.00 12,596.40 Net income 25,187.40 29,391.60 Increase/decrease Amount Preston, Inc. Balance Sheet (Horizontal analysis) December 31, 2016 and 2015 Assets Current assets: Cash Accounts receivable (net) Inventory Prepaid expenses Other current assets Total current assets Long-term Investments Plant assets Less: accumulated depreciation 2016 2015 29,314.00 30,601.00 41,408.00 802.00 17,908.00 120,033.00 20,114.00 25,240.00 39,225.00 1,367.00 15,618.60 101,564.60 71,927.00 49,085.00 299,435.00 39,568.00 250,180.00 24,086.00 Increase/decrease Amount Total plant assets Total assets 259,867.00 451,827.00 226,094.00 376,743.60 Liabilities and stockholders' equity Current liabilities: Accounts payable Accrued liabilities Income taxes payable Total current liabilities Long term liabilities: Notes Payable Total liabilities 23,669.00 1,135.00 1,548.00 26,352.00 24,986.00 1,876.00 3,724.00 30,586.00 229,933.00 256,285.00 170,578.00 201,164.00 Stockhoilders' equity: Common stock, $5 par value Additional paid-in capital Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 100,824.00 49,666.00 45,052.00 195,542.00 451,827.00 100,824.00 49,666.00 25,089.60 175,579.60 376,743.60 Use the area below to show your work (*Note: Your instructor may use this area to help review and Part 3 Preston, Inc. Income Statement (Vertical analysis) For the years ended December 31, 2015 and 2016 6 Increase/decrease Percent Sales (all on credit) Cost of goods sold Gross margin 2016 447,501.00 295,120.00 152,381.00 Depreciation expense Other operating expenses Operating expenses Operating income 15,482.00 99,454.00 114,936.00 37,445.00 Other income (expenses) Interest expense Gain on sale of investments Loss on sale of plant assets Total other income (expenses) (4,591.00) 4,802.00 (1,674.00) (1,463.00) Income before income taxes Income taxes expense 35,982.00 10,794.60 Net income 25,187.40 % Preston, Inc. Balance Sheet (Vertical analysis) December 31, 2016 and 2015 Increase/decrease Percent Assets Current assets: Cash Accounts receivable (net) Inventory Prepaid expenses Other current assets Total current assets Long-term Investments Plant assets Less: accumulated depreciation 2016 29,314.00 30,601.00 41,408.00 802.00 17,908.00 120,033.00 71,927.00 299,435.00 39,568.00 % Total plant assets Total assets 259,867.00 451,827.00 Liabilities and stockholders' equity Current liabilities: 2016 Accounts payable 23,669.00 Accrued liabilities 1,135.00 Income taxes payable 1,548.00 Total current liabilities 26,352.00 Long term liabilities: Notes Payable 229,933.00 Total liabilities 256,285.00 Stockhoilders' equity: Common stock, $5 par value Additional paid-in capital Retained earnings Total stockholders' equity Total liabilities and stockholders' equity o show your work and calculations. area to help review and resolve any incorrect answers) 100,824.00 49,666.00 45,052.00 195,542.00 451,827.00 % Rati analysis) 2015 and 2016 2015 378,292.00 222,480.00 155,812.00 Working capital: 2016 % Current ratio: 2016 13,078.00 95,929.00 109,007.00 46,805.00 Show Calcula (4,820.00) 2,282.00 (2,279.00) (4,817.00) Cash ratio: 2016 Show Calcula 41,988.00 12,596.40 29,391.60 Inventory turnover: 2016 nalysis) 2015 Days' sales inventory: 2016 2015 20,114.00 25,240.00 39,225.00 1,367.00 15,618.60 101,564.60 49,085.00 250,180.00 24,086.00 % Gross profit: 2016 226,094.00 376,743.60 2015 24,986.00 1,876.00 3,724.00 30,586.00 Accounts receivable turnover: 2016 % Days' sales in receivables: 2016 170,578.00 201,164.00 100,824.00 49,666.00 25,089.60 175,579.60 376,743.60 Debt ratio: 2016 Debt to equity ratio: 2016 Profit margin: 2016 Rate of return on total assets: 2016 Asset turnover ratio: 2016 Rate of return on common stockholders' equity ratio: 2016 Earnings per share: 2016 Price/earnings ratio (P/E): 2016 Dividend yield: 2016 Dividend payout: 2016 Ratios: Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below total assets: 2016 Show Calculations Below Show Calculations Below ockholders' equity ratio: 2016 Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations Below Show Calculations BelowStep 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