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% |