Hi I was wondering if you could help me with part b, c and d of case 10.2 in advance financial analysis.

Design a spread sheet for the preparation of projected income statements, balance sheets, and statements of cash ows for MSC for Year 8 Year 12. Also forecast the nancial statements for each of these years under three scenarios: (1) best case, (2) most likely, and (3) worst case. The following sections describe the assumptions you can make.