me Statement and Other Data For the Years Ended December 31, 2014 and 2013 (in millions) 2014 2013 Income statement data: $2,913 $3,050 296 Sales.. 310 Operating income. Interest expense. Net income Other data: 65 84 187 192 46.7 41.3 Average number of common shares outstanding.. Total dividends paid $ 52.3 $ 50.0

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

f, g, and h

**Ratio Analysis — Comprehensive Problem**

Presented here are summarized data from the balance sheets and income statements of Wiper, Inc.

### WIPER, INC.  
**Condensed Balance Sheets**  
*December 31, 2014, 2013, 2012*  
*(in millions)*

- **2014**
  - Current assets: $677
  - Other assets: $2,413
  - Total assets: $3,090
  - Current liabilities: $562
  - Long-term liabilities: $1,521
  - Stockholders' equity: $1,007

- **2013**
  - Current assets: $891
  - Other assets: $1,920
  - Total assets: $2,811
  - Current liabilities: $803
  - Long-term liabilities: $982
  - Stockholders' equity: $1,026

- **2012**
  - Current assets: $736
  - Other assets: $1,719
  - Total assets: $2,455
  - Current liabilities: $710
  - Long-term liabilities: $827
  - Stockholders' equity: $918

### WIPER, INC.  
**Selected Income Statement and Other Data**  
*For the Years Ended December 31, 2014 and 2013*  
*(in millions)*

- **2014**
  - Sales: $3,050
  - Operating income: $296
  - Interest expense: $84
  - Net income: $192
  - Average number of common shares outstanding: 41.3
  - Total dividends paid: $50.0

- **2013**
  - Sales: $2,913
  - Operating income: $310
  - Interest expense: $65
  - Net income: $187
  - Average number of common shares outstanding: 46.7
  - Total dividends paid: $52.3

These tables provide a snapshot of Wiper, Inc.’s financial position and performance over the specified years. Key measures such as assets, liabilities, equity, sales, income, and dividends are presented to highlight the company's financial health and trends.
Transcribed Image Text:**Ratio Analysis — Comprehensive Problem** Presented here are summarized data from the balance sheets and income statements of Wiper, Inc. ### WIPER, INC. **Condensed Balance Sheets** *December 31, 2014, 2013, 2012* *(in millions)* - **2014** - Current assets: $677 - Other assets: $2,413 - Total assets: $3,090 - Current liabilities: $562 - Long-term liabilities: $1,521 - Stockholders' equity: $1,007 - **2013** - Current assets: $891 - Other assets: $1,920 - Total assets: $2,811 - Current liabilities: $803 - Long-term liabilities: $982 - Stockholders' equity: $1,026 - **2012** - Current assets: $736 - Other assets: $1,719 - Total assets: $2,455 - Current liabilities: $710 - Long-term liabilities: $827 - Stockholders' equity: $918 ### WIPER, INC. **Selected Income Statement and Other Data** *For the Years Ended December 31, 2014 and 2013* *(in millions)* - **2014** - Sales: $3,050 - Operating income: $296 - Interest expense: $84 - Net income: $192 - Average number of common shares outstanding: 41.3 - Total dividends paid: $50.0 - **2013** - Sales: $2,913 - Operating income: $310 - Interest expense: $65 - Net income: $187 - Average number of common shares outstanding: 46.7 - Total dividends paid: $52.3 These tables provide a snapshot of Wiper, Inc.’s financial position and performance over the specified years. Key measures such as assets, liabilities, equity, sales, income, and dividends are presented to highlight the company's financial health and trends.
**Financial Analysis Exercises**

a. **Return on Investment (ROI) Calculation**
   - Calculate ROI based on net income and average total assets for the years 2014 and 2013.
   - Include both margin and turnover in your analysis.

b. **Return on Equity (ROE) Calculation**
   - Determine the ROE for the years 2014 and 2013.

c. **Working Capital and Current Ratio**
   - Compute working capital and the current ratio for each of the past three years.

d. **Earnings Per Share (EPS) Calculation**
   - Determine EPS for 2014 and 2013.

e. **Market Price Estimation**
   - Given a price/earnings (P/E) ratio of 13 at the end of 2014, estimate the market price of Wiper's stock.

f. **Cash Dividend Per Share and Dividend Yield**
   - Calculate the cash dividend per share for 2014 and evaluate the dividend yield based on the market price from part e.

g. **Dividend Payout Ratio**
   - Find the dividend payout ratio for 2014.

h. **Accounts Receivable Analysis**
   - Assuming accounts receivable totaled $309 million at December 31, 2014, compute the number of days' sales in receivables.

i. **Debt and Debt/Equity Ratio Calculation**
   - Calculate Wiper's debt ratio and debt/equity ratio on December 31, 2014, and 2013.

j. **Times Interest Earned Ratio**
   - Determine the times interest earned ratio for 2014 and 2013.

k. **Investment Suitability Evaluation**
   - Analyze the results of the calculations, assess the profitability and liquidity of the company, and determine its suitability as an investment for a young, single professional looking to invest in common stock.
Transcribed Image Text:**Financial Analysis Exercises** a. **Return on Investment (ROI) Calculation** - Calculate ROI based on net income and average total assets for the years 2014 and 2013. - Include both margin and turnover in your analysis. b. **Return on Equity (ROE) Calculation** - Determine the ROE for the years 2014 and 2013. c. **Working Capital and Current Ratio** - Compute working capital and the current ratio for each of the past three years. d. **Earnings Per Share (EPS) Calculation** - Determine EPS for 2014 and 2013. e. **Market Price Estimation** - Given a price/earnings (P/E) ratio of 13 at the end of 2014, estimate the market price of Wiper's stock. f. **Cash Dividend Per Share and Dividend Yield** - Calculate the cash dividend per share for 2014 and evaluate the dividend yield based on the market price from part e. g. **Dividend Payout Ratio** - Find the dividend payout ratio for 2014. h. **Accounts Receivable Analysis** - Assuming accounts receivable totaled $309 million at December 31, 2014, compute the number of days' sales in receivables. i. **Debt and Debt/Equity Ratio Calculation** - Calculate Wiper's debt ratio and debt/equity ratio on December 31, 2014, and 2013. j. **Times Interest Earned Ratio** - Determine the times interest earned ratio for 2014 and 2013. k. **Investment Suitability Evaluation** - Analyze the results of the calculations, assess the profitability and liquidity of the company, and determine its suitability as an investment for a young, single professional looking to invest in common stock.
Expert Solution
Step 1

  Dividend Payout Ratio =    Dividend Per Share(DPS)Earning Per Share(EPS)

 

  Dividend Yield    =  Dividend Per Share x100Market Price Per Share

Debtor Turnover Ratio =Net Credit SalesAverage Debtor

Dividend Per Share =  Dividend to equity shareholderNumber of equity Share

Debtor Velocity     =  365daysDebtor Turnover Ratio

COMMENT - Market Price per Share and earning Per share as calculated in part e, d, not mentioned. 

Better your learning with
Practice Pack
video

Learn your way

Includes step-by-step video

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Investment Companies
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.
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