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.