FIN 357 Chapter Notes - Chapter 3: Reserve Requirement, Current Liability, Asset Management
Document Summary
Get access
Related Documents
Related Questions
Joshua & White Technologies: December 31 Balance Sheets | ||||||
(Thousands of Dollars) | ||||||
Assets | 2010 | 2009 | ||||
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) | ||||||
2010 | 2009 | |||||
Sales | $420,000 | $400,000 | ||||
Expenses excluding depr. and amort. | 327,600 | 320,000 | ||||
EBITDA | $92,400 | $80,000 | ||||
Depreciation and Amortization | 19,660 | 18,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 | 2010 | 2009 | ||||
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) | $0 | $0 | ||||
Ratio Analysis | 2010 | 2009 | Industry Avg | |||
Liquidity Ratios | ||||||
Current Ratio | 2.38 | 2.52 | 2.58 | |||
Quick Ratio | 1.17 | 1.41 | 1.53 | |||
Asset Management Ratios | ||||||
Inventory Turnover | 1.11 | 1.22 | 7.69 | |||
Days Sales Outstanding | 45.63 | 43.80 | 47.45 | |||
Fixed Assets Turnover | 1.92 | 2.00 | 2.04 | |||
Total Assets Turnover | 3.81 | 5.64 | 1.23 | |||
Debt Management Ratios | ||||||
Debt Ratio | 32.1% | |||||
Times-interest-earned ratio | 15.33 | |||||
EBITDA coverage ratio | 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 | 21.87% | 19.35% | 16.10% | |||
Market Value Ratios | ||||||
Earnings per share | NA | |||||
Price-to-earnings ratio | 10.65 | |||||
Cash flow per share | NA | |||||
Price-to-cash flow ratio | 7.11 | |||||
Book Value per share | NA | |||||
Market-to-book ratio | 1.72 | |||||
a. Has Joshua & White's liquidity position improved or worsened? Explain. | ||||||
The position of JW has worsend because there ration has fallen from 1.41 to 1.17 | ||||||
b. Has Joshua & White's ability to manage its assets improved or worsened? Explain. | ||||||
c. How has Joshua & White's profitability changed during the last year? | ||||||
d. Perform an extended Du Pont analysis for Joshua & White for 2008 and 2009. | ||||||
ROE = | PM x | TA Turnover x Equity Multiplier | ||||
2010 | ||||||
2009 | ||||||
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 | 2010 | 2009 | ||||
Cash and cash equivalents | ||||||
Short-term investments | ||||||
Accounts Receivable | ||||||
Inventories | ||||||
Total current assets | ||||||
Net fixed assets | ||||||
Total assets | ||||||
Liabilities and equity | 2010 | 2009 | ||||
Accounts payable | ||||||
Accruals | ||||||
Notes payable | ||||||
Total current liabilities | ||||||
Long-term debt | ||||||
Total liabilities | ||||||
Common stock | ||||||
Retained Earnings | ||||||
Total common equity | ||||||
Total liabilities and equity | ||||||
Common Size Income Statements | 2010 | 2009 | ||||
Sales | ||||||
Expenses excluding depr. and amort. | ||||||
EBITDA | ||||||
Depreciation and Amortization | ||||||
EBIT | ||||||
Interest Expense | ||||||
EBT | ||||||
Taxes (40%) | ||||||
Net Income | ||||||
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 | 2010 | 2009 | ||||
Cash and cash equivalents | ||||||
Short-term investments | ||||||
Accounts Receivable | ||||||
Inventories | ||||||
Total current assets | ||||||
Net fixed assets | ||||||
Total assets | ||||||
Base | ||||||
Liabilities and equity | 2010 | 2009 | ||||
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 | 2010 | 2009 | ||||
Sales | ||||||
Expenses excluding depr. and amort. | ||||||
EBITDA | ||||||
Depreciation and Amortization | ||||||
EBIT | ||||||
Interest Expense | ||||||
EBT | ||||||
Taxes (40%) | ||||||
Net Income | ||||||
Joshua & White Technologies: December 31 Balance Sheets | ||||||
(Thousands of Dollars) | ||||||
Assets | 2010 | 2009 | ||||
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) | ||||||
2010 | 2009 | |||||
Sales | $420,000 | $400,000 | ||||
Expenses excluding depr. and amort. | 327,600 | 320,000 | ||||
EBITDA | $92,400 | $80,000 | ||||
Depreciation and Amortization | 19,660 | 18,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 | 2010 | 2009 | ||||
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) | $0 | $0 | ||||
Ratio Analysis | 2010 | 2009 | Industry Avg | |||
Liquidity Ratios | ||||||
Current Ratio | 2.38 | 2.52 | 2.58 | |||
Quick Ratio | 1.17 | 1.41 | 1.53 | |||
Asset Management Ratios | ||||||
Inventory Turnover | 1.11 | 1.22 | 7.69 | |||
Days Sales Outstanding | 45.63 | 43.80 | 47.45 | |||
Fixed Assets Turnover | 1.92 | 2.00 | 2.04 | |||
Total Assets Turnover | 3.81 | 5.64 | 1.23 | |||
Debt Management Ratios | ||||||
Debt Ratio | 32.1% | |||||
Times-interest-earned ratio | 15.33 | |||||
EBITDA coverage ratio | 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 | 21.87% | 19.35% | 16.10% | |||
Market Value Ratios | ||||||
Earnings per share | NA | |||||
Price-to-earnings ratio | 10.65 | |||||
Cash flow per share | NA | |||||
Price-to-cash flow ratio | 7.11 | |||||
Book Value per share | NA | |||||
Market-to-book ratio | 1.72 | |||||
a. Has Joshua & White's liquidity position improved or worsened? Explain. | ||||||
The position of JW has worsend because there ration has fallen from 1.41 to 1.17 | ||||||
b. Has Joshua & White's ability to manage its assets improved or worsened? Explain. | ||||||
c. How has Joshua & White's profitability changed during the last year? | ||||||
d. Perform an extended Du Pont analysis for Joshua & White for 2008 and 2009. | ||||||
ROE = | PM x | TA Turnover x Equity Multiplier | ||||
2010 | ||||||
2009 | ||||||
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 | 2010 | 2009 | ||||
Cash and cash equivalents | ||||||
Short-term investments | ||||||
Accounts Receivable | ||||||
Inventories | ||||||
Total current assets | ||||||
Net fixed assets | ||||||
Total assets | ||||||
Liabilities and equity | 2010 | 2009 | ||||
Accounts payable | ||||||
Accruals | ||||||
Notes payable | ||||||
Total current liabilities | ||||||
Long-term debt | ||||||
Total liabilities | ||||||
Common stock | ||||||
Retained Earnings | ||||||
Total common equity | ||||||
Total liabilities and equity | ||||||
Common Size Income Statements | 2010 | 2009 | ||||
Sales | ||||||
Expenses excluding depr. and amort. | ||||||
EBITDA | ||||||
Depreciation and Amortization | ||||||
EBIT | ||||||
Interest Expense | ||||||
EBT | ||||||
Taxes (40%) | ||||||
Net Income | ||||||
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 | 2010 | 2009 | ||||
Cash and cash equivalents | ||||||
Short-term investments | ||||||
Accounts Receivable | ||||||
Inventories | ||||||
Total current assets | ||||||
Net fixed assets | ||||||
Total assets | ||||||
Base | ||||||
Liabilities and equity | 2010 | 2009 | ||||
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 | 2010 | 2009 | ||||
Sales | ||||||
Expenses excluding depr. and amort. | ||||||
EBITDA | ||||||
Depreciation and Amortization | ||||||
EBIT | ||||||
Interest Expense | ||||||
EBT | ||||||
Taxes (40%) | ||||||
Net Income | ||||||
Show ALL work
Ratio Analysis. The Williams Corporationâs forecasted 2010 financial statements follow, along with some industry average ratios.
Forecasted Balance Sheet as of December 31, 2010 | ||||
Cash | $ 72,000 | |||
Accounts receivables | $ 439,000 | Accounts and notes payable | $ 432,000 | |
Inventories | $ 894,000 | Accruals | $ 170,000 | |
Total current assets | $1,405,000 | Total current liabilities | $ 602,000 | |
Land and building | $ 238,000 | Long-term debt | $ 404,290 | |
Machinery | $ 132,000 | Common stock | $ 575,000 | |
Other fixed assets | $ 61,000 | Retained earnings | $ 254,710 | |
Total assets | $1,836,000 | Total liabilities and equity | $1,836,000 |
Forecasted Income Statement for 2010 | ||||
Sales | $4,290,000 | |||
Cost of goods sold | $3,580,000 | Per-Share Data | ||
Gross operating profit | $ 710,000 | EPS | $ 4.71 | |
General admin & selling expenses | $ 236,320 | DPS | $ 0.95 | |
Depreciation | $ 159,000 | P/E Ratio | 5.00 | |
Misc. | $ 134,000 | Market price | $ 23.57 | |
Earnings before Taxes | $ 180,680 | Number of shares outstanding | 23000 | |
Taxes | $ 72,272 | |||
Net Income | $ 108,408 |
Industry Financial Ratios | Williamâs Financial Ratios | Ratio/Comment | ||
Quick Ratio | 1x | Quick Ratio | ||
Current Ratio | 2.7x | Current Ratio | ||
Inventory Turnover | 7x | Inventory Turnover | ||
Days Sales Outstanding | 40 days | Days Sales Outstanding | ||
Fixed Asset Turnover | 13x | Fixed Asset Turnover | ||
Total Asset Turnover | 2.6x | Total Asset Turnover | ||
Return on Assets | 9.10% | Return on Assets | ||
Return on Equity | 18.20% | Return on Equity | ||
Debt Ratio | 55% | Debt Ratio | ||
Profit Margin on Sales | 3.50% | Profit Margin on Sales | ||
P/E Ratio | 6x | P/E Ratio |
Please show all work for the following questions.
a. Calculate the indicated ratios for Williamâs in the appropriate blanks.
b. Outline Williamâs strengths and weaknesses as compared to its industry. Be detailed in your ratio analysis.
c. Recommend at least three areas for correction. Be sure to support your recommendations.
d. Why is being trustworthy essential to success in the business world? Use at least two of the following scriptures to answer this question: Psalm 101:7, Proverbs 4:20-27, Proverbs 13:11, and Proverbs 28:12-13.