I need 1-6 done in excel. The first picture is instructions. The second pic is the items being used for 1-6 and the last picture is an example of what the balance sheet should look like when finished. Please help!

OO Verizon 10:21 AM 87% Department of Agriculture AECO 3430 Lab Work Morgan cattle's Balance Sheet Meredith Morgan, sole owner and operator of Morgan Cattle, isamodest producer with several thousand acres of imigated and non-imigated farm and pasture land. She operates as a sole proprietorship with anmarginal income tax rate of around 35x. From the data provided 1. (20pts) Categorize all the items into the following headings: Current Assets Non-Current Assets Total Personal Assets Current Liabilities Non-Current Liabilities Total Personal Liabilies Total Equity 2. (40pts) calculate and listthe cost and Market values of the following financial statement items: Total Current Assets Total Business Assets Deferred taxes current Total Current Liabilities Deferred taxes Noncurrent Non-Curent Liabilities Total Liabilities Retained Earnings Personal Net Worth 30 (30pts) Construct Balance Sheet. 6(topts) What did you learn from this lab exercize