Calculation question 3. Suppose at the end of the year a farm has Total Assets of $1,000,000, of which $400,000 is current assets, $300,000 is Machinery and Breeding Livestock, and $300,000 is Land. Also suppose the firm owes $350,000 in total debt. The specifics regarding the debt are as follows: $100,000 on an operating loan, $150,000 on a machinery loan, of which $32,000 is due within the next year, and $100,000 on a land loan, of which $10,000 is due within the next year. a. (3)Create a simple balance sheet in Excel for this farm with the following categories clearly identified: Current Assets, Long-Term Assets, Total Assets, Current Liabilities, Long-Term Liabilities, Total Liabilities, and Net Worth. b. (3)Calculate a common "liquidity" measure for this farm and provide your assessment of the liquidity position of this farm. c. (3)Calculate a common "solvency" measure for this farm and provide your assessment of the solvency position of this farm. Last year this farm sold $185,000.00 worth of grain, and $36,000.00 worth of raised calves. Included in the grain sales were $30,000.00 of grain that had actually been produced the year before but not sold until last year. In addition, at the end of last year the farm had $15,000.00 worth of grain held in inventory that had not been sold. They also were paid $20,000.00 for custom work they did for other farmers during the year. d. (3)In your spreadsheet, calculate accrual revenue for last year based on the above information. Over the course of last year, the farm had cash operating outflows of $108,200.00, and in addition paid $16,795.00 in interest during the year. Of the operating cash outflows, $6000.00 was for seed they intend to use the following year, however, during the course of last year they did use $7,000.00 worth of fertilizer that they had paid for the year before. They had $16,000.00 in not-cash expenses (management depreciation) last year. They paid off $42,000.00 in principle payments on their equipment and land loans last year, and they purchased two breeding cows for $3500.00, and they purchased a new stock trailer for $8,500.00. They did not sell any equipment. The family withdrew $45,000.00 from the farm account for family living. e. (3)In your spreadsheet, calculate accrual expenses for last year based on the above information. f. (3)Calculate Net Farm Income. g. (4) Calculate Return on Assets (using the farm financial standards guidelines) for this farm based on the information from the Balance sheet information, and the cash flow and income statement information from above.