The following comparative balance sheet items are available from CoCo Corporation as of 30 June 2030:

Prepare and analyse the balance sheet The following comparative balance sheet items are available from CoCo Corporation as of 30 June 2030: Accounts payable 120 000 114 450 Accounts receivable 123 000 125 000 Additional equity 108 000 _ Buildings 450 000 400 000 m m_ Loan payable, due 31/01/2031 200 500 200 500 20 000 18 000 IE_ Dividends payable 90 225 120 000 90 160 198 650 Required 1. Using MS Excel, prepare a comparative, classified balance sheet for CoCo Corporation. 2. In the same MS Excel file, perform horizontal and vertical analyses, and interpret the results. In Excel, round percentages to 1 decimal place. 3. Assume the same information as above, except in 2030 dividends payable is $74,995, loan payable is $187,725, cash is $120,000 and accounts receivable i; $20,000. Does this new information change any interpretations you made in part (b)