Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. prepare a horizontal analysis of both the balance

Prepare a horizontal analysis of both the balance sheet and income statement. ? Analysis Bal Sheet...

Free

80.2K

Verified Solution

Question

Accounting

Prepare a horizontal analysis of both the balance sheet andincome statement. ? Analysis Bal Sheet Analysis Inc Stmt ? Completethis question by entering your answers in the tabs below. Prepare ahorizontal analysis of the balance sheet. (Negative answers shouldbe indicated by a minus sign. Round your answers to 1 decimalplace. (i.e., .234 should be entered as 23.4).) Analysis Bal SheetAnalysis Inc Stmt $ $ $ $ $ $ $ $ STUART COMPANY HorizontalAnalysis of Balance Sheets 2019 2018 Percentage Change

Assets

Current assets

Cash 17,000 13,400 %

Marketable securities 21,200 7,900

Accounts receivable (net) 54,600 46,200

Inventories 136,000 144,100

Prepaid items 26,600 10,300

Total current assets 255,400 221,900

Investments 28,300 21,100

Plant (net) 270,500 255,700

Land 29,900 25,700

Total long-term assets 328,700 302,500

Total assets 584,100 524,400

Liabilities and Stockholders’ Equity Liabilities

Current liabilities Notes payable 15,400 5,200

Accounts payable 113,400 99,200

Salaries payable 19,300 14,100

Total current liabilities 148,100 118,500

Noncurrent liabilities

Bonds payable 99,500 99,500

Other 30,000 25,600

Total noncurrent liabilities 129,500 125,100

Total liabilities 277,600 243,600

Stockholders' equity

Preferred stock (par value $10, 4% cumulative, nonparticipating;6,400 shares authorized and issued) 64,000 64,000

Common stock (no par; 50,000 shares authorized; 10,000 sharesissued) 64,000 64,000

Retained earnings 178,500 152,800

Total stockholders' equity 306,500 280,800

Total liabilities & stockholders’ equity 584,100 524,400%

We have 2018 and 2019 amounts. Just need the third column whichwould all be percentages.

If question can't be understood please comment. ASAP.

Answer & Explanation Solved by verified expert
4.5 Ratings (939 Votes)

Horizontal Analysis is shown as follows:-      (Amounts in $)

Stuart Company
Horizontal Analysis of Balance Sheet
2019 (A) 2018 (B) Change in $ (C=A-B) % Change (C/B)*100
Assets
Current Assets
Cash 17,000 13,400 3,600 26.9%
Marketable Securities 21,200 7,900 13,300 168.3%
Account Receivables (net) 54,600 46,200 8,400 18.2%
Inventories 136,000 144,100 (8,100) (5.6)%
Prepaid items 26,600 10,300 16,300 158.3%
Total Current Assets 255,400 221,900 33,500 15.1%
Investments 28,300 21,100 7,200 34.1%
Plant (net) 270,500 255,700 14,800 5.8%
Land 29,900 25,700 4,200 16.3%
Total Long term Assets 328,700 302,500 26,200 8.7%
Total Assets 584,100 524,400 59,700 11.4%
Liabilities and Stockholders' Equity
Liabilities
Current Liabilities
Notes payable 15,400 5,200 10,200 196.2%
Accounts Payable 113,400 99,200 14,200 14.3%
Salaries Payable 19,300 14,100 5,200 36.9%
Total Current Liabilities 148,100 118,500 29,600 25%
Non-Current Liabilities
Bonds Payable 99,500 99,500 0 0%
Other 30,000 25,600 4,400 17.2%
Total Non-Current Liabilities 129,500 125,100 4,400 3.5%
Total Liabilities 277,600 243,600 34,000 14%
Stockholders' Equity
Preferred Stock 64,000 64,000 0 0%
Common Stock 64,000 64,000 0 0%
Retained Earnings 178,500 152,800 25,700 16.9%
Total Stockholders' Equity 306,500 280,800 25,700 9.2%
Total Liabilities and Stockholders' Equity 584,100 524,400 59,700 11.4%

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students