Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

Discuss the key people management challenges that Dorian faced.

Answered: 1 week ago

Question

How fast should bidder managers move into the target?

Answered: 1 week ago