please can help me problem 10.2.

Design a spread sheet for the preparation of projected income statements, balance sheets, and statements of cash ows for MSC for Year 8Year 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.