Problem 17-5A Comparative ratio analysis LO P3 Skip to question   [The following information applies to the questions displayed below.]   Summary information from the financial statements of two companies competing in the same industry follows.     Barco Company Kyan Company     Barco Company Kyan Company Data from the current year-end balance sheets   Data from the current year’s income statement Assets               Sales $ 770,000   $ 882,200   Cash $ 19,000   $ 37,000     Cost of goods sold   593,100     638,500   Accounts receivable, net   36,400     58,400     Interest expense   7,800     18,000   Merchandise inventory   84,440     130,500     Income tax expense   14,800     24,355   Prepaid expenses   5,500     7,150     Net income   154,300     201,345   Plant assets, net   370,000     312,400     Basic earnings per share   4.06     4.09   Total assets $ 515,340   $ 545,450     Cash dividends per share   3.78     3.94                     Liabilities and Equity               Beginning-of-year balance sheet data   Current liabilities $ 67,340   $ 95,300     Accounts receivable, net $ 26,800   $ 56,200   Long-term notes payable   79,800     103,000     Merchandise inventory   61,600     111,400   Common stock, $5 par value   190,000     246,000     Total assets   438,000     392,500   Retained earnings   178,200     101,150     Common stock, $5 par value   190,000     246,000   Total liabilities and equity $ 515,340   $ 545,450     Retained earnings   167,540     93,653       I need help filling out the tabs thnak you once again

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

Problem 17-5A Comparative ratio analysis LO P3

Skip to question

 

[The following information applies to the questions displayed below.]
 
Summary information from the financial statements of two companies competing in the same industry follows.
 

  Barco
Company
Kyan
Company
    Barco
Company
Kyan
Company
Data from the current year-end balance sheets   Data from the current year’s income statement
Assets               Sales $ 770,000   $ 882,200  
Cash $ 19,000   $ 37,000     Cost of goods sold   593,100     638,500  
Accounts receivable, net   36,400     58,400     Interest expense   7,800     18,000  
Merchandise inventory   84,440     130,500     Income tax expense   14,800     24,355  
Prepaid expenses   5,500     7,150     Net income   154,300     201,345  
Plant assets, net   370,000     312,400     Basic earnings per share   4.06     4.09  
Total assets $ 515,340   $ 545,450     Cash dividends per share   3.78     3.94  
                 
Liabilities and Equity               Beginning-of-year balance sheet data  
Current liabilities $ 67,340   $ 95,300     Accounts receivable, net $ 26,800   $ 56,200  
Long-term notes payable   79,800     103,000     Merchandise inventory   61,600     111,400  
Common stock, $5 par value   190,000     246,000     Total assets   438,000     392,500  
Retained earnings   178,200     101,150     Common stock, $5 par value   190,000     246,000  
Total liabilities and equity $ 515,340   $ 545,450     Retained earnings   167,540     93,653  
 

 

I need help filling out the tabs thnak you once again.

**Problem 17-5A Comparative Ratio Analysis**

**Summary Information:**

This dataset provides insight into the financial statements of two companies, Barco Company and Kyan Company, which operate in the same industry. The information is categorized and compared across various financial metrics.

### Current Year-End Balance Sheets

#### Assets
- **Barco Company:**
  - Cash: $19,000
  - Accounts Receivable, Net: $36,400
  - Merchandise Inventory: $84,440
  - Prepaid Expenses: $5,500
  - Plant Assets, Net: $370,000
  - Total Assets: $515,340

- **Kyan Company:**
  - Cash: $37,000
  - Accounts Receivable, Net: $58,400
  - Merchandise Inventory: $130,560
  - Prepaid Expenses: $7,150
  - Plant Assets, Net: $312,400
  - Total Assets: $545,450

#### Liabilities and Equity
- **Barco Company:**
  - Current Liabilities: $67,340
  - Long-term Notes Payable: $79,800
  - Common Stock, $5 Par Value: $190,000
  - Retained Earnings: $178,200
  - Total Liabilities and Equity: $515,340

- **Kyan Company:**
  - Current Liabilities: $95,300
  - Long-term Notes Payable: $103,000
  - Common Stock, $5 Par Value: $246,000
  - Retained Earnings: $101,150
  - Total Liabilities and Equity: $545,450

### Current Year’s Income Statement

- **Barco Company:**
  - Sales: $770,000
  - Cost of Goods Sold: $593,100
  - Interest Expense: $7,800
  - Income Tax Expense: $14,800
  - Net Income: $154,300
  - Basic Earnings per Share: $4.06
  - Cash Dividends per Share: $3.78

