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 | % |
Answer-a)-
| RANDOLPH COMPANY | ||||
| HORIZONTAL ANALYSIS | ||||
| PARTICULARS | YEAR 2 | YEAR 1 | INCREASE/DECREASE | % |
| $ | $ | $ | ||
| ASSETS | ||||
| Current assets | 445 | 280 | 165 | 58.9 |
| Plant assets | 680 | 520 | 160 | 30.8 |
| Total assets | 1125 | 800 | 325 | 40.6 |
| LIABILITIES AND EQUITY | ||||
| Current Liabilities | 285 | 120 | 165 | 137.5 |
| Long-term debt | 255 | 160 | 95 | 59.4 |
| Common stock | 325 | 320 | 5 | 1.6 |
| Retained earnings | 260 | 200 | 60 | 30.0 |
| Total liabilities and stockholders' equity | 1125 | 800 | 325 | 40.6 |
b)-
| RANDOLPH COMPANY | ||||
| VERTICAL ANALYSIS | ||||
| PARTICULARS | YEAR 2 | % | YEAR 1 | % |
| $ | $ | |||
| ASSETS | ||||
| Current assets | 445 | 39.6 | 280 | 35.0 |
| Plant assets | 680 | 60.4 | 520 | 65.0 |
| Total assets | 1125 | 100.0 | 800 | 100.0 |
| LIABILITIES AND EQUITY | ||||
| Current Liabilities | 285 | 25.3 | 120 | 15.0 |
| Long-term debt | 255 | 22.7 | 160 | 20.0 |
| Common stock | 325 | 28.9 | 320 | 40.0 |
| Retained earnings | 260 | 23.1 | 200 | 25.0 |
| Total liabilities and stockholders' equity | 1125 | 100.0 | 800 | 100.0 |