Question

Comparative Balance Sheet AgBiz Corporation Account December 31, Year 1 December 31, Year 2 Difference Percent Difference Ass
Comparative Profit-and-Loss Statement AgBiz Corporation Percent of Sales 100.0 Percent of Sales 100.0 Year 2 $1,465,000 $1,25
Use the information above to complete the following table. Ratios Year 1 Year 2 Which year is better? Current Ratio Quick Rat
Ratios Year 1 Year 2 Which year is better? Accounts Receivable Turnover Ratio (Assuming credit sales are 10% of total sales.)
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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.
Add a comment
Know the answer?
Add Answer to:
Comparative Balance Sheet AgBiz Corporation Account December 31, Year 1 December 31, Year 2 Difference Percent...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Class Assignment 16 Comparative Balance Sheet AgBiz Corporation December 31, Year 1 Assets December 31, Year...

    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...

    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...

    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...

    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$...

    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...

    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...

    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:...

    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:...

    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 $...

    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 $...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT