Select the table below, copy it and then paste it into a spreadsheet (this works in Excel). Then for each row, determine if the person named is an independent board member and which sub-committee the person belongs to. If the person is independent, indicate with 'Y' in the appropriate cell, if not use 'N'. Do likewise for each sub-committee. ENRON BOARD of DIRECTORS and BOARD COMMITTEES at time of bankruptcy (2001) number of boards Audit Nominating Executive Compensation Finance Industry Independent? Director excluding Committee Committee Committee Committee Committee Experience (Y/N) Enron) (Y/N) (Y/N) (Y/N) (Y/N) (Y/N) (Y/N) (number) Lay Belfer Blake Chan Duncan Gramm laedicke Lemaistre Mendelsohn Pereira Powers Savage Troubh Wakeham Winokur INDEPENDENT 0 out of 0 0 out of 0 |0 out of 0 |0 out of 0 |0 out of 0 10 out of 0 Once you have completed the spreadsheet, use it to answer the questions in the quiz1 . Assess the level of board independence. Outline if the level of independence is acceptable or not, providing reasons [or your assessment. 2. Assess the membership ofthe Audit subcommittee. Based on the table you constructed, would you regard the Audit subcommittee as reliable? Provide reasons for your assessment. 3. Assess the membership ofthe Nominating subcommittee. Based on the table you constructed, would you regard the Nominating subcommittee as reliable? Provide reasons for your assessment. 4. Assess the membership of the Executive subcommittee. Based on the table you constructed, would you regard the Executive subcommittee as reliable? Provide reasons for you r assessment. 5. Assess the membership of the Compensation subcommittee. Based on the table you constructed, would you regard the Compensation subcommittee as reliable? Provide reasons foryour assessment. 6. Assess the membership ofthe Finance subcommittee. Based on the table you constructed, would you regard the Finance subcommittee as reliable? Provide reasons for your assessment. 7. Does any board member sit on an excessive number of boards? Why do you think that? 8. Based on the analysis you conducted, assess the structure ofthe Enron board. Is it structurally sound