Cash	24,000	Interest payable	10,650
Fuel and oil expense	37,000	Interest paid	11,850
Property tax payable	16,000	Supplies on hand	18,000
Labor expense	18,000	Repair expense	36,900
Property taxes paid	15,000	Insurance expense	10,500
Accounts receivable	32,000	Feeder livestock purchases	20,000
Feed purchases	15,000	Crop sales (corn and wheat)	350,750
Corn Inventory	120,000	Principal paid-Beef Loan	10,000
Prepaid expenses	20,000	Principal paid-Farm Mortgage	20,000
Livestock sales	17,500	Government program payments	2,000
Crop expenses	220,000	Other livestock expenses	12,000
Market Livestock Inventory	36,000	Accounts Payable	17,000
Wheat Inventory	50,000	Feed on Hand	70,000

Add a new sheet to your spreadsheet file. Label this sheet Analysis. Using the accrual income statement and beginning and ending balance sheets to calculate the farms profitability (ROA, ROE and Operating Profit Margin) and financial efficiency (Asset Turnover Ratio, Operating Expense Ratio, Depreciation Expense Ratio, Interest Expense Ratio, and Net Farm Income from Operations Ratio) for the year. Use $65,000 as the opportunity cost of labor and management.