Using the Internet, obtain the income statement (latest available year) for the insurance company where you insure your automobile(casualty insurance company) and perform a horizontal analysis of this company using Excel. If you do not have car insurance do the analysis for an automobile insurance company of your choice. Attach and submit the Excel file when done.

The following data were taken from the records of clarkson company for the fiscal year ended june 30, 2017. raw materials inventory 7/1/16 $58,100 factory insurance $4,800 raw materials inventory 6/30/17 46,600 factory machinery depreciation 17,100 finished goods inventory 7/1/16 99,700 factory utilities 29,400 finished goods inventory 6/30/17 21,900 office utilities expense 9,350 work in process inventory 7/1/16 21,200 sales revenue 560,500 work in process inventory 6/30/17 29,400 sales discounts 4,700 direct labor 147,550 plant manager’s salary 63,400 indirect labor 25,360 factory property taxes 9,910 accounts receivable 28,000 factory repairs 2,500 raw materials purchases 97,300 cash 39,200 a) prepare a cost of goods manufactured schedule (assume all raw materials used were direct materials). b) prepare an income statement through gross profit c)prepare the current assets section of the balance sheet at june 30, 2014