2012 Assets Cash & Short-term Investments 6,619.0 Total Receivables, Net 7,041.0
ID: 2732472 • 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:
Activity Ratios
10. Accounts receivable turnover: Net sales/Average accounts receivable
(Previous years: 2012: 7,041, 2011: 6,912, 2010: 6,323, 2009: 4,683)
11. Average Collection Period: Accounts receivable/Total credit sales / 365 days or
Average Collection Period: Accounts receivable/net sales
(Show which one)
Profitability Ratios
18. Price-earnings ratio (Note: See PepsiCo’s price per share in David and David (2015) p. 31)
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
Calcutaion of Activity Ratios 1. Accounts recieviable turnover It measures the number of times on an average accounts recieviables are collected during a period Debtor trunovers / Accounts recieviables = Sales / Average Accounts recieviables (( opening + closing)/2) sales - 2012 65492 accounts recieviables - 2012 7041 accounts recieviables - 2011 6912 Average accounts Recieviables 6976.5 Accounts recieviable turnover = 65492/ 6976.5 9.39 2. Average collection period Accounts reciveacle ratio is converted into average collection period interms of days/ weeks/ months Average collection period = (days/ weeks/ months ) / Recieviable turnover No. of days 365 Average collection period = 365/ 9.39 39 times 3 Profitability ratio Price earmning ration = MPS / EPS where : - MPS = Market price of share EPS = Earning per share earning per share Total comman outstanding share 1544 Net income for equity share holders - 2012 6178 EPS = Net income for equity / Outstanding equity ie = 6178/1544 4 MPS 103 Pepsico share price have been taken on current price as - the link in the question for share price could not be located Price earning ratio = 103/ 4 26
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.