Question

In: Accounting

perating Asset Management Analysis Partial comparative balance sheet and income statement information for Posad Company is...

perating Asset Management Analysis Partial comparative balance sheet and income statement information for Posad Company is as follows: 2014 2013 Cash $ 13,600 $ 10,400 Marketable securities 7,200 17,200 Accounts receivable (net) 44,800 35,600 Inventory 54,400 49,600 Total current assets $120,000 $112,800 Accounts payable $ 40,000 $ 28,200 Net sales $322,560 $220,720 Cost of goods sold 217,600 203,360 Gross margin $104,960 $ 17,360 In 2012, the year-end balances for Accounts Receivable and Inventory were $32,400 and $51,200, respectively. Accounts Payable was $30,600 in 2012 and is the only current liability. Compute the current ratio, quick ratio, receivables turnover, days' sales uncollected, inventory turnover, days' inventory on hand, payables turnover, days' payable for each year, and financing period. Assume 365 days in a year. Round your answers to one decimal place. 2014 2013 Current ratio: times times Quick ratio: times times Receivables turnover: times times Days' sales uncollected: days days Inventory turnover: times times Days' inventory on hand: days days Payables turnover: times times Days' payable: days days Financing period days days

Solutions

Expert Solution

1 Current ratio = Current assets / current Liabilities
Current assets 120000 112800
Current liabilities 40000 28200
Current ratio 3.0 4.0
2 Quick ratio = (current assets - inventory -prepaid expense )/ current liabilities
Quick assets 65600 63200
Current liabilities 40000 28200
Acid test ratio 1.6 2.2
3 Receivable turnover = Net sales / Average accounts receivable
Net sales   322560 220720
Beginning accounts receivable 35600 32400
Ending accounts receivable 44800 35600
Average accounts receivable 40200 34000
Average accounts receivable = (Beginning + ending )/2
Receivable turnover 8.02 6.49
4 Days sales uncollected = 365 / accounts receivable tunover
Days sales uncollected 45.49 56.23 Days
5 Inventory turnover = Cost of goods sold / Average inventory
Cost of goods sold 217600 203360
Beginning inventory 49600 51200
Ending inventory 54400 49600
Average inventory 52000 50400
Average inventory = (Beginning + Ending )/2
Inventory turnover 4.2 4.0
6 Days sale in inventory = 365 / inventory turnover
Days sales in inventory 87.2 90.5 Days
7 Payable turnover = Cost of goods sold / Average accounts payable
Cost of goods sold 217600 203360
Beginning payable 28200 30600
Ending payable 40000 28200
Average Payable 34100 29400
Average payable = (Beginning + Ending )/2
Inventory Payable 6.4 6.9
8 Days payable turnover = 365 / inventory turnover
Days payable turnover 57.2 52.8 Days

Related Solutions

