share the excel formulas please!

Link your answer Please create a forecast for the next five years for company widgets, based on the following information, and provide the cash on the balance sheet in yrs. General fin Financials This is a sa statements ability to cr Revenues Cost of Goods Sold (COGS) Gross Profit Operating Expenses (Opex) EBITDA YR1 12,7 16.9) 5,8 (1,7) 4,2 YR2 13.1 (7,2) 5,9 (17) 4,1 YR3 137 (76) 6,1 (18) 4.3 Revenue growth 75% in YR4,6% in VRS, and then 5% in YR6,4in YR7 and 3 in YRA Cost of Goods Sold (COGS) remain flot at 60% of sales Operating Expensen (Opex) remain content from YRI of aber Days receivable Days payable for inventory (purchase Inventory days (COGS) Days payable for opex Depreciation and capex % Revenues Net fixed Assets EoP 30 days 30 days 40 days 40 days 15 days 15 days O days o days 2,0% 2,0% 1,60 Calculate 30 days 40 days 15 days days 2.0% Depreciation and capex will remain constant from YR3 as of Revenues 1 year = 360 days All days ratios remain constant in the forecast period 30,0% Tax Rate Link your answer Please create a forecast for the next five years for company widgets, based on the following information, and provide the cash on the balance sheet in yrs. General fin Financials This is a sa statements ability to cr Revenues Cost of Goods Sold (COGS) Gross Profit Operating Expenses (Opex) EBITDA YR1 12,7 16.9) 5,8 (1,7) 4,2 YR2 13.1 (7,2) 5,9 (17) 4,1 YR3 137 (76) 6,1 (18) 4.3 Revenue growth 75% in YR4,6% in VRS, and then 5% in YR6,4in YR7 and 3 in YRA Cost of Goods Sold (COGS) remain flot at 60% of sales Operating Expensen (Opex) remain content from YRI of aber Days receivable Days payable for inventory (purchase Inventory days (COGS) Days payable for opex Depreciation and capex % Revenues Net fixed Assets EoP 30 days 30 days 40 days 40 days 15 days 15 days O days o days 2,0% 2,0% 1,60 Calculate 30 days 40 days 15 days days 2.0% Depreciation and capex will remain constant from YR3 as of Revenues 1 year = 360 days All days ratios remain constant in the forecast period 30,0% Tax Rate