In: Accounting
The balance sheet data below for Randolph Company for two recent
years.
Assets |
Year 2 |
Year 1 |
Current assets |
$445 |
$280 |
Plant assets |
680 |
520 |
Total assets |
$1,125 |
$800 |
Liabilities & Stockholders' Equity | ||
Current liabilities |
$285 |
$120 |
Long-term debt |
255 |
160 |
Common stock |
325 |
320 |
Retained earnings |
260 |
200 |
Total liabilities and stockholders' equity |
$1,125 |
$800 |
Required:
a. Using horizontal analysis, show the percentage change for each balance sheet item using Year 1 as a base year. If required, round percentage to one decimal place. If required, use the minus sign to indicate decreases in amounts and percents (negative values).
Randolph Company | ||||
Comparative Balance Sheet | ||||
December 31, Year 2 and Year 1 | ||||
Assets | Year 2 | Year 1 | Increase/Decrease Amount | Increase/Decrease Percentage |
Current assets | $445 | $280 | $ | % |
Plant assets | 680 | 520 | % | |
Total assets | $1,125 | $800 | $ | % |
Liabilities & stockholders' equity | ||||
Current liabilities | $285 | $120 | $ | % |
Long-term debt | 255 | 160 | % | |
Common stock | 325 | 320 | % | |
Retained earnings | 260 | 200 | % | |
Total liabilities and stockholders' equity | $1,125 | $800 | $ | % |
b. Using vertical analysis, prepare a comparative balance sheet. If required, round your answers to one decimal place.
Randolph Company | ||||
Comparative Balance Sheet | ||||
December 31, Year 2 and Year 1 | ||||
Assets | Year 2 Amount | Year 2 Percent | Year 1 Amount | Year 1 Percent |
Current assets | $445 | % | $280 | % |
Plant assets | 680 | % | 520 | % |
Total assets | $1,125 | % | $800 | % |
Liabilities & stockholders' equity | ||||
Current liabilities | $285 | % | $120 | % |
Long-term debt | 255 | % | 160 | % |
Common stock | 325 | % | 320 | % |
Retained earnings | 260 | % | 200 | % |
Total liabilities and stockholders' equity | $1,125 | % | $800 | % |
Solution a:
Randolph Company | ||||
Comparative Balance Sheet | ||||
December 31, Year 2 and Year 1 | ||||
Assets | Year 2 | Year 1 | Increase/Decrease Amount | Increase/Decrease Percentage |
Current assets | $445.00 | $280.00 | $165.00 | 58.9% |
Plant assets | $680.00 | $520.00 | $160.00 | 30.8% |
Total assets | $1,125.00 | $800.00 | $325.00 | 40.6% |
Liabilities & stockholders' equity: | ||||
Current liabilities | $285.00 | $120.00 | $165.00 | 137.5% |
Long-term debt | $255.00 | $160.00 | $95.00 | 59.4% |
Common stock | $325.00 | $320.00 | $5.00 | 1.6% |
Retained earnings | $260.00 | $200.00 | $60.00 | 30.0% |
Total liabilities and stockholders' equity | $1,125.00 | $800.00 | $325.00 | 40.6% |
Solution b:
Randolph Company | ||||
Comparative Balance Sheet | ||||
December 31, Year 2 and Year 1 | ||||
Assets | Year 2 Amount | Year 2 Percent | Year 1 Amount | Year 1 Percent |
Current assets | $445.00 | 39.6% | $280.00 | 35.0% |
Plant assets | $680.00 | 60.4% | $520.00 | 65.0% |
Total assets | $1,125.00 | 100.0% | $800.00 | 100.0% |
Liabilities & stockholders' equity | ||||
Current liabilities | $285.00 | 25.3% | $120.00 | 15.0% |
Long-term debt | $255.00 | 22.7% | $160.00 | 20.0% |
Common stock | $325.00 | 28.9% | $320.00 | 40.0% |
Retained earnings | $260.00 | 23.1% | $200.00 | 25.0% |
Total liabilities and stockholders' equity | $1,125.00 | 100.0% | $800.00 | 100.0% |