Widgets, Inc. Use the following information to answer the next ten questions
Net Sales: 1000
Cost of Goods Sold: 600
Depreciation: 100
Interest Paid: 30
Dividends Paid: 30
Tax Rate: 35%
Solve for: 1.) EBIT, 2.) Net Income, 3.) Addition to Retained Earnings, 4.) Operating Cash Flow.
Use this additional information about Widgets, Inc. to fill in the blanks:
2010 Net Capital Spending
Ending Net Fixed assets........$500
- Beginning Net Fixed Assets.......$300
+ Depreciation......5.)
Net Captial spending.......6.)
2010 Change in Net Working Capital
2010 Current Assets.......$1600
2010 Current Liabilities.....$1200
2010 Net Working Capital.......7.)
2009 Current Assets.....$1800
2009 Current Liabilities.....$1200
2009 Net Working Capitial......8.)
Change in Net Working Capital......9.)
10.) What is the 2010 Cash Flow from Assets?
Widgets, Inc. Use the following information to answer the next ten questions
Net Sales: 1000
Cost of Goods Sold: 600
Depreciation: 100
Interest Paid: 30
Dividends Paid: 30
Tax Rate: 35%
Solve for: 1.) EBIT, 2.) Net Income, 3.) Addition to Retained Earnings, 4.) Operating Cash Flow.
Use this additional information about Widgets, Inc. to fill in the blanks:
2010 Net Capital Spending
Ending Net Fixed assets........$500
- Beginning Net Fixed Assets.......$300
+ Depreciation......5.)
Net Captial spending.......6.)
2010 Change in Net Working Capital
2010 Current Assets.......$1600
2010 Current Liabilities.....$1200
2010 Net Working Capital.......7.)
2009 Current Assets.....$1800
2009 Current Liabilities.....$1200
2009 Net Working Capitial......8.)
Change in Net Working Capital......9.)
10.) What is the 2010 Cash Flow from Assets?
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 | ||||||
1.)Company ABC has sales of $1,650,000, cost of goods sold of$600,000, EBIT of $450,000, interest expense of $70,000, and a taxrate of 27%. If the company paid $57,000 in dividends what is theaddition to retained earnings.
2.)At the beginning of the year, a firm had current assets of$121,306 and current liabilities of $124,509. At the end of theyear, the current assets were $122,418 and the current liabilitieswere $103,718. What is the change in net working capital?
3.)
Use the Income Statement and Balance Sheet below to calculatethe companies free cash flow.
Income Statement | 2017 |
Net Sales | 675 |
Cost of goods sold | 210 |
Depreciation | 50 |
EBIT | 415 |
Interest Paid | 15 |
EBT | 400 |
Taxes (30%) | 120 |
Net Income | 280 |
Dividends | 105 |
Addition to Retained Earnings | 175 |
Assets | 2016 | 2017 | Liabilities and Shareholders equity | 2016 | 2017 |
Current Assets | Current Liabilities | ||||
Cash | 100 | 125 | Accounts Payable | 200 | 250 |
Accounts Receivable | 250 | 350 | Notes Payable | 150 | 225 |
Inventory | 400 | 375 | |||
Total Current Assets | 750 | 850 | Total Current Liabilities | 350 | 475 |
Long term debt | 300 | 250 | |||
Fixed Assets | Stockholders equity | ||||
PPE | 1500 | 1700 | Common stock | 300 | 300 |
Accumulated Depreciation | 400 | 450 | Retained earnings | 900 | 1075 |
Net PPE | 1100 | 1250 | Total Shareholderâs Equity | 1200 | 1375 |
Total Assets | 1850 | 2100 | Total Liabilities & Equity | 1850 | 2100 |
4.)A firm has net working capital of $900. Long-term debt is$4,200, total assets are $8,000, and fixed assets are $4,300. Whatis the amount of the total liabilities?
