Question

You will use Excel to complete this.

Suppose any company and make following documents in excel as a example.

1)Download financial statements

2)Income Statement

3)Balance Sheet

4)Statement of Stockholders’ Equity

5)Notes to the Financial Statement

6)Perform a vertical analysis of the balance sheet.

7)Perform a horizontal analysis on the income statement.

Answer 1

BALANCE SHEET
Assets		2020	% of Total assets
Current Assets
	Cash	$         20,000.00	10.8
	Accounts receivable	$         15,000.00	8.1
	Inventory	$      150,000.00	81.1
	Total current assets	$            185,000	100%
Non Current Assets
	Business Premises	$      650,000.00	84.4
	Property, plant, and equipment	$         50,000.00	6.49
	Vehicles	$         70,000.00	9.09
	Total non current assets	$            770,000	100%
Total Assets	$      955,000
Liabilities and Owner's Equity
Current Liabilities
	Accounts payable	$         25,000.00	35.7
	Bank Overdrafts	$         10,000.00	14.3
	Credit Card Debt	$           5,000.00	7.1
	Income Tax Liability	$         30,000.00	42.9
	Total current liabilities	$              70,000	100%
Non Current Liabilities
	Long-term debt	$      500,000.00	56.5
	Notes Payable	$      385,000.00	43.5
	Total Non Current liabilities	$            885,000	100%
Total Liabilities and Owner's Equity	$      955,000
	INCOME STATEMENT
	PARTICULARS	$ TOTALS	Percent
	SALES	1000000	100%
	COST OF GOODS SOLD	400000	40%
	GROSS MARGIN	600000	60%
	SALARIES AND WAGES	250000	25%
	OFFICE RENT	50000	5%
	SUPPLIES	10000	1%
	UTILITIES	20000	2%
	OTHER EXPENSES	90000	9%
	TOTAL EXPENSES	420000	42%
	NET PROFIT	180000	18%