In: Accounting
Vertical Analysis of Balance Sheet
Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows:
| Current Year | Previous Year | |||
| Current assets | $249,300 | $149,520 | ||
| Property, plant, and equipment | 465,360 | 404,950 | ||
| Intangible assets | 116,340 | 68,530 | ||
| Current liabilities | 149,580 | 87,220 | ||
| Long-term liabilities | 349,020 | 274,120 | ||
| Common stock | 99,720 | 99,680 | ||
| Retained earnings | 232,680 | 161,980 | ||
Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item as a percent of the total liabilities and stockholders' equity. If required, round percentages to one decimal place.
| Alvaraz Company | ||||
| Comparative Balance Sheet | ||||
| For the Years Ended December 31 | ||||
| Current year Amount | Current year Percent | Previous year Amount | Previous year Percent | |
| Current assets | $249,300 | % | $149,520 | % |
| Property, plant, and equipment | 465,360 | % | 404,950 | % |
| Intangible assets | 116,340 | % | 68,530 | % |
| Total assets | $831,000 | % | $623,000 | % |
| Current liabilities | $149,580 | % | $87,220 | % |
| Long-term liabilities | 349,020 | % | 274,120 | % |
| Common stock | 99,720 | % | 99,680 | % |
| Retained earnings | 232,680 | % | 161,980 | % |
| Total liabilities and stockholders' equity | $831,000 | % | $623,000 | % |
| Alvaraz Company | ||||
| Comparative Balance Sheet | ||||
| For the Years Ended December 31 | ||||
| Current Year | Previous Year | |||
| Amount | Percent | Amount | Percent | |
| Assets | ||||
| Current assets | 249,300 | 30% | 149,520 | 24% |
| Property, plant, and equipment | 465,360 | 56% | 404,950 | 65% |
| Intangible assets | 116,340 | 14% | 68,530 | 11% |
| Total assets | 831,000 | 100% | 623,000 | 100% |
| Liability | ||||
| Current liabilities | 149,580 | 18% | 87,220 | 14% |
| Long-term liabilities | 349,020 | 42% | 274,120 | 44% |
| Total Liability | 498,600 | 60% | 361,340 | 58% |
| Stockholder's Equity | ||||
| Common stock | 99,720 | 12% | 99,680 | 16% |
| Retained earnings | 232,680 | 28% | 161,980 | 26% |
| Total Stockholder's Equity | 332,400 | 40% | 261,660 | 42% |
| Total liabilities and stockholders' equity | 831,000 | 100% | 623,000 | 100% |
The calculation is done as follows :
Current Assets = 249300/831000*100 = 30%
Same way for all the line items.
Assets / Total Assets *100
For details please look at the Image.
Liability/ Total libility*100
Dear Student,
Best effort has been made to give quality and correct answer. But if you find any issues please comment your concern. I will definitely resolve your query.
Also please give your positive rating.
