Using the current year budget and master budgeted income statement from the Anthony's Orchards website (http://mym.cdn.laureate-media.com/2dett4d/Walden/ACCT/6130/mm/Anthonys_Orchard_Website-PDF%20format.pdf) , you will create and submit a budgeted balance sheet using the attached excel spreadsheet.

Budgeted Balance Sheet
		Current Year	Next Year
Cash		$1,750,000
Accounts receivable		950,000
Inventory:
	Prepared Apple Products	1,100,000
	Pick your Own Apples	750,000
	Community Events	180,170
Total Inventory		2,030,170
Fixed Assets		2,830,000
Total Assets		7,560,170
Accounts payable		1,475,000
Long-term debt		2,150,000
Total liabilities		3,625,000
Shareholder Equity		3,935,170
Total Liabilties & Equity		7,560,170
*Note that Anthony's Orchard has long term debt for 30 years, which it has not begun to pay back.