Question

13 Original Investment Balance 14 Expected Return After Retirement 1,000.00 4% 15 16 Year Age Salary UW BEBOOo vou AWNO 20 $8Taxable Pay Lower limit Taxable Pay Upper Limit Tax Rate % 9,525.00 10% 9,525.00 $ 38,700.00 12% 38,700.00 $ 82,500.00 22% 82

Can anyone help me how to calculate income tax in Excel?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

J K ДА В ср 1 Year Age Salary Tax 20 3 1 21 80000 13539.50 4 2 22 81600 13891.50 5 3 23 83232 14265.18 H I Taxable Pay Lower

A B Taxable Pay Lower Limit Base Tax 1 ar Age Salary Tax 20 3 1 =20+A3 80000 =INDEX($I$2:$I$8,MATCH(C3, $F$2:$F$8,1),1)+INDEX

Add a comment
Know the answer?
Add Answer to:
Can anyone help me how to calculate income tax in Excel? 13 Original Investment Balance 14...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Question 6 10 pts Using the below 2018 tax schedule, calculate the Federal income tax for a taxable income of $16,0...

    Question 6 10 pts Using the below 2018 tax schedule, calculate the Federal income tax for a taxable income of $16,000. Federal Inc Tax Schedule Marginal Rates Taxable income 2018 to $ 9,525.00 10% . $ 9,526.00 to $ 38,700.00 12% $ 38,701.00 to $ 82,500.00 22% $ 82,501.00 to $ 157,500.00 24% $ 157,501.00 to $ 200,000.00 32% $ 200,001.00 to $500,000.00 35% $ 500,001.00 and above 37%

  • mips add matrix Can anyone help me with adding matrix in MIPS? This is the code...

    mips add matrix Can anyone help me with adding matrix in MIPS? This is the code given. We will be using it to run it in spim-cache Write an assembly code program to perform addition between two matrices A and B, and store the result into a matrix C, i.e, 1 2 3 4 51 [26 27 28 29 301 27 29 31 33 35 6 7 8 9 10 31 32 33 34 35 37 39 41 43 45...

  • can anyone help me for describing how this cods work?? pleasssse help me

    1.  close all;2.  clear all;clc;3.   4.   t=1:0.025:5;5.   desired=5*sin(2*3.*t);6.   7.   noise=5*sin(2*50*3.*t);8.   9.   refer=5*sin(2*50*3.*t+ 3/20);10.  11.  primary=desired+noise;12.  13.  subplot(4,1,1);14.  plot(t,desired);15.  ylabel('desired');16.  17.  18. subplot(4,1,2);19.  plot(t,refer);20.  ylabel('refer'); 21.  22.  23.  24.  subplot(4,1,3);25.  plot(t,primary);26.  ylabel('primary');27.  28.   29.  30.  order= 2;31.  mu=0.005;32.  n=length(primary)33.  delayed=zeros(1,order);34.  adap=zeros(1,order);35.  cancelled=zeros(1,n);36.  37.  for k=1:n,38.      delayed(1)=refer(k);39.      y=delayed*adap';40.      cancelled(k)=primary(k)-y;41.      adap = adap + 2*mu*cancelled(k) .* delayed;42.      delayed(2:order)=delayed(1:order-1);43.  end44.  45.  subplot(4,1,4);46.  plot(t,cancelled);47.  ylabel('cancelled');

  • x Excel template - Saved Home Insert Data Review View Help Tell me what you want...

    x Excel template - Saved Home Insert Data Review View Help Tell me what you want to do 5 X Out - 10-AA 13 Currency Lu Copy BTW. DA S. % 9 et Delete 29 Forsbe Clear 816 1 Personal taxes Salary $84,000.00 Tax Table for Single Individuals Taxable income 4 Dividend Income 5 Interest income 6 LT Stock Sale 7 LT Stock Cost ST Stock Sale 9 ST Stock Cost 10 Personal Exemption 11 Pomured Deductions 12 Aplicable Tax...

  • Charles and Joan Thompson file a joint return. In 2018, they had taxable income of $92,370...

    Charles and Joan Thompson file a joint return. In 2018, they had taxable income of $92,370 and paid tax of $12,202. Charles is an advertising executive, and Joan is a college professor. During the fall 2019 semester, Joan is planning to take a leave of absence without pay. The Thompsons expect their taxable income to drop to $70,000 in 2019. They expect their 2019 tax liability will be $8,015, which will be the approximate amount of their withholding. Joan anticipates...

  • Mary Jarvis is a single individual who is working on filing her tax return for the...

    Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: • She received $106,000 in salary • She received $15,000 of dividend income. • She received $6,200 of interest income on Home Depot bonds. . She received $25,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $5,500. • She received $9,500 from the sale...

  • help and how do i enter in Excel We Really Love Cash, Co. Income Statement For...

    help and how do i enter in Excel We Really Love Cash, Co. Income Statement For the Year ended December 31, 2020 2019 $20,000 14,000 20,000 78,000 24,000) $108,000 Sales revenue Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income taxes Income tax expense Net income $242,000 175,000 67,000 24,000 43,000 3,000 40,000 8,000 $32,000 15 The points available for each row requiring input are noted in column on the temps 16 We...

  • please help me with this. i will give thumb up. Thanks -income statement, Balance Sheet, Retained...

    please help me with this. i will give thumb up. Thanks -income statement, Balance Sheet, Retained Earning 1 ABC Sales 2. Adjusted Trial Balance 3 December 31, 2020 4 5 Debits Credits 6 Cash $ 980,476 7 Accounts Receivable 207,610 8 Allowance for bad debts 6,335 9 Inventory 24,584 10 Prepaid insurance 600 11 Prepaid Web Service 100 12 Equipment - Computer 4,000 13 Accumulated Depreciation - Computer 600 14 Equipment - Van 130,000 15 Accumulated Depreciation - Van 7,105...

  • to find estimated tax, I was multiplying my taxable income with the percent (12%). its wrong...

    to find estimated tax, I was multiplying my taxable income with the percent (12%). its wrong so how do i figure it out ? Saved Jamie Lee Jackson, age 26, is in her last semester of college and is waiting for graduation day that is just around the corner! It is the time of year again when Jamie Lee must file her annual federal income taxes. Last year, she received an increase in salary from the bakery, which brought her...

  • Answer TRUE OR FALSE. CHAPTER 1 1. Two notable trends in tax revenue sources is that...

    Answer TRUE OR FALSE. CHAPTER 1 1. Two notable trends in tax revenue sources is that social security taxes have decreased gradually while corporate income taxes have increased gradually over the last fifty years. 2. If a progressive tax rate system is used, as a taxpayer's taxable income decreases, a progressively higher rate of tax is applied. 3. The marginal tax rate measures the tax rate applicable to the next dollar of income or deduction for a taxpayer. 4. All...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT