In this homework assignment you will be forecasting the firms financial statements out for the next 10 years using the t ee worksheets de You wil to fo e te direct yusi the appropriate forecast driver or growth rate. Forecasted items that are used in other caluclations should be directly linked back to the cell in which it was calculated, and NOT hardcoded (this means do not type the number directly). For example, when you use EBITA in the tax calculation, you should link the EBITA cell in the tax calc directly to the forecasted EBITA in the income statement. Don't just copy the number. Likewise, everything in this excel sheet should be calculated in excel whether you use excels prebuilt formulae or you write the formulas yourself don't use your calculator and then hardcode the values. If you do this correctly, the entire sheet should update correctly whenever any of the inputs are adjusted. You are only allowed to hardcode the cells for forecasted excess cash and newly issued debt (However, if you can figure out how to get the references to work so that they will calculate and update automatically I will give you extra credit.) GOOD LUCK. ng In this homework assignment you will be forecasting the firms financial statements out for the next 10 years using the t ee worksheets de You wil to fo e te direct yusi the appropriate forecast driver or growth rate. Forecasted items that are used in other caluclations should be directly linked back to the cell in which it was calculated, and NOT hardcoded (this means do not type the number directly). For example, when you use EBITA in the tax calculation, you should link the EBITA cell in the tax calc directly to the forecasted EBITA in the income statement. Don't just copy the number. Likewise, everything in this excel sheet should be calculated in excel whether you use excels prebuilt formulae or you write the formulas yourself don't use your calculator and then hardcode the values. If you do this correctly, the entire sheet should update correctly whenever any of the inputs are adjusted. You are only allowed to hardcode the cells for forecasted excess cash and newly issued debt (However, if you can figure out how to get the references to work so that they will calculate and update automatically I will give you extra credit.) GOOD LUCK. ng