AutoSave 2 Lab 1 - Chapter 13 - ACC 214 Template - Excel File Home Insert Page Layout Formulas Data Review View Help Arial -10 AA wap last Paste Currency $ - % *822 a-A- Mergea Center Clipboard Font Alignment Number ca G $3,000 12.000 9.000 1,000 3.000 A 25 Notes Payable 27 Accounts Payable 28 Accrued Expenses 29 Income Taxes Payable 30 Payments Due within One Year 31 Total Current Liabilities 32 Long Term Debe 33 Deferred Income Taxes 34 Other Labetes 35 Total Liabilities 36 Stockholders' Equity 37 Preferred Stock 38 Common Stock Additional Padin Capital - Common 39 4.0 Rand Earning 41 Total Stockholders' Equity 50,000 30.000 5.000 C 55,000 16000 11,000 1,000 Ratios for 20X9. use formulas: 2.000 Current ratio Quick Ratio (Acid-Test) 60,000 A/R turnover 27 000 Average of days to collect AR 4,000 Inventory Turnover Earnings per share of common stock Price Earnings ratio of common stock 20.000 Debt to assets) ratio 5.000 Equity to assets) ratio 35.000 Return on total assets 40 000 Return on common shareholder equity 20.000 5.000 35.000 42.000 13 Total Liab & Stockholders' Equity 44 45 Stock Information 45 55 Cumulative Preferred Stock, par value $100 per shares 47 500 liquidating value authorized 250.000 shares ACC 214 CH. 1) Template Ready Type here to search - a AutoSave Lab 1 - Chapter 13 - ACC 214 Template - Excel Review Data View File Formulas Help Insert Home Page Layout Arial 10 A A Currency 2 Wrap Test 3Merge & Center Paste IV- a. A- s-% NE Clipboard Font Alignment C23 A B Year 2 E (000's omitted) Year 1 Year 2% 180,000 147.000 9 10 11 Cash 12 Marketable Securities 13 Accounts Receivable (net) 14 Inventories 15 Prepaid Expenses 16 Total Current Assets 17 Property. Plant & Equipment 18 Investments 19 Long-Term Receivables 20 Goodwill and Patents 21 Other Assets 22 Total Assets 23 24 Liabilities and Equity 25 Liabilities 26 Notes Payable 27 Accounts Payable 28 Accrued Expenses 29 Income Taxes Payable 30 Payments Due within One Year 31 Total Current Liabilities 32 Long-Term Date ACC 214 CH. 13 Template $3,000 5,000 47000 50.000 2.000 107,000 100.000 1,000 3000 2.000 2.000 $100,000 $2,000 Net Sales 4,000 44,000 Cost of Goods Sold 60 000 1,000 Gross Margin 111,000 105,000 Other Expenses 1.000 Selling And Administrative 2,000Other Expenses 4,000 Total Other Expenses 3.000 $115,000 Income Before Taxes Income Taxes 20,000 2.000 22.000 5,000 $3.000 12 000 9.000 1.000 3.000 Net Income $5 000 16 000 11,000 1,000 Ratios for 20X9. use formulas: 2.000 Current ratio Quick Ratio (Acid.Test) 60.0001 IAR turnover 50.000 Type here to search S 6 G B D 34 Other Liabilities 5,000 4,000 Inventory Turnover 35 Total Liabilities Earnings per share of common stock 36 Stockholders' Equity Price Earnings ratio of common stock 37 Preferred Stock 20,000 20,000 Debt (to assets) ratio 38 Common Stocks 5,000 5,000 Equity (to assets) ratio Additional Paid in Capital - Common 35,000 35,000 39 Return on total assets 40 Retained Earnings 42,000 40,000 Return on common shareholder equity 41 Total Stockholders' Equity 42 43 Total Liab. & Stockholders' Equity 44 45 Stock information: 46 5% Cumulative Preferred Stock, par value $100 per share; 47 $100 liquidating value: authorized 250,000 shares 48 #issued & outstanding (000's omitted 200 49 Dividend Percent 5% 50 Par Value $100 51 52 51 par value common stock, 10 million shares authorized 53 issued and outstanding (000's omitted) 5000 54 Market Price Per Share, 12/31 of 2 $16.00 55 ACC 214 CH. 13 Template G a S Type here to search 2 4 5 ab WERT OM H Lab 1 - Chapter 13 - ACC 214 Template - Excel Search ome Insert Page Layout Formulas Data Review View Help Arial - -10 - A A Wrap Text - A Merge & Center - BIU Currency $. - % 48-58 Conditi Formatti Font Alignment Number E Income Taxes G H 4,000 K 5,000 M 000 000 000 .000 .000 .000 .000 ,000 Net Income $5,000 16.000 11,000 1,000 Ratios for 20X9-use formulas: 2.000 Current ratio Quick Ratio (Acid-Test) 60.000 A/R turnover 27.000 Average # of days to collect AR 4000 Inventory Turnover Earnings per share of common stock Price-Eearnings ratio of common stock 20 000 Debt to assets) ratio 5.000 Equity (to assets) ratio 35.000 Return on total assets 40 000 Return on common shareholder equity 000 000 000 000 ACC 214 CH 13 Template Type here to search E le Lab 1 - Chapter 13 - ACC 214 Template - Excel Data Formulas Review View 1 Help Page Layout Currency -10 - A A 23 Wrap Text a.A. Merge & Center $ %, 8-98 Conditional Formatting Font Alignment Number M E F G H K Piedmont Beverages, Inc. Income Statements for the 8 Years Ended 12/31 20x9 20X8 (000's omitted) Year 2 % of Sales Year 1 % of Sales % Change 2.000 Net Sales 180,000 100% 150,000 100% 20% 4.000 4,000 Cost of Goods Sold 147,000 82% 120,000 0.000 1,000 Gross Margin 1,000 5.000 Other Expenses 1,000 Selling And Administrative 20,000 18,000 2,000 Other Expenses 2.000 2,000 4.000 Total Other Expenses 22,000 20,000 3,000 15,000 Income Before Taxes Income Taxes 5.000 4,000 Net Income $5,000 16.000 11,000 1.000||Ratios for 20X9- use formulas: 214 CH. 13 Template CO ere to search