Nike's had reported the following

•Historical sales (from earliest to most recent, in $ millions): 867, 900

•Forecast sales next year (year 1): 934

•Forecast sales next year (year 2): 966

•Historical short-term debt (most recent year): 30

•Historical current portion of long-term debt (most recent year): 40

•Historical long-term debt in long-term liabilities (most recent year): 130

1) What would be the new forecast short term for the next two years; if the Short-term debt to revenue in each forecast year is 0.75 percentage points less than the ratio from the previous year?

2) Total long-term debt to revenue in each forecast in year 1 and in year 2, which equals the ratio of total long-term debt to revenue from the previous year?

3) Current portion of long-term debt to total long-term debt in each forecast in year 1 and year 2, which equals the average ratio from the historic period?

Please show your full work on excel and show the formula as well.