If someone could help me with the following problem with the work show that would be greatly appreciated. Thanks

In the first worksheet of the template file, you will have to predict the future financial statements of the Body Shop. Use the figures for 2017 and the forecasting assumptions on the template to forecast the income statement and the balance sheet for the next three years. For some variables, there are no assumptions provided since they should be calculated rather than predicted (e.g. retained earnings). Cash and short-term debt are the two plug items. Assumptions for the cash and debt plugs are described in question a.