Horizontal and Vertical Analysis

ACCT460.xlsx

Horizontal Analysis

Jim's Auto Body			Angel's Auto Body			Jim's Auto Body			Angel's Auto Body
Income Statement			Income Statement			Balance Sheet			Balance Sheet
As of April 30, 2014			As of April 30, 2015				As of April 30, 2014			As of April 30, 2015
						Assets:			Assets:
Revenues:			Revenues:			Cash	101,800		Cash	145,000
Service Revenue		28,000	Service Revenue		32,000	Acct Rec'able	20,000		Acct Rec'able	34,000
Total Revenue		28,000	Total Revenue		32,000	PP In	1,100		PP In	1,100
						Equipment	55,000		Equipment	62,000
Expenses:			Expenses:			Accu. Dep.		500	Accu. Dep.		750
Salary Expense	4,500		Salary Expense	5,200		Supplies	2,600		Supplies	2,300
Rent Expense	1,200		Rent Expense	1,300		Total Assets	180,000		Total Assets	243,650
Utility Expense	300		Utility Expense	420
Depreciation Expense	500		Depreciation Expense	500		Liabilities and Stockholders' Equity			Liabilities and Stockholders' Equity
Insurance Expense	100		Insurance Expense	125		Liabilities:			Liabilities:
Supply Expense	400		Supply Expense	325		Accounts Payable		8,000	Accounts Payable		22,000
Total Expenses		7,000	Total Expenses		7,870	Salary Payable		3,000	Salary Payable		4,500
						Total Liabilities		11000.00	Total Liabilities		26500.00
		21,000			24,130
						Stockholders' Equity:			Stockholders' Equity:
						Common Stock		150,000	Common Stock		198,150
						Retained Earnings		19000	Retained Earnings		19000
						Total Stockholders' Equity		169000.00	Total Stockholders' Equity		217150.00
						Total Liabilities & Stockholders' Equity	180,000		Total Liabilities & Stockholders' Equity	243,650

Jim's Auto Body			Angel's Auto Body			Jim's Auto Body			Angel's Auto Body
Income Statement			Income Statement			Balance Sheet			Balance Sheet
As of April 30, 2014			As of April 30, 2014				As of April 30, 2014			As of April 30, 2014
						Assets:			Assets:
Revenues:			Revenues:			Cash	101,800		Cash	332,000
Service Revenue		28,000	Service Revenue		189,000	Acct Rec'able	20,000		Acct Rec'able	67,000
Total Revenue		28,000	Total Revenue		189,000	PP In	1,100		PP In	1,100
						Equipment	55,000		Equipment	122,000
Expenses:			Expenses:			Accu. Dep.		500	Accu. Dep.		3,300
Salary Expense	4,500		Salary Expense	40,000		Supplies	2,600		Supplies	12,000
Rent Expense	1,200		Rent Expense	8,000		Total Assets	180,000		Total Assets	530,800
Utility Expense	300		Utility Expense	2,400
Depreciation Expense	500		Depreciation Expense	2,855		Liabilities and Stockholders' Equity			Liabilities and Stockholders' Equity
Insurance Expense	100		Insurance Expense	2,000		Liabilities:			Liabilities:
Supply Expense	400		Supply Expense	4,300		Accounts Payable		8,000	Accounts Payable		192,000
Total Expenses		7,000	Total Expenses		59,555	Salary Payable		3,000	Salary Payable		10,000
						Total Liabilities		11000.00	Total Liabilities		202000.00
		21,000			129,445
						Stockholders' Equity:			Stockholders' Equity:
						Common Stock		150,000	Common Stock		203,800
						Retained Earnings		19000	Retained Earnings		125000
						Total Stockholders' Equity		169000.00	Total Stockholders' Equity		328800.00
						Total Liabilities & Stockholders' Equity	180,000		Total Liabilities & Stockholders' Equity	530,800
For the Month Ended 4/30/2014