1.Adjust the colum width of column D and column F to 40.

2.Fill out the cells D2-D13 in "net income" worksheet with the appropriate the total for both TNIBT and TNIAT using the SUM function. Make sure any cells associated with dollars are formated as such.

3. You must use the tax rate table for the tax calculation associated with the results for Total Net Income After Tax based on the tax Table

4.Fill out the cells F2-F13 in "Net Income" worksheet with appropriate calculations by reducing the Tax Rate. Note:Use absolute refrence and tax rate in cell B16 to get credit

5. Be sure Net Income Tab is appropriately Labled

Bank of Brodnax Month Income Expense Total Net Income Before Tax Jan 20.00 s 10.00 10.00 Feb 21.00 9.00 12.00 Mar 23.00 21.00 2.00 Apr 24.00 2.00 22.00 May 50,00 34,00 16.00 Jun 32.00 23.00 9.00 Jul 74,00 50,00 24.00 Aug 84.00 44.00 40.00 Sep 32.00 21.00 11.00 Oct 10.00 8.00 2.00 Nov 21.00 1.00 20.00 Dec 5.00 2.00 3.00 Total 171.00 Tax Rate 1 Used for TNIBT if ess than 15 Tax Rate 2 15% Used for TNIBT if greater than or equal to 15 Total Net Income After Tax 9.00 10,80 1.800 18.70 13,60 8.10 20.40 34.00 9,90 1.80 17.00 2,70 147.80