01 Sep MATH EXCEL WORKSHEET. TAXES
Instructions
| Taxes | ||
| Project Description: | ||
| In this problem, you will calculate the federal income tax for married couples filing jointly in 2018 with different income levels. | ||
| Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. | ||
| Steps to Perform: | ||
| Step | Instructions | Points Possible |
| 1 | Start Excel. Download and open the workbook named: | 0 |
| Chapter_1-6_Taxes_Start | ||
| 2 | In cell H6, find the base tax for Arah and Beto according to their income in cell G6. | 2 |
| 3 | In cell I6, calculate the amount their income is over the appropriate cutoff value. | 2 |
| 4 | In cell J6, find the correct rate according to their income and base rate. | 2 |
| 5 | In cell K6, calculate the federal tax for Arah and Beto. | 2 |
| Note: Use only cell references to the values calculated in parts a-c. | ||
| 6 | In cell H18, find the base tax according to the income in cell G18. Fill cell H18 down the column to cell H105. | 4 |
| Note: The base rate doesn’t change with the income levels in cells G18:G105. Be sure to use the correct type of cell references. | ||
| 7 | In cell I18, calculate the amount the income in cell G18 is over the appropriate cutoff value. Fill cell I18 down the column to cell I105. | 4 |
| Note: Be sure to use absolute, mixed, and relative cell references. | ||
| 8 | In cell J18, find the correct rate according to the income in cell G18. Fill cell J18 down the column to cell J105. | 4 |
| Note: The rate doesn’t change with the income levels in cells J18:J105. Be sure to use the correct type of cell references. | ||
| 9 | In cell K18, calculate the federal tax for income in cell G18. Fill cell K18 down the column to cell K105. | 4 |
| Note: Use only cell references to the values calculated in part e. | ||
| 10 | In cells M36:Z55, insert a Scatter Chart to show the relationship between the income and federal rate. Select ranges G18:G105 and K18:K105. On the Insert tab, click Recommended Charts, and then click Scatter. Apply Style 7 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Federal Income Taxes for Filing Jointly Married. Add axis titles. Replace Axis Title for the horizontal axis with 2018 Income and Axis Title for the vertical axis with Federal Income Taxes. Double click on the horizontal axis of the chart. In Format Axis window, set 78000 as the minimum bound. | 4 |
| 11 | Save your file and submit for grading. | 0 |
| Total Points | 28 |
Questions
| Taxes |
| Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.