I need you to show how you got the work give directions not just the answer
24% 43:43 PM 3863 A+ Individual (Excel) Assignment 7 BUSA 128 Business Computing Systems Spring 2017 Instructor: J. Brodnax As an intern for Bank of Brodnax, your employer asks you to fill out the rest of the simple income statement. The following are tasks that you need to do: 1. Adjust the column width of column D and column F to 40. 2. Calculate the cells D3-D14 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 formatted as such 3. You must use he tax rate cel n the Rate Table work sheet for the tax calculation associated with the otal Net Income After Tax based on the tax table. results fo 4. Fill out the cells F2-F99 in "Net Income" worksheet with appropriate calculation by reducing the Tax Rate from the Rate Tal e work sheet. 5. Calculate the Projected Net Income After Tax by using appropriate rate applied from the Rate Table work sheet to derive Net Income After Tax 6. Use the AVERAGE function to calculate the average for all Net Income columns as noted 7, Color and shade cells as shown, Align Bank name as shown. Make sure all of Column A cells are labeled as shown 8. Be sure Net Income and Rate Table tabs are appropriately labeled. 9. Note all rates must come directly from the Rate Tables work sheet and applied appropriately. 10. Note project income and expenses are now applied directly from the Rate Table work sheet and not calculated in a All other rates are applied similar in each BoB CY table 11. Income for CY01 is calculated from the CY00 Income cell (column B) by applying the projected income rate from the Rate Table. Expense for CY01 is calculated from the CY00 Expense cell column C by applying the projected expense rate from the Rate Table. 12. Income and Expense for CY02-CY05 are calculated similar to H11 above except each is calculated from thier respective growth rates as indicated in the Rate Table. Thus, for CY02, the Income is projected from CY01 Income and the projected growth rate as noted inthe Rate Table. For CY03, the Income is projected from CY02 Income and the projected growth rate as noted in the Rate Table. Etx. Similar for the Expense column (C) 13. In order to get full credit, you need to submit an Excel file to the Excel Assignment Dropbox and fulfill all of the requirements below. Due Date, midnight, 1 May. BE SURE YOUR NAME AND CWI DIS ON THE ASSIGNMENT. A B C D E F of Brodnax CY00 Month income Expense Total Net Income Before T Tot Net Income After Ta Feb 2100 S 900 200 24% 43:43 PM 3863 A+ Individual (Excel) Assignment 7 BUSA 128 Business Computing Systems Spring 2017 Instructor: J. Brodnax As an intern for Bank of Brodnax, your employer asks you to fill out the rest of the simple income statement. The following are tasks that you need to do: 1. Adjust the column width of column D and column F to 40. 2. Calculate the cells D3-D14 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 formatted as such 3. You must use he tax rate cel n the Rate Table work sheet for the tax calculation associated with the otal Net Income After Tax based on the tax table. results fo 4. Fill out the cells F2-F99 in "Net Income" worksheet with appropriate calculation by reducing the Tax Rate from the Rate Tal e work sheet. 5. Calculate the Projected Net Income After Tax by using appropriate rate applied from the Rate Table work sheet to derive Net Income After Tax 6. Use the AVERAGE function to calculate the average for all Net Income columns as noted 7, Color and shade cells as shown, Align Bank name as shown. Make sure all of Column A cells are labeled as shown 8. Be sure Net Income and Rate Table tabs are appropriately labeled. 9. Note all rates must come directly from the Rate Tables work sheet and applied appropriately. 10. Note project income and expenses are now applied directly from the Rate Table work sheet and not calculated in a All other rates are applied similar in each BoB CY table 11. Income for CY01 is calculated from the CY00 Income cell (column B) by applying the projected income rate from the Rate Table. Expense for CY01 is calculated from the CY00 Expense cell column C by applying the projected expense rate from the Rate Table. 12. Income and Expense for CY02-CY05 are calculated similar to H11 above except each is calculated from thier respective growth rates as indicated in the Rate Table. Thus, for CY02, the Income is projected from CY01 Income and the projected growth rate as noted inthe Rate Table. For CY03, the Income is projected from CY02 Income and the projected growth rate as noted in the Rate Table. Etx. Similar for the Expense column (C) 13. In order to get full credit, you need to submit an Excel file to the Excel Assignment Dropbox and fulfill all of the requirements below. Due Date, midnight, 1 May. BE SURE YOUR NAME AND CWI DIS ON THE ASSIGNMENT. A B C D E F of Brodnax CY00 Month income Expense Total Net Income Before T Tot Net Income After Ta Feb 2100 S 900 200
