Question

It's NOT letting me upload a photo. I don't know why. Maybe you can google a photo? I'm sorry. Didn't think this would be such a hassle.

Required Prepare a vertical analysis of both the balance sheets and income statements for 2019 and 2018.  Analysis Bal Sheet Analysis Inc Stmt  Complete this question by entering your answers in the tabs below. Prepare a vertical analysis of the balance sheets for 2019 and 2018. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .23 should be entered as 23.45).) Analysis Bal Sheet Analysis Inc Stmt $ $ $ $ $ $ $ $ MUNOZ COMPANY Vertical Analysis of Balance Sheets 2019 2018 Amount Percentage of Total Amount Percentage of Total

Assets

Current assets

Cash 16,900 2.95 % 13,900 %

Marketable securities 21,600 7,500

Accounts receivable (net) 56,000 46,600

Inventories 135,600 143,600

Prepaid items 25,900 11,600

Total current assets 256,000 223,200

Investments 27,000 21,100

Plant (net) 271,400 255,900

Land 29,300 25,800

Total long-term assets 327,700 302,800

Total assets 583,700 526,000

Liabilities and stockholders' equity

Liabilities

Current liabilities

Notes payable 16,800 4,200

Accounts payable 113,600 99,800

Salaries payable 19,100 13,900

Total current liabilities 149,500 117,900

Noncurrent liabilities

Bonds payable 99,400 99,400

Other 30,800 26,900

Total noncurrent liabilities 130,200 126,300

Total liabilities 279,700 244,200

Stockholders' equity

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

Common stock (no par; 50,000 shares authorized; 10,000 shares issued) 60,000 60,000

Retained earnings 184,000 161,800

Total stockholders' equity 304,000 281,800

Total liabilities & stockholders’ equity 583,700 % 526,000 %

I need 2019 percentages of sale which is first. Then 2018 percentage of sale which is the row of second numbers (going down).

Required Prepare a vertical analysis of both the balance sheets and income statements for 2019 and 2018.  Analysis Bal Sheet Analysis Inc Stmt  Complete this question by entering your answers in the tabs below. Prepare a vertical analysis of an income statements for 2019 and 2018. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) Analysis Bal Sheet Analysis Inc Stmt $ $ $ $ MUNOZ COMPANY Vertical Analysis of Income Statements 2019 2018 Amount Percentage of Sales Amount Percentage of Sales

Revenues Sales (net) 230,800 % 211,700 %

Other revenues 8,800 5,900

Total revenues 239,600 217,600

Expenses

Cost of goods sold 119,200 102,400 Selling, general, and administrative expense 53,800 49,500

Interest expense 7,000 6,200

Income tax expense 23,000 22,000

Total expenses 203,000 180,100

Net income 36,600 % 37,500 %

I need 2019 percentages of sale which is first. Then 2018 percentage of sale which is the row of second numbers (going down).

Answer 1

MUNOZ COMPANY
COMPARATIVE BALANCE SHEET ANALYSIS
FOR THE YEAR ENDED 31 DEC. 2019 AND 2019
	2019		2018
Assets:	Amount-$	(%)	Amount-$	(%)
Current Assets
Cash	16,900	2.90	13,900	2.64
Marketable Securities	21,600	3.70	7,500	1.43
Account Receivable-Net	56,000	9.59	46,600	8.86
Inventories	135,600	23.23	143,600	27.30
Prepaid Items	25,900	4.44	11,600	2.20
Total Current Assets	256,000	43.86	223,200	42.43
Investment	27,000	4.62	21,100	4.01
Plant-Net	271,400	46.50	255,900	48.65
Land	29,300	5.02	25,800	4.90
Total Long Term Assets	327,700	56.14	302,800	57.57
Total Assets	583,700	100	526,000	100.00
Laibilities
Current Liabilities
Notes Payable	16,800	2.88	4,200	0.80
Account Payable	113,600	19.46	99,800	18.97
Salaries Payable	19,100	3.27	13,900	2.64
Total Current Liabilities	149,500	25.61	117,900	22.41
Non Current Liabilities
Bonds Payable	99,400	17.03	99,400	18.90
Others	30,800	5.28	26,900	5.11
Total Non-Current Liabilities	130,200	22.31	126,300	24.01
Total Liabilities	279,700	47.92	244,200	46.42
Stockholders' Equity
Pref. Stock,(PV$10) 4% Cum. NP	60,000	10.28	60,000	11.41
Common Stock- 10,000 CS Issued	60,000	10.28	60,000	11.41
Retained Earning	184,000	31.52	161,800	30.76
Total Stockholders' Equity	304,000	52.08	281,800	53.58
Total Liab & Stockholders' Equity	583,700	100	526,000	100.00

MUNOZ COMPANY
CPMPARATIVE INCOME STATEMENT ANALYSIS
FOR THE YEAR ENDED 31 DEC. 2019 AND 2019
	2019		2018
	Amount-$	(%)	Amount-$	(%)
Sales Revenue-Net	230,800	100	211,700	100
Other Revenue	8,800	3.81	5,900	2.79
Total Revenues	239,600	103.81	217,600	102.79
Expenses:
Cost of Goods Sold	119,200	51.65	102,400	48.37
Selling, Gen & Adm. Expense	53,800	23.31	49,500	23.38
Interest Expense	7,000	3.03	6,200	2.93
Tax Expenses	23,000	9.96	22,000	10.39
Total Expense	203,000	87.95	180,100	85.07
Net Income	36,600	15.86	37,500	17.72