A comparative balance sheet and income statement for Groton Company follow: Groton Company Comparative Balance Sheet...
A comparative balance sheet and income statement for Groton Company follow: Groton Company Comparative Balance Sheet December 31, 2011 and 2010 2011 2010   Assets   Cash $ 5   $ 16      Accounts receivable 322   237      Inventory 166    208      Prepaid expenses 16    14      Total current assets 509    475      Property, plant, and equipment 517    438      Less accumulated depreciation (89)    (75)      Net property, plant, and equipment 428    363      Long-term investments 29    40      Total assets $ 966    $ 878      Liabilities and Stockholders' equity   Accounts payable $...
A comparative balance sheet and income statement for Groton Company follow: Groton Company Comparative Balance Sheet...
A comparative balance sheet and income statement for Groton Company follow: Groton Company Comparative Balance Sheet December 31, 2011 and 2010 2011 2010   Assets   Cash $ 2   $ 13      Accounts receivable 310   231      Inventory 160    199      Prepaid expenses 10    8      Total current assets 482    451      Property, plant, and equipment 511    432      Less accumulated depreciation (86)    (72)      Net property, plant, and equipment 425    360      Long-term investments 26    34      Total assets $ 933    $ 845      Liabilities and Stockholders' equity   Accounts payable $...
A comparative balance sheet and income statement for Eaton Company follow: Eaton Company Comparative Balance Sheet...
A comparative balance sheet and income statement for Eaton Company follow: Eaton Company Comparative Balance Sheet December 31, 2011 and 2010 2011 2010 Assets Cash $ 42 $ 17 Accounts receivable 309 229 Inventory 156 195 Prepaid expenses 9 5 Total current assets 516 446 Property, plant, and equipment 534 454 Less accumulated depreciation 86 71 Net property, plant, and equipment 448 383 Long-term investments 27 33 Total assets $ 991 $ 862 Liabilities and Stockholders' equity Accounts payable $...
Ratio Analysis of Comparative Financial Statements A comparative income statement and balance sheet of Miller Electronics...
Ratio Analysis of Comparative Financial Statements A comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are shown. Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $646,120    $414,520    Cost of goods sold 384,590    253,000    Gross profit $261,530    $161,520    Administrative expenses $63,249    $41,647    Selling expenses 66,183    44,283    Total operating expenses $129,432    $85,930    Operating income $132,098    $75,590    Interest expense 1,316    1,222    Income before...
Horizontal Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of...
Horizontal Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are as follows: Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $652,630    $416,530    Cost of goods sold 387,960    250,560    Gross profit $264,670    $165,970    Administrative expenses $65,676    $42,758    Selling expenses 66,261    43,915    Total operating expenses $131,937    $86,673    Operating income $132,733    $79,297    Interest expense 1,331   ...
Vertical Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of...
Vertical Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of Miller Electronics Corporation for the last two years are as follows: Miller Electronics Corporation Comparative Income Statement For Years Ended December 31, 20-2 and 20-1 20-2 20-1 Net Sales (all on account) $662,120    $427,020    Cost of goods sold 395,040    263,840    Gross profit $267,080    $163,180    Administrative expenses $63,920    $43,090    Selling expenses 66,123    44,353    Total operating expenses $130,043    $87,443    Operating income $137,037    $75,737    Interest expense 1,268   ...
Partial information from the comparative balance sheet of Jackson Company as of December 31, 2020 and...
Partial information from the comparative balance sheet of Jackson Company as of December 31, 2020 and 2019 reflected the following selected account balances. From the information contained on the balance sheet and the additional information below, prepare the Net Cash Flows from Operating activities to answer the following two questions.   Jackson Company Comparative Balance Sheet Partial Information                                                            2020                2019 Current Assets: Cash                                                $114,000         $100,000 Accounts receivable                           18,400             20,700 Inventory                                            62,200             59,600 Current Liabilities: Accounts payable                               29,300             26,600 Accrued liabilities                                9,700             10,100 Additional information: Net income                                                       69,000 Depreciation expense                                         8,000 Question: What...
Presented below is the 2021 income statement and comparative balance sheet information for Tiger Enterprises.
Presented below is the 2021 income statement and comparative balance sheet information for Tiger Enterprises. Required:Prepare Tiger’s statement of cash flows, using the indirect method to present cash flows from operating activities. 
Tidwell Company has provided the following partial comparative balance sheets and the income statement for 20X2....
Tidwell Company has provided the following partial comparative balance sheets and the income statement for 20X2. Tidwell Company Comparative Balance Sheets At December 31, 20X1 and 20X2 1 20X1 20X2 2 Current assets: 3 Accounts receivable $346,000.00 $284,000.00 4 Inventories 122,000.00 147,000.00 5 Current liabilities: 6 Accounts payable 302,000.00 239,500.00 Tidwell Company Income Statement For the Year Ended December 31, 20X2 1 Revenues $1,204,000.00 2 Gain on sale of equipment 49,000.00 3 Cost of goods sold (655,000.00) 4 Depreciation expense...
Swasey Company provided the following partial comparative balance sheets and the income statement for 20X2. Swasey...
Swasey Company provided the following partial comparative balance sheets and the income statement for 20X2. Swasey Company Partial Comparative Balance Sheets At December 31, 20X1 and 20X2 1 20X1 20X2 2 Current Assets 3 Accounts receivable 745,000.00 677,000.00 4 Inventories 295,000.00 315,000.00 5 Current liabilities 6 Wages payable 705,000.00 680,000.00 Swasey Company Income Statement For the Year Ended December 31, 20X2 1 Revenues 3,120,000.00 2 Gain on sale of equipment 100,000.00 3 Cost of goods sold (1,910,000.00) 4 Depreciation expense...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT