| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
Vertical analysis | Horizontal analysis |
| ||||
| ||||
|
| ||
| ||
|
Balance Sheet
Assets Year 2003 Year 2004 Cash 500 450 Accounts Receivable 600 660 Inventory 500 550 Total CA 1300 1660 Plant, prop. equip 1000 1250 Total Assets 2600 2910 Liabilities Accounts Payable 500 550 Long term debt 700 1102 Total liabilities 1200 1652 Equity Common Stock 400 538 Retained Earnings 1000 720 Total Liabilities & Equity 2600 2910 Income Statement
Sales 3000 Cost of Goods Sold (1000) Gross Profit 2000 SG&A 500 Interest Expense 151 EBT 1349 Taxes (30%) 405 Net Income 944
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
Balance Sheet
Assets Year 2003 Year 2004 Cash 500 450 Accounts Receivable 600 660 Inventory 500 550 Total CA 1300 1660 Plant, prop. equip 1000 1250 Total Assets 2600 2910 Liabilities Accounts Payable 500 550 Long term debt 700 1102 Total liabilities 1200 1652 Equity Common Stock 400 538 Retained Earnings 1000 720 Total Liabilities & Equity 2600 2,910 Income Statement
Sales 3000 Cost of Goods Sold (1000) Gross Profit 2000 SG&A 500 Interest Expense 151 EBT 1349 Taxes (30%) 405 Net Income 944
| ||
| ||
|
Gross Operating Margin | Operating Profit Margin |
| ||||
| ||||
|
| ||
| ||
|
Balance Sheet
Assets Cash 100 Accounts Receivable 750 Marketable Securities 300 Inventory 850 Property, Plant & Equip 900 Accumulated Depreciation (150) Total Assets 2750 Liabilities and Equity Accounts Payable 300 Short-Term Debt 130 Long-Term Debt 700 Common Stock 1000 Retained Earnings 620 Total Liab. and Stockholder's equity 2750 Income Statement
Sales 1500 COGS 1100 Gross Profit 400 SG&A 150 Operating Profit 250 Interest Expense 25 Taxes 75 Net Income 150
| ||
| ||
|
Income Statement | % |
Sales | 100.0 |
Cost of goods sold | 58.2 |
Operating expenses | 30.2 |
Interest expense | 0.7 |
Income tax | 5.7 |
Net income | 5.2 |
Balance sheet | % | % | ||
Cash | 4.8 | Accounts payable | 15.0 | |
Accounts receivable | 14.9 | Accrued liabilities | 13.8 | |
Inventory | 49.4 | Long-term debt | 23.2 | |
Net fixed assets | 30.9 | Common equity | 48.0 | |
Total assets | 100.00 | Total liabilities & equity | 100.0 |
Current ratio | Return on equity |
| ||||
| ||||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
Earnings after taxes = 18% Equity = 40% Current assets = 60% Current liabilities = 30% Sales = $300 Total assets = $1,400
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
Balance Sheet
Assets Year 2003 Year 2004 Cash 500 450 Accounts Receivable 600 660 Inventory 500 550 Total CA 1300 1660 Plant, prop. equip 1000 1250 Total Assets 2600 2910 Liabilities Accounts Payable 500 550 Long term debt 700 700 Total liabilities 1200 1652 Equity Common Stock 400 400 Retained Earnings 1260 1260 Total Liabilities & Equity 2600 2910 Income Statement
Sales 3000 Cost of Goods Sold (1000) Gross Profit 2000 SG&A 500 Interest Expense 151 EBT 1349 Taxes (30%) 405 Net Income 944
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
Net Sales 200 Cost of Goods Sold 55 Gross Profit 145 Operating Expenses 30 Operating Profit (EBIT) 115 Interest 15 Earnings Before Taxes (EBT) 100 Taxes 40 Earnings After Taxes (EAT) 60
Gross Profit Margin | Operating Profit Margin |
| ||||
| ||||
|
Debt to Equity | Working Capital |
| ||||
| ||||
|
| ||
| ||
|
Net Sales | 200 |
Cost of Goods Sold | 55 |
Gross Profit | 145 |
Operating Expenses | 30 |
Operating Profit (EBIT) | 115 |
Interest | 15 |
Earnings Before Taxes (EBT) | 100 |
Taxes | 40 |
Earnings After Taxes (EAT) | 60 |
Interest Coverage Ratio | Net Profit Margin |
| ||||
| ||||
|
Balance Sheet
Assets Cash 100 Accounts Receivable 750 Marketable Securities 300 Inventory 850 Property, Plant & Equip 900 Accumulated Depreciation (150) Total Assets 2750 Liabilities and Equity Accounts Payable 300 Short-Term Debt 130 Long-Term Debt 700 Common Stock 1000 Retained Earnings 620 Total Liab. and Stockholder's equity 2750 Income Statement
Sales 1500 COGS 1100 Gross Profit 400 SG&A 150 Operating Profit 250 Interest Expense 25 Taxes 75 Net Income 150
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
Average Collection Period | Average Inventory Processing Period | Payables Payments Period |
| |||||
| |||||
|
Quick ratio | Debt-to-capital ratio |
| ||||
| ||||
|
Balance Sheet
Assets Cash 100 Accounts Receivable 750 Marketable Securities 300 Inventory 850 Property, Plant & Equip 900 Accumulated Depreciation (150) Total Assets 2750 Liabilities and Equity Accounts Payable 300 Short-Term Debt 130 Long-Term Debt 700 Common Stock 1000 Retained Earnings 620 Total Liab. and Stockholder's equity 2750 Income Statement
Sales 1500 COGS 1100 Gross Profit 400 SG&A 150 Operating Profit 250 Interest Expense 25 Taxes 75 Net Income 150
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
= 95 + 183 – 274 = 4 days
Revenue / Average working capital | Average total assets / Average total equity |
| ||||
| ||||
|
Receivables Collection Period | Inventory Processing Period | Payables Payment Period |
| |||||
| |||||
|
“On December 31, 20X7, Crabtree recognized a restructuring charge of $20 million, of which $5 million was for severance pay for employees who will be terminated in 20X8 and $15 million was for land that became permanently impaired in 20X7.”Based only on these changes, Crabtree’s net profit margin and fixed asset turnover ratio in 20X8 as compared to 20X7 will be?
Net profit margin | Fixed asset turnover |
| ||||
| ||||
|
| ||
| ||
|
| ||
| ||
|
Average Receivables Collection Period | Average Payables Payment Period | Average Inventory Processing Period |
| |||||
| |||||
|
Balance Sheet
Assets Year 2003 Year 2004 Cash 500 450 Accounts Receivable 600 660 Inventory 500 550 Total CA 1300 1660 Plant, prop. equip 1000 1250 Total Assets 2600 2,910 Liabilities Accounts Payable 500 550 Long term debt 700 1102 Total liabilities 1200 1652 Equity Common Stock 400 538 Retained Earnings 1000 720 Total Liabilities & Equity 2600 2,910 Income Statement
Sales 3000 Cost of Goods Sold (1000) Gross Profit 2000 SG&A 500 Interest Expense 151 EBT 1349 Taxes (30%) 405 Net Income 944
| ||
| ||
|
Balance Sheet
Assets Cash 100 Accounts Receivable 750 Marketable Securities 300 Inventory 850 Property, Plant & Equip 900 Accumulated Depreciation (150) Total Assets 2750 Liabilities and Equity Accounts Payable 300 Short-Term Debt 130 Long-Term Debt 700 Common Stock 1000 Retained Earnings 620 Total Liab. and Stockholder's equity 2750 Income Statement
Sales 1500 COGS 1100 Gross Profit 400 SG&A 150 Operating Profit 250 Interest Expense 25 Taxes 75 Net Income 150
| ||
| ||
|
Balance Sheet
Assets Cash 100 Accounts Receivable 750 Marketable Securities 300 Inventory 850 Property, Plant & Equip 900 Accumulated Depreciation (150) Total Assets 2750 Liabilities and Equity Accounts Payable 300 Short-Term Debt 130 Long-Term Debt 700 Common Stock 1000 Retained Earnings 620 Total Liab. and Stockholder's equity 2750 Income Statement
Sales 1500 COGS 1100 Gross Profit 400 SG&A 150 Operating Profit 250 Interest Expense 25 Taxes 75 Net Income 150
Current Ratio | Cash Ratio |
| ||||
| ||||
|
Accounts payable turnover5.0
Cost of goods sold$30 million
Average inventory$3 million
Average receivables$8 million
Total liabilities$35 million
Interest expense$2 million
Cash conversion cycle13.5 days
| ||
| ||
|
| ||
| ||
|
Current ratio | Cash ratio |
| ||||
| ||||
|
Transaction #1 | Transaction #2 |
| ||||
| ||||
|
Balance Sheet
Assets Year 2006 Year 2007 Cash 200 450 Accounts Receivable 600 660 Inventory 500 550 Total CA 1300 1660 Plant, prop. equip 1000 1580 Total Assets 2600 3240 Liabilities Accounts Payable 500 550 Long term debt 700 1052 Total liabilities 1200 1602 Equity Common Stock 400 538 Retained Earnings 1000 1100 Total Liabilities & Equity 2600 3240 Income Statement
Sales 3000 Cost of Goods Sold (1000) Gross Profit 2000 SG&A 500 Interest Expense 151 EBT 1349 Taxes (30%) 405 Net Income 944
| ||
| ||
|
20X0 | 20X1 | |
Sales | 78 | 82 |
Cost of Goods Sold | (47) | (48) |
Gross Profit | 31 | 34 |
Sales and Administration | (13) | (14) |
Operating Profit (EBIT) | 18 | 20 |
Interest Expense | (6) | (10) |
Earnings Before Taxes | 12 | 10 |
Income Taxes | (5) | (4) |
Earnings after Taxes | 7 | 6 |
| ||
| ||
|
2007 Actual Turnover | Expected Increase / (Decrease) | |
Accounts receivable | 5.0 | 10% |
Fixed asset | 3.0 | 7% |
Accounts payable | 6.0 | (20%) |
Inventory | 4.0 | (5%) |
Equity | 5.5 | — |
Total asset | 2.3 | 8% |
| ||
| ||
|
2007 | 2006 | 2005 | |
Average debt | $792,000 | $800,000 | $820,000 |
Average equity | $215,000 | $294,000 | $364,000 |
Return on assets | 5.9% | 6.6% | 7.2% |
Quick ratio | 0.3 | 0.5 | 0.6 |
Sales | $1,650,000 | $1,452,000 | $1,304,000 |
Cost of goods sold | $1,345,000 | $1,176,000 | $1,043,000 |
| ||
| ||
|
| ||
| ||
|
E Company | G Company | |
Sales | 70 | 90 |
Cost of Goods Sold | (30) | (40) |
Gross Profit | 40 | 50 |
Sales and Administration | (5) | (15) |
Depreciation | (5) | (10) |
Operating Profit | 30 | 25 |
Interest Expense | (20) | (5) |
Earnings Before Taxes | 10 | 20 |
Income Taxes | (4) | (8) |
Earnings after Taxes | 6 | 12 |
| ||
| ||
|
Balance Sheet
Assets Cash 100 Accounts Receivable 750 Marketable Securities 300 Inventory 850 Property, Plant & Equip 900 Accumulated Depreciation (150) Total Assets 2750 Liabilities and Equity Accounts Payable 300 Short-Term Debt 130 Long-Term Debt 700 Common Equity 1000 Retained Earnings 620 Total Liab. and Stockholder's equity 2750 Income Statement
Sales 1500 COGS 1100 Gross Profit 400 SG&A 150 Operating Profit 250 Interest Expense 25 Taxes 75 Net Income 150
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
An analyst has gathered the following information about a company.
The total asset turnover is 1.2.
The after-tax profit margin is 10%.
The financial leverage multiplier is 1.5.
Given this information, the company’s return on equity is:
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
| ||
| ||
|
Net profit margin | Dividend payout ratio |
| ||||
| ||||
|
| ||
| ||
|
For 20X7, McQueen sold 250 million units at a sales price of $1 each. For 20X8, McQueen has decided to reduce its sales price by 10%. McQueen believes the price cut will double unit sales. The cost of each unit sold is expected to remain the same. Calculate the change in McQueen’s expected gross profit for 20X8 assuming the price cut doubles sales.
Sales100%
Cost of goods sold60%
Gross profit40%
| ||
| ||
|
| ||
| ||
|
Sensitivity analysis | Scenario analysis |
| ||||
| ||||
|
欢迎光临 CFA论坛 (http://forum.theanalystspace.com/) | Powered by Discuz! 7.2 |