Instructions: Fill out the IT Budget by writing formulas (that begin with =) in the light pink cells. Format currency as currency with no decimals. 1. First figure out the growth rates (format as \% with 2 decimals) for various expense categories by writing formulas in Column B (rows 2 through 7) 2. Then, write formulas to forecast the future IT budget for the next 3 years (Year 3 to Year 5 ) in the projected budget section using your growth rates. 3.Note that the growth rate for one of your external expense categories fluctuates for Year 4 and Year 5 (see growth rate in cell B10) so use your Year 1Year 2 growth rate to forecast Year 3 for that expense category. Use your growth rate in cell B10 to forecast for Year 4 and Year 5 4. Write a formula to calculate the Average Expenses over the 5 years in column G. 5. Write formulas to calculate the IT Budget Revenue, Total Internal and External Expenses, Total IT Expenditures, and Balance. Write a formula for the training expenses. 6. Make a pie chart (called "Expenses for Software Licenses Over Five Years") showing expenses for the software licenses over the five-year period and show the legend on the left side of the pie. Place chart to right of the Average Expenses column 7. Make a line chart (called "Internal versus External Expenses") showing Total Internal Expenditures in purple and Total External Expenditures in green and show the legend on the right. Show the years on the horizontal axis and place chart to right of the pie chart Instructions: Fill out the IT Budget by writing formulas (that begin with =) in the light pink cells. Format currency as currency with no decimals. 1. First figure out the growth rates (format as \% with 2 decimals) for various expense categories by writing formulas in Column B (rows 2 through 7) 2. Then, write formulas to forecast the future IT budget for the next 3 years (Year 3 to Year 5 ) in the projected budget section using your growth rates. 3.Note that the growth rate for one of your external expense categories fluctuates for Year 4 and Year 5 (see growth rate in cell B10) so use your Year 1Year 2 growth rate to forecast Year 3 for that expense category. Use your growth rate in cell B10 to forecast for Year 4 and Year 5 4. Write a formula to calculate the Average Expenses over the 5 years in column G. 5. Write formulas to calculate the IT Budget Revenue, Total Internal and External Expenses, Total IT Expenditures, and Balance. Write a formula for the training expenses. 6. Make a pie chart (called "Expenses for Software Licenses Over Five Years") showing expenses for the software licenses over the five-year period and show the legend on the left side of the pie. Place chart to right of the Average Expenses column 7. Make a line chart (called "Internal versus External Expenses") showing Total Internal Expenditures in purple and Total External Expenditures in green and show the legend on the right. Show the years on the horizontal axis and place chart to right of the pie chart
