i. Use the following simplified 2019 balance sheet to show, in general terms, how an improvement in one of the ratios—say, the DSO—would affect the stock price. For example, if the company could improve its collection procedures and thereby lower the DSO from 38.1 days to 27.8 days, how would that change “ripple through” the financial statements (shown in thousands below) and influence the stock price? Accounts receivable $ 402 Debt $ 965 Other current assets 888 Net fixed assets 361 Equity 686. Total assets $1,651 Total liabilities and equity $1,651 j. Although financial statement analysis can provide useful information about a company’s operations and its financial condition, this type of analysis does have some potential problems and limitations, and it must be used with care and judgment. What are some problems and limitations?

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Topic Video
Question

i. Use the following simplified 2019 balance sheet to show, in general terms, how an improvement in one
of the ratios—say, the DSO—would affect the stock price. For example, if the company could improve its
collection procedures and thereby lower the DSO from 38.1 days to 27.8 days, how would that change
“ripple through” the financial statements (shown in thousands below) and influence the stock price?

Accounts receivable $ 402                                         Debt $ 965                              Other current assets 888

Net fixed assets 361 Equity 686.                        Total assets $1,651                  Total liabilities and equity $1,651

j. Although financial statement analysis can provide useful information about a company’s operations and
its financial condition, this type of analysis does have some potential problems and limitations, and it
must be used with care and judgment. What are some problems and limitations?

Assignment 1
Donna Jamison was recently hired a financial analyst by Computron Industries, a manufacturer of
electronic components. Her first task was to conduct a financial analysis of the firm covering the last two
years. To begin, she gathered the following financial statements and other data.
Balance Sheets
Assets
Cash
Accounts receivable
Inventories
Total current assets
Gross fixed assets
Less accumulated depreciation
Net fixed assets
Total assets
Liabilities and Equity
Accounts payable
Notes payable
Accruals
Total current liabilities
Long-term debt
Common stock (100,000 shares)
Retained earnings
Total equity
Total liabilities and equity
(continued)
$
2019
52,000
402,000
836,000
$1,290,000
527,000
166,200
$360,800
$1,650.800
$ 175,200
225,000
140,000
$540,200
424,612
460,000
225,988
$ 685,988
$1,650.800
$
2018
57,600
351,200
715,200
$1,124,000
491,000
146,200
$ 344,800
$1,468,800
$ 145,600
200,000
136,000
$ 481,600
323,432
460,000
203,768
$ 663,768
$1,468,800
Income Statements
Sales
Cost of goods sold
Other expenses
Depreciation
Total operating costs
EBIT
Interest expense
EBT
Taxes (40%)
Net income
EPS
Statement of Cash Flows (2019)
Operating Activities
Net income
Other additions (sources of cash)
Depreciation
Increase in accounts payable
Increase in accruals
Subtractions (uses of cash)
Increases in accounts receivable
Increase in inventories
Net cash flow from operations
Long-Term Investing Activities
Investment in fixed assets
Financing Activities
Increase in notes payable
Increase in long-term debt
Payment of cash dividends
Net cash flow from financing
Net reduction in cash account
Cash at beginning of year
Cash at end of year
2019
$3,850,000
(3,250,000)
(430,300)
(20,000)
$3,700,300
$ 149,700
( 76,000)
$ 73,700
(29,480)
$ 44,220
$0.442
(continued)
$ 44,220
20,000
29,600
4,000
(50,800)
(120,800)
$ 25,000
101,180
(22,000)
2018
$3,432,000
(2,864,000)
(340,000)
(18,900)
$3,222,900
$ 209,100
(62,500)
$ 146,600
( 58,640)
$ 87,960
$0.880
$( 73,780)
$( 36,000)
$104,180
$( 5,600)
57,600
$ 52,000
Other Data
December 31 stock price
Number of shares
Dividends per share
Lease payments
Industry average data for 2019:
Ratio
Current
Quick
Inventory turnover
Days sales outstanding (DSO)
Fixed assets turnover
Total assets turnover
Debt ratio
TIE
Fixed charge coverage
Net profit margin
ROA
ROE
Price/earnings
Market/book
2019
$6.00
100,000
$ 0.22
$40,000
2018
$8.50
100,000
$0.22
$40,000
Industry Average
2.7x
1.0x
6.0x
32.0 days
10.7x
2.6x
50.0%
2.5x
2.1x
3.5%
9.1 %
18.2%
14.2x
1.4x
Transcribed Image Text:Assignment 1 Donna Jamison was recently hired a financial analyst by Computron Industries, a manufacturer of electronic components. Her first task was to conduct a financial analysis of the firm covering the last two years. To begin, she gathered the following financial statements and other data. Balance Sheets Assets Cash Accounts receivable Inventories Total current assets Gross fixed assets Less accumulated depreciation Net fixed assets Total assets Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt Common stock (100,000 shares) Retained earnings Total equity Total liabilities and equity (continued) $ 2019 52,000 402,000 836,000 $1,290,000 527,000 166,200 $360,800 $1,650.800 $ 175,200 225,000 140,000 $540,200 424,612 460,000 225,988 $ 685,988 $1,650.800 $ 2018 57,600 351,200 715,200 $1,124,000 491,000 146,200 $ 344,800 $1,468,800 $ 145,600 200,000 136,000 $ 481,600 323,432 460,000 203,768 $ 663,768 $1,468,800 Income Statements Sales Cost of goods sold Other expenses Depreciation Total operating costs EBIT Interest expense EBT Taxes (40%) Net income EPS Statement of Cash Flows (2019) Operating Activities Net income Other additions (sources of cash) Depreciation Increase in accounts payable Increase in accruals Subtractions (uses of cash) Increases in accounts receivable Increase in inventories Net cash flow from operations Long-Term Investing Activities Investment in fixed assets Financing Activities Increase in notes payable Increase in long-term debt Payment of cash dividends Net cash flow from financing Net reduction in cash account Cash at beginning of year Cash at end of year 2019 $3,850,000 (3,250,000) (430,300) (20,000) $3,700,300 $ 149,700 ( 76,000) $ 73,700 (29,480) $ 44,220 $0.442 (continued) $ 44,220 20,000 29,600 4,000 (50,800) (120,800) $ 25,000 101,180 (22,000) 2018 $3,432,000 (2,864,000) (340,000) (18,900) $3,222,900 $ 209,100 (62,500) $ 146,600 ( 58,640) $ 87,960 $0.880 $( 73,780) $( 36,000) $104,180 $( 5,600) 57,600 $ 52,000 Other Data December 31 stock price Number of shares Dividends per share Lease payments Industry average data for 2019: Ratio Current Quick Inventory turnover Days sales outstanding (DSO) Fixed assets turnover Total assets turnover Debt ratio TIE Fixed charge coverage Net profit margin ROA ROE Price/earnings Market/book 2019 $6.00 100,000 $ 0.22 $40,000 2018 $8.50 100,000 $0.22 $40,000 Industry Average 2.7x 1.0x 6.0x 32.0 days 10.7x 2.6x 50.0% 2.5x 2.1x 3.5% 9.1 % 18.2% 14.2x 1.4x
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education