Ratio | Year 1 | Year 2 | Which year is better |
Current ratio (Current assets ÷ current liabilities) |
$205000÷$41500 =4.94 times |
$174000÷$89950 =1.93 times |
Higher current ratio is favourable so, year 1 is better. |
Quick ratio [(Current assets-inventory)÷current liabilities] |
$(205000-151000)÷$41500 =1.30 times |
$(174000-127000)÷$89950 =0.52 times |
Ratio higher than 1 is ideal. So, year 1 is better. |
Acid test ratio | same as quick ratio | Same as quick ratio | |
Debt to equity ratio (Total liabilities ÷ total equity) |
$343100÷$567700 =0.604 times |
$410000÷$610000 =0.672 times |
Year 2 is better as it has a higher ratio |
Times interest earned ratio (EBIT÷ Interest expense) |
$(36000+4000)÷$4000 =10 times |
$(51000+5000)÷$5000 =11.2 times |
Year 2 is better as it has a higher ratio of income compared to interest expense. |
Inventory turnover ratio (Cost of goods sold ÷ average inventory) |
$1026000 ÷ [$(100000 + 151000) ÷ 2] =$1026000 ÷ $125500 =8.17 times |
$1129000 ÷ [$(151000 + 127000)÷ 2] = $1129000 ÷ $139000 = 8.12 times |
Higher ratio is favourable. So, year 1 is better. |
Average number of days for Inventory to turn over (days in a year ÷ Inventory turnover ratio) |
=365 ÷ 8.17 = 44.68 days |
=365 ÷ 8.12 = 44.95 days |
Year 1 is better as it takes less days to convert inventory into sales. |
Accounts receivable turnover ratio (net credit sales ÷ average accounts receivable) |
=($1250000×10%)÷($5000÷2) =125000÷2500 =50 times |
=($1465000×10%)÷[($30000 + 5000)÷2] = 146500÷17500 =8.37 times |
Higher ratio is favourable. So, year 1 is better. |
Average number of days to receive payment from credit sales (no. of days in a year ÷ accounts receivable turnover ratio) |
= 365 ÷ 50 = 7.3 days |
= 365 ÷ 8.37 = 43.6 days |
Year 1 is better as it takes lesser number of days to encash its credit sales. |
Accounts payable turnover ratio (credit purchases ÷ average accounts payable) |
= [$(1077000×25%) ÷ $(20000÷2)] = 269250 ÷ 10000 = 26.925 times |
=[$(1105000×25%) ÷ $(53000+20000)÷2] = 276250 ÷ 36500 = 7.57 times |
Lower ratio is favourable. So, year 2 is better. |
Average number of days to pay bills (no. of days in a year÷ accounts payable turnover ratio) |
= 365 ÷ 26.925 = 13.56 days |
= 365 ÷ 7.57 = 48.22 days |
Year 2 is better as it gets more time to pay off its bills. |
Return on investment ratio (EBIT ÷ Capital employed) Here capital employed = total assets - current liabilities |
=[$(36000+4000)÷$(910800-41500) =40000 ÷ 869300 = 4.60% |
=[$(51000+5000)÷$(1020000-89950) = 56000 ÷ 930050 = 6.02% |
Higher return is better. So, year 2 is better. |
Return on owner's equity (net income ÷ shareholders equity) |
=$30000 ÷ $567700 = 5.28% |
=$42300 ÷ $610000 =6.93% |
Year 2 is better as it has higher returns. |
Profit as a percentage of sales (profit ÷ sales × 100) |
=$(30000 ÷ 1250000) × 100 = 2.4% |
=$(42300 ÷ 1465000) × 100 = 2.9% |
Year 2 is better as it has higher returns. |
Comparative Balance Sheet AgBiz Corporation Account December 31, Year 1 December 31, Year 2 Difference Percent...
Class Assignment 16 Comparative Balance Sheet AgBiz Corporation December 31, Year 1 Assets December 31, Year 2 Account Difference Percent Difference $ 49,000 5,000 151,000 $205,000 $ 17,000 30,000 127,000 $ 174,000 $ -32,000 +25,000 -24,000 $ -31,000 -653 +500.0 -15.9 15.1 Current assets: Cash Accounts receivable Inventories Total current assets Fixed assets: Land Buildings and equipment Less: Depreciation Total fixed assets Other investments: Cash value of life insurance Investment in other firms Investment in subsidiary Total other Total assets...
Class Assignment 16 Comparative Balance Sheet AgBiz Corporation December 31, Year 1 Assets December 31, Year 2 Account Difference Percent Difference $ 49,000 5,000 151,000 $205,000 $ 17,000 30,000 127,000 $ 174,000 $ -32,000 +25,000 -24,000 $ -31,000 -653 +500.0 -15.9 15.1 Current assets: Cash Accounts receivable Inventories Total current assets Fixed assets: Land Buildings and equipment Less: Depreciation Total fixed assets Other investments: Cash value of life insurance Investment in other firms Investment in subsidiary Total other Total assets...
can i pleasw have help on the comparative balance sheet Comparative Balance Sheet December 31, 2020 and 2019 2020 2019 Assets Current Assets: Cash Accounts Receivable, Net Inventory (sunglasses) Prepaid Insurance Prepaid Rent Total Current Assets S $ $ $ $ $ 90,000 130,000 135,000 25,000 S $ $ S $ S 70,000 90,000 80,000 20,000 12,000 272,000 380,000 Property, Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, Plant, and Equipment Total Assets $ $ $ $...
Following is a comparative balance sheet for Summer Days Corporation: Summer Days Corporation Comparative Balance Sheet December 31, 2019 and 2018 20192018 Current assets: Cash$ 150,000$ 90,000 Short-term investments90,00080,000 Accounts receivable, net350,000220,000 Inventory400,000430,000 Prepaid expenses30,00030,000 Total current assets$1,020,000$ 850,000 Property, plant, and equipment, net750,000500,000 Other assets280,000300,000 Total assets$2,050,000$1,650,000 Current liabilities: Short-term notes payable$650,000$670,000 Accounts payable200,000225,000 Total current liabilities$850,000$895,000 Non-current debt180,000220,000 Total liabilities$1,030,000$1,115,000 Shareholders' equity: Common shares$500,000$500,000 Retained earnings410,00035,000 Total shareholders' equity$ 910,000$535,000 Total liabilities and shareholders' equity$2,140,000$1,650,000 Notes: Net sales...
Summer Days Corporation Comparative Balance Sheet December 31, 2019 and 2018 20192018 Current assets: Cash$ 140,000$ 90,000 Short-term investments90,00080,000 Accounts receivable, net350,000220,000 Inventory500,000430,000 Prepaid expenses 30,00030,000 Total current assets$1,110,000$ 850,000 Property, plant, and equipment, net750,000500,000 Other assets 280,000300,000 Total assets$2,140,000$1,650,000 Current liabilities: Short-term notes payable$650,000$670,000 Accounts payable200,000225,000 Total current liabilities$850,000$895,000 Non-current debt380,000220,000 Total liabilities$1,230,000$1,115,000 Shareholders' equity: Common shares $500,000$500,000 Retained earnings410,00035,000 I Total shareholders' equity$ 910,000$535,000 Total liabilities and shareholders' equity$2,140,000$1,650,000 Notes: Net sales (all on credit) and cost of...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 800,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 800,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the...
Unit 10 - Financial Statement Analysis Following is a comparative balance sheet for Summer Days Corporation: Summer Days Corporation Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Current assets: Cash $ 140,000 $ 90,000 Short-term investments 90,000 80,000 Accounts receivable, net 350,000 220,000 Inventory 500,000 430,000 Prepaid expenses 30,000 30,000 Total current assets $1,110,000 $ 850,000 Property, plant, and equipment, net 750,000 500,000 Other assets 280,000 300,000 Total assets $2,140,000 $1,650,000 Current liabilities:...
Unit 10 - Financial Statement Analysis Following is a comparative balance sheet for Summer Days Corporation: Summer Days Corporation Comparative Balance Sheet December 31, 2019 and 2018 2019 2018 Current assets: Cash $ 150,000 $ 90,000 Short-term investments 90,000 80,000 Accounts receivable, net 350,000 220,000 Inventory 400,000 430,000 Prepaid expenses 30,000 30,000 Total current assets $1,020,000 $ 850,000 Property, plant, and equipment, net 750,000 500,000 Other assets 280,000 300,000 Total assets $2,050,000 $1,650,000 Current liabilities: Short-term notes payable $650,000 $670,000...
MONTGOMERY INC. Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $ 30,400 $ 30,550 Accounts receivable, net 10,050 12,150 Inventory 90,100 70,150 Total current assets 130,550 112,850 Equipment 49,900 41,500 Accum. depreciation—Equipment (22,500 ) (15,300 ) Total assets $ 157,950 $ 139,050 Liabilities and Equity Accounts payable $ 23,900 $ 25,400 Salaries payable 500 600 Total current liabilities 24,400 26,000 Equity Common stock, no par value 110,000 100,000 Retained earnings 23,550 13,050 Total liabilities and equity $...