Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Month Income Expense Total Net Income Before Tax Total Net Income After Tax As an intern for Bank of Brodnax, your employer asks you to
Month | Income | Expense | Total Net Income Before Tax | Total Net Income After Tax | 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: | |||||||||||||
Jan | 20 | 10 | ||||||||||||||||
Feb | 21 | 9 | 1. Adjust the column width of column D and column F to 40. | |||||||||||||||
Mar | 23 | 21 | 2. Fill out the cells D2-D13 in "Net Income" worksheet with the appropriate calculation. Make sure any cells associated with dollars are formated as such. | |||||||||||||||
Apr | 24 | 2 | 3. Make sure cell B16 is formated for calculations. | |||||||||||||||
May | 50 | 34 | 4. Fill out the cells F2-F13 in "Net Income" worksheet with appropriate calculation by reducing the Tax Rate. Note: Use absolute reference and tax rate in cell B16 to get credit. | |||||||||||||||
Jun | 32 | 23 | ||||||||||||||||
Jul | 74 | 50 | 5. Be sure Net Income tab is appropriately labeled. | |||||||||||||||
Aug | 84 | 44 | 6. In order to get full credit, you need to submit an Excel file to the Excel Assignment 2 Dropbox and fulfill all of the requirements below. Due Date, midnight, 16 February. BE SURE YOUR NAME AND CWID IS ON THE ASSIGNMENT. | |||||||||||||||
Sep | 32 | 21 | ||||||||||||||||
Oct | 10 | 8 | ||||||||||||||||
Nov | 21 | 1 | ||||||||||||||||
Dec | 5 | 2 | ||||||||||||||||
Tax Rate | 15% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started