Question: Im looking for an Excel formula to make a spreadsheet that does the following. I was to find the tax needed to pay formula. If

Im looking for an Excel formula to make a spreadsheet that does the following.

I was to find the tax needed to pay formula.

If the tax free threshold is 18200, and for every $1 over that tax is 19 cents tax.

Can anyone pls help with a formula. I know that obviously the 18200 has to be divided by 52 to get a rough idea of what the tax free threshold is for each week, but then I need the formula to find the $$ of tax over the $350 a week . . Please and thank you

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Pick the current or a past president of the United States and evaluate his performance against the leadership characteristics discussed in the text. On the basis of this comparison, do you think that...

Im looking for an Excel formula to make a spreadsheet that does the following. I was to find the tax needed to pay formula. If the tax free threshold is 18200, and for every $1 over that tax is 19...

pkjain, please help! I am getting incorrect values for sections a, c, and f; sections b,d and e are correct. I think my debt value is skewed. Please check the excel functions values and correct the...

incorrect document, we'll assume that the homework assignment was not actually completed. Background DBVac is considering adding an additional product to their lineup. The company's Research and...

In this assignment, you'll be writing a business case in which you will recommend to DBVac which of the three vacuums to bring to market, give them a sense for what to expect from its release in...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

FIN 300 Final: Moore?s Family Restaurant Case Study Note: All financial data in this case is found in the excel spreadsheet that goes along with this case study. A. Past & Current Operations ?Moore?s...

Just do Assignment 1. Thank you 6 CASE THE SKI RESORT INVESTMENT DECISION Decision Support Using Microsoft Excel PREVIEW In this case, you will use Microsoft Excel to help a ski resort establish a...

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

This question is from the textbook Problem Solving Cases in Microsoft Access and Excel, Edition 16. Prepare a spreadsheet following the instructions in the case. Your spreadsheet should contain three...

The circuit will be operated under continuous current mode (CCM) and open-loop conditions (no feedback). Build the circuit in Matlab- Simulink /Multisim 2.2.1 . The output voltage should vary in the...

Why are the revenues and expenditures of governmental- type funds independent of each other?

W 25 of 25 A 57-year-old male with a history of H. pylori infection, chronic kidney disease stage il, hypehetision, and gout is presenting with and albutle gout warswip involving his right metatarsal...

Consider the following table: Stock Fund Bond Fund Scenario Probability Rate of Return Rate of Return Severe recession 0.05 40% 9% Mild recession 0.25 14% 15% Normal growth 0.40 17% 8% Boom 0.30 33%...