- **Kyan Company:**
  - Sales: $882,200
  - Cost of Goods Sold: $638,150
  - Interest Expense: $18,000
  - Income Tax Expense: $24,350
  - Net Income:
Transcribed Image Text:**Problem 17-5A Comparative Ratio Analysis** **Summary Information:** This dataset provides insight into the financial statements of two companies, Barco Company and Kyan Company, which operate in the same industry. The information is categorized and compared across various financial metrics. ### Current Year-End Balance Sheets #### Assets - **Barco Company:** - Cash: $19,000 - Accounts Receivable, Net: $36,400 - Merchandise Inventory: $84,440 - Prepaid Expenses: $5,500 - Plant Assets, Net: $370,000 - Total Assets: $515,340 - **Kyan Company:** - Cash: $37,000 - Accounts Receivable, Net: $58,400 - Merchandise Inventory: $130,560 - Prepaid Expenses: $7,150 - Plant Assets, Net: $312,400 - Total Assets: $545,450 #### Liabilities and Equity - **Barco Company:** - Current Liabilities: $67,340 - Long-term Notes Payable: $79,800 - Common Stock, $5 Par Value: $190,000 - Retained Earnings: $178,200 - Total Liabilities and Equity: $515,340 - **Kyan Company:** - Current Liabilities: $95,300 - Long-term Notes Payable: $103,000 - Common Stock, $5 Par Value: $246,000 - Retained Earnings: $101,150 - Total Liabilities and Equity: $545,450 ### Current Year’s Income Statement - **Barco Company:** - Sales: $770,000 - Cost of Goods Sold: $593,100 - Interest Expense: $7,800 - Income Tax Expense: $14,800 - Net Income: $154,300 - Basic Earnings per Share: $4.06 - Cash Dividends per Share: $3.78 - **Kyan Company:** - Sales: $882,200 - Cost of Goods Sold: $638,150 - Interest Expense: $18,000 - Income Tax Expense: $24,350 - Net Income:
**Problem 17-5A Part 1**

**Required:**

**1a.** For both companies compute the following:
- (a) Current ratio
- (b) Acid-test ratio
- (c) Accounts receivable turnover
- (d) Inventory turnover
- (e) Days' sales in inventory
- (f) Days’ sales uncollected

*(Note: Do not round intermediate calculations.)*

**1b.** Identify the company you consider to be the better short-term credit risk.

**Instructions:**

Complete this question by entering your answers in the tabs below.

- **1A Current Ratio**
- **1A Acid Test Ratio**
- **1A Acct Rec Turn**
- **1A Invent Turnover**
- **1A Days Sal in Inv**
- **1A Days Sal Uncol**
- **1B short term**

**Calculation for Accounts Receivable Turnover:**

For both companies, compute the accounts (including notes) receivable turnover.

| Company | Choose Numerator: | / | Choose Denominator: | = Accounts Receivable Turnover |
|---------|-------------------|---|--------------------|----------------------------------|
| Barco   |                   | / |                    | = 0 times                     |
| Kyan    |                   | / |                    | = 0 times                     |

**Navigation:**

- **< 1A Acid Test Ratio**
- **1A Invent Turnover >** 

This setup provides a structured approach to analyze the financial metrics of the companies Barco and Kyan, focusing on their short-term financial health indicators.
Transcribed Image Text:**Problem 17-5A Part 1** **Required:** **1a.** For both companies compute the following: - (a) Current ratio - (b) Acid-test ratio - (c) Accounts receivable turnover - (d) Inventory turnover - (e) Days' sales in inventory - (f) Days’ sales uncollected *(Note: Do not round intermediate calculations.)* **1b.** Identify the company you consider to be the better short-term credit risk. **Instructions:** Complete this question by entering your answers in the tabs below. - **1A Current Ratio** - **1A Acid Test Ratio** - **1A Acct Rec Turn** - **1A Invent Turnover** - **1A Days Sal in Inv** - **1A Days Sal Uncol** - **1B short term** **Calculation for Accounts Receivable Turnover:** For both companies, compute the accounts (including notes) receivable turnover. | Company | Choose Numerator: | / | Choose Denominator: | = Accounts Receivable Turnover | |---------|-------------------|---|--------------------|----------------------------------| | Barco | | / | | = 0 times | | Kyan | | / | | = 0 times | **Navigation:** - **< 1A Acid Test Ratio** - **1A Invent Turnover >** This setup provides a structured approach to analyze the financial metrics of the companies Barco and Kyan, focusing on their short-term financial health indicators.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education