Question

In: Accounting

prepare a balance sheet data in the vertical look.

prepare a balance sheet data in the vertical look.

Solutions

Expert Solution

Solution

The following data shows balance sheet of Modern Textiles Ltd. In vertical look:

Modern Textiles Ltd.

Balance Sheet

31st March 2018

Particulars

Amount ($)

Liabilities and Stockholders’ Equity

Current Liability:

Accounts Payables

2,70,000

Accrued Liability

10,000

Proposed Dividend

90,000

Total Current Liabilities

3,70,000

Long Term Liability:

Long term debt

2,00,000

Stockholders’ Equity:

Stockholders’ Equity

6,00,000

Retained earnings

7,40,000

Total Stockholders’ Equity

13,40,000

Total Liabilities and Stockholders’ Equity

19,10,000

Asset

Current Assets:

Marketable securities

30,000

Inventory

7,34,000

Accounts Receivable

285,000

Prepaid expenses

6,000

Cash and Bank

40,000

Total Current Assets

10,95,000

Long Term Assets :

Land & Buildings

5,00,000

Furniture

1,00,000

Plant & Machinery

2,15,000

Total Long Term Assets

8,15,000

Total Asset

19,10,000


Related Solutions

Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
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 $254,100 $139,700 Property, plant, and equipment 499,730 450,850 Intangible assets 93,170 44,450 Current liabilities 177,870 107,950 Long-term liabilities 330,330 266,700 Common stock 67,760 63,500 Retained earnings 271,040 196,850 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
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 $302,470 $187,680 Property, plant, and equipment 594,510 508,300 Intangible assets 146,020 86,020 Current liabilities 239,890 140,760 Long-term liabilities 406,770 320,620 Common stock 93,870 86,020 Retained earnings 302,470 234,600 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
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 $339,140 $197,040 Property, plant, and equipment 623,580 558,280 Intangible assets 131,280 65,680 Current liabilities 251,620 147,780 Long-term liabilities 404,780 295,560 Common stock 98,460 106,730 Retained earnings 339,140 270,930 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
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...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
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 $304,500 $182,840 Property, plant, and equipment 461,100 437,510 Intangible assets 104,400 32,650 Current liabilities 174,000 84,890 Long-term liabilities 330,600 261,200 Common stock 87,000 91,420 Retained earnings 278,400 215,490 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
1. Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the...
1. 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 $277,440 $177,480 Property, plant, and equipment 432,480 397,800 Intangible assets 106,080 36,720 Current liabilities 163,200 79,560 Long-term liabilities 342,720 275,400 Common stock 73,440 67,320 Retained earnings 236,640 189,720 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity...
Vertical Analysis of Balance Sheet Balance sheet data for Hanes Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Hanes Company on December 31, the end of the fiscal year, are shown below. 20Y2 20Y1 Current assets 288,900 158,840 Property, plant, and equipment 558,540 512,620 Intangible assets 115,560 50,540 Current liabilities 173,340 79,420 Long-term liabilities 394,830 332,120 Common stock 96,300 93,860 Retained earnings 298,530 216,600 Prepare a comparative balance sheet for 20Y2 and 20Y1, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Prepare a balance sheet in report form as of December 31, 2016. * Balance sheet data:...
Prepare a balance sheet in report form as of December 31, 2016. * Balance sheet data: Accounts payable $ 194,300 Accounts receivable 545,000 Accumulated depreciation—office buildings and equipment 1,580,000 Accumulated depreciation—store buildings and equipment 4,126,000 Allowance for doubtful accounts 8,450 Available-for-sale investments (at cost) 260,130 Bonds payable, 5%, due 2024 500,000 Cash 246,000 Common stock, $20 par (400,000 shares authorized; 100,000 shares issued, 94,600 outstanding) 2,000,000 Dividends: Cash dividends for common stock 155,120 Cash dividends for preferred stock 100,000 Goodwill...
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi and Coca...
Prepare a vertical analysis or same size income statement and balance sheet for Pepsi and Coca Cola for 2016 and 2017. Write a paragraph highlighting what you learn from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2016 and 2017 and between Coke and Pepsi.
Using the data for Brady and Co. provided in the sheet labeled "Trial Balance" prepare Balance...
Using the data for Brady and Co. provided in the sheet labeled "Trial Balance" prepare Balance Sheet - comparative, classified in proper format for fiscal years 2015 2015 Dr Cr Accounts Payable        999,210 Accounts Receivable     2,943,125 Accrued Liabilities - Other        508,643 Accrued Pension Liabilities        650,216 Accrued Restructuring Charges        126,000 Accrued Salaries, Wages and Commissions        281,364 Accumulated Other Comprehensive Income (Loss)        621,236 Accumulated Depreciation - Property, Plant & Equipment     1,829,634 Accumulated Post-Employment Benefit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT