Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

I need assistance with the attached Accounting sheet. I am struggling with this subject.

image text in transcribed 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 Below

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Accounting

Authors: Tracie L. Miller nobles, Brenda L. Mattison, Ella Mae Matsumura

12th edition

9780134487151, 013448715X, 978-0134674681

More Books

Students also viewed these Accounting questions

Question

6. How can hidden knowledge guide our actions?

Answered: 1 week ago

Question

7. How can the models we use have a detrimental effect on others?

Answered: 1 week ago