77-13 Council_Energy_Tax_credit_Attachments.pdf

Acutal Implicit Amount Price State Aid Excess/ Year Received Deflator Formula (Deficit) 2001 5,433,612 5,433,612 - 2002 5,433,612 2.50% 5,569,452 (135,840) 2003 5,433,612 1.00% 5,625,147 (191,535) 2004 5,601,547 2.50% 5,765,775 (164,228) 2005 5,601,548 3.50% 5,967,578 (366,030) 2006 5,601,548 4.50% 6,236,119 (634,571) 2007 5,601,548 5.50% 6,579,105 (977,557) 2008 5,573,037 5.00% 6,908,060 (1,335,023) 2009 5,682,922 6.50% 7,357,084 (1,674,162) 2010 5,682,922 0.00% 7,357,084 (1,674,162) 2011 4,691,252 2.00% 7,504,226 (2,812,974) 2012 4,691,252 3.50% 7,766,874 (3,075,622) 2013 4,691,252 2.00% 7,922,211 (3,230,959) 69,719,664 85,992,329 (16,272,665) State Aid Impact Calculation Enter ETR and CMPTRA amounts received in cells c7 thru c19. The rest of the sheet is calculated for you.

Acutal Implicit Amount Price State Aid Excess/ Year Received (000) Deflator Formula (000) (Deficit) (000) 2001 1,580,292 1,580,292 - 2002 1,580,292 2.50% 1,619,799 (39,507) 2003 1,590,292 1.00% 1,635,997 (45,705) 2004 1,598,084 2.50% 1,676,897 (78,813) 2005 1,623,253 3.50% 1,735,589 (112,336) 2006 1,623,938 4.50% 1,813,690 (189,752) 2007 1,626,150 5.50% 1,913,443 (287,293) 2008 1,623,939 5.00% 2,009,115 (385,176) 2009 1,597,357 6.50% 2,139,708 (542,351) 2010 1,565,230 0.00% 2,139,708 (574,478) 2011 1,293,794 2.00% 2,182,502 (888,708) 2012 1,293,794 3.50% 2,258,889 (965,095) 2013 1,293,794 2.00% 2,304,067 (1,010,273) 19,890,209 25,009,697 (5,119,488) State Aid Impact Calculation - Statewide Enter ETR and CMPTRA amounts received in cells c7 thru c18. The rest of the sheet is calculated for you.