2012 Assets Cash & Short-term Investments 6,619.0 Total Receivables, Net 7,041.0
ID: 2732020 • Letter: 2
Question
2012
Assets
Cash & Short-term Investments
6,619.0
Total Receivables, Net
7,041.0
Total Inventory
3,581.0
Prepaid Expenses
1,479.0
Other Current Assets, Total
0.0
Total Current Assets
18,720.0
Property/Plant/Equipment, Total, Net
19,136.0
Goodwill, Net
16,971.0
Intangibles, New
16,525.0
Long-term Investments
2,351.0
Note Receivable, Long-term
136.0
Other Long-term Assets, Total
799.0
Total Assets
74,638.0
Liabilities & SEquity
Accounts Payable
4,451.0
Payable/Accrued
0.0
Accrued Expenses
3,892.0
Notes Payable/Short-term Debt
4,815.0
Current Port. Of LT Debt/Capital Leases
0.0
Other Current Liabilities, Total
3,931.0
Total Current Liabilities
17,089.0
Total Long-term Debt
23,544.0
Deferred Income Tax
5,063.0
Minority Interest
105.0
Other Liabilites, Total
6,543.0
Total Liabilities
52,344.0
Redeemable Preferred Stock
0.0
Preferred Stock, Non-Redeemable, Net
-(123.0)
Common Stock
26.0
Additional Paid-In Capital
4,178.0
Retained Earnings
43,158.0
Treasury Stock, Common
-(19,458.0)
ESOP Debt Guarantee
0.0
Unrealized Gain (Loss)
0.0
Other SEquity, Total
-(5,487.0)
Total SEquity
22,294.0
Total Liabilities & SEquity
74,638.0
Total Common Shares Outstanding
1,544.0
Total Preferred Shares Outstanding
0.8
2012
2011
Revenue
65,492.0
66,504.0
Other Revenue, Total
0.0
0.0
Total Revenue
65,492.0
66,504.0
Cost of Revenue, Total
31,291.0
31,593.0
Gross Profit
34,201.0
34,911.0
Selling/General/Administrative Expenses, Total
24,675.0
24,433.0
Research & Development
0.0
0.0
Depreciation/Amortization
119.0
133.0
Interest Expense (Income), Net Operating
0.0
0.0
Unusual Expense (Income)
295.0
712.0
Other Operating Expense, Total
0.0
0.0
Operating Income
9,112.0
9,633.0
Interest Income (Expense), Net Non-Operating
0.0
0.0
Gain (Loss) on Sale of Assets
0.0
0.0
Other, Net
0.0
0.0
Income Before Tax
8,304.0
8,834.0
Income Tax, Total
2,090.0
2,372.0
Income After Tax
6,214.0
6,462.0
Minority Interest
-(36.0)
-(19.0)
Equity in Affiliates
0.0
0.0
U.S. GAAP Adjustments
0.0
0.0
Net Income Before Extra Items
6,178.0
6,320.0
Total Extraordinary Items
0.0
0.0
Net Income
6,178.0
6,320.0
Please show ALL work!!!
home / study / business / accounting / questions and answers / please show all work!!!!! 2012 assets cash & short-term ...
Your question has been answered! Rate it below.
Let us know if you got a helpful answer.
Question
Please show ALL work!!!!!
2012
Assets
Cash & Short-term Investments
6,619.0
Total Receivables, Net
7,041.0
Total Inventory
3,581.0
Prepaid Expenses
1,479.0
Other Current Assets, Total
0.0
Total Current Assets
18,720.0
Property/Plant/Equipment, Total, Net
19,136.0
Goodwill, Net
16,971.0
Intangibles, New
16,525.0
Long-term Investments
2,351.0
Note Receivable, Long-term
136.0
Other Long-term Assets, Total
799.0
Total Assets
74,638.0
Liabilities & SEquity
Accounts Payable
4,451.0
Payable/Accrued
0.0
Accrued Expenses
3,892.0
Notes Payable/Short-term Debt
4,815.0
Current Port. Of LT Debt/Capital Leases
0.0
Other Current Liabilities, Total
3,931.0
Total Current Liabilities
17,089.0
Total Long-term Debt
23,544.0
Deferred Income Tax
5,063.0
Minority Interest
105.0
Other Liabilites, Total
6,543.0
Total Liabilities
52,344.0
Redeemable Preferred Stock
0.0
Preferred Stock, Non-Redeemable, Net
-(123.0)
Common Stock
26.0
Additional Paid-In Capital
4,178.0
Retained Earnings
43,158.0
Treasury Stock, Common
-(19,458.0)
ESOP Debt Guarantee
0.0
Unrealized Gain (Loss)
0.0
Other SEquity, Total
-(5,487.0)
Total SEquity
22,294.0
Total Liabilities & SEquity
74,638.0
Total Common Shares Outstanding
1,544.0
Total Preferred Shares Outstanding
0.8
Find the following:
Liquidity Ratios
1. Current ratio
2. Quick ratio
Leverage Ratios
3. Debt-to-total-assets ratio
4. Debt-to-equity ratio
5. Long-term debt-to-equity ratio
6. Times-earned-interest ratio
Activity Ratios
7. Inventory turnover
8. Fixed assets turnover
9. Total assets turnover
10. Accounts receivable turnover: Annual credit sales/Accounts receivable or
Accounts receivable turnover: Net sales/Average accounts receivable
(Show which one)
11. Average Collection Period: Accounts receivable/Total credit sales / 365 days or
Average Collection Period: Accounts receivable/net sales
(Show which one)
Profitability Ratios
12. Gross profit margin
13. Operating profit margin
14. Net profit margin
15. Return on total assets (ROA)
16. Return on stockholders’ equity (ROE)
17. Earnings per share (EPS)
18. Price-earnings ratio (Note: See PepsiCo’s price per share in David and David (2015) p. 31)
Growth Ratios
19. Sales: Annual % growth in total sales
20. Net income: Annual % growth in profits
21. Earnings per share: Annual % growth in EPS
22. Dividends per share: Annual % growth in dividends per share
2012
Assets
Cash & Short-term Investments
6,619.0
Total Receivables, Net
7,041.0
Total Inventory
3,581.0
Prepaid Expenses
1,479.0
Other Current Assets, Total
0.0
Total Current Assets
18,720.0
Property/Plant/Equipment, Total, Net
19,136.0
Goodwill, Net
16,971.0
Intangibles, New
16,525.0
Long-term Investments
2,351.0
Note Receivable, Long-term
136.0
Other Long-term Assets, Total
799.0
Total Assets
74,638.0
Liabilities & SEquity
Accounts Payable
4,451.0
Payable/Accrued
0.0
Accrued Expenses
3,892.0
Notes Payable/Short-term Debt
4,815.0
Current Port. Of LT Debt/Capital Leases
0.0
Other Current Liabilities, Total
3,931.0
Total Current Liabilities
17,089.0
Total Long-term Debt
23,544.0
Deferred Income Tax
5,063.0
Minority Interest
105.0
Other Liabilites, Total
6,543.0
Total Liabilities
52,344.0
Redeemable Preferred Stock
0.0
Preferred Stock, Non-Redeemable, Net
-(123.0)
Common Stock
26.0
Additional Paid-In Capital
4,178.0
Retained Earnings
43,158.0
Treasury Stock, Common
-(19,458.0)
ESOP Debt Guarantee
0.0
Unrealized Gain (Loss)
0.0
Other SEquity, Total
-(5,487.0)
Total SEquity
22,294.0
Total Liabilities & SEquity
74,638.0
Total Common Shares Outstanding
1,544.0
Total Preferred Shares Outstanding
0.8
Explanation / Answer
1. Current ratio = Current assets/Current liabilities
= 18720/17089
= 1.10
2. Quick ratio = Cash + cash equivalents + Short term investment + Current recievables/Current liabilities
= (6619 + 7041)/17089
= 0.80
3. Debt to total assets ratio = Long term debt/Total assest
= 23544/74638
= 0.32
4. Debt to equity ratio = Outsiders funds/Equity Shareholders fund
= (23544 - 123)/26 + 4178 + 43158 -19458 - 5487
= 23421/22417
= 1.04
5 LOng term debt to equity ratio = Long term debt/ Shareholders equity
= 23544/22294
= 1.06
6. Times-earned-interest ratio = EBIT/Inyerest on long term debt
= 9112/0 = 0
7. Inventory turnover = Net Sales/Average inventory
Average inventory = (Opening Inventory + Closing inventory)/2
= (3581 + 3581)/2
= 3581
In the absence of any information about opening inventories, it is assumed that there isno change in inventories.
Inventory turnover = 65492/3581 = 18.29
8. Fixed assets turnover = Net sales/Netfixed assets
= 65492/55918
= 1.17
9. Total assets turnover = Net sales/Total assets
= 65492/74638
= 0.88
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.