Please Its urgent i only need the formula of Part a

2017 Forceast Revenue COGS Gross Profit Fiscal Year 2016 Actual 3,750,000 1,200,000 2,550,000 Projected Changes 10.00% 10.00% Total Operating Expenses 1,000,000 9.00% Operating Income 1,550,000 Total Non-Operating Expenses 475,000 5.00% Net Income 1,075,000 5) ABC Corp Financial Projections (15 points) a) In the ABC Corp worksheet, the fiscal year results are provided in Column B. In Column C, you will f positive projected changes that will be used to forecast the corporation's financial performance in 2017. Calculate the appropriate projections for the 2017 Forecast in Column D (all the cells with g fills). Projections (2017 Forecast) D2, D3, D6, D10 are calculated by multiplying the (Projected Chan + 1) by the Fiscal Year 2016 Actual. This projection represents a conservative projection. (5 points) b) For the projected changes listed in Column C, define the names ChangelnRevenue for C2, ChangelnCOGS for C3, ChangelnTOE for C6, and ChangelnNOE for C10; then apply them to al the formulas. (5 points) c) Using the scenario manager, create two scenarios using the following information: (4 points) Changing Cells Changeln Revenue ChangelnCOGS ChangelnTOE Changeln NOE Scenario Name Conservative Projection Optimistic Projection 10% 25% 10% 9% 9% 6% 5% 2% d) Make sure that you keep the Optimistic projection visible. (1 point)