Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer on an excel spreadsheet with formula and explanations, thank you! Noah Valls Tax Advisor Income Filing Status Tax Amount Instructions: Enter an income

please answer on an excel spreadsheet with formula and explanations, thank you!
image text in transcribed
image text in transcribed
Noah Valls Tax Advisor Income Filing Status Tax Amount Instructions: Enter an income amount in B4 Enter a filing status in CA Calculate the correct tax amount using the INDEX and MATCH functions and the Tax Table worksheet Use data validation as appropriate 626 28.100 3.758 3.296 627 28.150 13.765 3.304 628 28.200 3.773 3.311 629 28.250 3.780 3.319 630 28.300 3.788 3.326 631 28.350 3.795 3.334 632 28.400 3.803 3.341 633 28.450 3.810 3.349 634 28.500 3.818 3.356 635 28.550 3.825 3.364 636 28.600 3.833 3.371 637 28.650 13.840 3.379 638 26.700 3.848 3.386 639 26.750 3.855 3.394 640 26.800 3.863 3.401 641 26.850 3.870 3.409 642 26.900 3.878 3.416 643 28.950 3.885 3.424 644 29.000 3.893 3.431 545 29.050 3.900 3.4.39 546 29.100 3.908 3.446 647 29.150 3.915 3.454 648 29,200 3.923 3.461 649 29.250 3.930 3.469 650 29.300 3.938 3.476 651 29.350 3.945 3.484 652 29.400 3.953 3.491 553 29.450 3.960 3.499 654 29.500 3.968 3.506 655 29.550 3.975 3.514 656 29.600 3.983 3.521 657 29.650 3.990 3.529 658 29.700 3.996 3.536 659 29.750 4.005 3.544 660 29.800 4.013 3.551 661 29.850 4.020 3.559 662 29.900 4.028 3.566 663 29.950 4.035 3.574 664 30.000 4.043 3.581 665 30.050 4.050 3.59 666 30.100_4.058 3.596 667 30.150 4.065 3.604 568 30.200 4.073 3.611 669 30.250 4.080 3.619 70 30.300 4.088 3.626 671 30.350 4.095 3.634 672 30.400 4.103 3.541 673 30.450 4.110 3.649 3.758 3.765 3773 3.780 3.788 3.795 3.803 3.810 3.818 3.825 3.823 3.840 3.848 3.855 3.863 3.870 3.878 3.885 3.893 "3.900 3.908 3.915 3.923 3.930 3.938 3.945 3.953 3.960 3.968 3.975 3.983 3.990 3.996 4.005 4.013 4.020 4.028 4.035 4.043 4.050 4.058 4.065 4.073 4.080 4.088 4.095 4.103 4.110 3.561 3.569 3.576 3.564 3.591 3.599 3.606 3.614 3.621 3.629 3.636 3.644 3.651 3.69 3.66 3.674 3.681 3.68 3.696 3.704 3.711 3.719 3.726 3.734 3.741 3.749 3.756 3.764 3.771 3.779 3.786 3.794 3.801 3.809 3.816 3.824 3.831 3.839 3.846 3.854 3.861 3.869 3.876 3.884 3.891 3.899 3.906 3.914 Noah Valls Tax Advisor Income Filing Status Tax Amount Instructions: Enter an income amount in B4 Enter a filing status in CA Calculate the correct tax amount using the INDEX and MATCH functions and the Tax Table worksheet Use data validation as appropriate 626 28.100 3.758 3.296 627 28.150 13.765 3.304 628 28.200 3.773 3.311 629 28.250 3.780 3.319 630 28.300 3.788 3.326 631 28.350 3.795 3.334 632 28.400 3.803 3.341 633 28.450 3.810 3.349 634 28.500 3.818 3.356 635 28.550 3.825 3.364 636 28.600 3.833 3.371 637 28.650 13.840 3.379 638 26.700 3.848 3.386 639 26.750 3.855 3.394 640 26.800 3.863 3.401 641 26.850 3.870 3.409 642 26.900 3.878 3.416 643 28.950 3.885 3.424 644 29.000 3.893 3.431 545 29.050 3.900 3.4.39 546 29.100 3.908 3.446 647 29.150 3.915 3.454 648 29,200 3.923 3.461 649 29.250 3.930 3.469 650 29.300 3.938 3.476 651 29.350 3.945 3.484 652 29.400 3.953 3.491 553 29.450 3.960 3.499 654 29.500 3.968 3.506 655 29.550 3.975 3.514 656 29.600 3.983 3.521 657 29.650 3.990 3.529 658 29.700 3.996 3.536 659 29.750 4.005 3.544 660 29.800 4.013 3.551 661 29.850 4.020 3.559 662 29.900 4.028 3.566 663 29.950 4.035 3.574 664 30.000 4.043 3.581 665 30.050 4.050 3.59 666 30.100_4.058 3.596 667 30.150 4.065 3.604 568 30.200 4.073 3.611 669 30.250 4.080 3.619 70 30.300 4.088 3.626 671 30.350 4.095 3.634 672 30.400 4.103 3.541 673 30.450 4.110 3.649 3.758 3.765 3773 3.780 3.788 3.795 3.803 3.810 3.818 3.825 3.823 3.840 3.848 3.855 3.863 3.870 3.878 3.885 3.893 "3.900 3.908 3.915 3.923 3.930 3.938 3.945 3.953 3.960 3.968 3.975 3.983 3.990 3.996 4.005 4.013 4.020 4.028 4.035 4.043 4.050 4.058 4.065 4.073 4.080 4.088 4.095 4.103 4.110 3.561 3.569 3.576 3.564 3.591 3.599 3.606 3.614 3.621 3.629 3.636 3.644 3.651 3.69 3.66 3.674 3.681 3.68 3.696 3.704 3.711 3.719 3.726 3.734 3.741 3.749 3.756 3.764 3.771 3.779 3.786 3.794 3.801 3.809 3.816 3.824 3.831 3.839 3.846 3.854 3.861 3.869 3.876 3.884 3.891 3.899 3.906 3.914

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

Fundamentals Of Corporate Finance

Authors: David W Blackwell, Robert Parrino, David S Kidwell

1st Edition

0471270563, 9780471270560

More Books

Students also viewed these Finance questions

Question

1. Maintain my own perspective and my opinions

Answered: 1 week ago

Question

2. What do the others in the network want to achieve?

Answered: 1 week ago