business (excle)

momo.xlsx

Home >Business & Finance homework help >business (excle)

Sheet1

			Unadjusted Trial Balance			Adjustments		Adjusted Trial Balance		Income Statement		Balance Sheet
			Debit	Credit		Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit
cash			12,000		a			12,000				12,000
supplies			30,000		b		22,500	7,500				7,500
Prepaid insurance			3,600				1,800	1,800				1,800
Equipaid			110,000		c			110,000				110,000
Accumulated Depreciation-Equipment				25,000			8,350		33,350				33,350
Trucks			60,000		d			60,000				60,000
Accumulated Depreciation-Trucks				15,000			6,200		21,200				21,200
Accounts Payable				4,000					4,000				4,000
Common Stock				26,000					26,000				26,000
Retained Earnings				70,000					70,000				70,000
Dividends			15,000					15,000				15,000
Service Revenue				160,000	e				160,000		160,000
Wages Expense			45,000			600		45,600		45,600
Rent Expense			10,600					10,600		10,600
Miscellaneous Expense			9,000					9,000		9,000
Please Add These Acccounts			4,800		e			4,800		4,800
Wages Payable					a		600		600				600
supplies Expense						22,500		22,500		22,500
Insurance Expense						1,800		1,800		1,800
Depr Expense-Equpment						8,350		8,350		8,350
Depr Expense-Trucks						6,200		6,200		6,200
			300,000	300000		39450	39,450	315,150	315150	108,850	160,000	206,300	155,150
										Net income		-51,150
													366,300
Lokota Freight Co	Co	These cells need equals signs to move the numbers form cell to cell
Income statement
For the year ended march 3,2016
Service Revenue			315150	incorrect number
Expenses
Wages Expense		45,600
Rent Expense		10,600
Truck Expense		9,000
Miscellaneous Expense		4,800
supplies Expense		22,500
insurance Expense		1,800
Depreciation Expense-Equipment		8,350
Depreciation Expense-Equipment	expense-Truck	6,200
Total expenses			108,850
net income			206,300
Lokota Freight Co
Balance Sheet
March31.2016
Assets									Liabilities
Current Assets									current Liabilities
Cash		12000							Accounts payable	400
supplies		7500							Wages payable	600
prepaid insurance		1800							Total Liabilities	1000	4600
total current assets			21300
Property,plant,and Equipment									Stock Holder Equity
Equipment		110000							common stock	2600	incorrect number and missing equals sign
Accumulated Depraction-Equipment		33350							Retained Earnings	206,300
Trucks		60000							Total stockholder equity		208,900
Accumulated Depraction-truck		21200							Total Liabilities and stuckholder Equity		missing number
Total property,plant,and Equipment			115450
Total Assets			136750