Question

Help me fill out the yellow collums. also make sure you add the formulas with the answers.

116 X D IF G 4 Present a comparative balance sheet 2018 2017 Dollar Change Percent Change Assets Cash Marketable securities Accounts receivable Inventories Deferred tax assets Vendor non-trade receivables Other current assets Total current assets Long-term securities PP&E Goodwill Intangible assets Other assets Total assets 21, 120 $ 13,844 20,481 11,233 16,849 17,460 2,349 2,111 5,546 4,318 13,494 9,759 9,539 9,806 89,378 68,531 164,065 130,162 22,471 20,624 5,116 4,616 3,893 4,142 5,556 3,764 290,479 $ 231,839 $ Liabilities Accounts payable Accrues expenses Deferred revenue Commercial paper Current nortion IT debt 35,490 25,181 8,940 8,499 2.500 30,196 18,453 8,491 6,308

Answer 1

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!

Balance Sheet			Horizontal Analysis
	USD	USD	Increase or (Decrease) 2018 over 2017
Assets	2018	2017	Dollars	Percent
Cash	21,120.00	13,844.00	7,276.00	52.56%
Marketable Securities	20,481.00	11,233.00	9,248.00	82.33%
Accounts Receivable	16,849.00	17,460.00	(611.00)	-3.50%
Inventories	2,349.00	2,111.00	238.00	11.27%
Deferred Tax Assets	5,546.00	4,318.00	1,228.00	28.44%
Vendor Non Trade Receivables	13,494.00	9,759.00	3,735.00	38.27%
Other Current Assets	9,539.00	9,806.00	(267.00)	-2.72%
Total Current Assets	89,378.00	68,531.00	20,847.00	30.42%
Long Term Securities	164,065.00	130,162.00	33,903.00	26.05%
PP&E	22,471.00	20,624.00	1,847.00	8.96%
Goodwill	5,116.00	4,616.00	500.00	10.83%
Intangible Assets	3,893.00	4,142.00	(249.00)	-6.01%
Other Assets	5,556.00	3,764.00	1,792.00	47.61%
Total Assets	290,479.00	231,839.00	58,640.00	25.29%
Liabilities
Accounts Payable	35,490.00	30,196.00	5,294.00	17.53%
Accrued Expense	25,181.00	18,453.00	6,728.00	36.46%
Deferred Revenue	8,940.00	8,491.00	449.00	5.29%
Commercial Paper	8,499.00	6,308.00	2,191.00	34.73%
Current Portion- LT Debt	2,500.00	-	2,500.00	100.00%
Total Current Liabilities	80,610.00	63,448.00	17,162.00	27.05%
Deferred Revenue- Non Current	3,624.00	3,031.00	593.00	19.56%
Long Term debt	53,463.00	28,987.00	24,476.00	84.44%
Other Non Current Liabilities	33,427.00	24,826.00	8,601.00	34.65%
Total Liabilities	171,124.00	120,292.00	50,832.00	42.26%
Stockholder's Equity
Common Stock	27,416.00	23,313.00	4,103.00	17.60%
Retained Earnings	92,284.00	87,152.00	5,132.00	5.89%
Accum. OCI	(345.00)	1,082.00	(1,427.00)	-131.89%
Total Stockholder's Equity	119,355.00	111,547.00	7,808.00	7.00%
Total Liabilities and Equity	290,479.00	231,839.00	58,640.00	25.29%

Income Statement			Horizontal Analysis
	USD	USD	Increase or (Decrease) 2018 over 2017
	2018	2017	Dollars	Percent
