Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Joshua & White Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2016 2015 Cash and cash equivalents $21,000 $20,000 Short-term investments 3,759 3,240 Accounts

Joshua & White Technologies: December 31 Balance Sheets
(Thousands of Dollars)
Assets 2016 2015
Cash and cash equivalents $21,000 $20,000
Short-term investments 3,759 3,240
Accounts Receivable 52,500 48,000
Inventories 84,000 56,000
Total current assets $161,259 $127,240
Net fixed assets 218,400 200,000
Total assets $379,659 $327,240
Liabilities and equity
Accounts payable $33,600 $32,000
Accruals 12,600 12,000
Notes payable 19,929 6,480
Total current liabilities $66,129 $50,480
Long-term debt 67,662 58,320
Total liabilities $133,791 $108,800
Common stock 183,793 178,440
Retained Earnings 62,075 40,000
Total common equity $245,868 $218,440
Total liabilities and equity $379,659 $327,240
Joshua & White Technologies December 31 Income Statements
(Thousands of Dollars)
2016 2015
Sales $420,000 $400,000
COGS except excluding depr. and amort. 300,000 298,000
Depreciation and Amortization 19,660 18,000
Other operating expenses 27,600 22,000
EBIT $72,740 $62,000
Interest Expense 5,740 4,460
EBT $67,000 $57,540
Taxes (40%) 26,800 23,016
Net Income $40,200 $34,524
Common dividends $18,125 $17,262
Addition to retained earnings $22,075 $17,262
Other Data 2016 2015
Year-end Stock Price $90.00 $96.00
# of shares (Thousands) 4,052 4,000
Lease payment (Thousands of Dollars) $20,000 $20,000
Sinking fund payment (Thousands of Dollars) $5,000 $5,000
Ratio Analysis 2016 2015 Industry Avg
Liquidity Ratios
Current Ratio 2.44 2.52 2.58
Quick Ratio 1.17 1.41 1.53
Asset Management Ratios
Inventory Turnover (Total COGS/Inventories) 5.00 7.14 7.69
Days Sales Outstanding 45.63 43.80 47.45
Fixed Assets Turnover 1.92 2.00 2.04
Total Assets Turnover 1.11 1.22 1.23
Debt Management Ratios
Debt Ratio (Total debt-to-assets) 23.1% 20.0% 20.0%
Liabilities-to-assets ratio 35.2% 33.2% 32.1%
Times-interest-earned ratio 12.67 13.90 15.33
EBITDA coverage ratio 4.37 4.09 4.18
Profitability Ratios
Profit Margin 9.57% 8.63% 8.86%
Basic Earning Power 19.16% 18.95% 19.48%
Return on Assets 10.59% 10.55% 10.93%
Return on Equity 16.35% 1.80% 16.10%
Market Value Ratios
Earnings per share $9.92 $8.63 NA
Price-to-earnings ratio 9.07 11.12 10.65
Cash flow per share $14.77 $13.13 NA
Price-to-cash flow ratio 6.09 7.31 7.11
Book Value per share $60.68 $54.61 NA
Market-to-book ratio 1.48 1.76 1.72
a. Has Joshua & White's liquidity position improved or worsened? Explain.
It was worsened because the quick ratio has fallen by quite a bit
b. Has Joshua & White's ability to manage its assets improved or worsened? Explain.
The assets has improved a little but the rations have not. Inventory turnover has worsened which means there maybe a bigger issue there.
c. How has Joshua & White's profitability changed during the last year?
all profit margins have increased and are above the industry standard
d. Perform an extended Du Pont analysis for Joshua & White for 2008 and 2009.
ROE = PM x TA Turnover x Equity Multiplier
2016 16.35% 9.57% 1.11 1.54
2015 15.80% 8.63% 1.22 1.50
e. Perform a common size analysis. What has happened to the composition
(that is, percentage in each category) of assets and liabilities?
Common Size Balance Sheets
Assets 2016 2015
Cash and cash equivalents 6.0% 6.0%
Short-term investments 1.0% 1.0%
Accounts Receivable 14.0% 15.0%
Inventories 22.0% 17.0%
Total current assets 42.0% 39.0%
Net fixed assets 58.0% 61.0%
Total assets 100.0%
Liabilities and equity 2016 2015
Accounts payable 9.0% 2.0%
Accruals 3.0% 4.0%
Notes payable 5.0% 2.0%
Total current liabilities 17.0% 15.0%
Long-term debt 18.0% 18.0%
Total liabilities
Common stock 48.0% 55.0%
Retained Earnings 16.0% 12.0%
Total common equity 65.0% 67.0%
Total liabilities and equity 100.0% 100.0%
Common Size Income Statements 2016 2015
Sales $ 4,200.00 $ 4,000.00
COGS except excluding depr. and amort. $ 3,000.00 $ 2,980.00
Depreciation and Amortization $ 19,660.00 $ 18,000.00
Other operating expenses $ 27,600.00 $ 22,000.00
EBIT $ 72,740.00 $ 62,000.00
Interest Expense $ 5,740.00 $ 4,460.00
EBT $ 670.00 $ 575.40
Taxes (40%) 26.8% 23.0%
Net Income $ 40,200.00 $ 34,524.00
f. Perform a percent change analysis. What does this tell you about the change in profitability
and asset utilization?
Percent Change Balance Sheets Base
Assets 2016 2015
Cash and cash equivalents
Short-term investments
Accounts Receivable
Inventories
Total current assets
Net fixed assets
Total assets
Base
Liabilities and equity 2016 2015
Accounts payable
Accruals
Notes payable
Total current liabilities
Long-term debt
Total liabilities
Common stock
Retained Earnings
Total common equity
Total liabilities and equity
Base
Percent Change Income Statements 2016 2015
Sales
COGS except excluding depr. and amort.
Depreciation and Amortization
Other operating expenses
EBIT
Interest Expense
EBT
Taxes (40%)
Net Income

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Auditing

Authors: Knapp, Rittenberg

1st Edition

1133731244, 978-1133731245

More Books

Students also viewed these Accounting questions