Net Sales	233,715.00	182,795.00	50,920.00	27.86%
Cost of sales	140,089.00	112,258.00	27,831.00	24.79%
Gross Margin	93,626.00	70,537.00	23,089.00	32.73%
Research & Development	8,067.00	6,041.00	2,026.00	33.54%
Selling, General & Administrative	14,329.00	11,993.00	2,336.00	19.48%
Total Operating Expenses	22,396.00	18,034.00	4,362.00	24.19%
Operating Income	71,230.00	52,503.00	18,727.00	35.67%
Other Income	1,285.00	980.00	305.00	31.12%
Income before taxes	72,515.00	53,483.00	19,032.00	35.59%
Income Taxes	19,121.00	13,973.00	5,148.00	36.84%
Net Income	53,394.00	39,510.00	13,884.00	35.14%
Basic Earnings Per share	9.28	6.59	2.69	40.82%

Balance Sheet			Vertical Analysis
	USD	USD	Common Size Percent
Assets	2018	2017	2018	2017
Cash	21,120.00	13,844.00	7.27%	5.97%
Marketable Securities	20,481.00	11,233.00	7.05%	4.85%
Accounts Receivable	16,849.00	17,460.00	5.80%	7.53%
Inventories	2,349.00	2,111.00	0.81%	0.91%
Deferred Tax Assets	5,546.00	4,318.00	1.91%	1.86%
Vendor Non Trade Receivables	13,494.00	9,759.00	4.65%	4.21%
Other Current Assets	9,539.00	9,806.00	3.28%	4.23%
Total Current Assets	89,378.00	68,531.00	30.77%	29.56%
Long Term Securities	164,065.00	130,162.00	56.48%	56.14%
PP&E	22,471.00	20,624.00	7.74%	8.90%
Goodwill	5,116.00	4,616.00	1.76%	1.99%
Intangible Assets	3,893.00	4,142.00	1.34%	1.79%
Other Assets	5,556.00	3,764.00	1.91%	1.62%
Total Assets	290,479.00	231,839.00	100.00%	100.00%
Liabilities
Accounts Payable	35,490.00	30,196.00	12.22%	13.02%
Accrued Expense	25,181.00	18,453.00	8.67%	7.96%
Deferred Revenue	8,940.00	8,491.00	3.08%	3.66%
Commercial Paper	8,499.00	6,308.00	2.93%	2.72%
Current Portion- LT Debt	2,500.00	-	0.86%	0.00%
Total Current Liabilities	80,610.00	63,448.00	27.75%	27.37%
Deferred Revenue- Non Current	3,624.00	3,031.00	1.25%	1.31%
Long Term debt	53,463.00	28,987.00	18.41%	12.50%
Other Non Current Liabilities	33,427.00	24,826.00	11.51%	10.71%
Total Liabilities	171,124.00	120,292.00	58.91%	51.89%
Stockholder's Equity			0.00%	0.00%
Common Stock	27,416.00	23,313.00	9.44%	10.06%
Retained Earnings	92,284.00	87,152.00	31.77%	37.59%
Accum. OCI	(345.00)	1,082.00	-0.12%	0.47%
Total Stockholder's Equity	119,355.00	111,547.00	41.09%	48.11%
Total Liabilities and Equity	290,479.00	231,839.00	100.00%	100.00%

Income Statement			Vertical Analysis
	USD	USD	Common Size Percent
	2018	2017	2018	2017
Net Sales	233,715.00	182,795.00	100.00%	100.00%
Cost of sales	140,089.00	112,258.00	59.94%	61.41%
Gross Margin	93,626.00	70,537.00	40.06%	38.59%
Research & Development	8,067.00	6,041.00	3.45%	3.30%
Selling, General & Administrative	14,329.00	11,993.00	6.13%	6.56%
Total Operating Expenses	22,396.00	18,034.00	9.58%	9.87%
Operating Income	71,230.00	52,503.00	30.48%	28.72%
Other Income	1,285.00	980.00	0.55%	0.54%
Income before taxes	72,515.00	53,483.00	31.03%	29.26%
Income Taxes	19,121.00	13,973.00	8.18%	7.64%
Net Income	53,394.00	39,510.00	22.85%	21.61%